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

["Paul Ho" <paultsho@xxxxxxxxxxxx>]

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@xxxxxxxxxps.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@xxxxxxxxxps.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

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___