| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/18/2017
Posts: 56
|
Hi Bruce,
If I want to know stocks gapped up from yesterday's close to today's open >5%, what should be the formula for condition?
Thanks
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
O/C1 >= 1.05
|
|
Registered User
Joined: 11/18/2017
Posts: 56
|
Thanks for that reply. If I want to show gap as value in a column, how to write the formula?
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
To show a percentage use (O/C1 -1) * 100
|
|
Registered User
Joined: 11/18/2017
Posts: 56
|
Hi,
If I want stocks that are gapped up 0.50 cents since yesterday's close to today's open, can that be written as formula for scan?
Thanks
|
|
Registered User
Joined: 11/18/2017
Posts: 56
|
Hi,
I am thinking of this
(C - L1)>0.50
Is it right?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Your formula is comparing the current price to the previous low. If you want to compare the current open to the previous close, please try the following instead.
O >= C1 + .5
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |