The Scenario
You run a quantitative equity strategy. Every Sunday evening you sit down to update the momentum screen for Monday's review. Fifty tickers in an Excel workbook, and you need the 14-day RSI, MACD histogram, and Bollinger Band width for each one populated before the week starts.
Your current process is three separate API calls per ticker. Fifty tickers, three calls each, 150 total operations. You've built macros that automate parts of it, but the macros break when Twelve Data updates its response schema, which happened twice last quarter. The last time it broke, you didn't notice until Tuesday.
The bad version:
- Run the RSI macro. Check the output log. Fix the three tickers the macro skipped because their response format was slightly different.
- Run the MACD macro. Notice the histogram field is in a different JSON path than last quarter and update the macro before it will run again.
- Calculate Bollinger Band width manually as (upper - lower) / midline for each of the 50 rows because the macro for that indicator never quite worked right and you've been doing it by hand.
The screen is supposed to save time. Maintaining the plumbing that makes the screen work costs more time than the screen saves.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the 50 tickers in column A and, through its built-in Twelve Data integration, fetches RSI, MACD histogram, and Bollinger Band data for each ticker and writes all values in one pass — no macros, no schema maintenance.
Calculate the 14-day RSI for each ticker in column A using Twelve Data daily data and write the latest value into column B. Flag values above 70 as OVERBOUGHT and below 30 as OVERSOLD in column C. Fetch the MACD histogram from Twelve Data and write into column D. Fetch 20-period Bollinger Bands and calculate bandwidth as (upper - lower) / midline, writing the result into column E.
What You Get
- Column B: latest 14-day RSI value for each ticker.
- Column C: OVERBOUGHT, OVERSOLD, or blank.
- Column D: latest MACD histogram value.
- Column E: Bollinger Band width as a decimal ratio.
- Tickers with insufficient price history for either indicator flagged with N/A DATA in column F.
What If the Data Is Not Quite Ready
If you want to add the MACD signal line alongside the histogram
Fetch MACD values from Twelve Data for each ticker in column A. Write the MACD line into column B, signal line into column C, and histogram into column D. In column E, write BULLISH CROSS if the MACD line crossed above the signal line in the most recent period, BEARISH CROSS if it crossed below, otherwise FLAT.
If some tickers were recently listed and don't have enough history for the 14-period RSI
Fetch the 14-day RSI from Twelve Data for each ticker in column A. Where fewer than 14 trading days of history exist, write INSUFFICIENT HISTORY in column B. For all other tickers, write the RSI value and apply the OVERBOUGHT/OVERSOLD flags in column C.
If you want to scope the screen to a past date for backtesting
Fetch the 14-day RSI from Twelve Data for each ticker in column A as of the date in column B. Write the RSI value as of that date into column C. Flag OVERBOUGHT or OVERSOLD in column D. This lets you replay the screen as of any historical date to evaluate signal quality.
Kill-chain: fetch all three indicators, build a composite momentum score, and surface the top 10
Fetch 14-day RSI, MACD histogram, and 20-period Bollinger Band width from Twelve Data for each ticker in column A. Write into columns B, C, D. In column E, calculate a composite momentum score: RSI normalized 0 to 1, plus MACD sign (1 if positive, 0 if negative), plus inverse bandwidth normalized 0 to 1 (tighter bands score higher). Write the composite into column E. Rank tickers from highest to lowest in column F. Highlight the top 10 rows in green.
Try It
Get the 7-day free trial of SheetXAI and open your Excel momentum screen with tickers in column A, then ask it to populate all three indicator columns in one prompt — no macros required. Also see enriching a volatility report with band metrics and the full Twelve Data overview.