Maybe this will help?
https://www.mql5.com/en/code/10881

Export to Excel in Real Time
- www.mql5.com
I use DDE library provided by Windows and wrap it up so that a novice coder can use it easily. DDE works as follow: Initialize DDE Create string handle for Excel Application (in DDE term, it is known as SERVICE) Create string handle for Sheet name (TOPIC) Connect to Sheet Free the above handles, they won't be used anymore Create string handle...

You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
I have an excel sheet with all the candlestick patterns formations. I want to have live feed data directly from MT4 so that for every formation of a candle i will have the values (OHLC) and the time of the occurence of the candle in my excel sheet automatically. I need this for every time-frame. Before you ask i already enabled DDE import from MT4. I just don't know the formula so that it will come automatically.