> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/finance-and-accounting/yahoo-finance-price.md).

# Yahoo Finance Price

Pull stock, ETF, and index prices from Yahoo Finance into Google Sheets or BigQuery. Track open, high, low, close, volume data across multiple tickers.

Yahoo Finance Price gives you historical and intraday stock price data for any publicly traded ticker. Connect it to Coupler.io to pull open, high, low, close, and volume data into your preferred destination — no manual downloads required.

## Why connect Yahoo Finance Price to Coupler.io?

* **Track multiple tickers at once** — pull data for any combination of stocks, ETFs, or indices in a single data flow
* **Flexible intervals** — from 1-minute granularity all the way to monthly bars, depending on your analysis needs
* **Automate your market data pipeline** — schedule refreshes so your dashboards and models always reflect the latest prices
* **Send data anywhere** — Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like ChatGPT, Claude, or Gemini

## Prerequisites

* A **RapidAPI** account with access to the Yahoo Finance API (or a compatible Yahoo Finance API key)
* Your **API key** from the provider — you'll paste this into Coupler.io during setup
* The ticker symbols you want to track (e.g., `AAPL`, `GOOGL`, `MSFT`)

## Quick start

{% hint style="success" %}
If you want to compare prices across multiple tickers, enter them as a comma-separated list in the **Stock tickers** field. You can also create separate sources for each ticker and use the **Append** transformation to combine them into one dataset.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Create a new data flow in Coupler.io.** Log in to your Coupler.io account, go to **Data flows**, and click **Add data flow**. Select **Yahoo Finance Price** as your source.
{% endstep %}

{% step %}
**Enter your API key.** Paste your Yahoo Finance API key into the credentials field. This authenticates Coupler.io to fetch price data on your behalf.
{% endstep %}

{% step %}
**Configure your source settings.** Enter the stock tickers you want to track (comma-separated), choose a **Price interval** (e.g., `1d` for daily), and select a **Date range** (e.g., `1y` for the past year).
{% endstep %}

{% step %}
**Choose your destination.** Select where you want the data sent — Google Sheets, BigQuery, Excel, Looker Studio, or an AI destination like ChatGPT or Claude.
{% endstep %}

{% step %}
**Run the data flow.** Click **Run** to execute your first manual sync and confirm the data loads correctly.
{% endstep %}
{% endstepper %}

## Yahoo Finance Price data overview

The Yahoo Finance Price source returns price history for any publicly traded stock, ETF, or index. You configure which tickers to pull, how granular the data should be, and how far back it should go.

## Available entity

| Entity | Description                                                                  |
| ------ | ---------------------------------------------------------------------------- |
| Prices | OHLCV price bars for one or more tickers at a chosen interval and date range |

## Available fields

#### Price data

| Field          | Type     | Description                                   |
| -------------- | -------- | --------------------------------------------- |
| Ticker         | String   | The stock symbol (e.g., AAPL, MSFT)           |
| Timestamp      | DateTime | The date and time of the price bar            |
| Open           | Number   | Opening price for the interval                |
| High           | Number   | Highest price during the interval             |
| Low            | Number   | Lowest price during the interval              |
| Close          | Number   | Closing price for the interval                |
| Adjusted Close | Number   | Close price adjusted for splits and dividends |
| Volume         | Number   | Number of shares traded during the interval   |

#### Interval options

| Interval | Label      |
| -------- | ---------- |
| 1m       | 1 minute   |
| 5m       | 5 minutes  |
| 15m      | 15 minutes |
| 30m      | 30 minutes |
| 90m      | 90 minutes |
| 1h       | 1 hour     |
| 1d       | 1 day      |
| 5d       | 5 days     |
| 1wk      | 1 week     |
| 1mo      | 1 month    |
| 3mo      | 3 months   |

#### Date range options

| Range | Label                     |
| ----- | ------------------------- |
| 1d    | 1 day                     |
| 5d    | 5 days                    |
| 7d    | 7 days                    |
| 1mo   | 1 month                   |
| 3mo   | 3 months                  |
| 6mo   | 6 months                  |
| 1y    | 1 year                    |
| 2y    | 2 years                   |
| 5y    | 5 years                   |
| ytd   | Year to date              |
| max   | Maximum available history |

## Common field combinations

* **Close + Timestamp** — the minimum you need for a price chart or trend line
* **Open + Close + Volume** — useful for identifying trading sessions with above-average activity
* **High + Low + Close** — inputs for volatility indicators like ATR or Bollinger Bands
* **Adjusted Close** — preferred for long-term return calculations because it accounts for splits and dividends
* **Ticker + Close + Timestamp** — essential when tracking multiple symbols side by side

## Use cases by role

{% tabs %}
{% tab title="Finance teams" %}

* Pull daily closing prices for a portfolio of holdings into Google Sheets or Excel to calculate returns, drawdowns, and correlations
* Use the **Append** transformation to combine price history from multiple tickers into a single table for portfolio-level analysis
* Send historical price data to BigQuery and join it with your internal transaction records to calculate cost-basis and P\&L
* Use the `max` date range with `1mo` intervals to build long-term performance charts in Looker Studio
  {% endtab %}

{% tab title="Analysts & Researchers" %}

* Pull intraday data (`1m` or `5m` interval) for short-term pattern analysis or backtesting trading strategies
* Combine Yahoo Finance Price data with macroeconomic datasets using Coupler.io's **Join** transformation
* Send price data to AI destinations like ChatGPT or Claude to generate plain-language summaries of recent price movements
* Use `ytd` range with `1d` interval to benchmark a watchlist of stocks against each other year-to-date
  {% endtab %}

{% tab title="Product & Operations" %}

* Track the price of publicly listed competitors or suppliers on a scheduled basis to inform procurement or strategy decisions
* Set up a data flow pulling weekly prices (`1wk` interval) into a shared Google Sheet that stakeholders can view without any finance tooling
* Use Gemini or Perplexity as a destination to ask questions about price trends in natural language
  {% endtab %}
  {% endtabs %}

## Platform-specific notes

* Intraday intervals (`1m` through `1h`) are only available for recent date ranges — typically the last 7–60 days depending on the interval. Using a long date range with a short interval may return no data or an error.
* The `max` date range returns the full available history for the ticker, which can be very large for frequently traded stocks — consider using `1mo` or `3mo` intervals with `max` to keep row counts manageable.
* Adjusted Close values are recalculated retroactively when splits or dividends occur, so historical values may shift slightly between pulls.
* Yahoo Finance data is sourced from exchanges and may have a 15-minute delay for some markets during trading hours.

## Yahoo Finance Price common issues

### Connection issues

<details>

<summary>My API key is not being accepted</summary>

Double-check that you've copied the full API key without any leading or trailing spaces. If you're using a RapidAPI-hosted Yahoo Finance API, make sure your subscription to that specific API is active — having a RapidAPI account alone isn't enough. You also need to verify that your plan hasn't exceeded its monthly request quota.

</details>

<details>

<summary>The data flow fails immediately after I run it</summary>

This usually means the API key is invalid or the API endpoint is unreachable. Try pasting your key into the provider's own test console to confirm it's working, then re-enter it in Coupler.io.

</details>

### Missing data

<details>

<summary>No data is returned for my selected interval and date range</summary>

Certain interval and date range combinations are not supported by Yahoo Finance. Specifically, short intervals like `1m` or `5m` are only available for very recent periods (typically 7 days or less). If you select `1m` with a `1y` range, the API will return nothing. Switch to a longer interval (e.g., `1d`) or a shorter date range (e.g., `7d`) for intraday data.

</details>

<details>

<summary>Some dates are missing from the results</summary>

Yahoo Finance does not return data for market holidays, weekends, or trading halts. Gaps in the data for those dates are expected and not a Coupler.io issue.

</details>

<details>

<summary>One of my tickers returns no data</summary>

Verify the ticker symbol is correct and that the security is still actively traded. Delisted stocks or tickers that have changed symbols (e.g., after a merger) may return empty results. Try looking up the exact symbol on Yahoo Finance directly before adding it to your data flow.

</details>

### Permission errors

<details>

<summary>I'm getting a 403 or "forbidden" error</summary>

This usually means your API plan does not have access to the endpoint Coupler.io is calling. Check whether your RapidAPI subscription tier includes historical data or the interval you've selected — some free tiers restrict access to certain endpoints.

</details>

### Data discrepancies

<details>

<summary>The Adjusted Close values changed between two pulls</summary>

This is expected behavior. Adjusted Close is recalculated retroactively whenever a stock split or dividend is announced. If you need a stable historical record, store a snapshot of each pull rather than overwriting previous data.

</details>

<details>

<summary>Prices don't match what I see on Yahoo Finance's website</summary>

Yahoo Finance may display prices with a 15-minute delay for some markets during live trading hours. The API data may also differ slightly from the website display due to post-market adjustments. For end-of-day analysis, always use the daily close from the previous completed session.

</details>

### Rate limits

<details>

<summary>I'm hitting rate limit errors when pulling many tickers</summary>

If you're querying a large number of tickers in one data flow, you may exceed the requests-per-minute or requests-per-month limit of your API plan. Consider splitting tickers across multiple data flows or upgrading your API plan. You can use Coupler.io's **Append** transformation to merge results from separate data flows into one destination table.

</details>

## Yahoo Finance Price FAQ

<details>

<summary>Which stock exchanges and securities are supported?</summary>

Yahoo Finance covers most major global exchanges, including NYSE, NASDAQ, LSE, TSX, and many others. You can pull prices for stocks, ETFs, mutual funds, indices (e.g., `^GSPC` for the S\&P 500), and cryptocurrencies (e.g., `BTC-USD`). Use the exact ticker format shown on Yahoo Finance's website.

</details>

<details>

<summary>How far back does historical data go?</summary>

Select `max` as your date range to get the full available history. For large-cap US stocks this can go back several decades. For newer listings, IPOs, or crypto, the history may be shorter. Pair `max` with a `1mo` or `1wk` interval to keep row counts manageable.

</details>

<details>

<summary>Can I pull data for multiple tickers in one data flow?</summary>

Yes. Enter your tickers as a comma-separated list in the **Stock tickers** field (e.g., `AAPL, GOOGL, MSFT`). All tickers will be returned in a single dataset with a Ticker column so you can filter or pivot by symbol at the destination.

</details>

<details>

<summary>What's the difference between Close and Adjusted Close?</summary>

Close is the raw price at which the last trade occurred during the session. Adjusted Close is modified retroactively to account for stock splits and dividend payments, making it the more accurate field for calculating historical returns across time.

</details>

<details>

<summary>Can I use Yahoo Finance Price data in AI tools?</summary>

Yes. Coupler.io supports AI destinations including ChatGPT, Claude, Gemini, Perplexity, Cursor, and OpenClaw. You can send your price data directly to these tools to ask questions, generate summaries, or build models based on the data.

</details>

<details>

<summary>Why do I get empty results even though the data flow runs without errors?</summary>

The most common cause is an incompatible interval and date range combination. For example, `1m` interval only works with very short date ranges (typically 7 days or less). Check the interval/range pairing and refer to the notes in the Data Overview article for supported combinations.

</details>

<details>

<summary>Can I combine Yahoo Finance Price data with other sources?</summary>

Absolutely. Use Coupler.io's **Join** transformation to merge price data with internal datasets (e.g., transaction records, portfolio holdings). Use **Append** to combine price histories from multiple tickers or API keys into one table. Use **Aggregate** to compute summary metrics like average price or total volume over a period.

</details>

{% hint style="info" %}
For details on available fields and supported interval/range combinations, see the [Data Overview](#yahoo-finance-price-data-overview) article. For help with API key errors, missing data, or rate limits, see [Common Issues](#yahoo-finance-price-common-issues).
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.coupler.io/sources/category/finance-and-accounting/yahoo-finance-price.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
