|
PureBytes Links
Trading Reference Links
|
Joe, Try this:
If((H-L) < Ref(LLV((H-L),4),-1),1,0);
Substitute ATR for (H-L) if you want to use Average Trading Range instead.
Shashi
============================================================================
======
Date: Tue, 2 Oct 2001 16:48:47 -0700 (PDT)
From: Joe Acevedo <cn001532@xxxxxxxxx>
Subject: Calculating Narrowest Trading Range
Can anyone help me with this formula. I'm trying to do
the following:
Determine that today's trading range is the narrowest
for the last four days.
today's trading range: i.e. If today's high-low <
(high
- -low)yesterday, and (high -low)two days ago, and (high
- -low)three days ago, and (high -low)four days ago then
then plot 1, otherwise 0
I had been playing around with HHV,and LLV functions
but these didn't quite work, because I needed to
determine each of the previous days trading ranges.
Thanks,
Joe
|