The Scenario
You day-trade US equities. Every morning before the open you want a seed list — the stocks moving the most in pre-market, ranked by percent change, with volume attached. You've been building this manually by scrolling through a screener, copy-pasting tickers and change percentages into a Google Sheet, and adding volume from a separate column on a different site.
It's 8:45 AM. The sheet has 12 tickers in it. You need 40 before the bell.
The bad version:
- Scroll through the top gainers list, copy the first 20 tickers with percent change and volume into the sheet.
- Switch to the top losers list, copy the next 20.
- Realize the volume figures from the two sources are in different units — one is in shares, the other in thousands of shares — and spend 10 minutes normalizing before you can rank the combined list.
The session opens at 9:30. Your watchlist is half-ready and the pre-market movers from 8:45 are already 45 minutes stale.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. Through its built-in Twelve Data integration, it fetches today's top gainers and losers for the US market and writes them into your sheet with consistent formatting.
Fetch today's top 20 US stock market gainers from Twelve Data and write symbol, company name, percent change, and volume into columns A through D. Then fetch the top 20 losers and append them below with a LOSERS header row separating the two sections.
What You Get
- Top 20 gainers written into rows 1 through 20 with symbol, company name, percent change, and volume.
- A LOSERS header row followed by the top 20 losers in the same column format.
- Volume expressed in shares (not thousands or millions) so the column is directly comparable across all 40 rows.
- The time of the fetch written into a header cell so you know the snapshot age.
What If the Data Is Not Quite Ready
If you want to filter to only stocks above a minimum volume threshold to exclude thinly traded movers
Fetch the top 20 US market gainers from Twelve Data. Filter to only stocks where volume exceeds 500,000 shares. Write symbol, percent change, volume, and current price into columns A through D. If fewer than 20 results clear the volume threshold, write however many qualify.
If you want pre-market movers rather than regular-session movers
Fetch today's pre-market top 10 gainers and top 10 losers from Twelve Data for the US equities market. Write symbol, percent change, and pre-market volume into columns A, B, and C. Separate gainers and losers with a header row.
If you want to cross-reference the movers list against your existing watchlist
Fetch today's top 20 US market gainers from Twelve Data and write them into columns A through D. Then check whether any symbol in column A also appears in the watchlist in column F. Write WATCHLIST MATCH in column E for any overlap.
Kill-chain: fetch gainers and losers, filter by volume and float, and flag high-conviction setups
Fetch the top 20 US market gainers and top 20 losers from Twelve Data. Write symbol, percent change, volume, and current price into columns A through D. Fetch float data from Twelve Data for each symbol and write into column E. Calculate a relative volume score (today's volume divided by average 30-day volume from Twelve Data) and write into column F. Flag any stock with relative volume above 3x as HIGH RVOL in column G. Sort each section (gainers and losers separately) from highest to lowest relative volume score.
Try It
Get the 7-day free trial of SheetXAI and open your morning watchlist sheet, then ask it to pull today's top gainers and losers from Twelve Data and populate the full list before the session opens. Also see refreshing live portfolio quotes and the full Twelve Data overview.