The Scenario
It's 8:45 AM. You have a portfolio review with the investment committee at 9:30 and the dashboard you're presenting still shows yesterday's closing prices. The sheet has 35 holdings across columns A through D — symbol, price, dollar change, and percent change. You need all of it current before the first slide goes up.
The bad version:
- Open Twelve Data's quote endpoint in a browser tab, fetch the first symbol, copy the price and change values, and paste them into the correct row of the dashboard.
- Work your way down all 35 tickers one by one, switching between the browser and the sheet, keeping track of which row you're on.
- Notice around ticker 22 that you pasted a percent change into the dollar change column for three rows back. Fix them. Realize you've now used 25 minutes and still have 13 tickers to go.
The committee is gathering in the conference room. The dashboard is half-updated and the numbers you're showing are a mix of yesterday and today.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the list of tickers in column A and, through its built-in Twelve Data integration, fetches the live quote for each one and writes price, dollar change, and percent change into columns B, C, and D in a single pass. All 35 holdings update together.
Fetch the latest real-time quote from Twelve Data for each stock symbol in column A and write current price into column B, dollar change into column C, and percent change into column D.
What You Get
- Column B updated with the latest trade price for each holding.
- Column C showing the dollar change from the prior close.
- Column D showing the percent change formatted as a decimal (e.g., -0.023 for -2.3%).
- Any symbol with no quote available — halted trading, bad ticker — flagged in column E with a short error note instead of leaving the row stale.
What If the Data Is Not Quite Ready
If your ticker symbols include both US equities and ADRs with ambiguous formats
Fetch live quotes from Twelve Data for each symbol in column A. Where column B already contains an exchange code (NYSE, NASDAQ, LSE), pass that as a qualifier to resolve ambiguous symbols. Write current price, dollar change, and percent change into columns C, D, and E.
If you want to add a 52-week high/low comparison column alongside the live quote
Fetch live quotes and 52-week range data from Twelve Data for each ticker in column A. Write current price into column B, percent change into column C, 52-week high into column D, 52-week low into column E, and flag in column F whether the current price is within 5% of the 52-week high.
If some rows in column A are blank because the portfolio has empty placeholders
Skip any blank rows in column A. For all non-blank tickers, fetch the latest quote from Twelve Data and write current price into column B, dollar change into column C, and percent change into column D.
Kill-chain: clean tickers, fetch quotes, and flag positions down more than 5% today
Check column A for any tickers with extra whitespace or lowercase letters and normalize them. Then fetch live quotes from Twelve Data for each normalized symbol, write current price into column B, dollar change into column C, and percent change into column D. In column E, write DOWN 5%+ for any position where the percent change is worse than -5%, otherwise leave the cell blank.
One prompt normalizes the list, pulls the data, and applies the flag — committee-ready in under a minute.
Try It
Get the 7-day free trial of SheetXAI and open your portfolio dashboard, then ask it to refresh all live quotes across every row at once. For deeper analysis, see pulling historical closing prices or the full Twelve Data overview.