The Scenario
You run a quant screening process every Thursday. Twenty token symbols live in your Excel workbook. You need RSI, MACD signal, and 50-day moving average values for each one, pulled in and laid out side by side so you can rank them before the weekly rebalance call.
Last Thursday your data analyst was out sick. You tried to pull the indicators yourself.
The bad version:
- Navigate to Token Metrics, search the first token, find the indicators panel, note the RSI value, write it down, switch tabs
- Repeat for 19 more tokens, then realize you transposed two values somewhere around token 11
- Go back through the entire list to verify, arrive at the rebalance call 20 minutes late with numbers you're not fully confident in
The signal quality from Token Metrics is good. The bottleneck is the data retrieval, not the analysis — and that's the wrong bottleneck.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your symbol list, queries Token Metrics for each token's technical indicators, and writes the values into the correct columns — without you touching a single dashboard.
Pull technical indicator data from Token Metrics for every token listed in column A of my Excel sheet — add columns for RSI (1d), MACD signal, and 200-day MA
What You Get
- New column headers for RSI (1d), MACD signal, and 200-day MA written alongside your existing data
- One value per row, matched to the token symbol in that row
- Tokens where Token Metrics returns no indicator data get a clear note in the cell rather than a blank that looks like a zero
What If the Data Is Not Quite Ready
You want the 14-day RSI and MACD histogram value, not just the signal line
For each token in my 'Watchlist' worksheet column A, fetch the 14-day RSI and MACD histogram value from Token Metrics — add them as columns named 'RSI (14d)' and 'MACD Histogram' next to the existing data
You want to add a 200-day MA and flag tokens where price is below it
Fetch the 50-day and 200-day moving averages from Token Metrics for each token symbol in column A — write into columns D and E, then add 'BELOW 200MA' in column F for any row where the current price in column B is below the 200-day MA in column E
Your symbols are split across two worksheets and you want indicators in both
For each token symbol in my 'Core Holdings' worksheet column A, fetch RSI, MACD signal, and 50-day MA from Token Metrics and write into the adjacent columns. Do the same for each symbol in my 'Speculative' worksheet column A
Full screening pass: fetch indicators, score each token, and sort by score descending
For each token symbol in column A, fetch RSI (14d), MACD signal, and 50-day moving average from Token Metrics — write into columns B, C, and D. In column E, add a score: 1 point if RSI is below 40, 1 point if MACD signal is positive, 1 point if price is above the 50-day MA. Sort the table by score descending.
One prompt covers the data pull, the scoring logic, and the sort. No intermediate workbook editing between steps.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of token symbols, then ask it to populate RSI and moving average data from Token Metrics. See also: Fetch AI Trading Signals and the Token Metrics overview.