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:
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: