MT4/Excel programmers

I want to compare the total live p/l of a group of currencies with the total live p/l of another group to find the “balance” and “peak” points.

I currently have a DDE link from MT4 to Excel feeding it live tick data. What I’m trying to do is to make a chart in Excel which updates (like any fiancial/forex chart) in real time.

So basically, 3 things need to be done:

1. Create DDE link from MT4 to Excel = done
2. Have the tick data automatically accumulate in a column
3. Have the chart automatically update every time the column receives new data.

Is this even possible? For live analysis purposes, it sure would be a great tool. ANY HELP WILL BE HUMONGOUSLY(sp) appreciated.

in VBA, you can user the onData handler (or something with a similar name) to execute a procedure everytime excel receives an update via DDE

Thanks pippero,

I guess I'd need to write a macro which points to the cell receiving the DDE feed, then? I'll give it a try.

Mucho gratos!
--> getting out my "VBA for beginners manual"...

oops... shouldnt write on friday night. the name is "SetLinkOnData". heres the msdn help with an example:

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

have phun

Thanks again, Pippero!

I am working on a system that utilizes different forms of support and resistance to spot areas of confluence using multiple forms of support and resistance.

I want to take the data in my Excel Spread sheet and have that data export itself into MT4 and set different types of Support and Resistance lines. Currently I am taking the data from my spreadsheets from hand and entering it into MT4 but this takes way too long and is very tedious so I want the data from Excel to export into MT4 but I am not a programmer and don't know where to start. Can anyone give me any ideas where to start or point me in the right direction?

Thanks in advance.

What you are asking for is not easy to do, but not impossible.

Most people export data from MT4 to Excel via CSV files rather than trying what you suggest. There have been a number of scripts/EAs to do this kind of thing. I don't recall anybody writing an EA to what you want and if you do a search you will probably find the export kind of EA, not the import. Give search a try or maybe someone else has a better memory than myself.

Given the limited usefulness of this kind of EA, I doubt if anybody is interested in writing one for free.

Hi, I'm looking for someone who can modify Zen Leow's flexi bar swing to generate a signal only on a close above or below the swing bar. Currently the indicator give a signal when price breaks above the swing bar and this generates too many false signals.

I am a junior member and cannot contact members privately yet and so, cannot get in touch with Zen Leow the creator of the indicator.

any suggestions would be greatly appreciated...

With a bit more detail I can help you with this...

You might be interesting in my programming service :-

MT4 / Meta Trader 4 Expert Advisers - Built to your specification
Automate your trading ideas. Custom built Meta Trader 4 Expert Advisers and Indicators. To your specification. Discretion guaranteed, competitive rates. I have over 5 years full time forex trading experience and 30 years software development experience.


www.facebook.com/MetaDeveloper

You could do that with a script.
The script would read your data file from excel and then plot the lines.

Hi Qpip,

Do you still have the DDE link from MT4 to excel file still?
Thanks in advanced.