The Scenario
You manage a multi-sector equity portfolio and you run a sector rotation model every Monday. The model needs daily change, weekly change, and YTD return for every US market sector in a Google Sheet — 11 rows of numbers that drive allocation decisions for the week. Right now, you pull them by visiting three different aggregator pages, comparing numbers across tabs, and hoping you're reading the same calculation methodology in each place.
A stakeholder asked to join your Monday rotation call starting next week. The data quality bar just moved.
The bad version:
- Open Finage's sector performance endpoint, retrieve the JSON response, parse out the fields you need for each sector.
- Paste 11 sector names, 11 daily change values, 11 weekly change values, and 11 YTD returns into four separate columns.
- Notice that two of the sector names from Finage don't match the labels your model uses, and spend 20 minutes fixing the mapping before your formulas will run.
Your model produces the rotation signal. Getting the input data into the right shape is not the model's job — it shouldn't be yours either.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the sheet and calls Finage on your behalf. It retrieves the sector performance data, maps the fields, and writes all four metrics for all 11 sectors into the rows and columns you specify.
Fetch US sector performance data from Finage and write sector name, daily change percent, weekly change, and YTD return into my Google Sheet
What You Get
- Column A: sector name, standardized (e.g., Technology, Healthcare, Energy, Financials)
- Column B: daily change expressed as a percentage
- Column C: weekly change expressed as a percentage
- Column D: YTD return expressed as a percentage
- All 11 standard GICS sectors written in a single contiguous block, ready to sort
What If the Data Is Not Quite Ready
Your model also needs 1-month and 3-month returns for each sector
Fetch US sector performance from Finage and write sector name, daily change, weekly change, 1-month return, 3-month return, and YTD return into columns A through F of my Sector Rotation sheet
You want to rank sectors by YTD return and add a momentum rank column
Fetch US sector performance from Finage, write sector, daily change, weekly change, and YTD return into columns A through D, then add column E with each sector's rank by YTD return descending so rank 1 is the top-performing sector
You want to compare this week's sector rankings to last week's, which are stored in a separate sheet
Fetch current US sector performance from Finage, write sector name, daily change, weekly change, and YTD return into columns A through D of my Current Week sheet, then in column E calculate the change in YTD return rank compared to the same sector's position in my Prior Week sheet
You want to clear stale data, reload this week's figures, rank by YTD return, and add a rotation signal column in one pass
Clear all data below the header on my Sector Rotation sheet, fetch current US sector performance from Finage, write sector, daily change, weekly change, and YTD return, add a YTD rank column, and in column F write "OVERWEIGHT" for the top 3 ranked sectors and "UNDERWEIGHT" for the bottom 3
One prompt handles the data pull, the ranking logic, and the allocation signal together.
Try It
Open a Google Sheet you use for your sector rotation model. Get the 7-day free trial of SheetXAI and ask it to populate current Finage sector performance data with the ranking logic you use. You can also ask it to pull individual sector ETF quotes, or return to the Finage hub for the full integration overview.