Need a python code for print the data from a live stock tick price price updating excel to another excel only if there is a change in a particular cell data of the excel
Budget: $10 – $30 USD
import pandas as pd
df = pd.read_excel('Live_Data.xlsm','Sheet1',skiprows = 5, nrows= 21, usecols = 'B:V')
print(df)
This code reads data from the streaming stock tick price updating file 'Live_Data.xlsm' from the 'B' to 'v' column and prints the output. I am trying to use a loop function to check the excel sheet in some time interval and print the output only if there is a change in value suppose in the 'v' columns data only.
df = pd.read_excel('Live_Data.xlsm','Sheet1',skiprows = 5, nrows= 21, usecols = 'B:V')
print(df)
This code reads data from the streaming stock tick price updating file 'Live_Data.xlsm' from the 'B' to 'v' column and prints the output. I am trying to use a loop function to check the excel sheet in some time interval and print the output only if there is a change in value suppose in the 'v' columns data only.