Registered User
Joined: 10/7/2004
Posts: 33
|
Hi, could you help me with a PCF to measure intraday range defined as low to high. At the end of each trading day I would like to rank all stocks by % intraday range as defined from low to high.
thanks,
Paul
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I don't know what % intraday range as defined from low to high means. If you want the Range as a Percent of the Low, you could use the following Personal Criteria Formula:
100 * (H / L - 1)
If you want the Range as a Percent of the High, you could use the following PCF instead:
100 * (1- L / H)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Create your own stock rankings using WatchLists and Sort conditions
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 10/7/2004
Posts: 33
|
For example, if a stock had as its low for the day $100 and its high $110 the range would be 10%. I would like to be able to sort stocks by that measure. So for example if another a stock had its low at $100 and its high at $112 that stock would be ranked higher then the first stock.
thanks
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Then you want the former of the solutions already provided:
100 * (H / L - 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 10/7/2004
Posts: 33
|
thank you
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|