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 |

Today's range Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Hard Money
Posted : Wednesday, May 21, 2014 11:32:26 PM
Registered User
Joined: 1/21/2014
Posts: 31

I made my own formula for the today's range, H-L . When I plot it in the chart it is  accurate.

However when I insert the same formula in my personal watch list , it gives some different , inacurate values for the range today.

Examples :

ACT range is correctly ploted in the chart as $3.64 ( today high minus today low), but in the watchlist column says the range is $4.08.

This is the case with almost all the stocks in the personal watchlist.Only in the chart plot it is all correct .

Can this be fixed , or I did something wrong?

Thank You

Bruce_L
Posted : Thursday, May 22, 2014 11:52:41 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Try right-clicking on the WatchList Column Header (the name of the WatchList Column at the top of the WatchList) for your range WatchList Column and select Edit Columns. Then set the Refresh Rate for your range WatchList Column to shortest period of time available in the drop-down menu.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Hard Money
Posted : Friday, May 23, 2014 1:20:18 AM
Registered User
Joined: 1/21/2014
Posts: 31

Thanx Bruce that helped..

Now I d like to have calculated value showing the difference from the: ATR10 ( the av true range 10 days) and the Range today. the idea is to see if the range the stock has made today is above or below the ATR10.

So I wrote ATR10-(H-L) but it does not give correct values.

Example:ATR10 for MSFT is 0.55. The range was H-L=0.50

So the difference from the ATR 10 and today's range is 0.05 . but it shows -0.50

How do I write it corectly?

Thank You 

Angelo

Bruce_L
Posted : Friday, May 23, 2014 11:40:08 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

ATR10 is not valid syntax in the Personal Criteria Formula Language.

The Sir Old Viking Trader and PCFs topic has formulas for different moving average types for a 10-period average true range.

The PCF Formula Descriptions has a list of all of the syntax which is valid in the Personal Criteria Formula Language and the Handy PCF example formulas to help you learn the syntax of PCFs! topic has basic examples of this syntax in use. If the syntax is not listed in the first of these topics, it is probably not going to work in a formula.

Assuming you want to match the 10-period simple moving average of true range used in TC2000 version 12.4 for the Average True Range indicator, an Indicator Formula subtracting Range (not True Range) for the current day from the 10-period ATR could be written as:

(AVGH10 - AVGL10) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9)) / 20 - (H - L)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Hard Money
Posted : Saturday, May 24, 2014 2:50:10 AM
Registered User
Joined: 1/21/2014
Posts: 31

Thank You Bruce !! Excelent help !!!

Angelo

Bruce_L
Posted : Tuesday, May 27, 2014 12:51:46 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.