Auto update of my trading journal via EA Possible? | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Clearing the Journal via an EA 2 replies

Automatic Strategies generation that could be auto traded via MT4 0 replies

10PipsPro v3 Auto Trading Journal 12 replies

Force M1 update via Indicator 0 replies

Via indicator: trading xxxyyy via zzz 0 replies

Auto update of my trading journal via EA Possible?

  • #1
  • First Post: Nov 1, 2010 5:18pm Nov 1, 2010 5:18pm
Is there a way of automate update of my daily spreadsheet with end of daily data through MT4 or in other ways?

It doesn't seems that i can do it through DDE in MT4.
Blindly following others will make you blind!
  • #2
  • Nov 2, 2010 6:35pm Nov 2, 2010 6:35pm
DDE provides a raw data feed to other applications such as Excel. Think of it as tick data. There is no concept of bars or end of day. How you capture and manipulate the raw data is up to you.

For your purposes, I think a script file would be needed to write a CSV file that could be imported to Excel.
  • #3
  • Nov 2, 2010 6:46pm Nov 2, 2010 6:46pm
Thanks CodeMeister,

Yes i know i could do that, but i was looking for a way to automate the process.
Blindly following others will make you blind!
  • #4
  • Nov 2, 2010 7:13pm Nov 2, 2010 7:13pm
Automating the updates would be difficult and can't be done with MQL4. You would have to use VBA or C#.
  • #5
  • Nov 2, 2010 7:19pm Nov 2, 2010 7:19pm
hi george,

MT4 DDE only provide daily high/low
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
  • #6
  • Nov 2, 2010 7:21pm Nov 2, 2010 7:21pm
Quoting CodeMeister
Automating the updates would be difficult and can't be done with MQL4. You would have to use VBA or C#.
Yea i know i need to find somebody that can code it for me.

Thanks CodeMeister.
Blindly following others will make you blind!
  • #7
  • Nov 2, 2010 7:24pm Nov 2, 2010 7:24pm
Quoting sangmane
hi george,

MT4 DDE only provide daily high/low
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
Hi sangmane, i already know this, but that is not what i'm after.

Thanks you anyway for the input.
Blindly following others will make you blind!
  • #8
  • Nov 2, 2010 7:54pm Nov 2, 2010 7:54pm
George,

Two ways to do this:

a) Easy way- If you will have a continued, uninteruppted DDE link between MT4 and Excel, you can have Excel capture the high or low of the day or whatever you want from the DDE live data (ie. using events in VBA your spreadsheet can check on every incoming tick if it is the high or low of the day) Then at the end of the session, voila, you will have your daily data.

or b) Slightly more complex- As mentioned before, have MT4 create CSV files and then periodically process them from Excel

Either way, I've done similar wok and could help you with the coding.

Shoot me a PM.
  • #9
  • Nov 3, 2010 7:45am Nov 3, 2010 7:45am
Quoting SmokyByers
George,

Two ways to do this:

a) Easy way- If you will have a continued, uninteruppted DDE link between MT4 and Excel, you can have Excel capture the high or low of the day or whatever you want from the DDE live data (ie. using events in VBA your spreadsheet can check on every incoming tick if it is the high or low of the day) Then at the end of the session, voila, you will have your daily data.

or b) Slightly more complex- As mentioned before, have MT4 create CSV files and then periodically process them from Excel

Either way, I've done similar...
Hi SmokyByers,

Thank you for your post.

I don't want high/low from the DDE.

What i need is, all the trades i have taken for a day should automatic update my spreadsheet so i don't have to type all the information into my spreadsheet every time i take a trade.

Hope is't more clear
Blindly following others will make you blind!
  • #10
  • Last Post: Nov 3, 2010 8:27am Nov 3, 2010 8:27am
hey george..... it's just a few steps to export trades to a spread sheet....

open the file, loop thru orders writing as you go, and close file.....

your spread sheet might have to reside in the files folder in the experts folder..... but a shortcut to it could reside anywhere, such as on your desktop.....


this could be done in a script, or in a ea that is coded to export at particular time/times of the day.....

the 'wrting as you go step' would obviously have to be writing in the same layout of your spread sheet....

ie, if orderopenprice() comes before ordercloseprice() in the spread sheet, the filewrite function should write accordingly...... fewer steps that way....


rough example below.... if your handy with excel, i'm not, you could then make any sort of cell manipulations/movements needed........h

Inserted Code
 
FileWrite( FileHandle, OrderTicket(), OrderSymbol(), OrderType(), OrderOenPrice(),OrderClosePrice() );
to trade and code, keep both simple... no call to impress....h
0 traders viewing now