获取股票中的历史行情数据（000001和600000为例）

import urllib
import re
import pandas as pd
import os
from io import StringIO, BytesIO
import time

def getHtml(url):
    html = urllib.request.urlopen(url).read()
    html = html.decode('gbk')
    return html

Url163 = 'http://quotes.money.163.com/service/chddata.html?code=%s&start=19910102&end=%s&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'

stock_id='1000001'
url = Url163%(stock_id,time.strftime("%Y%m%d", time.localtime()) )
aa=getHtml(url)

df = pd.read_csv(StringIO(aa))
df.to_excel(stock_id+'.xlsx')

stock_id='0600000'
url = Url163%(stock_id,time.strftime("%Y%m%d", time.localtime()) )
aa=getHtml(url)

df = pd.read_csv(StringIO(aa))
df.to_excel(stock_id+'.xlsx')

转载于:https://my.oschina.net/yangbaisheng/blog/3095654