Hi,

I'm trying to find a way to stream prices to an OpenOffice Calc Spreadsheet in Linux Mint. DDE is not an option in Linux. Is it possible to do this by writing to DB / SQL / CSV?

I would love to hear from anyone who has successfully achieved this. Or of course maybe there's an even better / simpler way!

Thanks in advance,

fifty_fifty

fifty_fifty:

On linux the best choices are exporting to a db or to csv files. The last one, seems to me the easy way as you pretend to use the data on OpenOffice Calc.
Calc can open csv files. If you choose this way, i made one article about exporting JForex data to text or csv files you can read here -> https://www.dukascopy.com/fxcomm/fx-arti ... ad&id=1198 or you can find also some information about on Wiki.

Trade well

JL

Hi JL,

Thanks for your reply! I had a read through your article, and it was very useful, but not quite what I am looking for. I need to write live bid/ask(ticks) into a spreadsheet. I have tried doing this using the method(from the Wiki) to write ticks to a csv file which is then linked to the spreadsheet (.ods file)

Then I get the last value from the column(which is the most recent tick). Works well except that the csv file becomes huge! So I scheduled an automatic deletion of the csv file every 5 minutes using crontab, but...the file is not then able to recreated automatically which means that the strategy has to be stopped and restarted.

There has to be an easier way!! Windows has DDE from MT4 or Jforex using prettytools.

Surely some linux genius's have the answer!!

Thanks,

fifty_fifty

Perhaps using a TCP socket connection?

Anyone have any experience with this?

Thanks

Hi fifty_fifty:

Yes, storing all tick data you can get *huge* files, but you don't need to delete them (if you don't have small hdd space). You can create files you want each one storing periods of 5 minutes, each one with a different name. You only need to calculate each 5 minutes interval and create a new file for each period with a different name, for example EURUSD_20130426_10_10.csv containing EURUSD tick information at 26 April 2013 started storing values from 10:10 until 10.14:59. You only need to code the period calculation separator and the name of the file.

I don't know if you need all tick data, but using my example you can filter only the fields you need and that way you can reduce the file lenght.

To me, the best way for this is to send the tick information data to a database, java DB, mysql, postgresql, hsqldb, dbo4j, etc, but that way you need to make a db connection and queries from openoffice.

Trade well

JL

Depending on what it is you are trying to achieve note that OpenOffice has a Java API you can use to talk to it directly:

https://wiki.openoffice.org/wiki/Documen ... pers_Guide
https://wiki.openoffice.org/wiki/Documen ... _Documents (menu to the right)

LibreOffice is an OpenOffice fork - I've not researched enough to understand if the fork extends deeply into major API differences:

https://api.libreoffice.org/
https://api.libreoffice.org/examples/examples.html
https://api.libreoffice.org/examples/java/Spreadsheet/ (spreadsheet examples)

Obviously this approach is a lot more involved but at the same time it places OO under your control via Java either directly from within your jforex codebase or from an external application that communicates with both your jforex codebase and OO.

There doesn't appear to be linux compatible add-ons for openoffice addressing this issue unfortuantely.

====================================================================================================

Another approach would be to make use of OO Basic, Java, Python, Javascript, etc from within the Spreadsheet you are working with
as a Macro to open up a socket connection to your "data server" to receive the stream.

https://wiki.openoffice.org/wiki/Documen ... ing_Macros
https://wiki.openoffice.org/wiki/Documen ... readsheets (Basic Manipulation)
https://forum.openoffice.org/en/forum/vi ... 44&t=59806

Good luck

Thanks CriticalSection for your in-depth response! Very much appreciated.

Will give me plenty of reading to do.

Cheers,
fifty_fifty