MetaTrader and Excel using DDE

Hi All,
I am trying to construct a table with prices using DDE links from MT4 to Excel. I can see only the last updated price in my Excel file, but I would like to create a VBA code so as I can keep old prices in the workseet in different cells. I ' ve seen something some codes use "setlinkstodata" but I couldn't manage to use that. Any help please ?

if you add this line to your vba project:

ActiveWorkbook.SetLinkOnData _
"MT4|BID!EURUSD", _
"testFunction"


testFunction will be called everytime there is a new price coming on eurusd. when it is called you can have it store the current value anyway you want..

Thank you Pippero ! I used your formula and now the file gets upgraded when new data comes. But I still cannot make a table to put new prices and store old ones in a different row.
I would like to make a macro to fill the range C6:H100 with prices, and when the range is filled, to start again from the beginning. With this, i will be able to calculate descriptive statistics for a period of time !

So far my code is:

Sub table()
Dim Rng1 As Range
Set Rng1 = Range("C4")
Rng1.Select
Selection.Copy
Dim mifila As Integer
mifila = 6
For mifila = 6 To 100
Range(mifila, 3).Select
ActiveSheet.Paste
mifila = mifila + 1
Next mifila
End Sub

It doesnt work and it will not start from row 6 once again when the 100 rows were filled with prices. Any help or advice ? thanks again ..

with meta trader comes an astonishing ability to create the charts and graphs with the use of excels. one doesn't have the need to learn mql and other typical languages.

with regards

David Paul

How do I log only the 5pm close price of a pair.
i know the bid price formula , but I only want the 5:00 p.m. price in a cell


=MT4|BID!USDCHF for the Bid and

=MT4|ASK!USDCHF for the Ask and so on

toddanderson,

u have the ans ?

No, never found how to log just a 5pm price with dde server
are you trying the same

i just need previous day close price on excel... using dde.

chanced upon this thread as i was looking for a way to log the open and close prices from a DDE feed into excel.

wonder if anyone knows of a solution already?