import re from datetime import * from pprint import pprint import ystockquote from StockDB import Stocks import StockCommon nowStrFull = datetime.now().strftime('%Y-%m-%d %H:%M:%S') print("Start:" + nowStrFull) todayStr = ( datetime.now() - timedelta(0)).strftime('%Y-%m-%d') sdb = Stocks(); for stock in StockCommon.getAllSymbols2(): #symbol,symbol_y = StockCommon.symbolFormat('300186') symbol = stock print('-------------------------------------') print(symbol) s,is_close_price = StockCommon.getStock(symbol,todayStr) if is_close_price: sdb.insertStocksSina(symbol,s) else: print('the stock market stil openning, need run later') break sdb.close() nowStrFull = datetime.now().strftime('%Y-%m-%d %H:%M:%S') print("End:" + nowStrFull)
from datetime import * from pprint import pprint import ystockquote from StockDB import Stocks import StockCommon date_start = '2015-01-01' date_end = '2015-10-24' nowStrFull = datetime.now().strftime('%Y-%m-%d %H:%M:%S') print("Start:" + nowStrFull) todayStr = ( datetime.now() - timedelta(0)).strftime('%Y-%m-%d') tomorrowStr = ( datetime.now() + timedelta(1) ).strftime('%Y-%m-%d') date_end = tomorrowStr print("update: %s - %s" % (date_start, date_end) ) sdb = Stocks(); stock = '000001' symbol,symbol_y = StockCommon.symbolFormat(stock) print('-------------------------------------') print(symbol_y) all = ystockquote.get_historical_prices(symbol_y,date_start, date_end) sdb.insertStocks(symbol,all) sdb.close() nowStrFull = datetime.now().strftime('%Y-%m-%d %H:%M:%S') print("End:" + nowStrFull)
#date_start = '2015-01-01' #date_end = '2015-10-24' nowStrFull = datetime.now().strftime('%Y-%m-%d %H:%M:%S') print("Start:" + nowStrFull) latestNDays = 3 todayStr = ( datetime.now() - timedelta(0)).strftime('%Y-%m-%d') tomorrowStr = ( datetime.now() + timedelta(1) ).strftime('%Y-%m-%d') ago = datetime.now() - timedelta(latestNDays) agoStr = ago.strftime('%Y-%m-%d') date_start = agoStr date_end = tomorrowStr print("update: %s - %s" % (date_start, date_end) ) sdb = Stocks(); for stock in StockCommon.getAllSymbols2(): #for stock in ['600008']: #if(stock < '600008'): continue #if(re.search('318$',stock)): continue symbol,symbol_y = StockCommon.symbolFormat(stock) print('-------------------------------------') print(symbol_y) #has = sdb.findStocksBySymbol(symbol) #if(len(has)): # print("existed:" + symbol_y) # continue s = sdb.findStockBySymbolAndDate(symbol,todayStr) if s is not None: