Tuesday, October 19, 2010

Downloading stock data from Yahoo

Yahoo provides a simple way to querying their database and get an updated stock-quote.

Here is the way to use it (quoting from Ilmu's blog):
http://finance.yahoo.com/d/quotes.csv?s=
a number 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:

aAska2Average Daily Volume
a5
Ask Size

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

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

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

d2
Trade Date
e
Earnings/Sharee1Error Indication (returned for symbol changed / invalid)

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

j
52-week Lowk52-week High
g1
Holdings Gain Percent

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

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

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

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

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

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

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

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

p2
Change in Percentp5Price/Sales
p6
Price/Book

q
Ex-Dividend Date
r
P/E Ratior1Dividend Pay Date

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

s7
Short Ratiot1Last Trade Time
t6
Trade Links

t7
Ticker Trend
t8
1 yr Target PricevVolume

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

y
Dividend Yield
:)

They can be easily used by curl or other scripting languages to get the stock updates! Google also has a similar way of downloading stock data but Yahoo has much bigger set of information.


 

No comments:

Post a Comment