What's the best way to pull yesterday's closing prices and/or current stock prices into Excel? I want to do this for *every* traded stock in S&P500 *every* morning, rather than for just a subset.
2006-09-18 08:19:57 · 4 answers · asked by dans 1 in Business & Finance ➔ Investing
1. Put together a comma-separated list of stocks constituting S&P 500 (no blank spaces, just symbols and commas).
2. Construct a long URL from three parts:
a. http://finance.yahoo.com/d/quotes.csv?s=
b. Your list
c. &f=sl1d1t1c1ohgv&e=.csv
3. Download the file from the URL you just constructed. This will be a CSV file containing current prices of all stocks in S&P 500.
It's possible that Yahoo will not be able to return 500 symbols at once, because there may be limits on the length of a URL it can accept. If so, you'll have to create several sublists and download them one at a time.
Another possibility is to write an Excel macro, which would retrieve quotes one by one...
2006-09-18 10:04:12 · answer #1 · answered by NC 7 · 0⤊ 0⤋
There are several sites where you can do that. But is sounds like you want to use this info to trade.
I'd recommend either eSignal or propet.net.
With a site like prophet.net. Depending on which level you subscribe to, you can set up to 100 watchlists including the S&P 500, S&P 100, Dow 30, 9 major sectors, 9 major and 34 subsectors, and so on. I have mine set up so that I can immediately see where the money's flowing and then click on the appropriate sector and see the stocks within the sector getting the most / least attention. I can (almost instantly) sort by volume, price change (both % and/or $$) and with a click, pop up the chart. Or with another click, pull up historical charts over several time periods! :-) It's the way to go for serious investors!
Hope that helps!
2006-09-18 10:01:24 · answer #2 · answered by Yada Yada Yada 7 · 0⤊ 0⤋
I'm not sure what you mean by "subset." Are you talking about intraday data? Are you talking about one of the sector averages?
You don't say where you are pulling this data "from," or what format it is in.
Here is the daily closing prices of the S&P 500 Index on Yahoo finance. At the bottom of the screen, just click on the button that says "Download to Spreadsheet."
If you are using a separate data feed, you have to specify what that is before we can help you.
2006-09-18 08:41:34 · answer #3 · answered by dredude52 6 · 0⤊ 0⤋
1
2017-02-14 20:28:04 · answer #4 · answered by ? 4 · 0⤊ 0⤋