The Scenario
You're building a backtesting model in Python and your input data lives in a Google Sheet — 10 stock tickers in column A, one per row. The model expects daily OHLCV bars for the past year for each ticker, written below the ticker header in a consistent format. Right now, that data doesn't exist in the sheet.
The bad version:
- Write a one-off Python script to call the Finage historical bars endpoint for each ticker, handle pagination, flatten the response, and export to CSV.
- Import each CSV into the sheet separately, fix the date formatting, make sure the column order matches your model's expected schema.
- Realize ticker 7 returned bars in a different timezone offset and spend an hour tracking down why your model's alignment is off by one day.
Your model can't run until the data is in the right shape. Every hour spent wrangling the input format is an hour not spent on the model itself.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the tickers and talks to Finage for you. It calls the historical OHLCV endpoint for each symbol, handles the pagination, and writes the bars into the sheet in the structure you describe — no script, no CSV import, no format cleanup.
For each ticker in column A of my Google Sheet, fetch daily OHLCV data from Finage for the past 12 months and write date, open, high, low, close, and volume into the sheet starting at column B
What You Get
- Date column (column B): trading dates in YYYY-MM-DD format
- Columns C through G: open, high, low, close, volume — one row per trading day per ticker
- Each ticker's data written in a contiguous block below the ticker header
- Gaps in trading days (weekends, holidays) are excluded automatically rather than written as empty rows
What If the Data Is Not Quite Ready
You need a shorter lookback window — only the last 90 days instead of a full year
For each ticker in column A, fetch daily OHLCV bars from Finage for the past 90 calendar days and write them below the ticker header in columns B through G
One of your tickers is a crypto pair and you need 24/7 bars instead of market-hours bars
For each symbol in column A, determine whether it is an equity or a crypto asset and call the appropriate Finage endpoint — stock daily bars for equities, crypto daily bars for pairs like ETHUSD — then write date, open, high, low, close, and volume below each header
You want the bars written into separate sheets, one sheet per ticker
For each ticker in column A of my Index sheet, create a new sheet named after the ticker, then fetch 12 months of daily OHLCV data from Finage and write it there with date in column A and open, high, low, close, volume in columns B through F
You want to drop any bars where volume was zero, add a daily return column, and load the result in one pass
For each ticker in column A, fetch 12 months of daily OHLCV bars from Finage, exclude any rows where volume is 0, add a column G that calculates the daily return as (close - prev close) / prev close, and write everything below the ticker header
One prompt handles the data fetch, the filter, and the derived column calculation together.
Try It
Open a Google Sheet with your backtest ticker list in column A. Get the 7-day free trial of SheetXAI and ask it to load the full historical OHLCV series from Finage. You can also ask it to enrich those same tickers with real-time quotes, or head back to the Finage hub for the complete list of what the integration supports.