Registered User Joined: 6/17/2015 Posts: 15
|
Can somoene help me write this?
I want to add a column for gappers with the following parameters so it will give me a check mark if it meets these conditrions:
1. The stock must gap up or down a minimum of $0.20
2. The gap must be less than 85% of yesterdays range
3. The gap must be greater than 15% of yesterdays range
I'm not good at programming so I am not sure if this is possible.
Every morning I want to check the SPY
|
Registered User Joined: 6/17/2015 Posts: 15
|
No one has any ideas?
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Since you want both directions with the additional parameters, you'll need two separate formulas:
Gap Up
L > H1 and L - H1 > .20 and (L - H1) / (H1-L1) < .85 and (L - H1) / (H1-L1) > .15
Gap Down
H < L1 and L1- H > .20 and (L1- H) / (H1-L1) < .85 and (L1- H) / (H1-L1) > .15
|
Registered User Joined: 6/17/2015 Posts: 15
|
Thanks
|