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

 

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.

 
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)

 

Thanks for your advice, Mr. Damiani!

Bluefish

 

Post Free Full version Standalone softwares

Here is the link everthing is in the file.

RapidShare: 1-Click Webhosting

2759 KB.

 

Help with script please

I want a script that writes a file of last 50 MACD entries from MACD 2 indicator.

What I have prints zero for the MACD values and only

one value for each.

I have tried another indicator and it prints only the figure at the max

loop number (in this case bar 50 only not 49,48,47,etc).

Any help greatly appriecated.

This is what I have so far

//+------------------------------------------------------------------+

//| script program start function |

//+------------------------------------------------------------------+

double macd,sig;

int start()

{

//----

int handle=FileOpen("my_data.csv",FILE_CSV|FILE_WRITE,',');

if (handle<0)return(0);

FileWrite(handle,"macd","sig");

for (int i=1;i<50;i++)

{

macd = iCustom(Symbol(),0,"MACD 2",0,i);

sig = iCustom(Symbol(),0,"MACD 2",1,i);

FileWrite(handle,macd,sig);

FileClose(handle);

}

//----

return(0);

}

 

script help

Might have figured it out.

iMACD seems to work.Any comments still welcome though.

 

Cot Data Working with exel

Does anyone know how to convert Cot data

commitments of traders .cftc.gov

Iam trying to convert to csv format to import to Excel

but I am not having any luck

my excel skills are very poor

 

New Trading Platform uses Excel

Today Sep 14 2007, SpoozTools released their new SpoozTools v2.0 trading Demo. The demo is a video in 3 parts.

Created by Camtasia Theater

This new Platform when released can manual and automatically trade stocks, futures, Forex, bonds, commodities and etc.

I think it worth a look.

 

You can also do a File, Save As to save your chart data, but it also does not save the indicator values that you have on your chart like eSignal will.

Anyone know how to do it? I want to do backtests that require database or excel manipulation.

Thanks