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:
