|
PureBytes Links
Trading Reference Links
|
<FONT face=Arial color=#008080
size=4>Steve
<FONT face=Arial color=#008080
size=4>
Use an
If statement and use your first formula if the day is < 15 and the second one
if the day is >=15.
<FONT face=Arial color=#008080
size=4>
<FONT face=Arial color=#008080
size=4>neo
<FONT face=Tahoma
size=2>-----Original Message-----From:
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Steve BrannSent: Wednesday, May 02, 2001 6:14
PMTo: metastock@xxxxxxxxxxxxxSubject: RE: Current
Day!
This
problem occurs at the start and end of months, not in between! While I
agree MS is challenged by large numbers, I suspect other things are having an
impact as well.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Steve
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<FONT face=Tahoma
size=2>-----Original Message-----From:
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of C.S.Sent: 02 May 2001 21:25To:
metastock@xxxxxxxxxxxxxSubject: Re: Current
Day!
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:
<FONT
size=2>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,
<FONT
size=2>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="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Lionel Issen
To: <A title=metastock@xxxxxxxxxxxxx
href="mailto: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="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Steve
Brann
To: <A
title=metastock@xxxxxxxxxxxxx
href="mailto: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 <FONT face=Arial
size=2>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
|