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

Re: too many numeric constants defined in formula



PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>
<DIV><FONT size=2>Error can be caused by:</FONT></DIV>
<DIV><FONT size=2>-missing characters, eg your 39th and 40th days weren't 
followed by the&nbsp;'+' (plus character), and</FONT></DIV>
<DIV>&nbsp; as such the formula will be read as though everything else&nbsp;that 
follows next ALSO belongs to your 39th day</DIV>
<DIV><FONT size=2>-try not to use numbers in a variable's name</FONT></DIV>
<DIV>-refrain from using capitol letters for small letters; eg do not use n for 
N (or vice versa)</DIV>
<DIV>-avoid too long variable formula's, eg split formula into&nbsp;some more, 
now shorter variables</DIV>
<DIV>-visualy break the formula's with Indented Lines, eg use CTRL+TAB (Formula 
Tips, MSK man. p.214)</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>N:=50;<BR>TN:=Mov(C,N,S);<BR>sOneA:=((n-1)/2)*C+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-3)/2)*Ref(C,-1)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-5)/2)*Ref(C,-2)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-7)/2)*Ref(C,-3)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-9)/2)*Ref(C,-4)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-11)/2)*Ref(C,-5)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-13)/2)*Ref(C,-6)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-15)/2)*Ref(C,-7)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-17)/2)*Ref(C,-8)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-19)/2)*Ref(C,-9);</FONT></DIV>
<DIV><FONT size=2>sOneB:=((n-21)/2)*Ref(C,-10)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-23)/2)*Ref(C,-11)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-25)/2)*Ref(C,-12)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-27)/2)*Ref(C,-13)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-29)/2)*Ref(C,-14)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-31)/2)*Ref(C,-15)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-33)/2)*Ref(C,-16)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-35)/2)*Ref(C,-17)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-37)/2)*Ref(C,-18)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-39)/2)*Ref(C,-19);</FONT></DIV>
<DIV><FONT size=2>sOneC:=((n-41)/2)*Ref(C,-20)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-43)/2)*Ref(C,-21)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-45)/2)*Ref(C,-22)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-47)/2)*Ref(C,-23)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-49)/2)*Ref(C,-24)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-51)/2)*Ref(C,-25)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-53)/2)*Ref(C,-26)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-55)/2)*Ref(C,-27)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-57)/2)*Ref(C,-28)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-59)/2)*Ref(C,-29);</FONT></DIV>
<DIV><FONT size=2>sOneD:=((n-61)/2)*Ref(C,-30)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-63)/2)*Ref(C,-31)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-65)/2)*Ref(C,-32)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-67)/2)*Ref(C,-33)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-69)/2)*Ref(C,-34)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-71)/2)*Ref(C,-35)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-73)/2)*Ref(C,-36)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-75)/2)*Ref(C,-37)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-77)/2)*Ref(C,-38)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-79)/2)*Ref(C,-39);</FONT></DIV>
<DIV><FONT size=2>sOneE:=((n-81)/2)*Ref(C,-40)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-83)/2)*Ref(C,-41)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-85)/2)*Ref(C,-42)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-87)/2)*Ref(C,-43)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-89)/2)*Ref(C,-44)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-91)/2)*Ref(C,-45)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-93)/2)*Ref(C,-46)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-95)/2)*Ref(C,-47)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-97)/2)*Ref(C,-48)+</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp; ((n-99)/2)*Ref(C,-49);</FONT></DIV>
<DIV>sOne:=sOneA+sOneB+sOneC+sOneD+sOneE;</DIV>
<DIV><FONT size=2>yTwo:=TN+(6*sOne)/((N+1)*N);</FONT></DIV>
<DIV><FONT size=2>yTwo<BR></FONT></DIV></FONT></DIV>
<DIV><FONT size=2><BR>Regards,<BR>Ton Maas</FONT></DIV>
<DIV><FONT size=2><A 
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss the 
".nospam" bit (including the dot) when replying.<BR>Homepage&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
  <A title=sky40912@xxxxxxxxx href="mailto:sky40912@xxxxxxxxx";>Theo E.M. 
  Lockefeer</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>Metastock User Group</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> zaterdag 19 februari 2000 
  15:50</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> too many numeric constants 
  defined in formula</DIV>
  <DIV><BR></DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT color=#008080><STRONG><EM>To All :</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080><STRONG><EM>You may not believe it but this formula 
  could be very usefull for</EM></STRONG></FONT></DIV>
  <DIV><FONT color=#008080><STRONG><EM>me :</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080><STRONG><EM>it's a 50 day modified moving average 
  .</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080><STRONG><EM>I get a " too many numeric constants 
  defined in formula"</EM></STRONG></FONT></DIV>
  <DIV><FONT color=#008080><STRONG><EM>error :&nbsp; ok but is there a way 
  around this ?</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080><STRONG><EM>Thx </EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080><STRONG><EM>Theo</EM></STRONG></FONT></DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV><FONT 
  size=2>N:=50;<BR>TN:=Mov(C,N,S);<BR>s1:=((n-1)/2)*C+((n-3)/2)*Ref(C,-1)+((n-5)/2)*Ref(C,-2)+((n-7)/2)*Ref(C,-3)<BR>+((n-9)/2)*Ref(C,-4)+((n-11)/2)*Ref(C,-5)+ 
  ((n-13)/2)*Ref(C,-6)+((n-15)/2)*Ref(C,-7)<BR>+((n-17)/2)*Ref(C,-8)+((n-19)/2)*Ref(C,-9)+ 
  <BR>((n-21)/2)*Ref(C,-10)+((n-23)/2)*Ref(C,-11)+((n-25)/2)*Ref(C,-12)+((n-27)/2)*Ref(C,-13)<BR>+((n-29)/2)*Ref(C,-14)+((n-31)/2)*Ref(C,-15)+ 
  ((n-33)/2)*Ref(C,-16)+((n-35)/2)*Ref(C,-17)<BR>+((n-37)/2)*Ref(C,-18)+((n-39)/2)*Ref(C,-19)+<BR>((n-41)/2)*Ref(C,-20)+ 
  ((n-43)/2)*Ref(C,-21)+((n-45)/2)*Ref(C,-22)+((n-47)/2)*Ref(C,-23)<BR>+((n-49)/2)*Ref(C,-24)+((n-51)/2)*Ref(C,-25)+ 
  ((n-53)/2)*Ref(C,-26)+((n-55)/2)*Ref(C,-27)<BR>+((n-57)/2)*Ref(C,-28)+((n-59)/2)*Ref(C,-29)+<BR>((n-61)/2)*Ref(C,-30)+<BR>((n-63)/2)*Ref(C,-31)+((n-65)/2)*Ref(C,-32)+((n-67)/2)*Ref(C,-33)<BR>+((n-69)/2)*Ref(C,-34)+((n-71)/2)*Ref(C,-35)+ 
  ((n-73)/2)*Ref(C,-36)+((n-75)/2)*Ref(C,-37)<BR>+((n-77)/2)*Ref(C,-38)+((n-79)/2)*Ref(C,-39)<BR>((n-81)/2)*Ref(C,-40)<BR>((n-83)/2)*Ref(C,-41)+((n-85)/2)*Ref(C,-42)+((n-87)/2)*Ref(C,-43)<BR>+((n-89)/2)*Ref(C,-44)+((n-91)/2)*Ref(C,-45)+ 
  ((n-93)/2)*Ref(C,-46)+((n-95)/2)*Ref(C,-47)<BR>+((n-97)/2)*Ref(C,-48)+((n-99)/2)*Ref(C,-49);</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT size=2></FONT>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT size=2>y2:=TN+(6*S1)/((n+1)*n);</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT size=2>y2<BR></FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sat Feb 19 18:31:19 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
	by purebytes.com (8.9.3/8.9.3) with ESMTP id SAA05952
	for <neal@xxxxxxxxxxxxx>; Sat, 19 Feb 2000 18:15:55 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id SAA30672
	for metastock-outgoing; Sat, 19 Feb 2000 18:45:02 -0700
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 SAA30656
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 19 Feb 2000 18:44:53 -0700
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
	by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id SAA28899
	for <metastock@xxxxxxxxxxxxx>; Sat, 19 Feb 2000 18:58:56 -0700 (MST)
Received: from escom ([195.121.216.136]) by smtp02.wxs.nl
          (Netscape Messaging Server 3.61)  with SMTP id AAB14A0
          for <metastock@xxxxxxxxxxxxx>; Sun, 20 Feb 2000 02:42:53 +0100
Message-ID: <003001bf7b44$3e4a1be0$88d879c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <002a01bf7af7$f68056e0$0101010a@xxxxxxxxxxxxx>
Subject: Re: moving average discrepancies
Date: Sun, 20 Feb 2000 00:32:16 +0100
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0093_01BF7B39.F031A180"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.3825.400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.3825.400
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>The MetaStock version is correct.</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>1. Are the underlying subjects data file's 
Closings</FONT></DIV>
<DIV><FONT size=2>-also given for the same dates</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;</FONT><FONT size=2>and/or</FONT></DIV>
<DIV><FONT size=2>-</FONT><FONT size=2>are Closings&nbsp;also&nbsp;of the same 
values</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>2. Is the correct underlay choosen, eg the correct object 
for&nbsp;indicator, when dragging</FONT></DIV>
<DIV><FONT size=2>the Moving Average indicator from </FONT><FONT size=2>the 
Indicator Quick List?</FONT></DIV>
<DIV><FONT size=2>It will always automaticaly </FONT><FONT size=2>select the 
Price indicator&nbsp;(Base Security's color will change to 
Magenta),</FONT></DIV>
<DIV><FONT size=2>but you can easely change and (accidently) influence this 
selecting behaviour by</FONT></DIV>
<DIV><FONT size=2>-at that time of selection-&nbsp; </FONT><FONT 
size=2>(accidently)&nbsp;pointing </FONT><FONT size=2>your mousepointer to 
another in Chart present</FONT></DIV>
<DIV><FONT size=2>indicator (which on its </FONT><FONT size=2>turn&nbsp;will 
then be selected&nbsp;(turn Magenta) for that&nbsp;pulled down indicator's 
underlay).</DIV></FONT>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>3. Are&nbsp;the correct&nbsp;</FONT><FONT size=2>base, 
displaying, periods&nbsp;+&nbsp;calculation methods etc. (the 
settings)&nbsp;being used:</FONT></DIV>
<DIV><FONT size=2>-right click indicator for Properties...</FONT></DIV>
<DIV><FONT size=2><FONT size=2>Base: -Open</FONT></FONT></DIV>
<DIV><FONT size=2><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-High</FONT></FONT></DIV>
<DIV><FONT size=2><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Low</FONT></FONT></DIV>
<DIV><FONT size=2><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Close</FONT></FONT></DIV>
<DIV><FONT size=2><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Median</FONT></FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Typical</FONT></DIV>
<DIV><FONT size=2>Method:&nbsp;</FONT><FONT size=2>-Simple</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><FONT 
size=2> -Exponential</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-Weighted</FONT></DIV>
<DIV><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
-Volume Adjusted&nbsp;{do both files carry the daily Volume 
figures}</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; etc. etc.</FONT></DIV>
<DIV><FONT size=2>-actualy while at it and there, check all the other settings 
"to be the correct ones</FONT><FONT size=2>" as well (MSK-man. 
p.160)</DIV></FONT>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>4. To Test for validity</FONT><FONT size=2>:</FONT></DIV>
<DIV><FONT size=2>-plot a 50-day SMA</FONT></DIV>
<DIV><FONT size=2>-create+plot a custom Summation indicator (MSK-man p. 
246)</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp; Sum(C,50)/50</FONT></DIV>
<DIV><FONT size=2>-and both will have&nbsp;identical values</FONT></DIV>
<DIV><FONT size=2>&nbsp;</DIV></FONT>
<DIV><FONT size=2></FONT><FONT size=2></FONT><FONT size=2>5. See also Chris, 
Daniel and Claud's excellent recommendations.</FONT></DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT><FONT 
size=2></FONT><BR>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.<BR>Homepage&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><STRONG>From:&nbsp;</STRONG>Joseph 
  Zilaitis </DIV>
  <DIV style="FONT: 10pt arial"><STRONG>To:</STRONG> <A 
  title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> zaterdag 19 februari 2000 
  17:39</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> moving average 
  discrepancies</DIV>
  <DIV><BR></DIV>
  <DIV><FONT size=2>I know this question was asked some time ago but I can't 
  find the answer in my archives. When plotting simple moving 
  averages[50,200,etc] I'm getting results that differ when compared to 
  identical simple moving averages plotted by other programs. The other 
  comparisons are identical&nbsp;with each other but differ by a wide margin 
  when compared to MetaStock's&nbsp;. Is this a problem with my software or am I 
  incorrectly plotting this average somehow? Could it be an incorrect default 
  setting for an ending date or what? Thank 
you.</FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sat Feb 19 16:35:45 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
	by purebytes.com (8.9.3/8.9.3) with ESMTP id QAA02080
	for <neal@xxxxxxxxxxxxx>; Sat, 19 Feb 2000 16:33:03 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id QAA28660
	for metastock-outgoing; Sat, 19 Feb 2000 16:37:13 -0700
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 QAA28656
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 19 Feb 2000 16:37:10 -0700
Received: from mplspop1.mpls.uswest.net (mplspop1.mpls.uswest.net [204.147.80.3])
	by freeze.metastock.com (8.8.5/8.8.5) with SMTP id QAA28788
	for <metastock@xxxxxxxxxxxxx>; Sat, 19 Feb 2000 16:51:12 -0700 (MST)
Received: (qmail 23782 invoked by alias); 19 Feb 2000 23:35:09 -0000
Delivered-To: fixup-metastock@xxxxxxxxxxxxx@fixme
Received: (qmail 23767 invoked by uid 0); 19 Feb 2000 23:35:08 -0000
Received: from jdsl152.mpls.uswest.net (HELO RandyHarmelink.mpls.uswest.net) (216.160.3.152)
  by mplspop1.mpls.uswest.net with SMTP; 19 Feb 2000 23:35:08 -0000
Message-ID: <018001bf7b31$a56c10c0$9803a0d8@xxxxxxxxxxxxxxx>
From: "Randy Harmelink" <rcharmelink@xxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <002501bf7aef$11a28820$76e24ec2@xxxxxxxxx>
Subject: Re: too many numeric constants defined in formula
Date: Sat, 19 Feb 2000 17:32:54 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_017D_01BF7AFF.5A8E7D40"
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:   

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Does it help to factor out the division by 2?&nbsp; The calculation would 
be more efficient that way as well.</DIV>
<DIV>&nbsp;</DIV>
<DIV>For example:</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
s1:=((n-1)/2)*C+((n-3)/2)*Ref(C,-1)+((n-5)/2)*Ref(C,-2)+((n-7)/2)*Ref(C,-3)+ ... 
+((n-99)/2)*Ref(C,-49);</DIV>
<DIV>&nbsp;</DIV>
<DIV>would become:</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
s1:=((n-1)*C+(n-3)*Ref(C,-1)+(n-5)*Ref(C,-2)+(n-7)*Ref(C,-3)+ ... 
+(n-99)*Ref(C,-49)/2;</DIV>
<DIV>&nbsp;</DIV>
<DIV>I'm confused why you use the variable "n" in the formula, if it's going to 
be fixed in length (because of the 50 elements in the summation).&nbsp; Wouldn't 
it be easier to code:</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3>
<DIV>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
s1:=(49*C+47*Ref(C,-1)+45*Ref(C,-2)+43*Ref(C,-3)+ ... 
-49*Ref(C,-49))/2;</DIV></FONT></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:sky40912@xxxxxxxxx"; title=sky40912@xxxxxxxxx>Theo E.M. 
  Lockefeer</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A 
  href="mailto:metastock@xxxxxxxxxxxxx"; title=metastock@xxxxxxxxxxxxx>Metastock 
  User Group</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, February 19, 2000 8:50 
  AM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> too many numeric constants 
  defined in formula</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>To All 
  :</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>You may not believe it but 
  this formula could be very usefull for</EM></STRONG></FONT></DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>me 
:</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>it's a 50 day modified moving 
  average .</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>I get a " too many numeric 
  constants defined in formula"</EM></STRONG></FONT></DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>error :&nbsp; ok but is there 
  a way around this ?</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 face=Arial><STRONG><EM>Thx 
</EM></STRONG></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT color=#008080 
face=Arial><STRONG><EM>Theo</EM></STRONG></FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial 
  size=2>N:=50;<BR>TN:=Mov(C,N,S);<BR>s1:=((n-1)/2)*C+((n-3)/2)*Ref(C,-1)+((n-5)/2)*Ref(C,-2)+((n-7)/2)*Ref(C,-3)<BR>+((n-9)/2)*Ref(C,-4)+((n-11)/2)*Ref(C,-5)+ 
  ((n-13)/2)*Ref(C,-6)+((n-15)/2)*Ref(C,-7)<BR>+((n-17)/2)*Ref(C,-8)+((n-19)/2)*Ref(C,-9)+ 
  <BR>((n-21)/2)*Ref(C,-10)+((n-23)/2)*Ref(C,-11)+((n-25)/2)*Ref(C,-12)+((n-27)/2)*Ref(C,-13)<BR>+((n-29)/2)*Ref(C,-14)+((n-31)/2)*Ref(C,-15)+ 
  ((n-33)/2)*Ref(C,-16)+((n-35)/2)*Ref(C,-17)<BR>+((n-37)/2)*Ref(C,-18)+((n-39)/2)*Ref(C,-19)+<BR>((n-41)/2)*Ref(C,-20)+ 
  ((n-43)/2)*Ref(C,-21)+((n-45)/2)*Ref(C,-22)+((n-47)/2)*Ref(C,-23)<BR>+((n-49)/2)*Ref(C,-24)+((n-51)/2)*Ref(C,-25)+ 
  ((n-53)/2)*Ref(C,-26)+((n-55)/2)*Ref(C,-27)<BR>+((n-57)/2)*Ref(C,-28)+((n-59)/2)*Ref(C,-29)+<BR>((n-61)/2)*Ref(C,-30)+<BR>((n-63)/2)*Ref(C,-31)+((n-65)/2)*Ref(C,-32)+((n-67)/2)*Ref(C,-33)<BR>+((n-69)/2)*Ref(C,-34)+((n-71)/2)*Ref(C,-35)+ 
  ((n-73)/2)*Ref(C,-36)+((n-75)/2)*Ref(C,-37)<BR>+((n-77)/2)*Ref(C,-38)+((n-79)/2)*Ref(C,-39)<BR>((n-81)/2)*Ref(C,-40)<BR>((n-83)/2)*Ref(C,-41)+((n-85)/2)*Ref(C,-42)+((n-87)/2)*Ref(C,-43)<BR>+((n-89)/2)*Ref(C,-44)+((n-91)/2)*Ref(C,-45)+ 
  ((n-93)/2)*Ref(C,-46)+((n-95)/2)*Ref(C,-47)<BR>+((n-97)/2)*Ref(C,-48)+((n-99)/2)*Ref(C,-49);</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>y2:=TN+(6*S1)/((n+1)*n);</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>y2<BR></FONT></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Sat Feb 19 16:13:19 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
	by purebytes.com (8.9.3/8.9.3) with ESMTP id QAA01126
	for <neal@xxxxxxxxxxxxx>; Sat, 19 Feb 2000 16:11:23 -0800
Received: (from majordom@xxxxxxxxx)
	by listserv.equis.com (8.8.7/8.8.7) id QAA28673
	for metastock-outgoing; Sat, 19 Feb 2000 16:39:42 -0700
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 QAA28670
	for <metastock@xxxxxxxxxxxxxxxxxx>; Sat, 19 Feb 2000 16:39:39 -0700
Received: from web902.mail.yahoo.com (web902.mail.yahoo.com [128.11.23.77])
	by freeze.metastock.com (8.8.5/8.8.5) with SMTP id QAA28792
	for <metastock@xxxxxxxxxxxxx>; Sat, 19 Feb 2000 16:53:42 -0700 (MST)
Received: (qmail 28460 invoked by uid 60001); 19 Feb 2000 23:38:11 -0000
Message-ID: <20000219233811.28459.qmail@xxxxxxxxxxxxxxxxxxxxx>
Received: from [199.174.205.244] by web902.mail.yahoo.com; Sat, 19 Feb 2000 15:38:11 PST
Date: Sat, 19 Feb 2000 15:38:11 -0800 (PST)
From: Allan Havemose <havemose@xxxxxxxxx>
Subject: RE: Is MetaStock worth it?
To: metastock@xxxxxxxxxxxxx
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:   

I have found MSPro 7 very reliable. I've used it with eSignal and have
had no crashes. The only issue I've faced is the somewhat limited
formula language. Now that equis has released a developers kit, that
last limitation should be gone.

Allan


--- Ullrich Fischer <uf@xxxxxxxxxxxxxxxxxxx> wrote:
> There's TradeStation from Omega Research, but based on my experience
> and 
> other on the omega-list@xxxxxxxxxx, it is even worse than Metastock
> in 
> terms of reliability, cost, and customer service.  I'm currently
> using 
> www.bigeasyinvestor.com's free charting, filtering package.  It
> doesn't do 
> back testing yet, but it does a lot of what metastock and Omega
> Research 
> end of day stuff does and real time data is coming soon.  The big
> plus is 
> that it does an awful lot and it is free.  The only cost is that you
> have 
> to put up with a small advertising bar that appears in the software.
> -uf
> 
> 
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com