RE: Current Day!

["Steve Brann" <steveb@xxxxxxxxxxx>]

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:
   
  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 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