gilgil / RTD-Extension

This is a Python based extension for LibreOffice Calc to make real-time data (RTD) available in Calc spreadsheets
Other
0 stars 0 forks source link

Examples and/or Documentation needed #3

Open chappypuzz opened 4 months ago

chappypuzz commented 4 months ago

Please add more comprehensive documentation and some examples.

I've tried RTD in Excel 365 and Calc using this extension. Data source is thinkorswim Excel export to RTD. (The tos export to Calc is DDE.) It should be simple enough according to the github instructions for this extensions but I can't get it to work.

When I do it in Excel, it just works like magic and all the data updates realtime. But in Calc the RTD() parameters may be different because it's expecting "key", which I don't know what that is. In Excel the documentation says: =RTD (ProgID, Server, Topic, Item)

But in this Calc extension I think Topic=key perhaps? Or Item=key maybe? And there is no ProgID? Or maybe there is just 1, 2, or 3 parameters it's expecting?

In any case, I'm just guessing at trial and error, and the cell mouseover popout help just says: [RTD]: Fetches Realtime Data

There are no parameters and trial and error guessing is not really possible. This extension would be infinitely valuable to the LO community if it could be used easily and straight forward, but as of 02/2024 I doubt anyone has gotten actual data into Calc using this.

I understand, yes, the source code is all there and a true hardcore should be able to read Python, C++, forge a sword, field assemble an AR15 blindfolded, wrestle a crocodile, and rebuild a car transmission from spare parts. But users of this extension are usually analysts and traders, spending 80+ hours/week analyzing and trading, not Python coders.