

In [2]:

    
#coding=utf-8
import tushare as ts
from datetime import datetime, timedelta

import xlrd


def get_code_data(code, d_start, d_end):
    # st_day = datetime.strftime(d_start, '%Y-%m-%d')
    # end_day = datetime.strftime(d_end, '%Y-%m-%d')
    # print(st_day,end_day)
    try:
        hst_data_all = ts.get_k_data(code, ktype='D', autype='None', start=d_start, end=d_end)
        hst_data_all.to_csv('stock_data/'+code+".csv")
    except:
        print(code + "error")
        return None

def read_workbook(d_start,d_end):
    workbook = xlrd.open_workbook('stocks_all_000.xls')
    stocks = workbook.sheet_by_name(u'stocks_all')
    all_code_data = {}
    for j in range(1, min(3177, 3208)):
        code = stocks.cell(j, 0).value
        outstanding = stocks.cell(j, 1).value
        # print(j,code,outstanding)
        # 流通盘大于1000万股
        if outstanding >= 0.1:
            get_code_data(code, d_start, d_end)
            # print(code,len(code_data))


if __name__ == "__main__":
    # get_code_data('002729','2017-01-01','2017-04-01')
    read_workbook('2017-01-01','2017-07-31')









    



---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
<ipython-input-2-472b117c2b5b> in <module>()
      1 
----> 2 import tushare as ts
      3 from datetime import datetime, timedelta
      4 
      5 import xlrd

ImportError: No module named tushare