Thanks, Steve. That does the job. I could have searched for years without arriving at a sensible solution (find Valuewhen)...
Steve --- In [email protected], "Steve Dugas" <[EMAIL PROTECTED]> wrote: > > StartPrice = ValueWhen( DateNum() == 1020501, Close ); > EndPrice = ValueWhen( DateNum() == 1030501, Close ); > PctRtn = ( EndPrice - StartPrice ) / StartPrice * 100 > > Steve > > ----- Original Message ----- > From: "steve_almond" <[EMAIL PROTECTED]> > To: <[email protected]> > 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 > > > > > > > > >
