/>get_login(api_k,api_s) #function that is used to get connected to api<br />def on_ticks(ws,ticks):<br />global j, df, df_cols, tradedic<br />#keeps extracted tick data
/>get_login(api_k,api_s); #function that used to get connected with API<br />wb = xw.Book('store.xlsx')<br />sht = wb.sheets['Sheet1']<br />row=2<br />def on_ticks(ws, tick
#api_secret<br />get_login(api_k,api_s); #function that used to get connected with API<br />ohlc = {}; # python dictionary to store the ohlc data in it<br />for x in trd_portfolio:&