The Scenario
You swing-trade equities. Your edge is entering early in a confirmed trend before the momentum crowd arrives. You've built a 30-ticker dashboard in Google Sheets, and there's a column called "Trend Strength" that's been blank for three weeks because populating it is a multi-step manual process involving two separate Twelve Data endpoints and a judgment call you have to make per ticker.
The column exists. It just doesn't have data in it.
The bad version:
- Call the Aroon indicator endpoint for the first ticker, extract Aroon Up and Aroon Down, compare them, decide on UPTREND/DOWNTREND/NEUTRAL, and manually write the label.
- Call the MACD endpoint for the same ticker to get the crossover status, compare with the Aroon signal, and decide how to weight them in the composite label.
- Repeat for 29 more tickers, spending about 90 seconds per ticker and ending up with a column that reflects a blend of your manual judgment and whatever your attention span was like when you hit ticker number 24.
The signal is in the data. The problem is getting it out fast enough to be useful.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the 30 tickers in column A and, through its built-in Twelve Data integration, fetches Aroon and MACD data for each ticker and writes signal labels into the specified columns.
Fetch Aroon indicator values from Twelve Data for each stock in column A. Write Aroon Up into column B and Aroon Down into column C. In column D, write UPTREND if Aroon Up is above 70 and Aroon Down is below 30, DOWNTREND if Aroon Down is above 70 and Aroon Up is below 30, and NEUTRAL otherwise. Also fetch the latest MACD crossover status and write BULLISH CROSS or BEARISH CROSS into column E where a crossover occurred in the last 3 periods, otherwise write FLAT.
What You Get
- Aroon Up and Aroon Down values in columns B and C, reflecting the most recent completed period.
- A trend label in column D — UPTREND, DOWNTREND, or NEUTRAL — based on the Aroon thresholds.
- Column E showing recent MACD crossover events, giving you a second directional confirmation per ticker.
- Tickers where Aroon returned no data (insufficient history or unavailable symbol) noted in column F.
What If the Data Is Not Quite Ready
If you want Ichimoku Cloud data instead of Aroon for trend direction
Fetch the latest Ichimoku Cloud values from Twelve Data for each ticker in column A. Write Tenkan-sen into column B, Kijun-sen into column C. In column D, write BULLISH if price in column E is above the cloud (Senkou Span A and B both below price), BEARISH if price is below the cloud, and NEUTRAL if price is inside the cloud.
If you want to see Aroon values over the past 10 days to confirm a trend is holding
Fetch Aroon Up and Aroon Down from Twelve Data for each ticker in column A for the last 10 trading days. Write each day's Aroon Up and Aroon Down into a side-by-side grid with dates as column headers, so you can see whether each ticker's trend signal is stable or oscillating.
If your dashboard already has a price column and you want to compare price direction with Aroon
For each ticker in column A, fetch Aroon Up and Aroon Down from Twelve Data and write them into columns B and C. Write the trend label into column D. Then compare the Aroon trend label with the price change in column E (positive or negative) and write ALIGNED if the Aroon trend and price direction agree, DIVERGING if they disagree, into column F.
Kill-chain: fetch Aroon and MACD, label trend strength, and sort the dashboard by signal quality
Fetch Aroon Up and Aroon Down from Twelve Data for each ticker in column A and write into columns B and C. Write UPTREND, DOWNTREND, or NEUTRAL into column D. Fetch MACD crossover status and write into column E. Create a composite signal score in column F: 2 points for UPTREND with a BULLISH CROSS, 1 point for UPTREND with FLAT, 0 for NEUTRAL, -1 for DOWNTREND with FLAT, -2 for DOWNTREND with a BEARISH CROSS. Sort the dashboard rows from highest to lowest composite score.
Try It
Get the 7-day free trial of SheetXAI and open your swing-trading dashboard with tickers in column A, then ask it to populate the full trend-strength column in one pass. Also see adding RSI and MACD indicators and the full Twelve Data overview.