📊 Yahoo Finance - Analysis-Ready (SMA, EMA, RSI, MACD, ATR...)

Your Financial Data Automation Powerhouse

Stop wasting time calculating technical indicators manually. Get analysis-ready financial data with pre-calculated indicators delivered in automation-friendly JSON format. Perfect for n8n, Make, Zapier, and any workflow automation platform that needs reliable financial data.

🎯 Built for Automation Engineers

This actor is specifically designed for:

• Workflow Builders creating automated financial dashboards
• Data Pipeline Architects needing clean financial datasets
• Automation Engineers integrating financial data into business processes
• Backtesting Systems requiring historical data with indicators

🚀 Zero-Code Technical Analysis

We handle all the complex calculations so you don't have to. Every data row comes enriched with 17+ pre-calculated technical indicators across four categories:

📈 Trend Indicators

• SMA_50, SMA_100, SMA_200 - Simple Moving Averages (50, 100, 200 periods)
• EMA_50, EMA_100, EMA_200 - Exponential Moving Averages (50, 100, 200 periods)
• MACD, MACD_Signal, MACD_Hist - Moving Average Convergence Divergence
• ADX_14 - Average Directional Index (14 periods)

⚡ Momentum Indicators

• RSI_14 - Relative Strength Index (14 periods)
• STOCH_k, STOCH_d - Stochastic Oscillator (%K and %D)

📊 Volatility Indicators

• ATR_14 - Average True Range (14 periods)
• BB_Upper, BB_Mid, BB_Lower - Bollinger Bands (20 periods, 2 std dev)

📈 Volume Indicators

• OBV - On-Balance Volume
• VWAP - Volume-Weighted Average Price

⚙️ Input Configuration Guide

Based on .actor/input_schema.json, configure your data requests:

1. Queries (Required)

Define what assets to download. Maximum 10 items per run.

Parameter	Type	Description	Options / Examples
ticker	String	Yahoo Finance symbol (case-insensitive)	AAPL, TSLA, BTC-USD, EURUSD=X, ^GSPC
interval	String	Candle time granularity	1d (Daily) 1wk (Weekly) 1mo (Monthly)
period	String	Historical time range	1d, 3d, 1wk, 1mo, 3mo, 6mo, 1y, 2y, 5y, ytd, max

2. Proxy Configuration (Recommended)

Enable Apify Proxy to prevent Yahoo Finance blocking:

{
  "proxyConfiguration": {
    "useApifyProxy": true
  }
}

Why use proxy?

• ✅ Prevents 429 Too Many Requests errors
• ✅ Ensures 99%+ reliability for scheduled automation
• ✅ Residential IPs avoid detection
• ❌ Disabled = Faster but risk of blocking

📋 Example Input Configurations

Basic Single Asset

{
  "queries": [
    { "ticker": "AAPL", "interval": "1d", "period": "1y" }
  ],
  "proxyConfiguration": { "useApifyProxy": true }
}

Multi-Asset Portfolio (Max 10)

{
  "queries": [
    { "ticker": "AAPL", "interval": "1d", "period": "1y" },
    { "ticker": "MSFT", "interval": "1d", "period": "1y" },
    { "ticker": "BTC-USD", "interval": "1d", "period": "1y" }
  ],
  "proxyConfiguration": { "useApifyProxy": true }
}

Weekly Report Data

{
  "queries": [
    { "ticker": "SPY", "interval": "1wk", "period": "5y" }
  ],
  "proxyConfiguration": { "useApifyProxy": true }
}

⚠️ Critical: Time Window Requirements

Technical indicators require sufficient historical data. If your period is too short, you'll get null values for indicators that can't be calculated.

Minimum Periods to Avoid Null Values:

Indicator	Minimum Data Points	Daily (1d)	Weekly (1wk)	Monthly (1mo)
SMA_50	50 periods	~3 months	~1 year	~4 years
SMA_200	200 periods	~1 year	~4 years	~16 years
RSI_14	14 periods	~1 month	~4 months	~14 months
MACD	35 periods	~2 months	~9 months	~3 years
Bollinger Bands	20 periods	~1 month	~5 months	~20 months

Recommendation: Use "period": "1y" or longer for daily data to ensure all indicators calculate properly.

🔧 Automation Integration Examples

n8n Workflow Integration

1. Add Apify node to your workflow
2. Configure with actor ID and input
3. Process JSON output with Function or Set nodes
4. Send to Google Sheets, databases, or alert systems

Make (Integromat) Scenario

1. Use HTTP module to trigger actor
2. Parse JSON response
3. Route data to CRM, email, or reporting tools
4. Schedule with Schedule module

Webhook Configuration

Trigger runs via webhooks for real-time data pipelines:

• Market close alerts
• Daily portfolio updates
• Real-time monitoring systems

📊 Output Data Structure

Clean, predictable JSON perfect for automation parsing:

[
  {
    "ticker": "AAPL",
    "date": "2024-01-02T00:00:00",
    "open": 185.20,
    "high": 186.45,
    "low": 184.75,
    "close": 185.85,
    "volume": 45678900,
    "SMA_50": 182.34,
    "RSI_14": 58.4,
    "MACD": 1.25,
    "ATR_14": 2.34,
    // ... all other indicators
  }
]

Column Order (Consistent for Reliable Mapping)

1. ticker, date
2. Price data: open, high, low, close, volume
3. Volume indicators: VWAP, OBV
4. Trend indicators: SMA_50, SMA_100, SMA_200, EMA_50, EMA_100, EMA_200
5. Momentum: RSI_14, ADX_14, MACD, MACD_Signal, MACD_Hist, STOCH_k, STOCH_d
6. Volatility: ATR_14, BB_Upper, BB_Mid, BB_Lower

🛠️ Best Practices for Automation

1. Scheduling Recommendations

• Daily runs: Schedule 1 hour after market close (5 PM EST)
• Weekly runs: Monday morning for previous week's data
• Avoid: Market hours (9:30 AM - 4 PM EST) due to data volatility

2. Error Handling

• Monitor for 429 errors (enable proxy if occurring)
• Implement retry logic for failed runs
• Validate data completeness before processing

3. Processing Large Portfolios

10-asset limit workaround:

1. Split large portfolios into batches of 10
2. Run sequentially with 1-minute delays
3. Aggregate results in your automation workflow

4. Data Validation

• Check for null values in critical indicators
• Verify date ranges match expected periods
• Validate ticker symbols return data

❓ Frequently Asked Questions

Q: How do I connect this to Google Sheets?

A: Use Apify's Google Sheets integration or n8n/Make connectors. The consistent JSON structure makes mapping straightforward.

Q: Can I process more than 10 tickers?

A: Yes, split into multiple runs. Each run handles max 10 tickers. Schedule sequential runs with your automation tool.

Q: What about weekends and holidays?

A: Yahoo Finance returns no data for non-trading days. Your automation should handle gaps in date sequences.

Q: How fresh is the data?

A: Data is typically available 15-60 minutes after market close. For real-time data, consider live data sources instead.

Q: Why do I see null values for some indicators?

A: The period is too short. Extend your period parameter (recommend "1y" minimum for daily data).

Q: Is this financial advice?

A: NO. This actor provides historical data and technical indicators for informational purposes only. All investment decisions are your responsibility.

📈 Sample Automation Workflows

Daily Portfolio Data Collection

1. Schedule daily run for 10 portfolio assets
2. Collect price data and technical indicators
3. Store in database or cloud storage
4. Update reporting dashboards

Weekly Market Report Generation

1. Run every Monday for key market indices
2. Aggregate weekly price movements
3. Generate summary reports with charts
4. Distribute to stakeholders

Cryptocurrency Market Monitoring

1. Monitor BTC-USD, ETH-USD daily
2. Track price movements and volatility
3. Log historical data for analysis
4. Generate market insight reports

⚖️ Limitations & Considerations

• Max 10 tickers per run - Split larger portfolios
• Yahoo Finance rate limits - Use proxy for reliability
• Market hours data - Most accurate after market close
• Historical data only - Not for real-time trading

🚀 Get Started

1. Configure your input with tickers and periods
2. Enable proxy for reliable execution
3. Schedule runs in your automation platform
4. Process the clean JSON output

Start automating your financial data workflows today!

---

Disclaimer: This actor provides historical financial data and technical indicators for informational purposes only. The data comes from Yahoo Finance and its accuracy is not guaranteed. This is not financial advice. Always conduct your own research and consult with financial professionals before making investment decisions.