-
Notifications
You must be signed in to change notification settings - Fork 87
/
Copy pathstockHistory.py
118 lines (100 loc) · 3.58 KB
/
stockHistory.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
# encoding:utf8
#部分股票数据历史价格有误，尤其是2011年以前的数据，等一些历史数据
#无论是yahoo还是新浪的
__author__ = 'nooper'
import cStringIO
import csv
from bs4 import BeautifulSoup
from httpGet import httpGetContent
#年
years = ["2010", "2011", "2012", "2013"]
#季度
quarter = [1, 2, 3, 4]
def stock_day_history_sina(stock_code, year, qr):
"""
stockcode:股票代码
market：市场
year：2013
qr：季度1，2，3，4格式
货的股票历史数据
返回数据格式
日期2013-03-29
开盘：10.030
最高：10.210
停盘：10.130
最低9.910
数据量131028760
价格：1315731584
API:http://money.finance.sina.com.cn/corp/go.php/vMS_MarketHistory/stockid/600000.phtml?year=2013&jidu=1
"""
#todo 没有复权价格
url = "http://money.finance.sina.com.cn/corp/go.php/vMS_MarketHistory/stockid/%s.phtml?year=%s&jidu=%s" \
% (stock_code, year, qr)
content = httpGetContent(url=url)
if content:
soap = BeautifulSoup(content)
table = soap.select('table#FundHoldSharesTable>tbody')
if table:
tr_list = table[0].select('tr')
for i, tr in enumerate(tr_list):
stock = {}
if i == 0 or i == 1:
continue
td_list = tr.select('td')
for j, td in enumerate(td_list):
if j == 0: #日期
stock['date'] = td.div.a.text
elif j == 1: #开盘价格
stock['start'] = float(td.div.text)
elif j == 2: #
stock['high'] = float(td.div.text)
elif j == 3:
stock['end'] = float(td.div.text)
elif j == 4:
stock['low'] = float(td.div.text)
elif j == 5:
stock['rate'] = int(round(int(td.div.text) / 100.0, 0))
elif j == 6:
stock['money'] = int(round(int(td.div.text) / 10000.0, 0))
yield stock
# todo 完成测试
def stock_day_history_Yahoo(code, market):
"""
雅虎股票数据接口
得到yahoo股票的历史数据信息
深市数据链接：http://table.finance.yahoo.com/table.csv?s=000001.sz
上市数据链接：http://table.finance.yahoo.com/table.csv?s=600000.ss
Date 日期
Open 开盘价格
High 最高价格
Low 最低价格
Close 结束价格
Volume 量
Adj Close 收盘加权价格
"""
if market not in ('sz', 'ss'):
return
url = "http://table.finance.yahoo.com/table.csv?s=%s.%s" % (code, market)
content = httpGetContent(url=url)
if content:
data = cStringIO.StringIO(content)
reader = csv.reader(data)
for i, row in enumerate(reader):
stock_dict = {}
if i == 0:
continue
stock_dict['date'] = row[0] # 日期
stock_dict['open'] = float(row[1]) # 开盘价格
stock_dict['high'] = float(row[2]) # 最高价格
stock_dict['low'] = float(row[3]) # 最低价格
stock_dict['close'] = float(row[4]) # 结束价格
stock_dict['volume'] = float(row[5]) # 量
stock_dict['adj_close'] = float(row[6]) # 几日收盘加权价格？
yield stock_dict
def main():
pass
# code = getStockDayHistoryByYahoo('601989', 'ss')
# for cod in code:
# print cod
if __name__ == "__main__":
main()