You could use the excel file provided with the MT4 installation as example. DDE is just a protocol. See from the link you provided 4. Cell Function DDE.

See this example, is StarCalc the brother of OOCalc but it's the same thing.

Attached Images

2008-08-18_115924.gif (30.7 KB, 237 views)

__________________

Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum

Has anyone looked at or have a excel sheet that shows correlation
between gold, oil, bond , dow and currency

or any work sheet that has correlation on it to get me started
I am not that good with excel but will try

Please someone help me to convert qqe.mq4 to excel, i very very need it.

or you can make simple equation like this (example, laquerre):
Inputs: Price((H+L)/2),
gamma(.8);

Vars: L0(0),
L1(0),
L2(0),
L3(0),
Filt(0)
FIR(0);

L0 = (1 - gamma)*Price + gamma*L0[1];
L1 = -gamma*L0 + L0[1] + gamma*L1[1];
L2 = -gamma*L1 + L1[1] + gamma*L2[1];
L3 = -gamma*L2 + L2[1] + gamma*L3[1];

Filt = (L0 + 2*L1 + 2*L2 + L3) / 6;
FIR = (Price + 2*Price[1] + 2*Price[2] + Price[3]) / 6;

Plot1(Filt, "Filt");
Plot2(FIR, "FIR");

i can make it for my self.
thank you in advance

Attached Files

QQE.mq4 (3.1 KB, 8 views)

I am not getting volume to work, the mt4 sample does not have volume
I have tried these but not getting volume to work i have bid,ask,hi,low working but not volume
='MT4'|VOL!EURUSD
='MT4'|VOLUME!EURUSD
=MT4|VOL!EURUSD
=MT4|VOLUME!EURUSD

I am not getting these to work

There is no explanation about Volume on the help files and I can't find any information about.Sorry

__________________

Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum

Thank you, no problem i will keep looking,

I do find it strange i have read many times that you can do it.
but i have not seen it done yet with volume.

Hi,

Can anyone give me some idea of how i can connect excel and metatrader. I have managed to get the bid/ask in excel via DDE but am looking to get the order ticket into excel.

Any help would be appreciated.

Thanks

Excel –DDE server CDF Tickers
I am getting errors when enter formulas on some of the future tickers
WhCapital CDF
=MT4|BID!6EU8 this creates an error any ticker that starts with a number creates an error as Excel see it as a invalid formula =MT4|BID!EURUSD AND OTHERS WORK FINE
I posted this question in some of the excel forums , but didnt get any help as most of them are not
Fimiluar with stock cdf tickers. Hoping to find some help.

Please, take a look to my last post on: Mt4 and DDE

__________________

Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum

Hi guys,

From this forum I learned to save data into a cvs file. I tried to also make the zig zag point onto the data file, but failure. I don't really understand the indicator. Can anyone give me some tips?

Cheers