[amibroker] Re: finding a stock's lowest price within AA date range

["jtelang" <jtelang@xxxxxxxxx>]

Dave,

As far as lowest in the range is concerned, try following -

bi = BarIndex();
start = LastValue(ValueWhen(Status("firstbarinrange"), bi));
end = LastValue(ValueWhen(Status("lastbarinrange"), bi));
numBars = end - start;
llvNumBars = LLV(L, numBars);
llvAtEndOfRange = LastValue(ValueWhen(Status("lastbarinrange"), 
llvNumBars));

// Filter = llvAtEndOfRange > 10;
Filter = True;
AddColumn(L, "L");
AddColumn(llvAtEndOfRange, "llvAtEndOfRange");

Jitu

--- In amibroker@xxxxxxxxxxxxxxx, "Dave Merrill" <dmerrill@xxxx> 
wrote:
> say I'd like to find stocks whose price has stayed above $1 within 
the AA
> date range. any ideas how to do that?
> 
> I thought I'd first find the lowest price within that date range, 
but I'm
> not sure how. the method needs to handle stocks whose quotes start 
after the
> beginning of the range, or end before the end of it, finding them 
if the
> quotes that do exist meet the criteria.
> 
> I think the following gets you the lowest price since the start of 
the test
> range, but keeps looking past the end of the test range to the end 
of all
> quotes:
> 	LastValue(LowestSince(Status("FirstBarInTest"), c))
> 
> it seems like there should be a clean and simple way to do this, 
but I'm not
> seeing it.
> 
> thanks in advance for any ideas.
> 
> dave


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/