def GetTop10Holder(mFilename, startDate, endDate):
engine = create_engine(
'mysql://root:@localhost/Financedata?charset=utf8') # 连接数据库
codes = pd.read_csv(mFilename)
pro = ts.pro_api()
for codename in codes['ts_code']:
df = pro.top10_floatholders(ts_code=codename,
start_date=startDate,
end_date=endDate)
df.to_csv('D:\\StockFile\\HolderData\\' + codename + '.csv',
encoding='utf_8_sig')
#df.to_sql(codename, engine, if_exists='append')
datetime.sleep(1)
def updateAuto():
current = datetime.datetime.now().minute
con = fxcmpy.fxcmpy(config_file='fxcm.cfg', server='demo')
while True:
time.sleep(5)
if datetime.datetime.now().minute != current:
current = datetime.datetime.now().minute
data2 = con.get_candles('BTC/USD', period='m1', number=1)
data2 = preprocess(data2)
print(current)
with open('data/BTC.csv', 'a', newline='') as f:
data2.to_csv(f, mode='a', index=False, header=f.tell() == 0)
else:
continue
def Timer():
while flag == True:
print Time
datetime.sleep(20)
def sleep_till_end(trader):
while True:
t = trader.get_last_trade_time()
t = t.time()
if t < dt.time(14, 0, 0):
dt.sleep(60 * 61)
elif t < dt.time(15, 00, 0):
dt.sleep(60 * 31)
elif t < dt.time(15, 30, 0):
dt.sleep(60 * 16)
elif t < dt.time(15, 45, 0):
dt.sleep(60 * 3)
elif t < dt.time(15, 55, 0):
dt.sleep(60 * 2)
elif t < dt.time(15, 58, 30):
dt.sleep(60 * 1)
elif t < dt.time(15, 59, 0):
dt.sleep(10)
else:
break
return True
def d_input():
d = input("Press e/E to go back to what to do: ")
if d == "e" or d == "E ":
what_to_do_logic()
else:
print("You have inputed the wrong input")
d_input()
d_input()
elif asking == "C." or asking == "c." or asking == "c" or asking == "C":
print("Good Bye. Thankyou " + username)
else:
print(
"You did not put the write input above. Please try again."
)
what_to_do_logic()
what_to_do_logic()
# return('exist')
break
else:
print("Username and password are not recognised")
again = input("Do u want to try again?(y/n): ")
if again.lower() == "n":
print("Good Bye")
time.sleep(1)
# return('exit')
break
elif cmd == 'stupid1':
# рассказать анекдот
speak("Look at your self, my boy")
else:
print('Please repeat!')
# запуск
r = sr.Recognizer()
m = sr.Microphone(device_index=1)
with m as source:
r.adjust_for_ambient_noise(source)
speak_engine = pyttsx3.init()
# Только если у вас установлены голоса для синтеза речи!
voices = speak_engine.getProperty('voices')
speak_engine.setProperty('voice', voices[0].id)
# forced cmd test
speak("My boy did't teach to tell funny story, but is his job")
speak("Golos is HERE my boy")
speak("Golos is listening")
stop_listening = r.listen_in_background(m, callback)
while True:
datetime.sleep(0.1) # infinity loop
def listen():
with m as source:
r.adjust_for_ambient_noise(source)
stop_listening = r.listen_in_background(m, callback)
while True:
datetime.sleep(0.1)