[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Formula for Thomas De mark Sequential Setup & Countdown


  • To: <metastock@xxxxxxxxxxxxx>
  • Subject: Re: Formula for Thomas De mark Sequential Setup & Countdown
  • From: "A.J. Maas" <anthmaas@xxxxxxxxx>
  • Date: Thu, 19 Aug 1999 12:50:09 -0700
  • In-reply-to: <014801bee85d$f26a2e00$488574cb@xxxxxxx>

PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3401" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>passing on some old mails on this 
subject..........</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>Regards,<BR>Ton Maas<BR><A 
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss the 
".nospam" bit (including the dot) when replying and<BR>note the new address 
change. Also for my Homepage<BR><A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV><FONT size=2>
<DIV>----- Original Message ----- 
<DIV>From: Ken</DIV>
<DIV>To: &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</DIV>
<DIV>Sent: zaterdag 5 september 1998 4:44</DIV>
<DIV>Subject: Re: DeMark Sequential</DIV></DIV>
<DIV><BR></DIV>
<DIV>&gt; <BR>&gt; <BR>&gt; Al Taglavore wrote:<BR>&gt; <BR>&gt; &gt; I went 
long 200 HDI today.&nbsp; As I look at the EOD chart I have printed,<BR>&gt; 
&gt; it appears to be a textbook example of DeMark's 9 day set up with<BR>&gt; 
&gt; intersection having occurred yesterday (9th day). I bought because 
HDI<BR>&gt; &gt; had a successful retest of the low of two days ago.&nbsp; Would 
appreciate<BR>&gt; &gt; any Sequential followers to look at the chart and post a 
comment.<BR>&gt; &gt;<BR>&gt; &gt; Al Taglavore<BR>&gt; <BR>&gt; Al,<BR>&gt; 
<BR>&gt; Thanks!&nbsp; I'm glad you brought this up, because I didn't get a 
signal.<BR>&gt; That caused me to re-examine the formula that I'm using and 
re-read the<BR>&gt; rules for a set up.&nbsp; What I found is that there was 
indeed a&nbsp; valid set up<BR>&gt; on 9/3.&nbsp; So why'd I get left 
behind?&nbsp; Here's why:&nbsp; DeMark says that the<BR>&gt; day prior to day 
one of a buy set up must have a close &gt;= the close 4 days<BR>&gt; 
earlier.&nbsp; I didn't have the "=" in this formula, which caused it not 
to<BR>&gt; fire, because the close of&nbsp; 8/21 and 8/17 are in fact 
equal.&nbsp; Fortunately<BR>&gt; that condition doesn't happen very often. ( I 
keep telling myself that.<BR>&gt; :-) )&nbsp;&nbsp; BUT, who knows, maybe it 
caused me to miss the "big one" (way back<BR>&gt; when) and Maybe I could'a 
retired already by now.&nbsp; &lt;g&gt;&nbsp;&nbsp; The successful<BR>&gt; 
retest of the previous low can't be a bad thing.&nbsp; If you're still in, 
I<BR>&gt; hope it works out.&nbsp;&nbsp; If you ARE still in, it must seem to 
you like time is<BR>&gt; standing still, based on your usual 2 hour +\-&nbsp; 
trades.&nbsp; &lt;G&gt;<BR>&gt; <BR>&gt; Have a great weekend,<BR>&gt; <BR>&gt; 
Ken<BR></DIV>
<DIV>At 10:43 PM 6/16/98 , CLAUDB wrote:<BR>&gt;<BR>&gt;&gt; 
Ken,<BR>&gt;&gt;<BR>&gt;&gt; I can't use Mime files. Any chance you can send it 
in another format?<BR>&gt;&gt;<BR>&gt;&gt; Claud<BR>&gt;<BR>&gt;Yep, in fact I 
prefer to send it in plain old text, even though it's a<BR>&gt;little more 
work.&nbsp; That MS data file _alone_ that&nbsp; I sent was a pig<BR>&gt;(about 
20 - 30k).&nbsp; I think the chart was only about half 
that.<BR>&gt;</FONT></DIV>
<DIV><FONT size=2>&gt;Believe me, the indicators that I sent are nothing 
fancy.&nbsp; Setup is<BR>&gt;nearly the same as what was posted earlier.&nbsp; I 
think Intersection is a<BR>&gt;little different though, but I haven't had the 
time to compare.&nbsp; This<BR>&gt;Countdown indicator is simply a day to day 
indicator that requires using<BR>&gt;your fingers and toes once Setup (and 
Intersection, if you choose to use<BR>&gt;it) is/are complete.&nbsp; Nothing 
sophisticated at all.&nbsp; I find it easier and<BR>&gt;quicker to let the 
indicators help me determine the current phase than to<BR>&gt;compare a bar's 
close with another prior bar's close or low/high.&nbsp; As far<BR>&gt;as 
Countdown, I've written many high-falutin type indicators (or so I<BR>&gt;like 
to think &lt;g&gt; ) that I thought were going to be the answer, but 
in<BR>&gt;the end they all fizzled.<BR>&gt;<BR>&gt;You could run a test or 
exploration for Setup, then from there manually<BR>&gt;track Intersection (if 
you're so inclined), then Countdown.&nbsp; Sometimes<BR>&gt;you get a pretty 
good reaction at the completion of Setup, so you may not<BR>&gt;want to include 
Intersection in an exploration or you could possibly miss<BR>&gt;it, although 
Intersection occurs more often than not by day 9.&nbsp; Back when<BR>&gt;it 
first was published, Sequential&nbsp; worked well on the few markets that 
I<BR>&gt;watched, but I haven't been watching it lately, although all 
this<BR>&gt;discussion has got me curious again.<BR>&gt;<BR>&gt;I think 
everything I'm sending are the correct formulas, but if something<BR>&gt;doesn't 
look right, let me know.<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp; - 
Indicators-<BR>&gt;<BR>&gt;(The following BUY SETUP/SELL SETUP is one indicator 
in 6.5.<BR>&gt;Pre-6.5 users need to use it as two indicators)<BR>&gt;* SeqSETUP 
w/Validation day*<BR>&gt;<BR>&gt;{BUY SETUP}<BR>&gt;<BR>&gt;If((C &lt; Ref(C,-4) 
AND<BR>&gt;Ref(C,-1) &lt; Ref(C,-5) AND<BR>&gt;Ref(C,-2) &lt; Ref(C,-6) 
AND<BR>&gt;Ref(C,-3) &lt; Ref(C,-7) AND<BR>&gt;Ref(C,-4) &lt; Ref(C,-8) 
AND<BR>&gt;Ref(C,-5) &lt; Ref(C,-9) AND<BR>&gt;Ref(C,-6) &lt; Ref(C,-10) 
AND<BR>&gt;Ref(C,-7) &lt; Ref(C,-11) AND<BR>&gt;Ref(C,-8) &lt; Ref(C,-12) 
AND<BR>&gt;{Validation Day}<BR>&gt;Ref(C,-9) &gt; Ref(C,-13) 
),1,0)<BR>&gt;<BR>&gt;{SELL SETUP}<BR>&gt;<BR>&gt;If((C &gt; Ref(C,-4) 
AND<BR>&gt;Ref(C,-1) &gt; Ref(C,-5) AND<BR>&gt;Ref(C,-2) &gt; Ref(C,-6) 
AND<BR>&gt;Ref(C,-3) &gt; Ref(C,-7) AND<BR>&gt;Ref(C,-4) &gt; Ref(C,-8) 
AND<BR>&gt;Ref(C,-5) &gt; Ref(C,-9) AND<BR>&gt;Ref(C,-6) &gt; Ref(C,-10) 
AND<BR>&gt;Ref(C,-7) &gt; Ref(C,-11) AND<BR>&gt;Ref(C,-8) &gt; Ref(C,-12) 
AND<BR>&gt;{Validation Day}<BR>&gt;Ref(C,-9) &lt; Ref(C,-13) 
),-1,0)<BR>&gt;<BR>&gt;<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
*SeqINTERSECTION*<BR>&gt;<BR>&gt;{DeMark says this is now ELECTIVE in futures 
and index markets}<BR>&gt;<BR>&gt;L &lt;= Ref(HHV(H,6),-3) AND L &gt;= 
Ref(LLV(L,6),-3) OR<BR>&gt;H &gt;= Ref(LLV(L,6),-3) AND H &lt;= 
Ref(HHV(H,6),-3)<BR>&gt;<BR>&gt;<BR>&gt;<BR>&gt;(The following is one indicator 
in 6.5.&nbsp; Pre-6.5 users need to use it as<BR>&gt;two 
indicators)<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *SeqCdB/S 
(Countdown for Buys and Sells)*<BR>&gt;<BR>&gt;{plots +1 for BUYS, plots -1 for 
SELLS.}<BR>&gt;<BR>&gt;If(C &lt; Ref(L,-2),1,0) ;<BR>&gt;If(C &gt; 
Ref(H,-2),-1,0)<BR>&gt;<BR>&gt;(...and all this time you probably thought I had 
come up with something<BR>&gt;fancy.&nbsp; :)&nbsp;&nbsp; 
)<BR>&gt;<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *System Test * (If you 
don't want validation day, don't use it.)<BR>&gt;<BR>&gt;Seq SETUP,V 
day<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp; {BUY SETUP}<BR>&gt;C &lt; Ref(C,-4) 
AND<BR>&gt;Ref(C,-1) &lt; Ref(C,-5) AND<BR>&gt;Ref(C,-2) &lt; Ref(C,-6) 
AND<BR>&gt;Ref(C,-3) &lt; Ref(C,-7) AND<BR>&gt;Ref(C,-4) &lt; Ref(C,-8) 
AND<BR>&gt;Ref(C,-5) &lt; Ref(C,-9) AND<BR>&gt;Ref(C,-6) &lt; Ref(C,-10) 
AND<BR>&gt;Ref(C,-7) &lt; Ref(C,-11) AND<BR>&gt;Ref(C,-8) &lt; Ref(C,-12) 
AND<BR>&gt;{Validation Day}<BR>&gt;Ref(C,-9) &gt; 
Ref(C,-13)<BR>&gt;<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
{SELL SETUP}<BR>&gt;C &gt; Ref(C,-4) AND<BR>&gt;Ref(C,-1) &gt; Ref(C,-5) 
AND<BR>&gt;Ref(C,-2) &gt; Ref(C,-6) AND<BR>&gt;Ref(C,-3) &gt; Ref(C,-7) 
AND<BR>&gt;Ref(C,-4) &gt; Ref(C,-8) AND<BR>&gt;Ref(C,-5) &gt; Ref(C,-9) 
AND<BR>&gt;Ref(C,-6) &gt; Ref(C,-10) AND<BR>&gt;Ref(C,-7) &gt; Ref(C,-11) 
AND<BR>&gt;Ref(C,-8) &gt; Ref(C,-12) AND<BR>&gt;{Validation 
Day}<BR>&gt;Ref(C,-9) &lt; 
Ref(C,-13)<BR>&gt;<BR>&gt;<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Exploration-<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
(Plug it in yourself !)<BR></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>
<DIV>
<DIV>----- Original Message ----- 
<DIV>From: A.J. Maas</DIV>
<DIV>To: &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</DIV>
<DIV>Sent: maandag 24 augustus 1998 13:57</DIV>
<DIV>Subject: Re: formula/exploration help</DIV></DIV>
<DIV><BR></DIV>&gt; Correct Steve, there is a character("=") missing for it to 
be a proper Function.<BR>&gt; Should be as follows:<BR>&gt; <BR>&gt; Formula 
Name: REI Indicator<BR>&gt; VAR1:=<BR>&gt; If(Ref(H,-2),&lt; 
,Ref(C,-7),If(<BR>&gt; etc. etc.<BR>&gt; <BR>&gt; You will have to add the " = " 
character to every Function in the REI Indicator-formula.<BR>&gt; <BR>&gt; 
Actualy, this is on the side, but have a look too on p. 
209-212(MS65-manual).<BR>&gt; You will be amaced on this type of 
Function(Variable) and its usage posibilities.<BR>&gt; (Remember never to use 
any EXCISTING names, eg all that are "internaly known" in<BR>&gt; the 
MS-program+its subprograms, see Tip3-Naming of Variables at bottom 
p.209)<BR>&gt; <BR>&gt; Regards,<BR>&gt; Ton Maas<BR></FONT></DIV></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>----- Original Message ----- </FONT>
<DIV><FONT size=2>From: Harvey Pearce</FONT></DIV>
<DIV><FONT size=2>To: &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</FONT></DIV>
<DIV><FONT size=2>Sent: maandag 24 augustus 1998 8:51</FONT></DIV>
<DIV><FONT size=2>Subject: Re: formula/exploration help</FONT></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>&gt; Steve/<BR>&gt; <BR>&gt; The formulas in A.J.Maas post 
"Re: DeMark Indicators" were in MS 5.0<BR>&gt; code, with many commas.&nbsp; 
Translated into v.6.5 the following should do<BR>&gt; it.<BR>&gt; <BR>&gt; 
DeMark Indicator<BR>&gt; <BR>&gt; 
Sum(If(H&gt;Ref(H,-1),H-Ref(H,-1),0),13)/<BR>&gt; 
(Sum(If(H&gt;Ref(H,-1),H-Ref(H,-1),0),13)+<BR>&gt; 
Sum(If(L&gt;=Ref(L,-1),0,Ref(L,-1)-L),13))<BR>&gt; <BR>&gt; <BR>&gt; REI 
Indicator<BR>&gt; <BR>&gt; Var1:=If(Ref(H,-2)&lt;Ref(C,-7),<BR>&gt; 
If(Ref(H,-2)&lt;Ref(C,-8),<BR>&gt; If(H&lt;Ref(L,-5),<BR>&gt; 
If(H&lt;Ref(L,-6),<BR>&gt; 0,1),1),1),1);<BR>&gt; 
Var2:=If(Ref(L,-2)&gt;Ref(C,-7),<BR>&gt; If(Ref(L,-2)&gt;Ref(C,-8),<BR>&gt; 
If(L&gt;Ref(H,-5),<BR>&gt; If(L&gt;Ref(H,-6),<BR>&gt; 0,1),1),1),1);<BR>&gt; 
SubValues:=Var1*Var2*(H-Ref(H,-2))+Var1*Var2*(L-Ref(L,-2));<BR>&gt; 
AbsDailyVal:=Abs(H-Ref(H,-2))+Abs(L-Ref(L,-2));<BR>&gt; 
REI2:=Sum(SubValues,8)/Sum(AbsDailyVal,8);<BR>&gt; REI2<BR>&gt; <BR>&gt; Harvey 
Pearce, Victoria, B.C., Canada<BR>&gt; 
=====================================<BR></FONT></DIV>
<DIV><FONT size=2>Steve Karnish wrote:<BR>&gt; <BR>&gt; Ton,<BR>&gt; When I put 
in DeMark's REI formula...MS rejects the "VAR1" with:<BR>&gt; {This character is 
invalid when used in this manner at this<BR>&gt; location}.&nbsp; What 
gives?&nbsp; I know I'm an idiot when it comes to<BR>&gt; simple programming, 
but I copied the formula and I'm really good<BR>&gt; at typing things in 
exactly.<BR>&gt; <BR>&gt; Thanks in advance,<BR>&gt; Steve Karnish<BR>&gt; 
CCT<BR>&gt;<BR></DIV></FONT>
<DIV><FONT size=2>
<DIV>----- Original Message ----- 
<DIV>From: A.J. Maas</DIV>
<DIV>To: &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</DIV>
<DIV>Sent: zondag 23 augustus 1998 2:58</DIV>
<DIV>Subject: Re: DeMark Indicators</DIV></DIV>
<DIV><BR></DIV>&gt; Resend of prev. mail<BR>&gt; <BR>&gt; Reg.<BR>&gt; Ton 
Maas<BR></FONT></DIV>
<DIV><FONT size=2>&gt; </FONT><FONT size=2>For more on Tom DeMark</FONT></DIV>
<DIV><FONT size=2>&gt; <A 
href="http://www.cwigroup.com/cqg.htm";>http://www.cwigroup.com/cqg.htm</A><BR><BR><BR></DIV></FONT>
<DIV>&nbsp;</DIV>
<DIV><FONT 
size=2>======================================================<BR><BR>DeMark 
Indicator, and REI 
Indicator.<BR><BR>--------------------------------------------------------------------------------<BR><BR><BR>SOFTWARE: 
Metastock<BR>SW VERSION: 5.0<BR>FORMULA NAME: DeMark Indicator, and REI 
Indicator.<BR><BR><BR>INVENTOR: Maury Hill (<A 
href="mailto:EquisInt@xxxxxxx";>EquisInt@xxxxxxx</A> - Equis Support) Reprinted 
here with kind permission.<BR>SUBMITTED BY: Ian Rawnsley (<A 
href="mailto:sdavidr@xxxxxxxxxxx";>sdavidr@xxxxxxxxxxx</A>) MetaStock User Group 
AUCKLAND NEW ZEALAND<BR>SUBMITTED ON: Jun 10 1995.<BR>PUBLISHED: Page 98 and 100 
of Tom Demark's new book, "The New Science of Technical Analysis" 
1994.<BR>COMMENTS: Note that the DeMark indicator on page 100 follows first and 
is contained in one formula only.<BR><BR>The REI(Range Expansion Index follows 
that and is contained over 5 formulas. They could probably be compacted to 
one<BR>formula, but I felt that this is more readable as Tom DeMark presents 
them in a similar manner.<BR><BR><BR>FORMULA:<BR><BR><BR>Formula Name: DeMark 
Indicator<BR>Sum(If(H,&gt; ,Ref(H,-1),H-Ref(H,-1),0),13)/(Sum(If(H,&gt; 
,Ref(H,-1),H-Ref(H,-1),0) ,13)+ 
Sum(If(L,&gt;<BR>=,Ref(L,-1),0,Ref(L,-1)-L),13))<BR><BR><BR>Formula Name: REI 
Indicator<BR>VAR1:<BR>If(Ref(H,-2),&lt; ,Ref(C,-7),If(Ref(H,-2),&lt; 
,Ref(C,-8),If(H,&lt; ,Ref(L,-5),If(H,&lt; ,Re f(L,- 
6),0,1),1),1),1)<BR>VAR2:<BR>If(Ref(L,-2),&gt; ,Ref(C,-7),If(Ref(L,-2),&gt; 
,Ref(C,-8),If(L,&gt; ,Ref(H,-5),If(L,&gt; ,Re f(H,- 
6),0,1),1),1),1)<BR>SubValues:<BR>( Fml("Var1") * Fml("Var2") * (H-Ref(H,-2)) ) 
+ (Fml("Var1") * Fml("Var2") * (L-Ref(L,-2)) )<BR>AbsDailyVal:<BR>( 
Abs(H-Ref(H,-2)) + Abs(L-Ref(L,-2)) )<BR>REI2:<BR>Sum(Fml("SubValues"),8) / 
Sum(Fml("AbsDailyVal"),8)<BR><BR><BR>To the best of my knowledge, these are 
correct. Please inform me if you experience any problems.<BR>Thank You - Maury 
Hill [EQUIS 
Support]<BR><BR><BR>==========================================================</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
  <A href="mailto:kish@xxxxxxxxxxxxxxx"; title=kish@xxxxxxxxxxxxxxx>Kishore 
  Rochey</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A 
  href="mailto:metastock@xxxxxxxxxxxxx"; 
  title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> dinsdag 17 augustus 1999 5:09</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Formula for Thomas De mark 
  Sequential Setup &amp; Countdown</DIV>
  <DIV><BR></DIV>
  <DIV><FONT size=2>I have sent two messages to this listserver. Lets hope this 
  one goes through.</FONT></DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT size=2>Does anyone of you metastock users use the TD Sequential and 
  follow the</FONT></DIV>
  <DIV><FONT size=2>methodology.</FONT></DIV>
  <DIV><FONT size=2>If so do you have the formulas for it.</FONT></DIV>
  <DIV><FONT size=2>I have been manually inserting the de mark counts and it can 
  be quite</FONT></DIV>
  <DIV><FONT size=2>troublesome.</FONT></DIV>
  <DIV><FONT size=2>Any help would be most appreciated.</FONT></DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT size=2>Kishore</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Thu Aug 19 08:04:23 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
	by purebytes.com (8.8.7/8.8.7) with ESMTP id IAA19304
	for <neal@xxxxxxxxxxxxx>; Thu, 19 Aug 1999 08:04:24 -0700
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id WAA13861
	for metastock-outgoing; Thu, 19 Aug 1999 22:20:16 -0600
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
	by listserv.equis.com (8.8.7/8.8.7) with ESMTP id WAA13858
	for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 19 Aug 1999 22:20:13 -0600
Received: from hme0.mailrouter01.sprint.ca (hme0.mailrouter01.sprint.ca [207.107.250.16])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id IAA29735
	for <metastock@xxxxxxxxxxxxx>; Thu, 19 Aug 1999 08:10:09 -0600 (MDT)
Received: from walter (spc-isp-ott-uas-19-32.sprint.ca [209.103.36.183])
	by hme0.mailrouter01.sprint.ca (8.8.8/8.8.8) with SMTP id JAA14990
	for <metastock@xxxxxxxxxxxxx>; Thu, 19 Aug 1999 09:56:50 -0400 (EDT)
Message-ID: <000701beea4a$6fedfda0$b72467d1@xxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
Subject: MS trade analysis
Date: Thu, 19 Aug 1999 09:54:57 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

Thanks for your email.

Here are the basics for doing detailed trade analysis. This will get you
started.

Using System Test in Metastock --> Summary Reports --> click on the
"Reports" button --> click on the "Trades" tab

you get the following column headings:

Trade #
Trade Type
Entry Date
Entry Time
Close Date
Close Time
Profit
MAE
Reason For Close

and the following typical data:

--- Out 07/02/1996 0:00:000 07/18/1996 0:00:000 0.00 0.00 Enter long signal
1 Long 07/18/1996 0:00:000 07/19/1996 0:00:000 -1.41 0.02 Enter short signal
2 Short 07/19/1996 0:00:000 08/01/1996 0:00:000 4.94 0.00 Enter long signal
3 Long 08/01/1996 0:00:000 09/05/1996 0:00:000 34.24 0.00 Enter short signal
4 Short 09/05/1996 0:00:000 09/06/1996 0:00:000 -7.85 0.11 Enter long signal
5 Long 09/06/1996 0:00:000 12/04/1996 0:00:000 132.08 0.02 Enter short
signal
6 Short 12/04/1996 0:00:000 12/10/1996 0:00:000 3.51 0.00 Enter long signal
7 Long 12/10/1996 0:00:000 12/11/1996 0:00:000 -17.67 0.25 Enter short
signal

Most Users put arrows on their test chart and examine the trades visually on
the chart.

But you can more closely examine these CLOSED trades that you would have
experienced had you traded this system. This is your CLOSED trade data base.

Metastock does not allow for further trade analysis, maybe in the future
perhaps, but you can transfer your test index/stock/contract data and this
closed trade data to Excel for detailed "trade analysis"

Set up your data columns and paste in your test data

set up a trades column ... 0 for flat or out; 1 for long, and -1 for short

Set up a profit column with your formulas set for % change or $'s or points
change.

Forget about MAE for now, we're only talking about the basics.

Set up 4 new worksheets:

Long winners
Long losers
Short winners
Short losers

Put Days-in-Trade headings across the top of each new sheet: Day 1, Day 2,
... up to Day 100 or whatever your time frame is.

Transfer the individual trades which are VERTICALLY orientated using copy
and paste to a HORIZONTAL orientation in your new sheets. So that all of
your long winners are grouped together, etc.

Chart your sorted trades ... put all four charts onto a chart sheet (as
embedded charts) if you want to save space otherwise use separate chart
sheets for maximum viewing pleasure.

This will allow you to visually see the relationships and patterns between
your sorted CLOSED trades.

This will allow you to gain a traders perspective on realistic expectations
and cutoff points that is different from a statistical perspective.

Using this approach you can easily establish a Closed trade data base of
several thousand trades.

MAE and MFE are the basics of trade analysis and trade indicator development
as moving averages are the basis of many technical indicators.

I know that this exercise is a lot of work initially, but whatever you can
do manually in Excel you can use macros and VBA to automate the process.

Best regards

Walter