0

So i have an excel sheet that dumps the LTP of a stock (right now it is manual) also the stoploss is updated constantly in the excel sheet. Now the problem is how will i use this excel sheet(that is constantly updated) and place order in my broker terminal. I know you can routinely open the excel sheet after a fixed time. How do i solve this problem?

Secondly i use Ms Office to open the excel sheet and keep it open for updating the data. In my python program it says that the excel is opened in another program. How to get around this?

monucool
  • 425
  • 1
  • 6
  • 15
  • https://stackoverflow.com/questions/17063458/reading-an-excel-file-in-python-using-pandas?r=SearchResults&s=4|50.7201 could help – Ruperto Jan 26 '21 at 03:41
  • Would you explain which problem you are identifying as the *problem*? That the excel sheet is constantly updated, or how to place an order in the broker terminal? Or python complaining about sharing a data file? – wallyk Jan 26 '21 at 03:41
  • also making a copy of the file and using that, would avoid "excel is opened in another program" – Ruperto Jan 26 '21 at 03:42
  • @wallyk yes. The excel sheet is constantly updated that is my problem. – monucool Jan 26 '21 at 16:29

0 Answers0