[amibroker] Re: Fixed Date for Annual Returns

["steve_almond" <me@xxxxxxxxxxxxxxxxxxxxx>]

Thanks, Steve. That does the job.
I could have searched for years without arriving at a sensible 
solution (find Valuewhen)...

Steve


--- In amibroker@xxxxxxxxxxxxxxx, "Steve Dugas" <sjdugas@xxx> wrote:
>
> StartPrice = ValueWhen( DateNum() == 1020501, Close );
> EndPrice = ValueWhen( DateNum() == 1030501, Close );
> PctRtn = ( EndPrice - StartPrice ) / StartPrice * 100
> 
> Steve
> 
> ----- Original Message ----- 
> From: "steve_almond" <me@xxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Thursday, July 10, 2008 8:22 AM
> Subject: [amibroker] Fixed Date for Annual Returns
> 
> 
> >I would like to do an exploration to calculate simple stock 
returns, 
> > but at fixed dates. I don't want to use the Ref function which 
links 
> > the return to today's date.
> > 
> > For example:
> > 
> > % return from May/1/2002 to May/1/2003
> > % return from Feb/1/2004 to Feb/28/2005
> > 
> > How can I specify those dates in an exploration?
> > I'm guessing I could use Datenum, but how would I ask for the 
closing 
> > price on datenum=1011231?
> > 
> > Thanks,
> > 
> > Steve
> > 
> > 
> > ------------------------------------
> > 
> > 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
> > 
> > 
> > 
> >
>



------------------------------------

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/