コード例 #1
0
ファイル: live_trade.py プロジェクト: hbwzhsh/stock
def get_all_stock_current_price():
    if cm.DB_WAY == 'redis':
        r = redis.Redis(host='127.0.0.1', port=6379)
        stockList = list(r.smembers(cm.INDEX_STOCK_BASIC))
    elif cm.DB_WAY == 'sqlite':
        engine = create_engine('sqlite:///..\stocks.db3')
        sql = 'select %s from %s' % (cm.KEY_CODE, cm.INDEX_STOCK_BASIC)
        df = pd.read_sql_query(sql, engine)
        stockList = df[cm.KEY_CODE].get_values()
    
    stockList_group = util.group_list(stockList, 20)
    
    stockClassList = []
    for eachList in stockList_group:
        #print eachList
        eachClasses = OnlineData.getLiveMutliChinaStockPrice(eachList)
        if eachClasses != []:
            stockClassList.extend(eachClasses) 
    print '交易股票总数:%d' % len(stockClassList)
    return stockClassList
コード例 #2
0
def getAllChinaStock2():
    df_list = pd.read_csv(cm.DownloadDir + cm.TABLE_STOCKS_BASIC + '.csv')
    stockList = df_list['code'].values
    stockList_group = util.group_list(stockList, 20)
    print len(stockList_group)
    print stockList_group[1]
    stockList = []
    for group in stockList_group:
        df = ts.get_realtime_quotes(group)

        for se in df.get_values():
            stock = st.Stock('')
            stock.code = se[0]
            stock.name = se[1]
            stock.current = se[3]
            stock.open = se[4]
            stock.high = se[5]
            stock.low = se[6]
            stock.close = se[7]
            stock.dealAmount = se[8] / 100
            stock.time = time.localtime(time.time())  #时间
            #print stock
            stockList.append(stock)
    return stockList
コード例 #3
0
ファイル: online_data.py プロジェクト: cbbing/stock
def getAllChinaStock2():
    df_list = pd.read_csv(cm.DownloadDir + cm.TABLE_STOCKS_BASIC + '.csv')
    stockList = df_list['code'].values;
    stockList_group = util.group_list(stockList, 20)
    print len(stockList_group)
    print stockList_group[1]
    stockList = []
    for group in stockList_group:
        df = ts.get_realtime_quotes(group)
    
        for se in df.get_values():
            stock = st.Stock('')
            stock.code = se[0]
            stock.name = se[1]
            stock.current = se[3]
            stock.open = se[4]
            stock.high = se[5]
            stock.low = se[6]
            stock.close = se[7]
            stock.dealAmount = se[8]/100
            stock.time = time.localtime(time.time()) #时间
            #print stock
            stockList.append(stock)
    return stockList