Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Daily Range Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Youngamerican
Posted : Tuesday, May 26, 2009 3:48:19 PM
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

Bruce_L
Posted : Tuesday, May 26, 2009 3:58:58 PM


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
Youngamerican
Posted : Tuesday, May 26, 2009 4:07:18 PM
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
Bruce_L
Posted : Tuesday, May 26, 2009 4:20:40 PM


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
Youngamerican
Posted : Tuesday, May 26, 2009 4:24:29 PM
Registered User
Joined: 10/7/2004
Posts: 33
thank you
Bruce_L
Posted : Tuesday, May 26, 2009 4:29:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.