with this code, I am checking if the value in the column check_val is true or not,
and create list of Ticker to render on html webpage.
as the values in check_val column changes frequently, to make sure that correct list
is rendered, i call this endpoint every 10 seconds using following line in html file
<meta http-equiv="refresh" content="10">
.
@app.route('/check')
def check():
filename = r'C:\Users\91956\Desktop\Book.xlsm'
df = pd.read_excel(filename)
df = df.loc[df['check_val'] == True]
ticker_list = df['Ticker'].to_list()
return render_template('layout.html',lis = ticker_list)
this causes refresh of page every 10 seconds. is there any other alterative to accomplish this, without refreshing the page?
