I have created some strategies using Python. I would like to generate an Excel file containing the data from these Python functions when I execute the code. I want to rerun the code for every minutes .Could you please provide suggestions on how this can be achieved, along with any recommended resources that might be helpful
If i understand correctly, you need to run Python as Server side COM
Quick Start to Server side COM and Python (timgolden.me.uk)
How do I start a COM server? Code is in Python - Stack Overflow
In Excel VBA, you can create ole object of the python script that acts as a server and use it. Both links are enough to setup a full running example.
Thank you @chirag
hey I have developed python connected to excel, where LTP refreshes every tick and it also gives you other updates like Best buy, best sell , LTP, Volume, OI, VWAP and more in realtime from web socket data.
its also connected to fyers API for automated order execution via commands written on excel.
DM 8147084334 for more info