How To Integrate Excel =rtd() Function In Python

I am using a real-time-data from a proprietary application which provides real time weather data. All I know know from the data is, it provides a link to import to excel as: =RTD('

Solution 1:

From the link which you have provided it seems that Microsoft has provided a wrapper for VBA(but not for Python).

I would suggest to check with the data provider if he offers an API to Python. This has nothing to do with Excel, but it would allow you to receive data directly into Python.

Another option is to receive data in Excel using RDT and use something like xlwings module http://xlwings.org/ to get data from Excel to Python.

Solution 2:

Its not Directly reading to python, but using temporary text file. I tryed the following, in excel I use Workbook_SheetCalculate, to write RTD data to text file, on every data change, sometimes 3 reading per second.

From Python I read that text file to Dataframe with Pandas, its almost real time.

Solution 3:

You can stream real time data into Excel as an RTD function using PyXLL.

See https://www.pyxll.com/docs/userguide/rtd.html for details, or have a look at this article that shows how to stream live tweets into Excel with Python https://www.pyxll.com/blog/a-real-time-twitter-feed-in-excel/