|
PureBytes Links
Trading Reference Links
|
<x-html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40";>
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@xxxxxxxxxxxxxxxxx";>
<!--[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 Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:16792199 0 0 0 65791 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
{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;
color:navy;}
span.EmailStyle19
{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;
color:#993366;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
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 bgcolor=white lang=EN-US link=blue vlink=blue style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><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'>Ton,<o:p></o:p></span></font></span></p>
<p class=MsoNormal><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'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><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'>I found my problem.<span style="mso-spacerun: yes"> </span>My two databases
weren’t entirely in sync.<span style="mso-spacerun: yes"> </span>Your
first equation as well as mine worked fine.<span style="mso-spacerun:
yes"> </span>Now I’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"> </span>I’m not sure I understand your technique, so I’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 size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><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'>Thanks,<o:p></o:p></span></font></span></p>
<p class=MsoNormal><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'><![if !supportEmptyParas]> <![endif]><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"> </span>AUTOTEXTLIST \s "E-mail
Signature" <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 size=3 color="#993366" face="Times New Roman"><span
style='font-size:12.0pt;color:#993366'><![if !supportEmptyParas]> <![endif]></span></font><font
color="#993366"><span style='color:#993366;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#993366" face="Times New Roman"><span
style='font-size:12.0pt;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 size=2 color="#993366" face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----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:.5in'><font size=3 color="#993366"
face="Times New Roman"><span style='font-size:12.0pt;color:#993366'><![if !supportEmptyParas]> <![endif]></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:.5in'><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'>Ton,<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'>Your first two calculations equaled my results, but
aren’t correct as far as I can tell.<span style="mso-spacerun: yes">
</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"> </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"> </span>In the Clipper program, I
changed the start date in both directions and the results were the same.<span
style="mso-spacerun: yes"> </span>The daily changes are correct, but the
accumulations are not.<span style="mso-spacerun: yes"> </span>I think
I’ll next try to initialize them both at zero and see if that might help.<span
style="mso-spacerun: yes"> </span>It’s possible that it doesn’t mean
anything since the daily differences are identical.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'>I haven’t checked your second set of calculations
yet, but I think there’s one error I noticed.<span style="mso-spacerun:
yes"> </span>In COMHCRT, if there is no change in direction (COMHCRXX =
0) we don’t want to subtract 1 but want to use the previous day’s number + 0.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'>The two results are supposed to be identical.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'>Thanks,<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><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'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoAutoSig style='margin-left:.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"> </span>AUTOTEXTLIST
\s "E-mail Signature" <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:.5in'><font size=3 color="#993366"
face="Times New Roman"><span style='font-size:12.0pt;color:#993366'><![if !supportEmptyParas]> <![endif]></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:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;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:.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
size=2 color=navy face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----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:1.0in'><font size=3 color="#993366"
face="Times New Roman"><span style='font-size:12.0pt;color:#993366'><![if !supportEmptyParas]> <![endif]></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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>COMHCRXX:=
FmlVar("COM-CNTRY","COMCR"); </span></font><font size=2
color="#993366"><span style='font-size:10.0pt;color:#993366;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> COMHCRXX
> 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> (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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> COMHCRXX
< 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> (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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> COMHCRXX
> 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> +
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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
COMHCRXX < 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> -
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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
- 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
COMHCRXX > 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
Ref( COMHCRT, -1 ) + 1 ,<br>
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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
COMHCRXX < 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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>
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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;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:1.0in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>hope you will
get the drift tho, from the alterations that were 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:1.0in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:10.0pt'>ms-irb@xxxxxxxxxxxxxxxx</span></font></a><br>
</span></font><font size=2 color=black><span style='font-size:10.0pt;
color:black'>Dismiss the ".nospam" bit (including the dot) when
replying.<br>
Homepage </span></font><font color=black><span style='color:black'><a
href="http://home.planet.nl/~anthmaas";><font size=2><span style='font-size:
10.0pt'>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:1.0in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'> </span></font><font
size=2 color="#993366"><span style='font-size:10.0pt;color:#993366;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>From:
"Guy Tann" <</span></font><font color=black><span
style='color:black'><a href="mailto:grt@xxxxxxxxxxxx";><font size=2><span
style='font-size:10.0pt'>grt@xxxxxxxxxxxx</span></font></a></span></font><font
size=2 color=black><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>To:
"Metastock User Group" <</span></font><font color=black><span
style='color:black'><a href="mailto:metastock-list@xxxxxxxxxxxxx";><font size=2><span
style='font-size:10.0pt'>metastock-list@xxxxxxxxxxxxx</span></font></a></span></font><font
size=2 color=black><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;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:1.0in'><font size=3 color="#993366"
face="Times New Roman"><span style='font-size:12.0pt;color:#993366'><![if !supportEmptyParas]> <![endif]></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:1.0in'><font size=2 color=black
face="Times New Roman"><span style='font-size:10.0pt;color:black'>> List,<br>
> <br>
> Well, I'm still trying to move our Intermediate Term Signals into MS and
I'm<br>
> still having problems. I have completed all of the coding and am now
in the<br>
> debugging stage.<br>
> <br>
> First, here are two calculations that I've tried. One works (the one
with<br>
> PREV) and one doesn't. After all of the help the last time around, I<br>
> naturally tried the Ref() function because everyone said it was the<br>
> preferable approach.<br>
> <br>
> Any and all help is appreciated.<br>
> <br>
> COMHCRR:= If( FmlVar("COM-CNTRY","COMCR") > 0 ,
PREV + 1 , If(<br>
> FmlVar("COM-CNTRY","COMCR") < 0 , PREV - 1 , PREV )
);<br>
> COMHCRR;<br>
> <br>
> COMHCRT:= If( FmlVar("COM-CNTRY","COMCR") > 0
, Ref( COMHCRT, -1 ) + 1 ,<br>
> If( FmlVar("COM-CNTRY","COMCR") < 0 , Ref(
COMHCRT , -1 ) - 1 , Ref(<br>
> COMHCRT , -1 ) ) );<br>
> COMHCRT;<br>
> <br>
> This is a simple calculation where I accumulate a total, adding 1 if the<br>
> indicator > 0, subtracting 1 if it is < 0 and just carrying
the previous<br>
> day's value forward if there is no change. Nothing sophisticated.<br>
> <br>
> My second minor problem is that the answer is incorrect. I've
exported my<br>
> MS SPI data into a Clipper database to insure an identical test data set.<br>
> Based upon that, the results should be identical, especially since this<br>
> calculation is so simple. I haven't double-checked that COMCR
calculation<br>
> in both systems, but I will right now. I should say that I had
verified<br>
> that calculation before but I will do it again just to make sure nothing<br>
> else managed to get screwed up.<br>
> <br>
> Guy<br>
> <br>
> Never be afraid to try something new. Remember, amateurs built the ark,<br>
> professionals built the Titanic.<br>
> <br>
> <br>
> </span></font><font color="#993366"><span style='color:#993366;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
</div>
</body>
</html>
</x-html>
|