a36_3_email_realtime.py

#%%

from import_basics import *
from import_mongo import *
# %%
# path1=f'/Users/{getpass.getuser()}/Library/CloudStorage/GoogleDrive-ryan.ichun9@gmail.com/My Drive/ibkr/2 import data/6 twilio/stock_alert.xlsx'
# path1='/Users/ryanchun1/Downloads/stock_alert.xlsx'
# df=read_excel(path1)
# df=reset_index(df)
# df=df[:13][['ticker','alert_price']]
# df
# # %%
# # mongo_update_insert_one('stock','alert_stock_above',df,'ticker')
# #%%
# # mongo_set_df('stock','alert_stock_above','ticker',df)
# # %%
# dw=mongo_get_df('stock','alert_stock_above')
# dw
# %%
os.system('clear')
print('start..')
# for _ in range(30000):
    # print('#####')
# %%
ticker=input('NVDA = ')
price=float(input('price = '))
below=float(input('below = '))
dn=pd.DataFrame([ticker,price,below,0]).T
dn.columns=['ticker','alert_price','below','count']
dn
# %%
dw=mongo_update_insert_one('stock','alert_stock_realtime',dn,'ticker')
print(dw)
# %%