The Scenario
You write a daily crypto market briefing for a small subscriber list. Your source material lives in an Excel workbook — 8 token symbols in column A. Every morning you need the five most recent news headlines and article URLs for each token to decide what to cover. Right now you're opening browser tabs and scanning aggregator sites before you can write a single word.
A subscriber asked why this week's briefing was 45 minutes late. The honest answer is that the news sourcing took longer than the writing.
The bad version:
- Open Finage's crypto news endpoint, search for token 1, copy the first five headlines and URLs, paste them into the Excel workbook.
- Repeat for each of the 8 tokens.
- Realize headlines for two tokens returned in a language you don't recognize and spend time filtering those out before the sourcing is usable.
Your readers pay for the interpretation. The time you spend on aggregation comes out of the time you have for that.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the token list and calls Finage on your behalf. It fetches the latest news articles for each symbol, extracts headline, source, and URL, and writes them into adjacent columns — all 8 tokens in a single operation.
Read 8 crypto ticker symbols from my Excel sheet and pull recent market news from Finage for each, filling the adjacent rows with headline and article URL
What You Get
- For each token: up to 5 rows of news, each with headline in column B, source name in column C, and full article URL in column D
- Results written in a contiguous block beneath each token so the layout matches your briefing format
- Tokens that return fewer than 5 articles get however many exist; no padding with empty rows
What If the Data Is Not Quite Ready
You want 10 articles per token instead of 5
For each crypto symbol in column A of my Excel workbook, fetch the latest 10 news articles from Finage and write headline, source, and URL into columns B, C, and D
You want to filter out any article from a source you've flagged as low-quality
For each crypto symbol in column A, fetch the latest 10 news articles from Finage, exclude any articles whose source appears in my Blocked Sources list on the Reference worksheet, and write headline, source, and URL for the remaining articles into columns B through D
Your token list includes both crypto pairs like BTCUSD and standalone symbols like ETH
For each symbol in column A of my Excel workbook, determine whether it is formatted as a pair (e.g., BTCUSD) or a standalone ticker (e.g., ETH) and call the appropriate Finage news endpoint for each format, then write headline, source, and URL for the 5 most recent articles into columns B through D
You want to load news for all 8 tokens, deduplicate any article that appeared under multiple tokens, and rank unique headlines by token
For each token in column A, fetch the latest 5 news articles from Finage, write headline, source, and URL for each, then identify any article URL that appeared under more than one token and mark it "SHARED" in column E so you can decide whether to include it once or under each token in the briefing
One prompt handles the fetch, the deduplication logic, and the shared-article tagging together.
Try It
Open an Excel workbook with your crypto watchlist in column A. Get the 7-day free trial of SheetXAI and ask it to populate the latest Finage news headlines for every token before you write your morning briefing. You can also ask it to refresh the current price and 24-hour change for those same tokens, or return to the Finage hub for everything the integration covers.