The Scenario
It's 7:45 AM and your trading session starts in 15 minutes. You want an Excel workbook with the top 10 gaining and top 10 losing US stocks from this morning — ticker, price, change amount, and change percent — so you can build a watchlist before the open. The data exists in Finage. Your workbook is empty.
The bad version:
- Go to Finage's market movers endpoint, retrieve the gainers list, copy the results, paste them into the top half of the worksheet.
- Go back, retrieve the losers, paste into the bottom half.
- Notice the column order from the API response doesn't match your worksheet headers and spend five minutes fixing the alignment manually.
By the time your workbook is ready, the pre-market window you wanted to analyze is gone.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the worksheet structure and talks to Finage on your behalf. It calls the market movers endpoint, retrieves both lists, and writes them into the correct sections of your workbook with the columns you specify.
Pull today's top 10 gaining and top 10 losing US stocks from Finage and fill my Excel sheet with ticker, price, change amount, and change percent
What You Get
- Gainers section: rows 1 through 11, with headers in row 1 and 10 gainers sorted by percent change descending
- Losers section: starts after a blank separator row, same column structure, sorted by percent change ascending
- All four fields — ticker, price, change amount, change % — written as properly typed numbers
What If the Data Is Not Quite Ready
You only want movers from a specific sector
Fetch the top 10 US stock gainers and top 10 losers from Finage, then filter to show only tickers in the Technology or Healthcare sector, and write ticker, price, change amount, and change % into my Market Movers worksheet
You want to cross-reference the movers against your existing watchlist on a separate worksheet
Fetch today's top 10 gainers and top 10 losers from Finage, write them into my Market Movers worksheet, and in column E mark any ticker that also appears in column A of my Watchlist worksheet with "ON WATCHLIST"
You want volume added as a fifth column
Fetch the top 10 US stock gainers and losers from Finage and write ticker, price, change amount, change %, and volume into my Market Movers worksheet in separate sections
You want to clear yesterday's data, reload today's movers, and immediately flag any with a change greater than 15%
Clear all rows below the header on my Market Movers worksheet, fetch today's top 10 gainers and losers from Finage, write ticker, price, change amount, and change % into the respective sections, and in column F flag any entry where the absolute percent change exceeds 15%
One prompt handles the stale data cleanup, the fresh pull, and the alert flag in a single operation.
Try It
Open an Excel workbook you use for your daily trading prep. Get the 7-day free trial of SheetXAI and ask it to populate today's market movers from Finage before the open. You can also ask it to enrich those tickers with live quotes, or return to the Finage hub for the full picture of what the integration handles.