The Scenario
You run a quant screening process every Thursday. Twenty token symbols live in your Google Sheet. 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 the signals before the weekly rebalance call.
Last Thursday your data analyst was out sick. You tried to pull it 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 mixed up two values somewhere around token 12
- 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 backwards.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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.
For each token symbol in my sheet, fetch the RSI, MACD, and 50-day moving average from Token Metrics and add them as new columns
What You Get
- New column headers for RSI, MACD, and 50-day MA added 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 the MACD histogram value, not just the signal line
For each token in my sheet's 'Symbols' column, 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 tabs and you want indicators in both
For each token symbol in my 'Core Holdings' tab 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' tab column A
You want 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. Then 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 when done.
One prompt covers the data pull, the scoring logic, and the sort. No intermediate steps, no formula building in between.
Try It
Get the 7-day free trial of SheetXAI and open any sheet 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.