Working with Excel (tools, indicators, conversion ...) - Page 5

primajaya · #41 (**permalink**) 11-30-2006, 09:57 AM

Quote:

Originally Posted by hapalkos

I have several Excel sheets that utilize the DDE data from MT4. I am unable to update my sheets. They just stall and have to be terminated. I tried the MT4 DDE Excel example and it would not update. Same results. I tested with codersguru's DDE client and another DDE client. They both are successful in reading the DDE data. I think the problem may be with Excel, some automatic security update or some system setting but I have not yet found a solution. Has anyone else run into a similar problem? I suspect that the solution is simple but it eludes me. Please help.

Please make sure your DDE server is activated
on MT4 click Tools=>options then choose Server tab, then activated your DDE then OK..
hope this can help you....

Bench J · #42 (**permalink**) 03-12-2007, 04:00 AM

In history center you can export.. open-high-low-close .. but not the indicator values.. does any one know how to export indicator values as well ?

thank you..

newdigital · #43 (**permalink**) 03-14-2007, 02:18 PM

Some tools:

- ExoticWaves: small software to create exotic waves indicators (MT4).

- ForecasterXL for excel.

I did not try it.
Just found it inside my computer.

davsar · #44 (**permalink**) 04-05-2007, 02:48 PM

Have you figured it out? Im stuck on the same problem...

Nordic12 · #45 (**permalink**) 04-13-2007, 09:08 AM

Hi

I am trying to backtest, I have tried to look at MQL but since I am not a programmer its a long uphill struggle.

Does anyone have a basic spreadsheet (or suggest other easier tools) to help in backtesting ?

thanks

rene · #46 (**permalink**) 04-26-2007, 06:18 AM

backtesting in MT is very simple!
Just press ctrl+r to display the strategy tester,select the EA which you want to test, and select the symbol and time period, click start, then everything is OK.
why you try to use excel to do backtesting.

sprtn · #47 (**permalink**) 07-27-2007, 12:09 AM

I built this in excel back when I first started forex and it has served me well. I made it a little prettier than what it was when I first built it.

The directions are on the second sheet and I don't guarantee that the calculator works for all brokers.

Download here:
SPRTN_Forex_Pip_Calculator.xls

InTrance · #48 (**permalink**) 08-04-2007, 12:37 PM

Hi,

I'm looking for a way to import backtests to excel to do some analysis there, is it possible?

thanks

ldamiani · #49 (**permalink**) 08-04-2007, 02:32 PM

I use the library below, called Damianalisys, which is an adaption of a library available in Metaquote site. Unfortunately I made some changes in order to make comma as the decimal separator, but it is not so difficult to re-write the code.

I am also including a simple script so that you can export indicators to csv files by simply dragging the script.

ldamiani · #50 (**permalink**) 08-04-2007, 03:39 PM

Quote:

Originally Posted by InTrance

Hi,

I'm looking for a way to import backtests to excel to do some analysis there, is it possible?

thanks

Hi, InTrance, it seems there was already a lot of posts about your question (as they moved the thead here). So forget my stuff, it is probably useless. Any way I don't use Excel anymore, I only use csv as a intermediary format so that i can import data to R (The R Project for Statistical Computing ). if you are really serious about automated trading, besides the best simulation software (thats to say Metatrader), you will need a good statistical package (R, S-plus, etc)