How to Export Yahoo Finance Quotes, Historical Prices, and Fundamentals
Yahoo Finance shows quotes, historical prices, and company fundamentals one ticker at a time, with no bulk export. This tool fetches any list of stock, ETF, or index symbols and returns current quotes, OHLCV historical price series, and fundamental data (margins, ROE, debt, cash flow, analyst targets) as structured data.
In short: Manually checking quotes and fundamentals across a watchlist of tickers doesn't scale, and Yahoo Finance doesn't offer a way to download it in bulk. This tool automates it — you get structured, ready-to-use data instead of copying it by hand.
What the data shows: In this sample of 5 large-cap tickers, Apple carries a forward P/E of 34.6 against a trailing P/E of 39.7 — the kind of forward-vs-trailing valuation gap that's buried a few clicks deep on Yahoo's own site but immediate once the data is structured.
Sample data
| Ticker | Company | Price | Change | Market Cap |
|---|---|---|---|---|
| AAPL | Apple Inc. | $333.26 | +1.76% | $4.89T |
| MSFT | Microsoft Corporation | $401.10 | +1.38% | $2.98T |
| TSLA | Tesla, Inc. | $391.06 | -0.86% | $1.47T |
| NVDA | NVIDIA Corporation | $207.40 | -2.40% | $5.02T |
| GOOGL | Alphabet Inc. | $354.46 | -4.44% | $4.33T |
What each field means
| Field | Description |
|---|---|
symbol, shortName, longName, exchange, quoteType | Symbol identification |
price, change, changePercent, previousClose, dayHigh, dayLow, volume | Current quote |
marketCap, trailingPE, forwardPE, eps, dividendYield, fiftyTwoWeekHigh/Low | Valuation snapshot |
fundamentals.sector/industry/employees/beta/margins/ROE/ROA/debt/cashflow | Full fundamental profile, when enabled |
fundamentals.recommendationKey, targetMeanPrice | Analyst consensus rating and price target |
Historical mode | OHLCV price time series for any range from 1 day to max, at daily/weekly/monthly intervals |
How to use it
- Open the tool on Apify (link below).
- Fill in the search form — no code required.
- Run it and wait for it to finish (usually seconds).
- Download your results as JSON, CSV, or Excel.
Frequently asked questions
Do I need to know how to code?
No. You list ticker symbols and pick which data blocks you want, then download the results as JSON, CSV, or Excel.
Is this real-time data?
Yes, every run fetches current quotes and fundamentals directly from Yahoo Finance at the time you run it.
Can I get historical prices too?
Yes, enable the historical data block and pick a range (1 day to max) and interval (daily, weekly, monthly).