Thank-you, Tomasz, I've got it working now (I'm using AB v. 5.2). I just
didn't understand enough about how JScript worked before.
I "parameterized" the code and turned it into an indicator (just for the
purpose of checking the output, complete code below). I'm thinking it should
be an easy matter to add it in to the option pricing calculator I got from the
AB library, so one can enter in the expiration date as a parameter and have the
number of days to expiry calculated automatically for the pricing formula.
Sebastian
EnableScript("JScript");
<%
function GetDaysTill( y, m, d )
{
msecPerDay = 1000 * 60 * 60 * 24;
dt = new Date( y, m-1, d, 23, 59, 59 );
today = new Date();
distance = dt.getTime() - today.getTime();
return Math.floor( distance/msecPerDay );
}
%>
sc = GetScriptObject();
y=Param("Year",2009,2009,2019,1);
m=Param("Month",12,1,12,1);
d=Param("Day",1,1,31,1);
Plot(sc.GetDaysTill(y,m,d),"DaysToExpiry",colorBlue,styleLine);
--- In [email protected], "Tomasz Janeczko" <gro...@...> wrote:
>
> Hello,
>
> Alternativelly if you are using 5.27 or higher you can use AFL-only solution
>
> SecInDay = 60 * 60 * 24;
> "Calendar days from today till January 1st, 2010 = " + floor( DateTimeDiff(
> StrToDateTime("2010-01-01"), Now( 5 ) )/SecInDay ) ;
>
>
>
> Also the old code needs amendment because JScript Date() gets month as 0..11
> (instead of 1..12)
>
>
>
> EnableScript("JScript");
> <%
> function GetDaysTill( y, m, d )
> {
> msecPerDay = 1000 * 60 * 60 * 24;
>
> dt = new Date( y, m-1, d, 23, 59, 59 );
> today = new Date();
>
> distance = dt.getTime() - today.getTime();
>
> return Math.floor( distance/msecPerDay );
> }
> %>
>
> sc = GetScriptObject();
>
> "Calendar days from today till January 1st, 2010 = " + sc.GetDaysTill( 2010,
> 1, 1 );
>
>
> Best regards,
> Tomasz Janeczko
> amibroker.com
> ----- Original Message -----
> From: "Tomasz Janeczko" <gro...@...>
> To: <[email protected]>
> Sent: Wednesday, October 21, 2009 5:50 PM
> Subject: Re: [amibroker] re: Count calendar days
>
>
> > Hello,
> >
> > Sorry, I was writing from memory and forgot that DaysSince1900 does not
> > take arguments therefore can not be used for that purpose.
> >
> > Instead use this:
> >
> > EnableScript("JScript");
> > <%
> > function GetDaysTill( y, m, d )
> > {
> > msecPerDay = 1000 * 60 * 60 * 24;
> >
> > dt = new Date( y, m, d, 0, 0, 0 );
> > today = new Date();
> >
> > distance = dt.getTime() - today.getTime();
> >
> > return Math.floor( distance / msecPerDay );
> > }
> > %>
> >
> > sc = GetScriptObject();
> >
> > "Calendar days from today till January 1st, 2010 = " + sc.GetDaysTill(
> > 2010, 1, 1 );
> >
> > Best regards,
> > Tomasz Janeczko
> > amibroker.com
> > ----- Original Message -----
> > From: "sebastiandanconia" <sebastiandanco...@...>
> > To: <[email protected]>
> > Sent: Wednesday, October 21, 2009 5:21 PM
> > Subject: [amibroker] re: Count calendar days
> >
> >
> >> (response got mixed up with different poster)
> >>
> >> Tomasz said: "You can use DateTimeConvert in conjunction with
> >> DaysSince1900. First one will convert from string representing
> >> date to datetime format and second one will report number of days. By
> >> subtracting this and DaysSince1900 of today you will get
> >> number of calendar days till future date."
> >>
> >> Tomasz, you've never yet let me down.:) I'll give that a whirl and post
> >> the code when I get it puzzled out.
> >>
> >>
> >> Sebastian
> >>
> >>
> >>
> >> ------------------------------------
> >>
> >> **** IMPORTANT PLEASE READ ****
> >> This group is for the discussion between users only.
> >> This is *NOT* technical support channel.
> >>
> >> TO GET TECHNICAL SUPPORT send an e-mail directly to
> >> SUPPORT {at} amibroker.com
> >>
> >> TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
> >> http://www.amibroker.com/feedback/
> >> (submissions sent via other channels won't be considered)
> >>
> >> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> >> http://www.amibroker.com/devlog/
> >>
> >> Yahoo! Groups Links
> >>
> >>
> >>
> >
> >
> >
> > ------------------------------------
> >
> > **** IMPORTANT PLEASE READ ****
> > This group is for the discussion between users only.
> > This is *NOT* technical support channel.
> >
> > TO GET TECHNICAL SUPPORT send an e-mail directly to
> > SUPPORT {at} amibroker.com
> >
> > TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
> > http://www.amibroker.com/feedback/
> > (submissions sent via other channels won't be considered)
> >
> > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> > http://www.amibroker.com/devlog/
> >
> > Yahoo! Groups Links
> >
> >
> >
>