Hello , I would like to retrieve 1 min and 1 hour live data from IB TWS into Oppenoffice calculate. As an example, the 1 hour data would look like this Date Open High Low Close 22:00:00 3194.25 3196.25 3191.75 3192.75 23:00:00 3192.75 3194.75 3190.75 3192.25 00:00:00 3192.50 3194.25 3191.25 3192.00 Is anyone doing this already? Need some help please to get this up and running. Already looked at IBs site for help but they work with excel and I could not find my way with their documentation.
DDE and RTD is not compatible with OpenOffice. It probably doesn't work with Excel Online, either. You need Excel on your desktop. MS Access might work. Most technologies from that era have very closed architectures.
You can save the data as a csv file. Then open this file with OpenOffice or LibreOffice Calc. From there on you can process it.
You could use IB's API in Python to pull data into a file and then open it in OpenOffice. Unfortunately most brokerages are VERY winDOHs centric. And so they do not understand why one might want to use some tool other than a Microsoft product. Be glad that at least IB's platform runs nicely on a Linux desktop.
Does anyone have a file similar to the one attached that works with TWS, annd wouldnt mind sharing it with me??? Can anyone make the attached work with the current TWS?
You could use the Open Office API and Python to update any info into the spreadsheet just like you would Excel. Should be fairly simple. The Apache OpenOffice API Project