| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 2/2/2005
Posts: 3
|
I am trying to create a scan that will find stocks that are trading within +/- 25 cents of an option's strike price (e.g., stocks that are trading between 4.75 and 5.25, 7.25 and 7.75, 9.75 and 10.25 etc.). Any ideas?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm not sure if it will do exactly what you want or not, but you may wish to try the following:
(C > 25 AND C <= 200 AND ABS((C - (C / 5 - .499999) \ 1 * 5) - 2.5) >= 2.25) OR (C <= 25 AND ABS((C - (C / 2.5 - .499999) \ 1 * 2.5) - 1.25) >= 1) OR (C > 200 AND ABS((C - (C / 10 - .499999) \ 1 * 10) - 5) >= 4.75)
You will probably wish to use this as an EasyScan Condition in conjunction with the built in Fundamental Criteria called Optionable Stocks. You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Concerning Option ONLY!
Definitions of all built in scanning and sorting criteria
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/2/2005
Posts: 3
|
thanks Bruce, I will try it out and let you know if it works...
|
|
Registered User
Joined: 2/2/2005
Posts: 3
|
well, it worked like a champ... thanks again...
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm happy to read it worked as desired.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/24/2008
Posts: 55
|
does that work for all optionable stocks 5 dollar strikes 1 dollars strikes 10 dollar strikes??
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If the Price is less than or equal to $25.00, the formula assumes the strike price is a multiple of $2.50.
If the Price is above $25.00 but less than or equal to $200.00, the formula assumes the strike price is a multiple of $5.00.
If the Price is above $200.00, the formula assumes the strike price is a multiple of $10.00.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |