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) got the 2nd formula out of its "circular loop"
{that is if MSK interpreted the use</FONT></DIV>
<DIV><FONT size=2> of a formula's variable that's 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 <A
href="http://home.planet.nl/~anthmaas">http://home.planet.nl/~anthmaas</A></DIV>
<DIV> </DIV>
<DIV> </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]> <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"> </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 face=Arial color=#993366
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><![if !supportEmptyParas]><![endif]> <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]> <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 face="Times New Roman" color=#993366 size=3><SPAN
style="FONT-SIZE: 12pt; 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 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]> <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]> </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]> <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’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: 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]> <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’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: 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]> <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]> <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]> <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"> </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: 0.5in"><FONT face="Times New Roman"
color=#993366 size=3><SPAN style="FONT-SIZE: 12pt; 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: 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]> <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]> </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"> 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 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">
);</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"> 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 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">
);</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">
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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 1in"><FONT face="Times New Roman"
color=black size=2><SPAN
style="FONT-SIZE: 10pt; 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: 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">
);</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"> </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"> </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, 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: 1in"><FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; 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">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
</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"> </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"> </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" <</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">></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" <</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">></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]> </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">>
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></BLOCKQUOTE></BODY></HTML>
</x-html>
|