Ilmu Saham | ISX Stock Market Resource Center

Downloading Stock Quote Yahoo data

Posted in Useful Tools by ilmusaham on March 14, 2008

Here’s a neat way to download stock data from Yahoo, perhaps into a spreadsheet
(so you can play with the data):

http://finance.yahoo.com/d/quotes.csv?s=

a BUNCH of STOCK SYMBOLS separated by “+”
&f=a bunch of special tags

for example:
http://finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr

where some special tags are (thanks to Mike):

a Ask a2 Average Daily Volume
a5
Ask Size

b
Bid
b2
Ask (Real-time) b3 Bid (Real-time)

b4
Book Value
b6
Bid Size
c
Change & Percent Change
c1 Change
c3
Commission
c6
Change (Real-time)

c8
After Hours Change (Real-time) d Dividend/Share
d1
Last Trade Date

d2
Trade Date
e
Earnings/Share e1 Error Indication (returned for symbol changed / invalid)

e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter
f6 Float Shares
g
Day’s Low
h
Day’s High

j
52-week Low k 52-week High
g1
Holdings Gain Percent

g3
Annualized Gain
g4
Holdings Gain g5 Holdings Gain Percent (Real-time)

g6
Holdings Gain (Real-time)
i
More Info
i5
Order Book (Real-time)
j1 Market Capitalization
j3
Market Cap (Real-time)
j4
EBITDA

j5
Change From 52-week Low j6 Percent Change From 52-week Low
k1
Last Trade (Real-time) With Time

k2
Change Percent (Real-time)
k3
Last Trade Size k4 Change From 52-week High

k5
Percebt Change From 52-week High
l
Last Trade (With Time)
l1
Last Trade (Price Only)
l2 High Limit
l3
Low Limit
m
Day’s Range

m2
Day’s Range (Real-time) m3 50-day Moving Average
m4
200-day Moving Average

m5
Change From 200-day Moving Average
m6
Percent Change From 200-day Moving Average m7 Change From 50-day Moving Average

m8
Percent Change From 50-day Moving Average
n
Name
n4
Notes
o Open
p
Previous Close
p1
Price Paid

p2
Change in Percent p5 Price/Sales
p6
Price/Book

q
Ex-Dividend Date
r
P/E Ratio r1 Dividend Pay Date

r2
P/E Ratio (Real-time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7 Price/EPS Estimate Next Year
s
Symbol
s1
Shares Owned

s7
Short Ratio t1 Last Trade Time
t6
Trade Links

t7
Ticker Trend
t8
1 yr Target Price v Volume

v1
Holdings Value
v7
Holdings Value (Real-time)
w
52-week Range
w1 Day’s Value Change
w4
Day’s Value Change (Real-time)
x
Stock Exchange

y
Dividend Yield :)

For example, if y’all copy and paste this URL into your browser address:


http://finance.yahoo.com/d/quotes.csv?s=BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr

you’ll get something which looks like:

YahooDataand

http://finance.yahoo.com/d/quotes.csv?s=GE&f=nkqwxyr1l9t5p4

gives this:

“GENERAL ELEC CO”,32.98,”Jun 26″,”21.30 – 32.98″,”NYSE”,2.66,”Jul 25″,28.55,”Jul 3″,”-0.21%”

whereas, to get the data already in a spreadsheet (so you can play it),
you can use (for example):

http://finance.yahoo.com/d/quotes.csv?s=XOM+EK+JNJ+MSFT&f=snd1t1l1ohgvwdyr


Here’s a spreadsheet that’ll download the Yahoo data according to the tags that you specify:

You just follow steps
1, 2, 3 then 4 (click the button).
Yahoo.xls

>And all that info gets …?

Gets downloaded into the spreadsheet. You just have to identify the Yahoo Symbols, stick in the Yahoo Tags that define the info you want,
stick in some Headings
(so you know what you’re getting), then click the Download Data button. You will also want to reformat the columns so that prices don’t display as dates

To download the spreadsheet, click on the picture above.

See also Portfolio spreadsheet.


If you’d like to play with the 500 S&P stocks, you can use the spreadsheet described
here. It also uses some of these tags.


Yahoo URL Changes


It’s now Feb, 2004 and Yahoo has changed the pertinent URL

from

http://finance.yahoo.com/d/quotes.csv?s=

to

http://quote.yahoo.com/d/quotes.csv?s=

AARGH!


It’s now Mar, 2007 and Yahoo has changed the pertinent URL again …
to
http://finance.yahoo.com/d/quotes.csv?s=AARGH!

To make the change you can try this:

  1. Right-click on the Download button that calls the macro
  2. Choose Assign macro then Edit
  3. Look for a statement containing the phrase:
    qurl = “http://quote.yahoo.com/d/quotes.csv?s=”
  4. Change it to read:
    qurl = “http://finance.yahoo.com/d/quotes.csv?s=”
  5. Exit the macro, pray** … then try the modified spreadsheet. :)

** That’s the most important part of the ritual.



Downloading Yahoo Option stuff

After getting e-mail from R.K., I discover that Yahoo has option data, too :)

So, there’s a spreadsheet that looks like this:

Yahoo2.xls


Click on the picture to download

Of course, ya gotta know the Yahoo option symbols !!



Downloading a BUNCH!
  • Since Yahoo has a limit on the number of stock symbols you can use, there’s another spreadsheet (Yahoo2.xls) here that gets around that limitation.
    It puts up to 200 stock symbols on each of several sheets and you download to each sheet in turn.
  • There’s another spreadsheet (Yahoo3.xls) here that downloads data for up to 1000 symbols and 10 tags to a single sheet.

Source:

Follow

Get every new post delivered to your Inbox.