def PR_UpdateDailyQuotation(H5Db, start_datecode, end_datecode=DayCode().today(), DEBUG=False): DailyQ_twse = Web_TwseDailyQuotation(H5Db) DailyQ_tpex = Web_TpexDailyQuotation(H5Db) daycode = DayCode().copy_from(start_datecode) while daycode.to_int() <= end_datecode.to_int(): #info percentage = 100 * (daycode.to_int() - start_datecode.to_int()) / ( end_datecode.to_int() - start_datecode.to_int()) print("\n\n\n===>Progress: %s/[%s-%s] (%d%%).....\n" % (daycode, start_datecode, end_datecode, percentage)) #上市行情 stock_dq = DailyQ_twse.get_data(daycode, DEBUG) H5Db.update_daily_quotation(stock_dq) #上櫃行情 stock_dq = DailyQ_tpex.get_data(daycode, DEBUG) H5Db.update_daily_quotation(stock_dq) #Advance one day daycode.go_next_day()
def PR_UpdateLatestStockInfo(H5Db, DEBUG=False): #更新上市公司資訊 today = DayCode() DailyQ = Web_TwseDailyQuotation(H5Db) while True: #Part1: Stock Info (TWSE) stock_info = DailyQ.get_stock_info(today, DEBUG) if (len(stock_info) > 0): break else: today.go_prev_day() H5Db.update_stock_info(stock_info) #更新上櫃公司資訊 today.today() DailyQ = Web_TpexDailyQuotation(H5Db) while True: #Part1: Stock Info (TWSE) stock_info = DailyQ.get_stock_info(today, DEBUG) if (len(stock_info) > 0): break else: today.go_prev_day() H5Db.update_stock_info(stock_info)
def PR_UpdateLatestStockInfo(H5Db, DEBUG=False): #更新上市公司資訊 today = DayCode() DailyQ = Web_TwseDailyQuotation(H5Db) while True: #Part1: Stock Info (TWSE) stock_info = DailyQ.get_stock_info(today, DEBUG) if( len(stock_info) > 0 ): break else: today.go_prev_day() H5Db.update_stock_info(stock_info) #更新上櫃公司資訊 today.today() DailyQ = Web_TpexDailyQuotation(H5Db) while True: #Part1: Stock Info (TWSE) stock_info = DailyQ.get_stock_info(today, DEBUG) if( len(stock_info) > 0 ): break else: today.go_prev_day() H5Db.update_stock_info(stock_info)
def PR_UpdateDailyQuotation(H5Db, start_datecode, end_datecode = DayCode().today(), DEBUG=False): DailyQ_twse = Web_TwseDailyQuotation(H5Db) DailyQ_tpex = Web_TpexDailyQuotation(H5Db) daycode = DayCode().copy_from( start_datecode ) while daycode.to_int() <= end_datecode.to_int(): #info percentage = 100*(daycode.to_int() - start_datecode.to_int()) / (end_datecode.to_int() - start_datecode.to_int()) print("\n\n\n===>Progress: %s/[%s-%s] (%d%%).....\n" % (daycode, start_datecode, end_datecode, percentage ) ) #上市行情 stock_dq = DailyQ_twse.get_data(daycode, DEBUG) H5Db.update_daily_quotation(stock_dq) #上櫃行情 stock_dq = DailyQ_tpex.get_data(daycode, DEBUG) H5Db.update_daily_quotation(stock_dq) #Advance one day daycode.go_next_day()