获取历史数据

# 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()