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

Re: Calculation question again



PureBytes Links

Trading Reference Links

<x-html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40"; xmlns:v = 
"urn:schemas-microsoft-com:vml" xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content=Word.Document name=ProgId>
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK 
href="cid:filelist.xml@xxxxxxxxxxxxxxxxx"; rel=File-List><!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:ForgetLastTabAlignment/>
   <w:DoNotUseHTMLParagraphAutoSpacing/>
  </w:Compatibility>
 </w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
	font-family: Tahoma;
}
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
P.MsoAutoSig {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoAutoSig {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoAutoSig {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
SPAN.EmailStyle18 {
	COLOR: navy; mso-style-type: personal; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
}
SPAN.EmailStyle19 {
	COLOR: #993366; mso-style-type: personal-reply; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
}
DIV.Section1 {
	page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US style="tab-interval: .5in" vLink=blue link=blue bgColor=white>
<DIV><FONT size=2>Guy, forgot to mention the alterations.........</FONT></DIV>
<DIV><FONT size=2>The changes made were</FONT></DIV>
<DIV><FONT size=2>1) in the first formula placed brackets around the 
PREV</FONT></DIV>
<DIV><FONT size=2>2)&nbsp;got the&nbsp;2nd formula out of its "circular loop" 
{that is if MSK interpreted the use</FONT></DIV>
<DIV><FONT size=2>&nbsp;&nbsp; of a formula's variable that's&nbsp;referencing 
itselve in its own formula, as an error}</FONT></DIV>
<DIV><FONT size=2>Like said, cannot promise this all to be correct since that it 
will take up some</FONT></DIV>
<DIV><FONT size=2>more time </FONT><FONT size=2>to do a proper checkup on 
it.........</FONT></DIV>
<DIV><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>&nbsp;</DIV>
<DIV>&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> 
  Guy Tann </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> donderdag 17 augustus 2000 
  6:30</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Calculation question 
  again</DIV>
  <DIV><BR></DIV>
  <DIV class=Section1>
  <P class=MsoNormal><SPAN class=EmailStyle19><FONT face=Arial color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Ton,<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle19><FONT face=Arial color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle19><FONT face=Arial color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">I 
  found my problem.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>My two 
  databases weren&#8217;t entirely in sync.<SPAN style="mso-spacerun: yes">&nbsp; 
  </SPAN>Your first equation as well as mine worked fine.<SPAN 
  style="mso-spacerun: yes">&nbsp; </SPAN>Now I&#8217;m going to look at your second 
  approach using ref() instead of PREV and see if I can get that to work.<SPAN 
  style="mso-spacerun: yes">&nbsp; </SPAN>I&#8217;m not sure I understand your 
  technique, so I&#8217;m going to look at it again a little 
  closer.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle19><FONT face=Arial color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle19><FONT face=Arial color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Thanks,<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal><SPAN class=EmailStyle19><FONT face=Arial color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoAutoSig><!--[if supportFields]><span class=EmailStyle19><font 
size=2 color="#993366" face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style='mso-element:field-begin'></span><span 
style="mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail 
Signature&quot; <span style='mso-element:field-separator'></span></span></font></span><![endif]--><FONT 
  color=#993366><SPAN style="COLOR: #993366">Guy</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoAutoSig><FONT face="Times New Roman" color=#993366 size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: #993366"><![if !supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face="Times New Roman" color=#993366 size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: #993366">Never be afraid to try something new. 
  Remember, amateurs built the ark, professionals built the 
  Titanic.</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><!--[if supportFields]><span class=EmailStyle19><font 
size=2 color="#993366" face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span style='mso-element:field-end'></span></span></font></span><![endif]--><SPAN 
  class=EmailStyle19><FONT face=Arial color=#993366 size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma color=black 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original 
  Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> 
  owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]<B><SPAN 
  style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Guy Tann<BR><B><SPAN 
  style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, August 16, 2000 5:40 
  PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 
  metastock@xxxxxxxxxxxxx<BR><B><SPAN 
  style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Calculation question 
  again</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" 
  color=#993366 size=3><SPAN style="FONT-SIZE: 12pt; COLOR: #993366"><![if !supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Ton,<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Your 
  first two calculations equaled my results, but aren&#8217;t correct as far as I can 
  tell.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>I went back and check the 
  COMCR calculations in both the Clipper program and MS and they were 
  identical.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>I even went back and 
  revised the x-axis and set both systems up for the same date range.<SPAN 
  style="mso-spacerun: yes">&nbsp; </SPAN>In the Clipper program, I changed the 
  start date in both directions and the results were the same.<SPAN 
  style="mso-spacerun: yes">&nbsp; </SPAN>The daily changes are correct, but the 
  accumulations are not.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>I think 
  I&#8217;ll next try to initialize them both at zero and see if that might help.<SPAN 
  style="mso-spacerun: yes">&nbsp; </SPAN>It&#8217;s possible that it doesn&#8217;t mean 
  anything since the daily differences are 
  identical.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">I 
  haven&#8217;t checked your second set of calculations yet, but I think there&#8217;s one 
  error I noticed.<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>In COMHCRT, if 
  there is no change in direction (COMHCRXX = 0) we don&#8217;t want to subtract 1 but 
  want to use the previous day&#8217;s number + 0.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">The 
  two results are supposed to be identical.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Thanks,<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle18><FONT 
  face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoAutoSig style="MARGIN-LEFT: 0.5in"><!--[if supportFields]><span 
class=EmailStyle18><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-begin'></span><span style="mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST 
\s &quot;E-mail Signature&quot; <span style='mso-element:field-separator'></span></span></font></span><![endif]--><FONT 
  color=navy><SPAN style="COLOR: navy">Guy</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoAutoSig style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" 
  color=#993366 size=3><SPAN style="FONT-SIZE: 12pt; COLOR: #993366"><![if !supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" 
  color=navy size=3><SPAN style="FONT-SIZE: 12pt; COLOR: navy">Never be afraid 
  to try something new. Remember, amateurs built the ark, professionals built 
  the Titanic.</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><!--[if supportFields]><span 
class=EmailStyle18><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><span style='mso-element:
field-end'></span></span></font></span><![endif]--><SPAN 
  class=EmailStyle18><FONT face=Arial color=navy size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]>&nbsp;<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma color=black 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original 
  Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> 
  owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]<B><SPAN 
  style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>A.J. Maas<BR><B><SPAN 
  style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, August 16, 2000 4:23 
  PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 
  Metastock-List<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: 
  Calculation question again</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=#993366 size=3><SPAN style="FONT-SIZE: 12pt; COLOR: #993366"><![if !supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">COMHCRXX:= 
  FmlVar("COM-CNTRY","COMCR"); </SPAN></FONT><FONT color=#993366 size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">COMHCRR:= 
  If(</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COMHCRXX 
  &gt; 0 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(PREV) 
  + 1 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If(</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COMHCRXX 
  &lt; 0 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(PREV) 
  - 1 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PREV</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  )</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  );</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">COMHCRT:= 
  If(</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COMHCRXX 
  &gt; 0 ,&nbsp;</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+ 
  1 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If(</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  COMHCRXX &lt; 0 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- 
  1 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  - 1</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  )</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  );</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">COMHCRT2:= 
  If(</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  COMHCRXX &gt; 0 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Ref( COMHCRT, -1 ) + 1 
  ,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  If(</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  COMHCRXX &lt; 0 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &nbsp;Ref( COMHCRT , -1 ) - 1 ,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Ref( COMHCRT , -1 )</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  )</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  );</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">COMHCRR;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">COMHCRT2</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black">&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black">&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">Adjustments 
  were made...just from eyeballing. </SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">Will take up a 
  closer look + more time, to see and test it for it to be 
  correct,</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">hope you will 
  get the drift tho,&nbsp;from the alterations that 
  were&nbsp;made.</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black">&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">Regards,<BR>Ton 
  Maas<BR></SPAN></FONT><FONT color=black><SPAN style="COLOR: black"><A 
  href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt">ms-irb@xxxxxxxxxxxxxxxx</SPAN></FONT></A><BR></SPAN></FONT><FONT 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">Dismiss the 
  ".nospam" bit (including the dot) when replying.<BR>Homepage&nbsp; 
  </SPAN></FONT><FONT color=black><SPAN style="COLOR: black"><A 
  href="http://home.planet.nl/~anthmaas";><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt">http://home.planet.nl/~anthmaas</SPAN></FONT></A></SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black">&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">////////////////////============//////////////////////</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&nbsp;</SPAN></FONT><FONT color=#993366 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">----- Original 
  Message ----- </SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">From: "Guy 
  Tann" &lt;</SPAN></FONT><FONT color=black><SPAN style="COLOR: black"><A 
  href="mailto:grt@xxxxxxxxxxxx";><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt">grt@xxxxxxxxxxxx</SPAN></FONT></A></SPAN></FONT><FONT 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&gt;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">To: "Metastock 
  User Group" &lt;</SPAN></FONT><FONT color=black><SPAN style="COLOR: black"><A 
  href="mailto:metastock-list@xxxxxxxxxxxxx";><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt">metastock-list@xxxxxxxxxxxxx</SPAN></FONT></A></SPAN></FONT><FONT 
  color=black size=2><SPAN 
  style="FONT-SIZE: 10pt; COLOR: black">&gt;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">Sent: woensdag 
  16 augustus 2000 18:50</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">Subject: 
  Calculation question again</SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=#993366 size=3><SPAN style="FONT-SIZE: 12pt; COLOR: #993366"><![if !supportEmptyParas]><![endif]>&nbsp;</SPAN></FONT><FONT 
  color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" 
  color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black">&gt; 
  List,<BR>&gt; <BR>&gt; Well, I'm still trying to move our Intermediate Term 
  Signals into MS and I'm<BR>&gt; still having problems.&nbsp; I have completed 
  all of the coding and am now in the<BR>&gt; debugging stage.<BR>&gt; <BR>&gt; 
  First, here are two calculations that I've tried.&nbsp; One works (the one 
  with<BR>&gt; PREV) and one doesn't.&nbsp; After all of the help the last time 
  around, I<BR>&gt; naturally tried the Ref() function because everyone said it 
  was the<BR>&gt; preferable approach.<BR>&gt; <BR>&gt; Any and all help is 
  appreciated.<BR>&gt; <BR>&gt; COMHCRR:= If( FmlVar("COM-CNTRY","COMCR") &gt; 0 
  , PREV + 1 , If(<BR>&gt; FmlVar("COM-CNTRY","COMCR") &lt; 0 , PREV - 1 , PREV 
  ) );<BR>&gt; COMHCRR;<BR>&gt; <BR>&gt; COMHCRT:= If(&nbsp; 
  FmlVar("COM-CNTRY","COMCR") &gt; 0 , Ref( COMHCRT, -1 ) + 1 ,<BR>&gt; 
  If(&nbsp; FmlVar("COM-CNTRY","COMCR") &lt; 0 , Ref( COMHCRT , -1 ) - 1 , 
  Ref(<BR>&gt; COMHCRT , -1 ) ) );<BR>&gt; COMHCRT;<BR>&gt; <BR>&gt; This is a 
  simple calculation where I accumulate a total, adding 1 if the<BR>&gt; 
  indicator&nbsp; &gt; 0, subtracting 1 if it is &lt; 0 and just carrying the 
  previous<BR>&gt; day's value forward if there is no change.&nbsp; Nothing 
  sophisticated.<BR>&gt; <BR>&gt; My second minor problem is that the answer is 
  incorrect.&nbsp; I've exported my<BR>&gt; MS SPI data into a Clipper database 
  to insure an identical test data set.<BR>&gt; Based upon that, the results 
  should be identical, especially since this<BR>&gt; calculation is so 
  simple.&nbsp; I haven't double-checked that COMCR calculation<BR>&gt; in both 
  systems, but I will right now.&nbsp; I should say that I had verified<BR>&gt; 
  that calculation before but I will do it again just to make sure 
  nothing<BR>&gt; else managed to get screwed up.<BR>&gt; <BR>&gt; Guy<BR>&gt; 
  <BR>&gt; Never be afraid to try something new. Remember, amateurs built the 
  ark,<BR>&gt; professionals built the Titanic.<BR>&gt; <BR>&gt; <BR>&gt; 
  </SPAN></FONT><FONT color=#993366><SPAN 
  style="COLOR: #993366; mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>

</x-html>