I am trying to read price data from Eikon Excel to Python Pandas DataFrame during real time updates.
The issue is that Eikon Excel does not save streaming data in real time, while Python can only read saved excel files. I tried to use an Excel macro to automatically save the file during real time updates, but unfortunately, it crashes Eikon Excel addon. It seems that the two events (macro save and Eikon updates) cannot run at the same time.
Is there a way to stream price data from Eikon Excel to Python without saving the Excel file?
PS.: I am using MetaStock subscription, thats why I cant read directly from your Data Feed API using Python.
You could try using xlwings to transfer data from Excel to Python. I can't say I have much experience with using xlwings to transfer frequently updating data from Excel to Python.
On a separate note Refinitiv Developer Portal is probably not the best place for a question that essentially aims to circumvent Refinitiv commercial policy, that deems programmatic access to Refinitiv data a premium feature and only makes it available in products that are significantly more expensive than Metastock Xenith.
Thanks for your reply!
I will check the python addon.
On a separate note, I didnt know that trying to access excel data from Python is considered an act of fraud and deception. Too bad alot of analysts do that everyday. They should listen to your great advice.
Refinitiv is very expensive and I dont need 99% of its features. So why would I buy it?
Why are you imposing a huge fee just to access a data feed? Exploitation? or perhaps bad marketing?
Learn to segment your product line better, before accusing anyone!