The Scenario
It's 7:45 AM and your trading session starts in 15 minutes. You want a Google Sheet with the top 20 US stock gainers and top 20 losers from this morning — symbol, company name, price, and percent change — so you can build a watchlist before the open. The data exists in Finage. Your sheet 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 your sheet.
- Go back, retrieve the losers, paste into the bottom half.
- Notice the column order from the API response doesn't match your sheet headers and spend five minutes fixing the alignment manually.
By the time your sheet 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 Google Sheet that reads the sheet 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 sheet with the columns you specify.
Fetch the top 20 US stock gainers and top 20 losers from Finage and write symbol, company name, price, and percent change into separate sections of my Google Sheet
What You Get
- Gainers section: rows 1 through 21, with headers in row 1 and 20 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 — symbol, company name, price, change % — written as properly typed numbers and text
What If the Data Is Not Quite Ready
You only want movers from a specific sector
Fetch the top 20 US stock gainers and top 20 losers from Finage, then filter to show only tickers in the Technology or Healthcare sector, and write the filtered results with symbol, company name, price, and change % into my Market Movers sheet
You want to cross-reference the movers against your existing watchlist on a separate sheet
Fetch today's top 20 gainers and top 20 losers from Finage, write them into my Market Movers sheet, and in column E mark any ticker that also appears in my Watchlist sheet with "ON WATCHLIST"
You want volume added as a fifth column
Fetch the top 20 US stock gainers and losers from Finage and write symbol, company name, price, change %, and volume into my Market Movers sheet 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 sheet, fetch today's top 20 gainers and losers from Finage, write symbol, company name, price, 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 a Google Sheet 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.