Archive for March 31st, 2009
Yahoo Stocks API Documentation
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 |