Internet Bandaid   [RSS Feed]

Yahoo Stocks API Documentation

with one comment

Yahoo offers a free Stock Quotes API. I found informal documentation at http://ilmusaham.wordpress.com/tag/stock-yahoo-data/ which I’ll re-iterate here in the event that site disappears.

Here is an example link to the Yahoo Stocks feed in CSV format:
http://ca.finance.yahoo.com/d/quotes.csv?s=AX-UN.TO+BEI-UN.TO&f=sd1t1ohgv&e=.csv

It currently shows two symbols: the AX-UN.TO and BEI-UN.TO. You can choose which symbols you want to display by replacing the blue text in the url with desired symbols, each separated by a plus sign. The red string in the url specifies the columns you want in the CSV file. The red string currently tells the csv to pull symbol (s), last trade date (d1), last trade time (t1), open (0), day’s high (h) and day’s low (g). The list of available field options are shown in table below.

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

Written by John Lai

March 31st, 2009 at 5:16 pm

Start Mission - Project management and invoicing

One Response to 'Yahoo Stocks API Documentation'

Subscribe to comments with RSS

  1. Hi,
    Would it be possible to query with wildcards like .. if i want all stocks with goo*, it should return goog, good etc .. is there any way to do this.

    Any help would be great

    Dan

    29 Apr 10 at 8:59 pm

Leave a Reply