Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 22
|
How do I calculate a True False for Stocks that have pulled back to make at least a 5 day low?
Thanks,
Amir
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
L=MINL5
Will be true for stocks whose low today is the lowest in the last five days.
- Craig Here to Help!
|
|
Registered User Joined: 10/7/2004 Posts: 22
|
what if I want low in the previous 5 days? is it L1=minL6
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I am not sure what you mean by "low in the previous 5 days".
The formula you give will return TRUE if the low yesterday (L1) is equal to the lowest low for the last six trading days (MINL6).
- Craig Here to Help!
|
|
Registered User Joined: 10/7/2004 Posts: 22
|
The wording that I am trying to interpret is as follows: "Stocks that have pulled back to make at least a five day low."
I think your formula is correct, but I want it up to yesterday, not including today.
Thanks,
Amir
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Then use:
L1=MINL5.1
Put it in your system. Look at the charts and let me know if it is what you wanted.
- Craig Here to Help!
|
|
Registered User Joined: 10/7/2004 Posts: 22
|
perfect
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
We did it!
- Craig Here to Help!
|
|
Guest-1 |