Document directory
- Request address
- Parameters
- Example
- Request address
- Parameters
- Example
- Reference
This article describes the yahoo financial channel's API for obtaining stock data. You can use this API to obtain real-time data.
Real-time Data Request address
Http://finance.yahoo.com/d/quotes.csv? S = <stock name> & F = <data column Options>
Parameters
- S-indicates the stock name. Multiple stocks are separated by the plus signs, for example, "XOM + bbdb. to + jnj + MSFT ", which lists the shares of four companies: XOM and bbdb. to, jnj, MSFT.
- F-indicates the returned data column, such as "snd1l1yr ". For more details, see the appendix.
Example
http://finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr
Return Value:
"XOM","Exxon Mobil Corpo","10/7/2010",63.85,2.69,12.33
"BBD-B.TO","BOMBARDIER INC., ","10/7/2010",5.27,1.90,N/A
"JNJ","Johnson & Johnson","10/7/2010",63.22,3.26,13.06
"MSFT","Microsoft Corpora","10/7/2010",24.53,2.12,11.68
Historical data requests
The preceding figure shows the latest data. To obtain historical data, use the following API.
Request address
http://ichart.yahoo.com/table.csv?s=<string>&a=<int>&b=<int>&c=<int>&d=<int>&e=<int>&f=<int>&g=d&ignore=.csv
Parameters
- S-stock name
- A-start time, month
- B-start time, day
- C-start time, year
- D-End Time, month
- E-end time, day
- F-End Time, year
- G-time period. Example: g = W, indicating the cycle is 'Week '. D-> 'day' (day), w-> 'Week' (week), M-> 'month' (mouth), V-> 'dividends only'
Pay attention to the month parameter. Its value is greater than the actual data-1. If you need the data for January 1, September, it is written as 08.
Example
Query the daily data of Shanghai Pudong Development Bank between 2010.09.25 and 2010.10.8
http://ichart.yahoo.com/table.csv?s=600000.SS&a=08&b=25&c=2010&d=09&e=8&f=2010&g=d
Return Value:
Date,Open,High,Low,Close,Volume,Adj Close
2010-09-30,12.37,12.99,12.32,12.95,76420500,12.95
2010-09-29,12.20,12.69,12.12,12.48,79916400,12.48
2010-09-28,12.92,12.92,12.57,12.58,63988100,12.58
2010-09-27,13.00,13.02,12.89,12.94,43203600,12.94
Shenzhen-Shanghai Stock Code
Yahoo's API is international and supports the domestic Shanghai and Shenzhen stock markets, but the code changes slightly. For example, the Code of Shanghai and Shenzhen Pudong Development Bank is 600000.ss. The rule is: Add. SS at the end of the Shanghai market, and Add. sz at the end of the Shenzhen Market.
-- EOF --
Reference
- Http://code.google.com/p/yahoo-finance-managed/
- Http://finance.yahoo.com/
- Http://www.gummy-stuff.org/Yahoo-data.htm
- Python API class http://www.goldb.org/ystockquote.html
- Ruby API class http://www.transparentech.com/opensource/yahoofinance
Appendix
Yahoo stock api f parameter table
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 |
|