Learn how to fetch historical stock data for your time series analysis
Free historical data with easy CSV downloads
Use GOOGLEFINANCE() for live data in spreadsheets
Free API for programmatic access to market data
Search company name to find symbols
3 steps to download historical data
Visit finance.yahoo.com and search for your ticker
Navigate to the 'Historical Data' tab on the stock page
Click 'Download' to get your .csv file
Fetch live data directly in Sheets
=GOOGLEFINANCE("0700.HK", "all", DATE(2024,1,1), TODAY(), "DAILY")Replace 0700.HK with your ticker
Returns: Date, Open, High, Low, Close, Volume
Download a clean CSV with Apple vs. Tencent data (100 days) ready for the Sandbox