The Scenario
You are a quant analyst. It is Tuesday morning. You have 200 S&P 500 tickers in an Excel workbook on the Screener tab and you want a buy signal list: all stocks where the 14-day RSI is below 30 and the 50-day SMA is above the 200-day SMA. You run this screen every Tuesday before the market opens.
The manual version:
- You look up the Alpha Vantage RSI endpoint, make a call for ticker one, parse the JSON
- You find the 14-day RSI value, check if it is below 30, note the result
- You make separate calls for SMA 50 and SMA 200 for ticker one
- You compare the two values
- You do all of this again for ticker two
- By ticker fifteen you have missed the pre-market window and the screen is useless.
The fast version is one prompt and the screen runs while the market is still dark.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your workbook that calls the Alpha Vantage technical indicator endpoints for every ticker and applies your signal logic automatically.
Open the SheetXAI sidebar and type:
For every ticker in column A of the Screener tab, fetch the current 14-day RSI from Alpha Vantage and flag stocks where RSI is below 30 in a column called 'Oversold'. Then calculate the 50-day and 200-day simple moving averages for all 200 tickers and mark stocks where SMA50 is greater than SMA200 as 'Golden Cross' in column F.
SheetXAI calls the RSI endpoint and both SMA endpoints for all 200 tickers, evaluates the conditions for each, and writes the flags into the workbook before you finish your first coffee.
What You Get
A screened ticker list with five columns of signal data on the Screener tab:
- Column B — 14-day RSI value for each ticker
- Column C — "Oversold" flag for RSI below 30
- Column D — SMA 50 value
- Column E — SMA 200 value
- Column F — "Golden Cross" flag for SMA 50 above SMA 200
The combined signal list writes itself. Any ticker that is both Oversold and Golden Cross appears in a summary section at the top of the workbook if you add that to the prompt.
Want MACD signal lines added to the screen? Add "also fetch the MACD histogram value for each ticker and flag those where the histogram crossed from negative to positive in the last 3 periods" and SheetXAI adds the column.
What If the Data Is Not Quite Ready
Technical screens at 200-ticker scale have real-world complications. SheetXAI handles them in the same prompt.
When some tickers have been added recently and lack enough history for a 200-day SMA
A new addition to the index does not have 200 days of data yet.
For tickers in the Screener tab where fewer than 200 trading days of data are available, write "INSUFFICIENT HISTORY" in column E instead of the SMA 200 value. Exclude those tickers from the Golden Cross flag in column F. Run the RSI screen on all tickers regardless of history length.
When you want to add Bollinger Band width to the screen
You want a volatility squeeze signal: flag stocks where the Bollinger Band width is in the bottom 20% of its 52-week range.
After writing RSI and SMA data on the Screener tab, fetch Bollinger Band upper and lower values for each ticker from Alpha Vantage. Calculate band width. Identify the 20th percentile of band width across all 200 tickers. Flag any ticker below that threshold in column G as "Squeeze."
When you want to rank the results rather than just flag them
You want the strongest buy signals at the top, not just a binary flag column.
After writing RSI, SMA 50, SMA 200, Oversold, and Golden Cross columns, add a column H "Signal Score" that adds 1 point for each signal condition met (Oversold = 1, Golden Cross = 1, RSI below 20 = 1 extra). Sort the Screener tab by Signal Score descending before writing the final output.
When you need the full buy signal report before the 8 AM standup
You have the ticker list and a 7:45 AM standup. You need RSI, both SMAs, the combined signal flags, a ranked score column, and a written summary of the top ten names.
For all 200 tickers in column A of the Screener tab, fetch 14-day RSI, SMA 50, and SMA 200 from Alpha Vantage. Write each into columns B through D. Flag RSI below 30 as "Oversold" in column E and SMA 50 above SMA 200 as "Golden Cross" in column F. Score each ticker in column G (1 point per signal met). Sort by score descending. Then write a summary section below the data listing the top 10 ranked tickers with a two-sentence explanation for each based on the technical data.
The pattern: the fetch, the signal logic, the ranking, and the written brief all run before the market opens.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with a ticker list, then ask it to run a technical indicator screen using Alpha Vantage. The Alpha Vantage integration is included in every SheetXAI plan. For related workflows, see how to pull price history and compute returns in Excel or the Alpha Vantage in Excel overview.