Posted by CANbike on Sat, 10 Aug 2013

Yahoo! Finance: URL Download to a CSV File

Yahoo! Finance direct download of stock information to a CSV file, unofficially supports many additional options. They are unofficial as they are used by Yahoo!, but are not published nor supported.

The following details the direct download hidden options.

Official Download Link Location

For a stock, the download feature can be found on the Summary page, under the header Toolbox. It’s labeled as Download Data (delayed).

In addition, the download feature can also be found at the top of a table listing multiple stocks. It’s labeled as Download.

Unofficial Direct Download URL

The download URL is of the form

http://download.finance.yahoo.com/d/[FILENAME]?s=[TICKER SYMBOL(S)]&f=[TAGS]&e=.csv

where

[FILENAME] - Name of the file to save to (usually "quotes.csv")
[TAGS] - The stock information to download (usually "sl1d1t1c1ohgv")
[TICKER SYMBOL(S)] - Ticker symbol of a company (separate multiple tickers with a comma)

Example: AAPL

The default direct download link for AAPL looks like

http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=sl1d1t1c1ohgv&e=.csv

Example: AAPL and IBM

The default direct download link for AAPL and IBM looks like

http://download.finance.yahoo.com/d/quotes.csv?s=AAPL,IBM&f=sl1d1t1c1ohgv&e=.csv

Example: AAPL – Company Name, Price, P/E Ratio

Tags to use are n – Company Name, l1 – Last Trade Price, and r – P/E Ratio.

The resulting URL would look like

http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=nl1r&e=.csv

Tags

The following are known tags. They are unofficial and subject to change.

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
c4 Currency
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
f0 Trade Links Additional
f6 Float Shares
g Day’s Low
g1 Holdings Gain Percent
g3 Annualized Gain
g4 Holdings Gain
g5 Holdings Gain Percent (Real-time)
g6 Holdings Gain (Real-time)
h Day’s High

i More Info
i5 Order Book (Real-time)
j 52-week Low
j1 Market Capitalization
j2 Shares Outstanding
j3 Market Cap (Real-time)
j4 EBITDA
j5 Change From 52-week Low
j6 Percent Change From 52-week Low
k 52-week High
k1 Last Trade (Real-time) With Time
k2 Change Percent (Real-time)
k3 Last Trade Size
k4 Change From 52-week High
k5 Percent 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
s6 Revenue
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


Key Statistics Missing?

There are over 85 tags listed, but some key statistics are missing. Most notable would be Levered Free Cash Flow. Unfortunately, either the tags are unknown or the data is not retrievable by direct download.

A possible solution, though, is to scrape the data from the web page to a CSV file. However, that is topic for another article. See Yahoo! Finance Key Statistics: Download to a CSV File for details.

Media

Yahoo Finance-CSV Download Tags-01-thumb.jpgYahoo Finance-CSV Download Tags-02-thumb.jpg


Related Item(s):