Working with Excel (tools, indicators, conversion ...) - page 24

 

DDE Tics don't match

After finally getting my DDE to work I have a problem.

I checked the tics on MT4 and at the same time the tics on XL (2007) via DDE.

XL appears to miss some of the tics.

Can someone please explain why this would be and/or what to do to correct it.

Any help much appreciated.

 

Supertrend excel formula

Hello everyone!

Does anyone know the mathematical formula of the indicator SUPERTREND?

I would like to accomplish in Excel.

THANKS!

 

Weekly, Monthly, high - low in excel.

HI There,

Can anyone help me by letting me know how to print Weekly, Monthly, high - low in excel.

I know how to do daily , not sure about weekly and monthly.

='MT4'|HIGH!EURUSD

thanks

 

MT4 to Excel

I am well versed with c++ and MQL4 but beyond that I have no experience with app development. I am computing data using an indicator and writing the data to a csv file. I would like to write to an xls file such that the code would also generate a chart. So my file has the format of two rows of data, block of empty rows, then two rows of data then block of empty rows. I would like the code to generate a chart in the block of empty rows. I searched google and youtube on how to do this but none showed how to do this with only c++ and mql4.

Help please!

 

Help - Excel Indicator

Please, if anyone is willing to share this excel indicator or a link to where it may be found I would very much appreciate it.

Thank you!

Files:
 

Excels forecast function

--------------------------------------------------------------------------------

I have been using Excel forecast formula to predict price with MT4 data

Its pretty accurate. I need to how to code this formula into an indicator or EA.

Any excel experts out there who knows how to decode the formula used in Excels forecast function

 

Microsoft Excel Trader

I am using Microsoft Excel trader - Is there any one who is using it and can you please let me know how to record the daily price move in a separate sheet.

Files:
 

Can anybody tell me why the values for eur usd and gbp usd are *1000?

Files:
 

...

What version (build) of metatrader are you using

This is that same example with build 419 and everything is OK

phili:
Can anybody tell me why the values for eur usd and gbp usd are *1000?
Files:
excel_dde.png  7 kb
 

Opening a file with an MT4 script

Hi all,

I built a script that writes some data to a .csv

Is there a way to actually open that file using the script?

I dont mean using FileOpen but actually launching the file with excel.

Thanks

Reason: