def purchaseStock(stockData):
if len(stockData) > 0:
fundCol, fundData = searchAllData(STOCK_VERSION_META_TABLE)
crt_dttm = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
if stock_closed_daytime.ClosedDayTime().is_stockOpenDayTime():
if len(fundData) > 0:
for idx, data in enumerate(stockData):
if int(fundData[0][0]) >= int((data[4])):
purchase_count = math.floor(
int(fundData[0][0]) / int(data[4]))
purchase_amt = purchase_count * int(data[4])
sql = """insert into """ + STOCK_VERSION_TABLE + """ (code, item, status
, purchase_current_amt , purchase_count, purchase_amt, search_rate, yesterday_rate
, up_down_rate, ps_cnt, c_amt, h_amt, l_amt, crt_dttm) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"""
sqlParam = (data[1], data[2], "I", data[4],
purchase_count, purchase_amt, data[3],
data[5], data[6], data[7], data[8],
data[9], data[10], crt_dttm)
executeDB(sql, sqlParam)
log('--- stock info save ---', "N")
main_process()
def purchaseStockMonitoring(purchaseData):
log('--- stock info monitoring ---', "N")
if stock_closed_daytime.ClosedDayTime().is_stockOpenDayTime():
for idx, data in enumerate(purchaseData):
getStocInfoData(data, "ING")
else:
for idx, data in enumerate(purchaseData):
getStocInfoData(data, "CLOSE")
def stockMonitoring(purchaseData):
if stock_closed_daytime.ClosedDayTime().is_stockOpenDayTime():
log('--- stock monitoring ---',"N")
initStock = False
for idx, data in enumerate(purchaseData):
if "P" == data[3]:
initStock = True
break
if initStock == True:
choiceStock(purchaseData)
else:
for idx, data in enumerate(purchaseData):
getStocInfoData(data,"ING")
else:
log('--- stock market close ---',"N")
for idx, data in enumerate(purchaseData):
getStocInfoData(data,"CLOSE")
def tempPurchaseStock(stockData):
if stock_closed_daytime.ClosedDayTime().is_stockOpenDayTime():
if len(stockData) > 0 :
fundCol,fundData = searchAllData(VERSION_META_TABLE)
crt_dttm = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
if len(fundData) > 0 :
for idx, data in enumerate(stockData):
if int(fundData[0][0]) >= int((data[3])) :
sql = """insert into """+VERSION_TABLE+""" (code, item, status, crt_dttm) values (?, ?, ?, ?)"""
sqlParam = (data[1], data[2], "P" , crt_dttm)
executeDB(sql,sqlParam)
log('--- temp stock info save ---',"N")
main_process()
else:
log('--- stock item list empty ---',"N")
else:
log('--- stock market close ---',"N")
def stockMonitoring(purchaseData, VERSION_META_TABLE, VERSION_TABLE):
if stock_closed_daytime.ClosedDayTime().is_stockOpenDayTime():
log('--- stock monitoring ---', "P")
initStock = False
for idx, data in enumerate(purchaseData):
if "P" == data[3]:
initStock = True
break
if initStock == True:
choiceStock(purchaseData, VERSION_META_TABLE, VERSION_TABLE)
else:
for idx, data in enumerate(purchaseData):
getStocInfoData(data, "ING", VERSION_META_TABLE, VERSION_TABLE)
else:
log('--- stock market close ---', "N")
dpstock.clear()
downstock.clear()
for idx, data in enumerate(purchaseData):
getStocInfoData(data, "CLOSE", VERSION_META_TABLE, VERSION_TABLE)
