The Scenario
Your board deck goes out Thursday morning. It's Tuesday at 4 PM.
The portfolio summary tab is supposed to show 1-year price performance and the latest news headline for each of the 10 tickers in column A. Last quarter you built that manually — opening the Composio Search Finance API tab, querying each ticker one at a time, copying the percentage change into column B, the current price into column C, and then doing the same song for headlines in columns D and E.
The bad version:
- Query the first ticker in the Finance API, copy the 52-week change, paste it into B2. Realize the API returned a decimal but the column is formatted as text. Reformat. Paste again.
- Move to headlines. Search the news endpoint for the same ticker, find the most recent result, copy the title and date. Paste into D2 and E2. Repeat nine more times.
- Halfway through, the tab crashes. You reopen it and spend 10 minutes checking whether the pastes you already did are still there.
The deck is going to a room of people who will ask follow-up questions about these numbers. Showing up with four tickers updated and six still blank from last quarter is not a version of prepared.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data in your open tab and talks to Composio Search Finance on your behalf — for every row in your list, all at once. No API tab switching, no copy-paste, no row-by-row querying.
For each ticker in column A, fetch the 1-year weekly closing price history from Composio Search Finance, calculate the percentage change from 52 weeks ago to today, and write the percentage change into column B and the current price into column C. Then pull the most recent financial news headline and publication date for each ticker and write them into columns D and E.
One prompt. All 10 tickers. The whole table filled.
What You Get
- Column B: 52-week percentage change for each ticker, expressed as a percentage
- Column C: Current price pulled from the Finance API
- Column D: Most recent news headline for the ticker from Composio Search
- Column E: Publication date of that headline
- Any tickers that return no data are flagged in the cell rather than left blank
What If the Data Is Not Quite Ready
The ticker list has inconsistent formatting
Some rows have the ticker in lowercase, some have exchange prefixes, some have trailing spaces from a copy-paste.
Normalize the values in column A — strip whitespace, convert to uppercase, remove any exchange prefix before the colon — then fetch the Composio Search Finance data for each cleaned ticker and write results into columns B through E.
Some tickers are international and need a different data source
Column A has a mix of US and London Stock Exchange tickers. The LSE ones need a different endpoint query.
For each ticker in column A, check whether it ends in '.L' to identify London Stock Exchange listings. Query Composio Search Finance accordingly and write the 1-year percentage change and current price into columns B and C for all tickers regardless of exchange.
The sheet has multiple portfolio tabs and you want to run it across all of them
You have tabs named "Growth," "Income," and "Speculative." Each has tickers in column A.
For each tab in this workbook named Growth, Income, and Speculative, fetch the 1-year percentage change and current price from Composio Search Finance for each ticker in column A and write results into columns B and C on that same tab.
One shot: clean, enrich, and flag underperformers
Normalize all tickers in column A, fetch 1-year price performance and the latest news headline from Composio Search Finance, write percentage change into column B, current price into column C, headline into column D, and date into column E. Then mark any ticker with a negative 1-year return in red in column F labeled 'Underperform'.
Ask for the cleanup, the enrichment, and the analysis in the same breath — SheetXAI handles all three in sequence.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your ticker watchlist. Ask it to pull a year of price history and the latest headline for every row. Link to the sibling spoke: Bulk Amazon Product Research Into a Google Sheet With Composio Search. Or go back to the Composio Search overview.