How to Get Stock History for Multiple Stocks in Excel?
To get stock history for multiple stocks in Excel, list the tickers in a column and use MarketXLS formulas: =Close_Historical(A2, DATE(2024,12,31)) returns one stock's closing price on a date, so you can fill a grid of tickers by dates, and =QM_GetHistory("AAPL") returns a full table of daily prices for one ticker. Without an add-in, you can download CSV files from a site such as Yahoo Finance for each ticker and combine them, but the data does not update. Once the history is in Excel, select the data range you would like to analyze. You can add in filters, such as selecting a minimum value or a particular stock range. Once you have selected the parameters you would like to use, you can use formulas such as SUM, AVERAGE, and COUNT to calculate the stock market data within the data range. If you wish to visualize the data, you can use charts and graphs to look for trends or patterns in the stock data. By analyzing the historical data, you can make better informed decisions when investing.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
How to use =CloseHistorical function in MarketXLS?
The =Close_Historical(Ticker, Date) function in MarketXLS returns a security's closing price on the date you enter, for example =Close_Historical("MSFT", "2024-12-31"). This information can come in handy when doing technical analysis and researching historical trends. You can combine it with the open, high, low, adjusted close, and volume functions below.
More MarketXLS functions on historical data:
| Function Name | Excel Function | Description |
|---|---|---|
| Close | “=Close_Historical(Ticker,date)” | Returns the closing price for the date provided |
| Open | “=Open_Historical(Ticker,date)” | Returns the opening price for the date provided |
| High | “=High_Historical(Ticker,date)” | Returns the highest price reached for the date provided |
| Low | “=Low_Historical(Ticker,date)” | Returns the lowest price reached for the date provided |
| Adjusted close | “=Adjusted_Close_Historical(Ticker,date)” | Returns the closing price for the date provided after considering any corporate actions of the day |
| Volume | “=Volume_Historical(Ticker,date)” | Amount of shares traded on a defined date. |
How can MarketXLS help?
MarketXLS is an Excel and Google Sheets add-in whose historical functions return daily prices and volumes as formulas, so a price history grid refreshes instead of being re-downloaded. See historical stock data in Excel for more examples and ready-made workbooks in MarketXLS templates.
Relevant MarketXLS Templates on this topic:
- O'Shaughnessy: Small Cap Growth & Value Screen
- O'Shaughnessy: Growth Market Leaders Screen
- Weiss Blue Chip Div Yield Screen
- Historical IV Calculator
- Foolish Small Cap 8 Screen
- F score
- PE Band Valuation Method
- Technical Analysis Timeliness
Browse all MarketXLS templates.
Relevant blogs that you can read to learn more about the topic