[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



PureBytes Links

Trading Reference Links

If you're just taking the difference between the two values, then you
don't need the -1 in each equation, as it will cancel out.

Regards,
GP


--- In amibroker@xxxxxxxxxxxxxxx, "Homar Simpson" <x77777x@xxx> wrote:
>
>   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@> 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/