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
[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)
The default direct download link for AAPL looks like
Example: AAPL and IBM
The default direct download link for AAPL and IBM looks like
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
The following are known tags. They are unofficial and subject to change.
|a2||Average Daily Volume|
|c||Change & Percent Change|
|c8||After Hours Change (Real-time)|
|d1||Last Trade Date|
|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|
|g1||Holdings Gain Percent|
|g5||Holdings Gain Percent (Real-time)|
|g6||Holdings Gain (Real-time)|
|i5||Order Book (Real-time)|
|j3||Market Cap (Real-time)|
|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||Percent Change From 52-week High|
|l||Last Trade (With Time)|
|l1||Last Trade (Price Only)|
|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|
|p2||Change in Percent|
|r1||Dividend Pay Date|
|r2||P/E Ratio (Real-time)|
|r6||Price/EPS Estimate Current Year|
|r7||Price/EPS Estimate Next Year|
|t1||Last Trade Time|
|t8||1 yr Target Price|
|v7||Holdings Value (Real-time)|
|w1||Day’s Value Change|
|w4||Day’s Value Change (Real-time)|
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.