Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

formula using ATR Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
stevehchis
Posted : Wednesday, July 15, 2015 9:59:00 PM
Registered User
Joined: 3/7/2010
Posts: 168

hi i would show you a copy of the 14 day average true range to referance the formula that i'm trying to explain for this formula  ..but for some reason when i open the formula to copy it it won't let me ..and it  won't let me paste ...so hopfully fixed by the time i copy the formula that you give me...do you know anything about that problem?

 

so about the formula ok ...the ATR using the 14 period (but not including today)  what that number is 

say its 1..20  ...so now what i want is to use yesterdays high ( C1) say that number is 60.00 so subtract 1/2 the ATR (ATR is 1.20 so that would be .60 )  subtract that to get the number that i want  its for a column ...

summary 14 piriod ATR subtract 1/2 of whatever that number is from yesterdays high ..to get the number  i'm looking for (for a column indicator) ...i want a similar one as well but lets see if you get what i mean with this one first ..thx

Bruce_L
Posted : Thursday, July 16, 2015 9:55:44 AM


Worden Trainer

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

You can usually use ctrl-c to copy and ctrl-v to paste when there are no options to copy and paste when right-clicking.

The high of the previous bar minus half of the 14 period average true range can be written as follows.

H1 - ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) / 2

Please provide a description and PCF for calculating an ATR value to be used as a stop loss value
How to create and save an Indicator (PCF) Formula
How to add a column to a watchlist



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Thursday, July 16, 2015 10:19:36 AM
Registered User
Joined: 3/7/2010
Posts: 168

does this ATR 14 period ...include any price action of todays candle ...because i wanted a 14 piriod that did not include today (C or H ) ..no price action of the current trading day...thx again

 

Bruce_L
Posted : Thursday, July 16, 2015 10:23:19 AM


Worden Trainer

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

Yes, it did include the current candle in the calculation of the ATR. If you only want to include information through the previous bar in the calculations. Doing all the calculations based on the information available at the time of the close of the previous bar instead would result in the following.

H1 - ((AVGH14.1 - AVGL14.1) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14)) / 28) / 2



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Friday, July 17, 2015 10:18:21 AM
Registered User
Joined: 3/7/2010
Posts: 168
i used (below tfromula o get add 1/2  ATR from yesterdays close  (including todays action) is this right because it was yesterday when i used it.....but for some reason its not giving me the right numbers today example ticker AMT the numbers im getting in this column is 96.57 ...the right numbers should be 98.64
 
C1 + ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) / 2
 
stevehchis
Posted : Friday, July 17, 2015 10:35:15 AM
Registered User
Joined: 3/7/2010
Posts: 168
also i made this oneyesterday as well  its for "from todays high subtract 1/2 ATR"  and it worked yesterday as well ...its not giving the right numbers today however i opened the formula copied it recreated it (with no change) and added the new column keeping the old column and the new one is giving the right numbers the old one is not ....what do you make of that?
 
H - ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) / 2
 
Bruce_L
Posted : Friday, July 17, 2015 11:01:39 AM


Worden Trainer

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

Did you change the formula after you made the WatchList Column? If so, you will need to remove the WatchList Column and re-add it in order to reflect the changes in the formula. I would actually suggest trying to remove and re-add the WatchList Column even if you don't think you changed the formula after adding it.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Friday, July 17, 2015 3:30:06 PM
Registered User
Joined: 3/7/2010
Posts: 168

yes that worked...but i wanted to know is there a formula to get tc2000 to produce a line on the chart that would be generated ..with the results of the formula above 

 

Bruce_L
Posted : Friday, July 17, 2015 3:41:26 PM


Worden Trainer

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

There isn't a way to create a line across the chart using the formula. About the best you can do is use it as a Custom PCF Indicator. The value will get re-calculated at each point and be squiggly instead of straight however.

How to add an indicator to a chart template
How to edit an Indicator



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Wednesday, August 5, 2015 3:17:20 PM
Registered User
Joined: 3/7/2010
Posts: 168

i have another request inregards to ATR's ....if i wanted a column that would give me the % move of the ATR  from 

-todays open to current price

- yesterdays close to price 

and if you give me that i should be able to extract the rest from those ...thank you

 

Bruce_L
Posted : Wednesday, August 5, 2015 3:58:58 PM


Worden Trainer

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

The % Change in the 14 period average true range between the close of the previous bar and the current price can be written as follows.

100 * ((14 * (AVGH14 - AVGL14) + 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / (14 * (AVGH14.1 - AVGL14.1) + 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14)) - 1)

The % Change in the 14 period average true range between the close of the open of the bar and the current price can be written as follows.

100 * ((14 * (AVGH14 - AVGL14) + 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / (13 * (AVGH13.1 - AVGL13.1) + 2 * ABS(O - C1) + 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Wednesday, August 5, 2015 9:48:00 PM
Registered User
Joined: 3/7/2010
Posts: 168

sorry bruce getting errors in both of them

stevehchis
Posted : Wednesday, August 5, 2015 10:10:45 PM
Registered User
Joined: 3/7/2010
Posts: 168

oh and its not so cut and dry to extract the rest that i need ...so i will need to ask for them as well

 

% from 

-yesterdays low to price

-yesterdays low to todays open 

-yesterdays low to todays high

-yesterdays close to todays high

-yesterday close to todays open

 

-todays open to todays high

-todays low to todays high

-todays low to current price

 

-todays high to current price

-yesterdays high to current price

 

i think thats it thank you very much i know its alot but i could not see any other way but to ask 

i think i got them all but might be a few more ( like these ) anyway thanks again  you are fast i will give you that   i appreciate that 

 

 

 

Bruce_L
Posted : Thursday, August 6, 2015 1:00:19 PM


Worden Trainer

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

There is no way to know (at least from daily bars) what the average true range might have been at the high and low of the trading day. It is only possible to know what the average true range is/was at the open, close of a bar or at the current time.

This means the only one of the most recently requested items which could be written as the percent change in ATR between one point in time and another point in time would be yesterday close to today's open.

100 * ((13 * (AVGH13.1 - AVGL13.1) + 2 * ABS(O - C1) + 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / (14 * (AVGH14.1 - AVGL14.1) + 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14)) - 1)

Which leads me to the conclusion that instead of wanting what was requested (% move of the ATR), you actually want the change expressed as a percentage of ATR. These formulas would be shorter and easier to adjust because we would only need to put in the ATR once instead twice in each formula.

If this in fact the case, change from previous close to current price expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (C - C1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the open of the current bar to current price expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (C - O) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the low of the previous bar to current price expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (C - L1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the low of the previous bar to the open of the current bar expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (O - L1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) - 1)

Change from the low of the previous bar to the high of the current bar expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (H - L1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the close of the previous bar to the high of the current bar expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (H - C1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the close of the previous bar to open of the current bar expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (O - C1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the open of the current bar to the high of the current bar expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (H - O) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the low of the current bar to the high of the current bar expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (H1 - L1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the low of the current bar to current price expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (C - L) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the high of the current bar to current price expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (C - H) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Change from the high of the previous bar to current price expressed as a percentage of the current 14 period ATR could be written as follows.

100 * (C - H1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Thursday, August 6, 2015 10:52:03 PM
Registered User
Joined: 3/7/2010
Posts: 168

i will start by saying yes your right about what i wanted ...seems to be something wrong 

explained in youtube video  (link below)

https://www.youtube.com/watch?v=AOLo2zHT7HQ

Bruce_L
Posted : Friday, August 7, 2015 10:24:36 AM


Worden Trainer

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

The formulas were just flat out wrong. I had blindly replaced the numerator and denominator in the percent change formulas I had been using earlier in the topic.

In that case the extra set of parentheses and - 1 in the formula were correct because it was a percent change from one value to another value.

100 * (value2 - value1) / (value) = 100 * (value2 / value1 - 1)

But in the newer formulas it was a change expressed as percentage of something else entirely so the extra parentheses and -1 should not have been in the formula.

100 * (value2 - value1) / ATR

I have removed the extra parentheses and -1 from the formulas in the post. The extra parentheses would not have actually hurt anything, but were unneccessary.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Wednesday, August 12, 2015 2:45:31 PM
Registered User
Joined: 3/7/2010
Posts: 168

thx its all working fine now 

but to make the 1/2 ATR you put in /2 into the ATR formula ...but what do you put to make it 2/3  of ATR i tried  / 0.75  no go ..what am i missing ...thx again

stevehchis
Posted : Wednesday, August 12, 2015 2:46:41 PM
Registered User
Joined: 3/7/2010
Posts: 168

i mean 3/4 to make 0.75  not  2/3

Bruce_L
Posted : Wednesday, August 12, 2015 3:12:52 PM


Worden Trainer

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

The / 2 doesn't make it .5 ATR. The / 2 is there because of the way the math works in the algorithm being used to calculate the ATR.

Keep in mind that true range is the higher of the high or previous close minus the lower of the low or previous close.

The first post in in the Min Max PCFs topic explores one way of calculated both the higher of two values and the lower of two values. Note that the resulting formulas end use ABS() functions and have a / 2 at the end. This same / 2 is what appears in the formulas above.

The / 28 near the end is the / 14 to calculate the moving average with the / 2 applied to everything thrown in.

If you want to compare the move to 3 / 4 of ATR instead of comparing it to ATR, you could replace the following portion of each formula:

((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

With the following.

(((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) * 3 / 4)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Wednesday, August 12, 2015 3:22:16 PM
Registered User
Joined: 3/7/2010
Posts: 168

oh and one more 

i tried somethings but could not get it to work ...so i ask how do you get from (todays low + 1x ATR  + 1/2x ATR /2) in other words right in between  1 ATR and  1/2 ATR ...thx

Bruce_L
Posted : Wednesday, August 12, 2015 3:40:07 PM


Worden Trainer

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

Please try the following Indicator Formula.

L + .75 * ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Sunday, August 16, 2015 11:10:04 PM
Registered User
Joined: 3/7/2010
Posts: 168

hi bruce

is it possible to formulate ...the max 5 day high exculding today and yesterday (C & C1 ) the rgang on that  day being greater then 1.2 x  (120%)  of todays ATR 

 

and  an alternative scan same but instead of greater then todays ATR ..greater then 1.2x ATR on the day of the max5 high ...thx

Bruce_L
Posted : Monday, August 17, 2015 12:56:44 PM


Worden Trainer

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

Perhaps the following for the first formulas. This only checks the most recent of the bars at the high, but this only matters if more than one bar hit the high and you want to compare them both.

Days Since Last Peak (or other day-counting needs)

ABS(H2 = MAXH5.2) * (H2 - L2) + ABS(H2 < MAXH5.2) * (ABS(H3 = MAXH5.2) * (H3 - L3) + ABS(H3 < MAXH5.2) * (ABS(H4 = MAXH5.2) * (H4 - L4) + ABS(H4 < MAXH5.2) * (ABS(H5 = MAXH5.2) * (H5 - L5) + ABS(H5 < MAXH5.2) * (H6 - L6)))) > 1.2 * ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

And the following for the second formula. This formula actually compares each bar individually since the ATR is changing instead of remaining static.

(H2 = MAXH5.2 AND H2 - L2 > 1.2 * ((AVGH14.2 - AVGL14.2) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15)) / 28)) OR (H3 = MAXH5.2 AND H3 - L3 > 1.2 * ((AVGH14.3 - AVGL14.3) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16)) / 28)) OR (H4 = MAXH5.2 AND H4 - L4 > 1.2 * ((AVGH14.4 - AVGL14.4) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17)) / 28)) OR (H5 = MAXH5.2 AND H5 - L5 > 1.2 * ((AVGH14.5 - AVGL14.5) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18)) / 28)) OR (H6 = MAXH5.2 AND H6 - L6 > 1.2 * ((AVGH14.6 - AVGL14.6) / 2 + (ABS(H6 - C7) + ABS(C7 - L6) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19)) / 28))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Friday, August 28, 2015 10:25:51 AM
Registered User
Joined: 3/7/2010
Posts: 168

hey bruce this formula would give you positive numbers if the stock was up from the close say for example 50% of the ATR range  it would not give you  like this right (-50.00 ) it would give it to you like this right (50.00 ) ......because in my column with this formula for the ticker FB its giving me  -53.36 and its up just about almost 50.00...is there a problem

100 * (H - C1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

stevehchis
Posted : Friday, August 28, 2015 10:31:24 AM
Registered User
Joined: 3/7/2010
Posts: 168

hold on i may have found the problem....stay tuned for confirm

stevehchis
Posted : Friday, August 28, 2015 10:39:00 AM
Registered User
Joined: 3/7/2010
Posts: 168

it looks like some of my column sets  got messed  ...ok i got it now

 

Bruce_L
Posted : Monday, August 31, 2015 12:24:48 PM


Worden Trainer

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

I am happy to read you were able to figure it out on your own.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Tuesday, December 8, 2015 8:45:25 AM
Registered User
Joined: 3/7/2010
Posts: 168

can you give me the formula for 

from 10 day low to 10 day high (not including today)  greater then 340% of ATR

thank you

Bruce_L
Posted : Tuesday, December 8, 2015 10:00:43 AM


Worden Trainer

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

What is the period of the ATR? Does the ATR include today?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Tuesday, December 8, 2015 3:56:26 PM
Registered User
Joined: 3/7/2010
Posts: 168

how about one that includs today and one that does not ...thank again

Bruce_L
Posted : Tuesday, December 8, 2015 4:08:26 PM


Worden Trainer

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

OK, I'll just assume an ATR period of 14.

Including today:

MAXH10.1 - MINL10.1 > 3.4 * ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Excluding today:

MAXH10.1 - MINL10.1 > 3.4 * ((AVGH14.1 - AVGL14.1) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14)) / 28)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Thursday, December 17, 2015 3:30:03 PM
Registered User
Joined: 3/7/2010
Posts: 168

thank you yes that was right  a 14 period

 

now this one was tricky for me ...is it possible to ask for instead of the 2 data points being an open to a close or a hight to a low to calulate the ATR range on the day can it be something like from 75% of yesterdays range (zero starting from yesterdays low 75% being near the top of yesterdays range) so from that 75% point to todays high .... thank you

what i want is like below but replace yesterdays close with 75% of yesterdays range (as mentioned above)

example of from yesterdays close to todays high

100 * (H - C1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)
 
Bruce_L
Posted : Thursday, December 17, 2015 3:56:37 PM


Worden Trainer

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

Maybe the following?

100 * (H - .75 * H1 - .25 * L1) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Monday, December 28, 2015 1:34:06 PM
Registered User
Joined: 3/7/2010
Posts: 168

yes thats was right  (the one you did above)

now if i could have the formula for the ATR 14 period  ...but on a weekly time frame

one with the current week included and one that excludes the current week if you can...thank you

 

Bruce_L
Posted : Tuesday, December 29, 2015 4:09:18 PM


Worden Trainer

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

Unless you are using TC2000 v7, you don't need to change the formula to change it from daily to weekly. You would just change the time frame setting when editing or create the formula.

So the current bar would be as follows.

(AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28

And the previous bar would be as follows.

(AVGH14.1 - AVGL14.1) / 2 + (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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14)) / 28



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Tuesday, December 29, 2015 9:01:45 PM
Registered User
Joined: 3/7/2010
Posts: 168

ok great that makes things easy

but ...well i think i got it just uesing what i already have but copying the given formula im getting errors 

Bruce_L
Posted : Wednesday, December 30, 2015 9:53:32 AM


Worden Trainer

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

Please try the formulas again. I think there was an extra closing parenthesis at the end of each of the formulas.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Thursday, January 21, 2016 6:09:15 PM
Registered User
Joined: 3/7/2010
Posts: 168

this one cant seem to figure out and hard to explain so i added a video to help explain hope it helps

the scan that im asking for will be  ...with the ATR 14 period inculding today..and the rest in the video to better explain...thank you

 

https://youtu.be/kBsD71R1QNU

 

or try this link below  if above no work

https://www.youtube.com/watch?v=kBsD71R1QNU&feature=youtu.be

Bruce_L
Posted : Friday, January 22, 2016 10:07:37 AM


Worden Trainer

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

There isn't an automated way to calculate the value of the line on an intraday chart, but you can calculate the value of the line using a daily time frame.

H - ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) / 2

This allows you to create an Indicator Formula for either the net difference between the current price and the line.

C - (H - ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) / 2)

Or the percent difference between the current price and the line.

100 * (C / (H - ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28) / 2) - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stevehchis
Posted : Thursday, January 28, 2016 8:57:11 PM
Registered User
Joined: 3/7/2010
Posts: 168

 

hey bruce

referring to the last post ..the middle formula of the last post  i wanted something similar 

but in stead of the line being (todays high subtact 1/2 ATR ) i wanted the line to be camarilla L3 and so i thought all i had to do was what i have (below) but numbers are coming up wrong ...can you fix it please...same as the middle one (above  post )  net difference between the current price and the line 

the line now wanting it to be camarilla (L3) and this is what i have for camarilla (L3).......................... C1 - (1.1 * (H1 - L1) / 2)  can you fix it

100 * (C - C1 - (1.1 * (H1 - L1) / 4)) / ((AVGH14 - AVGL14) / 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) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

 
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.