Batch Retrieval of Historical Stock Prices in Spreadsheets

Summary

The question seeks a way to retrieve prices for many stock tickers together, avoiding one-at-a-time lookups or a custom web scraper. The answers suggest spreadsheet-based workflows: one recommends a financial data service with Excel integration, while another points to Google Sheets functions for retrieving open, high, low, and close values over a date range.

The evidence is limited to these brief recommendations; no setup steps, coverage details, or comparisons are provided. The first answer says the service can support stock lookups and spreadsheet building, but may not suit users needing tick-level data. The second answer does not specify data availability, ticker coverage, or limits. Since data products and spreadsheet functions can change, the suggestions are best treated as starting points rather than a complete guide to current service capabilities.

Key ideas

• Spreadsheet integrations can help retrieve prices for multiple stock symbols in one workflow.
• Google Sheets is suggested for querying open, high, low, and close prices across dates.
• A financial data service with Excel support is presented as an option for users who do not need tick data.
• The answers provide no detailed instructions or data-coverage comparison.

Tags

# Obtain prices for list of stocks


# Obtain prices for list of stocks












I have a spreadsheet with a large number of ticker symbols. Is there any site that can get the current or past (either works) price for each of these stocks in one fell swoop? Paste in the list of stock ticker symbols, and receive a list of their current or past prices as an output.

Doing them one by one would take an eternity in my case, and creating a web scraper is something I'm hoping to avoid if a site out there already has this capability.

## Answer by sgdata (score 3, accepted)

https://quant.stackexchange.com/a/30238

I would highly suggest Quandl as a great place to start: https://www.quandl.com/tools/excel

Has a lot capabilities for stock look ups and works really well once you've gained some familiarities with it. Can really build out a powerful sheet if you don't need tick data or anything like that.

## Answer by Qen BirQeni (score 1)

https://quant.stackexchange.com/a/30240

GoogleSheets can query multiple stock data also. Using the built-in functions you can query open, high, low, close prices for a particular date range.

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.