The Scenario
You track 30 altcoins. Every Monday you check which ones Token Metrics is signaling as buys before you decide where to allocate. The process is supposed to be systematic. In practice, you've missed signals twice in the last month because the manual check took so long the session moved on without you.
The third time it happened, you decided something had to change.
The bad version:
- Open Token Metrics and navigate to each token individually to check the current signal
- Copy the signal type, confidence score, and entry price into your Excel workbook as you go
- Return to tokens you already checked and find two of them have flipped signals in the time it took to get through the list
You need the signal view in thirty seconds, not thirty minutes. The decision-making is the job. The data collection is the overhead.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your watchlist, queries Token Metrics for every token's current signal in one pass, and writes the signal type, confidence score, and entry price into the right columns — so Monday morning is spent on decisions, not dashboards.
Pull the latest Token Metrics trading signals for all tokens in my Excel sheet's 'Watchlist' column and write the signal, confidence score, and suggested entry point into adjacent columns
What You Get
- Signal type (buy, sell, or hold) in the designated column for each row
- Confidence score as a number, not a percentage string
- Suggested entry price in the adjacent column
- A clear note for any token where Token Metrics returns no active signal — not a blank that reads as ambiguous
What If the Data Is Not Quite Ready
You want only buy signals written to a separate worksheet
Fetch Token Metrics trading signals for each token in my 'Watchlist' worksheet column A — write only rows where the signal is 'buy' to a 'Buy Signals' worksheet, with columns for symbol, entry price, exit price, and confidence score
You want to flag high-conviction signals above 80% confidence
Fetch Token Metrics trading signals for all tokens in my 'Watchlist' worksheet and write signal type, confidence score, and entry price into the adjacent columns — add 'HIGH CONVICTION' in a Flag column for any row where confidence is above 80
Your watchlist is split across two worksheets and you want a unified signal view
Fetch Token Metrics trading signals for every symbol in my 'Majors' worksheet column A and my 'Altcoins' worksheet column A — combine the results into a single table on a new 'Signals' worksheet with columns for symbol, signal, confidence, and entry price
Full kill-chain: fetch signals, filter to high-confidence buys, sort, and summarize
Fetch Token Metrics trading signals for every token symbol in my 'Watchlist' worksheet column A. Filter to rows where signal is 'buy' and confidence is above 75. Sort by confidence descending. Write the filtered results to a 'Filtered Buys' worksheet with columns for symbol, signal, confidence, entry price, and exit price. Write a one-line count summary in cell A1 of that worksheet.
The filtering and the fetch happen together. You open 'Filtered Buys' and the allocation decisions are waiting for you.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of altcoin symbols, then ask it to pull the current Token Metrics buy/sell/hold signals with confidence scores. See also: Pull Technical Indicators and the Token Metrics overview.