Page 1 of 1

strategy automaticly export into a xls sheet.

Posted: Mon Jun 19, 2006 4:27 pm
by phi
HI i´m new in this froum. and i have already a question;)
maybe someone can help me.

i have a strategy like this


{*******************************************************************
Description : Moving Average Crossover (2 Line) Long Entry
Provided By : Omega Research, Inc. (c) Copyright 1999
********************************************************************}




Inputs: Price(Close), FastLen(9), SlowLen(18);




If CurrentBar > 1 AND AverageFC(Price, FastLen) Crosses Above AverageFC(Price, SlowLen) Then
Buy ("MAC") 10 contracts This Bar on Close;


Print(date,close);


and i want to export the buysignal into a excel sheet.
it should export every day if it is long or short or flat, and the date, price close.
you think this is possible?

many thanks

josef

Posted: Sat Jun 24, 2006 6:15 pm
by phi
maybe somebody can help me please?

thx

josef

Posted: Tue Jul 25, 2006 6:12 pm
by phi
maybe someone can take a look at this..

many tahnks

josef

Posted: Mon Sep 11, 2006 11:42 am
by twalker
I have been trying to do the same thing and asked this question on the TS forum to which I received the folloing code

{Collect Statistics & Write Excel file}

vars:
Intrabarpersist xAction("");
condition0=(Action<>"" AND Action<>"Spread Warning" AND Action<>xAction);

vars:xDate("");
xDate=DateToString( DateToJulian( Date ) );

If condition0 then begin //Check only for new trades

if time>=0930 AND time<1601 then
fileappend("c:\TSStats1_" + NumToStr( Date, 0 ) + ".csv",
GetSymbolName +";" +
xDate +";" +
numtostr(t,0)+";"+
numtostr(C,2) +";"+
Action+";"+
a1Min+";" +
a5Min+";" +
a15Min+";"+
a60Min+";"+
a120Min+";"+
aDaily+";"+
aWeek+
NewLine);

end;//End Printing
{Update Intrabarpersist values}
xAction=Action;

This seems to be decipherable so you can adjust the data for what is required to be exported. I am using this as a way to automate execution through another platform.

Posted: Tue Sep 12, 2006 6:03 am
by phi
thx twalker!