Best Practices

Recommended setup

Match interval to your use case

Use daily (`1d`) for portfolio tracking and long-term analysis. Reserve intraday intervals (`1m`, `5m`) only for short-term or algorithmic work — they're restricted to recent data and generate far more rows.

Group tickers into one data flow

Enter multiple tickers as a comma-separated list in a single source rather than creating one data flow per ticker. This keeps your workspace tidy and reduces the number of API calls you make.

Use Append for multi-account or multi-source setups

If you need to pull tickers from different API keys (e.g., separate team accounts), set up separate sources and use Coupler.io's Append transformation to merge them into one unified dataset at the destination.

Data refresh and scheduling

Schedule after market close for daily data

If you're pulling daily prices, schedule your data flow to run after the market closes (e.g., after 4:30 PM ET for US stocks) so you always capture the final settled close price rather than an intraday snapshot.

Don't over-refresh intraday data

Pulling 1-minute data every few minutes burns through your API quota quickly. Match your refresh frequency to your actual decision-making cadence — hourly refreshes are sufficient for most intraday monitoring needs.

Performance optimization

Use longer intervals with the `max` range

If you need the full price history of a stock, use `1mo` or `1wk` intervals instead of `1d`. Daily data going back decades can produce tens of thousands of rows, which slows down spreadsheets and increases processing time.

Store snapshots instead of overwriting

Because Adjusted Close values can change retroactively, consider appending each data pull to a historical log rather than replacing it. This gives you a stable audit trail for return calculations.

Common pitfalls

Do not combine short intervals with long date ranges — Yahoo Finance will return no data and your data flow will appear to succeed but produce empty results. Always verify the interval/range compatibility before scheduling.

Do

• Verify ticker symbols on Yahoo Finance before adding them to a data flow

• Use Adjusted Close for return and performance calculations

• Test with a single ticker first before adding a large list

• Check your API plan's monthly request limit before scheduling frequent refreshes

Don't

• Use 1m or 5m intervals with date ranges longer than 7 days

• Assume gaps in the data are a bug — weekends and holidays are always missing

• Overwrite historical price data in place if you need stable Adjusted Close records

• Add dozens of tickers without checking whether your API plan supports the request volume