[amibroker] Re: what is the simplest method of calculating the diff between two dates in AFL

["Homar Simpson" <x77777x@xxxxxxxxx>]

  Simple enough once you get past the myriad of possible options for
getting dates.  I did it this way


mLastBarsdays= (LastValue(Year() )-1)*365 +LastValue(Day());
mTodaysDays=  (Now(8)-1) *365 + Now(10);

I don't think it handles leap year but its sufficient  for this purpose.


--- In amibroker@xxxxxxxxxxxxxxx, "Paul Ho" <paultsho@xxx> wrote:
>
> this is exceedingly simple.  Check out Tomasz's knowledge base.
> Now just to give you where you'll need to head towards
> use the now() function to return the year and day of year of day
> use lastvalue(year()) and Lastvalue(dayofyear() to calculate the
last bar
> take the difference, and check for leap year if they fall on different
> years.
> its all there is the knowledge base
>  
>  
>  
> 
> 
>   _____  
> 
> From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]
On Behalf
> Of Homar Simpson
> Sent: Thursday, 3 January 2008 3:47 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: what is the simplest method of calculating
the diff
> between two dates in AFL
> 
> 
> 
> I see why I didn't want to tackle this. Lot's of code there.
> 
> All I really want to do is check to see if the last bar date is
> older than X days from today. I'm filtering for stale dates, and ran
> into a problem with the simple way I did this when the year rolled over.
> 
> Surely theres a less cumbersome way. 
> 
> --- In amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com,
> "gp_sydney" <gp.investment@> wrote:
> >
> > If you mean number of calendar days between two dates, then it's not a
> > particularly simple problem (not that hard, but not trivial). There
> > are issues with different numbers of days in a month and leap years.
> > 
> > If you download the document "AmiBroker Custom Backtester
> > Interface.pdf" from the files area here, there's some sample code for
> > this in Appendix A. Has nothing specifically to do with the CBI, but
> > was part of an example used in that document.
> > 
> > Regards,
> > GP
> > 
> > 
> > --- In amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com>
ps.com,
> "Homar Simpson" <x77777x@> wrote:
> > >
> > > seems quite obscure given the simplicity of the problem.
> > > 
> > > Using datenum()
> > >
> >
>




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/