Dukascopy
 
 
Wiki JStore Search Login

Attention! Read the forum rules carefully before posting a topic.

    Try to find an answer in Wiki before asking a question.
    Submit programming questions in this forum only.
    Off topics are strictly forbidden.

Any topics which do not satisfy these rules will be deleted.

Export data to Excel
 Post subject: Export data to Excel Post rating: 0   New post Posted: Fri 15 Jul, 2016, 17:07 
User avatar

User rating: 0
Joined: Fri 15 Jul, 2016, 16:52
Posts: 3
Location: United Kingdom,
Hello all,

Does anyone know if jforex will export data to excel like MT4 will. I want to build a large database of tick data for external strategy evaluation and development. I know that jforex contains good automated strategy capability, but I am engaged in vb development and don't want to break off to learn how to program in java until I know it will work.

Thanks in advance

Steve


 
 Post subject: Re: Export data to Excel Post rating: 0   New post Posted: Mon 25 Jul, 2016, 09:56 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
To write price data to file please use Tools > Historical Data Manager


 
 Post subject: Re: Export data to Excel Post rating: 0   New post Posted: Mon 25 Jul, 2016, 15:41 
Visual JForex expert at Dukascopy
User avatar

User rating:
Joined: Mon 22 Apr, 2013, 11:30
Posts: 604
Location: UkraineUkraine
Also might help:
https://www.dukascopy.com/wiki/#Write_in_Excel_(DDE)
https://www.dukascopy.com/wiki/#Write_bars_in_CSV
https://www.dukascopy.com/wiki/#Get_data_from_CSV


 
 Post subject: Re: Export data to Excel Post rating: 0   New post Posted: Wed 27 Jul, 2016, 07:54 
User avatar

User rating: 0
Joined: Fri 15 Jul, 2016, 16:52
Posts: 3
Location: United Kingdom,
Thank you both for your input.

I have downloaded some historic tick data and am working with it.
I have realised that with this data, I don't need live data, as I can reconstruct a virtual live market for testing.

Regarding the 3 suggestions from vadim berezhnoj, I have read all 3, but the one that looked particularly interesting-
the Write in Excel, I couldn't find any reference to excel, and the search didn't return anything. Can you possibly provide
more detail here so I can find the topic?

Thanks

Steve


 
 Post subject: Re: Export data to Excel Post rating: 0   New post Posted: Thu 28 Jul, 2016, 15:19 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
The link to excel was not correct. Please use this one:
here


 
 Post subject: Re: Export data to Excel Post rating: 0   New post Posted: Thu 28 Jul, 2016, 17:13 
User avatar

User rating: 0
Joined: Fri 15 Jul, 2016, 16:52
Posts: 3
Location: United Kingdom,
Thanks Vadim,

I am used to coding in vb in excel 2010.
I don't recognise most of the code, apart from the sheetname, column and row update.
Which is the jar file, and which is the dll?
Can you say if this outputs tick data live?

Sorry to be a burden, but if I get this right, I can run truly live.

Also, will the dll allow 2 way communication between jforex and excel so I can do
my programming in vb and thus avoid needing to learn java?

Thanks in advance


 
 Post subject: Re: Export data to Excel Post rating: 0   New post Posted: Wed 17 Aug, 2016, 15:31 
User avatar

User rating:
Joined: Fri 31 Aug, 2007, 09:17
Posts: 6139
In this forum we try to focus on JForex API issues. There are a number of external programmers who can program the strategy for you:
https://www.dukascopy.com/fxcomm/member ... am_service


 

Jump to:  

  © 1998-2024 Dukascopy® Bank SA
On-line Currency forex trading with Swiss Forex Broker - ECN Forex Brokerage,
Managed Forex Accounts, introducing forex brokers, Currency Forex Data Feed and News
Currency Forex Trading Platform provided on-line by Dukascopy.com