The Scenario
It's 7:45 AM and you manage a crypto portfolio tracker for a small family office. Column A of your "Watchlist" worksheet has 50 token symbols — BTC, ETH, SOL, and 47 others. Columns B through D are supposed to hold live price, market cap, and 24-hour change. They're currently showing data from three days ago, because the last person who refreshed it manually got halfway through and gave up.
The bad version:
- Download the CoinMarketCap CSV export, open it alongside the workbook, run an XLOOKUP to match each symbol in column A, drag the formula down 50 rows, fix the three tokens where the symbol casing doesn't match.
- Notice that the CSV structure shifted since last week — a column header changed — and the XLOOKUP is returning the wrong field for half the rows.
- Rebuild the lookup, fix the formatting, and realize you've now spent the time between when the market opened and when the morning brief goes out.
The fund's morning brief lands with the partners at 8:30 AM. Running through this manually is not an option you have — not because of the clock, but because you've already done it eleven times this month and your actual job is analysis, not export reconciliation.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives directly inside your Excel workbook. It reads the spreadsheet, understands the structure, and through its CoinMarketCap integration pulls live market data and writes it back into the right cells. No CSV exports. No lookup formulas that break when a header changes.
For each token symbol in column A of the "Watchlist" worksheet, fetch the current USD price, market cap, and 24h percent change from CoinMarketCap and fill in columns B, C, and D
What You Get
- Column B fills with the current USD price for each token, formatted as a number.
- Column C fills with market cap in USD — full integer, no rounding unless your cell format is already set to truncate.
- Column D fills with the 24-hour percent change — positive values for gainers, negative for losers.
- Any symbol that CoinMarketCap can't resolve returns a clear error note in the cell rather than a silent blank.
What If the Data Is Not Quite Ready
The symbols in column A use different casing than CoinMarketCap expects
For each symbol in column A of "Watchlist," normalize the casing to uppercase, then fetch the current USD price, market cap, and 24h percent change from CoinMarketCap and write them into columns B, C, and D
Some rows have token names instead of ticker symbols
For each cell in column A of "Watchlist" that contains a full token name rather than a ticker symbol, look up the correct CoinMarketCap ticker, then fetch the USD price, market cap, and 24h change and fill columns B, C, and D accordingly
The watchlist spans two worksheets and I need both refreshed
For each symbol in column A of the "Watchlist-Core" worksheet and the "Watchlist-Alt" worksheet, fetch current USD price, market cap, and 24h percent change from CoinMarketCap and write the results into columns B, C, and D of each respective worksheet
The data's stale, there are duplicates, and I need a summary alongside it
Remove any duplicate symbols in column A of "Watchlist," then fetch current USD price, market cap, and 24h percent change from CoinMarketCap for each unique symbol, write the results into columns B through D, and add a summary row at the bottom of the worksheet showing total portfolio market cap and the three top gainers by 24h change
Cleanup and data pull in one instruction — the workbook comes back ready for the morning brief.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your token watchlist, then ask it to refresh the market data from CoinMarketCap. You might also find these useful: Build a DeFi Token Screener in an Excel workbook and the CoinMarketCap integration overview.