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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 3/7/2010 Posts: 168
|
sorry bruce getting errors in both of them
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 3/7/2010 Posts: 168
|
i mean 3/4 to make 0.75 not 2/3
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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)
|
|
Registered User Joined: 3/7/2010 Posts: 168
|
hold on i may have found the problem....stay tuned for confirm
|
|
Registered User Joined: 3/7/2010 Posts: 168
|
it looks like some of my column sets got messed ...ok i got it now
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 3/7/2010 Posts: 168
|
how about one that includs today and one that does not ...thank again
|
|
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
|
|
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)
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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)
|
|
Guest-1 |