|
PureBytes Links
Trading Reference Links
|
> From: colognetrader@xxxx [mailto:colognetrader@x...]
> Sent: Tuesday, November 20, 2001 3:11 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Auto Analyser
>
> I want to create a filter wich shows me if today is the day with the
> biggest range ( High - Low ) of the last 10 days! This means, the
> ranges of every individual day from the last 10 days must be smaller
> then the range of today!
I have no other idea than just go with the nested iif formula:
IsHighestRange = IIf(H-L <= Ref(H, -1) - Ref(L, -1), 0,
IIf(H-L <= Ref(H, -2) - Ref(L, -2), 0,
IIf(H-L <= Ref(H, -3) - Ref(L, -3), 0,
IIf(H-L <= Ref(H, -4) - Ref(L, -4), 0,
IIf(H-L <= Ref(H, -5) - Ref(L, -5), 0,
IIf(H-L <= Ref(H, -6) - Ref(L, -6), 0,
IIf(H-L <= Ref(H, -7) - Ref(L, -7), 0,
IIf(H-L <= Ref(H, -8) - Ref(L, -8), 0,
IIf(H-L <= Ref(H, -9) - Ref(L, -9), 0,
IIf(H-L <= Ref(H, -10) - Ref(L, -10), 0, 1));
gives True (1) when the range is highest of the last 10 days, otherwise returns False (0)
Marek
|