|
PureBytes Links
Trading Reference Links
|
This may be part of the problem which tripped up Guy Tann when
he tried to convert his formulas and methods to MS. Metastock had a math bug
which drove him nuts trying to figure out.
For instance:
MON:=Month()*100;YR:=Year()*10000;YR+MON<FONT
size=2>
Gives the correct data.
But,
<FONT
size=2>MON:=Month()*100;YR:=Year()*10000;YR+MON+1
Doesn't.
But,
MON:=Month();YR:=Year()*100;YR+MON+1
Does.
Clearly, Metastock has a serious math bug when the order of
magnatude reaches a certain limit.
This is why Guy found out that to draw pretty little pictures,
use Metastock. To crunch numbers that your financial life depends on, use Excel.
Excel has a real formula language anyway.
Fair Warning.
-Corey
----- Original Message -----
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Lionel Issen
To: <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx
Sent: Wednesday, May 02, 2001 6:52
AM
Subject: Re: Current Day!
Steve:
This is an excellent concise method.
What version are you using?
Lionel Issen<A
href="mailto:lissen@xxxxxxxxx";>lissen@xxxxxxxxx
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Steve Brann
To: <A
href="mailto:metastock@xxxxxxxxxxxxx";
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx
Sent: Wednesday, May 02, 2001 7:05
AM
Subject: Current Day!
<FONT face=Arial
size=2>Hi
<FONT face=Arial
size=2>
I use the
following in my explorations to denote the date of the last price data in
the format yyyymmdd;
<FONT face=Arial
size=2>
<FONT face=Arial
size=2>DayOfMonth()+(Month()*100)+(Year()*10000)
<FONT face=Arial
size=2>
However, this
fails if the date is the first of the month such as March 1st 2001, instead
of getting 20010301 I get 20010300!
<FONT face=Arial
size=2>
Has anyone else
experienced this and if so is there a solution? By the way, using
DayOfMonth() on its
own produces 01.
<SPAN
class=632160112-02052001>
<SPAN
class=632160112-02052001>Thanks in advance
<SPAN
class=632160112-02052001>
<SPAN
class=632160112-02052001>Steve
|