I see a couple of problems: 1) 6/10/07 was not a market day. Try 6/8/07 or a day that the market was open. 2) Your StartDate is not in a format that your DateNum() == StartDate will ever match up with. Removing the DateTimeConvert portion of the statment should help because ParamDate will return it in DateNum format. 3) StartPrice is an array with only one bar set to something other than zero (assuming 2nd statement was working), so you will need to reference that bar within the array.
--- In [email protected], "huandy631" <[EMAIL PROTECTED]> wrote: > > hi > > I need to find out the return of a group of stocks over a certain > period. The code below to find out the price at a certain date doesn't > seem to work. > > StartDate=DateTimeConvert(0,ParamDate("Start date","2007-06- > 10")); > StartPrice=IIf(DateNum()==StartDate,ValueWhen(StartDate,Close),0); > > Is this the right method? > > thanks > > Hugh >
