The Scenario
Your crypto portfolio tracking workbook has 40 token symbols in column A of the "Portfolio" worksheet. Every morning you need columns B through E filled with current price, 24h volume, market cap, and holder count — before you review positions for the day.
You did this manually last week. You know exactly how it went.
The bad version:
- Open Token Metrics, search the first symbol, screenshot the numbers, switch to your workbook, type them in
- Repeat for 39 more rows while prices tick against you in real time
- Realize the price you entered in row 4 is already 2% stale by the time you reach row 25
By row 30, you're not maintaining a live dashboard — you're building a historical artifact of your own typing speed. The data you needed for the morning session is already yesterday's news.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook and talks to Token Metrics for you — pulling data for every row in one pass, not one API call per 20 minutes of your morning.
Pull live price data from Token Metrics for every row in my Excel sheet's 'Watchlist' tab — populate 'Price', 'Market Cap', '24h Volume', and 'Holders' columns for each symbol
What You Get
- Price column: current price in USD as a number
- Market Cap and 24h Volume columns: populated as numbers, not text
- Holders column: holder count where Token Metrics returns it
- Any symbol Token Metrics doesn't recognize gets an error note in the cell rather than a silent blank
What If the Data Is Not Quite Ready
The symbols in your workbook are mixed case and some have trailing spaces
Normalize every symbol in the 'Symbol' column of my 'Watchlist' worksheet to uppercase and trim whitespace, then fetch current price, 24h volume, and market cap from Token Metrics and write the results into the adjacent columns
You want to add a 24h price change percentage column and flag tokens down more than 5%
For each token symbol in the 'Watchlist' worksheet, fetch the current price, 24h volume, market cap, and 24h price change percentage from Token Metrics — write into the designated columns, and add 'FLAG' in the 'Alert' column for any token where the 24h change is below -5%
Your symbols live across two worksheets and you want a combined view
Pull token symbols from both my 'Core' worksheet column A and my 'Watchlist' worksheet column A, fetch current price and market cap from Token Metrics for each, and write a combined results table starting at cell A2 of a new 'Live Data' worksheet
Full refresh: clear stale data, fetch new values, and flag anything missing holders data
Clear the Price, Volume, Market Cap, and Holders columns in my 'Watchlist' worksheet, then for each symbol in column A fetch the current values from Token Metrics — write the results, and mark 'N/A — no holder data' in the Holders column for any token where Token Metrics doesn't return a holder count
When the data isn't clean, ask for the cleanup and the pull in the same prompt. SheetXAI handles both steps without requiring you to fix the workbook first and run the query second.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of crypto token symbols, then ask it to bulk-fetch live prices and market data from Token Metrics. See also: Import the Top Tokens by Market Cap and the Token Metrics overview.