FAQs
This is most likely caused by licensing terms between Yahoo and the particular stock exchange or index provider. Unfortunately this currently (2023) applies to some of the most popular stock indices, including S&P500 (^GSPC) and the Dow Jones Industrial Average (^DJI).
How do I export historical data from Yahoo Finance? ›
Download historical data in Yahoo Finance
- Go to Yahoo Finance.
- Enter a quote into the search field.
- Select a quote in the search results to view it.
- Click Historical Data.
- Select a Time Period, data to Show, and Frequency.
- Quote data will refresh automatically.
- To use the data offline, click Download.
This is most likely caused by licensing terms between Yahoo and the particular stock exchange or index provider. Unfortunately this currently (2023) applies to some of the most popular stock indices, including S&P500 (^GSPC) and the Dow Jones Industrial Average (^DJI).
Where can I download historical stock data? ›
Internet Sources for Historical Market & Stock Data
- Yahoo! Finance - Historical Prices. ...
- Dow Jones Industrial Averages. Historical and current performance data. ...
- S&P Indices. Historical performance data.
- IPL Newspaper Collection. ...
- Securities Industry and Financial Markets Association. ...
- FINRA: Market Data Center.
See whether a quote is real-time by checking the trading information below the quote price on the quote summary page. Observe the date and time, volume, and price change. You'll also know a quote is real-time when a red or green background flashes behind the stock price.
How do I download Yahoo Finance data to Excel? ›
Export and import portfolio data in Yahoo Finance
- Sign in to Yahoo Finance.
- Click My Portfolio.
- Click the portfolio name of the list you want to export.
- Click Export.
- Open the Downloads folder on your computer to find the exported file named "quotes. csv."
Is Yahoo Finance Web Scraping Legal. In short, YES. Most of the data available on the Yahoo Finance website is open-source and public information. But you should still pay attention to your local web scraping laws and rules when you're scraping and using these data.
Is there a replacement for download Yahoo Finance? ›
RapidAPI's Marketplace lists many free and freemium Yahoo finance alternatives. Morning Star by API dojo allows users to find data about stocks, movers, and finance summaries. Its free Basic plan has a hard limit of 500 requests per month. Twelve Data is another freemium stock market API similar to Yahoo finance APIs.
How far back does Yahoo Finance data go? ›
If the data requested is beyond the range of historical prices available through Yahoo Finance, all available data within the range is displayed. Historical prices usually don't go back earlier than 1970.
Is Yahoo Finance historical data accurate? ›
Yahoo Finance does not maintain data on its own. It passes on data from other sources, most of which are considered highly reliable. Go to a company page on YF and scroll all the way to the bottom. On the right you will see a link for “Data Disclaimer”.
Open a new or existing Google Sheets spreadsheet. In a cell, enter one of the import formulas followed by the Yahoo Finance URL in parentheses. For example, to import the current stock price for Apple (AAPL), use the formula: =IMPORTXML("https://finance.yahoo.com/quote/AAPL","//fin-streamer[@data-symbol='AAPL']")
How do you get past stock data? ›
There are many other places to find historical stock quotes, to be sure. There are thousands of websites and mobile apps that will provide both real-time and historical quotes as well as financial metrics across all categories. Sites like Bloomberg and MarketWatch are among the most popular, as well as Yahoo Finance.
Why was Yahoo Finance discontinued? ›
The official Yahoo Finance API was shut down by Yahoo in 2017 due to widespread abuse against their terms of service.
Does Yahoo Finance have a free API? ›
Yahoo finance has a free api for real time stock data and polygon.io has a free api for historical data. In Python, yfinance module is a good wrapper for yahoo finance api and polygon module is a good wrapper for polygon.io api.
How to pull Yahoo Finance data Python? ›
Installation of Yahoo Finance Module in Python
- Let us install them via pip commands.
- Once it is installed, we can import yfinance package in Python code. ...
- If we want to display all the rows of a ticker symbol, we will use the Python Pandas module and set the set_option() function to display maximum rows.
To export portfolio data:
- In the "My Portfolio" section, click on the portfolio you want to export.
- Click on the "Export" button.
- Select the data fields you want to include (e.g., symbols, prices, dates).
- Choose the file format (CSV or HTML).
- Save the exported file to your computer.
Open a new or existing Google Sheets spreadsheet. In a cell, enter one of the import formulas followed by the Yahoo Finance URL in parentheses. For example, to import the current stock price for Apple (AAPL), use the formula: =IMPORTXML("https://finance.yahoo.com/quote/AAPL","//fin-streamer[@data-symbol='AAPL']")
