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
|
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
|
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
|
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
|
Registered User Joined: 1/21/2014 Posts: 31
|
Thank You Bruce !! Excelent help !!!
Angelo
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|