0
$\begingroup$

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.

$\endgroup$
1
  • $\begingroup$ Depending on how large your list is, investexcel.net/… may do the trick, though I'm surprised there isn't a canonical source for this. You may try asking on opendata.stackexchange.com as well $\endgroup$
    – user59
    Sep 20, 2016 at 23:10

2 Answers 2

3
$\begingroup$

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.

$\endgroup$
1
$\begingroup$

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.

$\endgroup$
1
  • $\begingroup$ Which built-in functions? Do you have an example of how I could do this with Google Docs? $\endgroup$
    – abagh0703
    Sep 21, 2016 at 20:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.