Yahoo Finance Stock Data API Get _ Stock

Source: Internet
Author: User

Yahoo provides daily transaction data for domestic and foreign stock markets http://table.finance.yahoo.com/table.csv?s=&a=&b=&c=&d=&e=&f= &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, which means that the cycle is ' Week '. D-> ' Day ', w-> ' Zhou ' (week),m-> ' month ' (mouth),v-> ' dividends only '

Be sure to note the month parameters, which are worth more than real data-1. If the September data is required, it is written as 08.

For example: http://table.finance.yahoo.com/table.csv?s=ibm&d=6&e=22&f=2006&g=d&a=11&b=16&c= 1991&ignore=.csv
The links above can crawl IBM shares from December 16, 1991 to 22 of July 2006 data.

For the Chinese stock market data, Shanghai stock is the stock code followed by the. SS, deep proof stock is the stock code plus. SZ
For example: 000001 = 000001.sz
Shenzhen Data Link: http://table.finance.yahoo.com/table.csv?s=000001.sz
Listing Data Link: HTTP://TABLE.FINANCE.YAHOO.COM/TABLE.CSV?S=600000.SS
Shanghai index Code: 000001.SS, Deep proof exponentially code: 399001.SZ, CSI 300 Code: 000300.SS

For Sina data and download from VBA, you can refer to:

http://www.douban.com/note/25911691/

http://www.cnhup.com/index.php/archives/downloading-a-file-from-the-web-in-vba/

References: http://www.predream.org/show-58-320-1.html

http://club.excelhome.net/forum.php?mod=viewthread&tid=1016103

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: