| gotafish |
|
Gold User, Member, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Thursday, December 30, 2004 |
| Monday, January 25, 2016 1:56:00 PM |
10
[0.00% of all post / 0.00 posts per day] |
|
I have recently built an excel spreadsheet that calculates Wilders ATR Smoothed and compared it to some of the formulas I copied into Telechart. My numbers using the excell spreadsheet are quite different than the ones I have been using in Telechart. I did a search in the knowledgebase and found this formula from Sir Tanstaafl. The results of this appear very close to my excel spreadsheet. My problem is that this is just a 10 ATR formula. I would like to use a 14 day but looking at this formula I don't really understand how to edit this for a 14 day period. Does anyone have this formula already written for 14 day or could someone help me to learn how to edit this one for 14 days. Any help would be greatly appreciated. The 10 Day formula is below:
Greg V.
.01*( 10.0979*(H0-L0+Abs(H0-C1)+Abs(L0-C1)) +9.0881*(H1-L1+Abs(H1-C2)+Abs(L1-C2)) +8.1793*(H2-L2+Abs(H2-C3)+Abs(L2-C3)) +7.3614*(H3-L3+Abs(H3-C4)+Abs(L3-C4)) +6.6252*(H4-L4+Abs(H4-C5)+Abs(L4-C5)) +5.9627*(H5-L5+Abs(H5-C6)+Abs(L5-C6)) +5.3665*(H6-L6+Abs(H6-C7)+Abs(L6-C7)) +4.8298*(H7-L7+Abs(H7-C8)+Abs(L7-C8)) +4.3468*(H8-L8+Abs(H8-C9)+Abs(L8-C9)) +3.9121*(H9-L9+Abs(H9-C10)+Abs(L9-C10)) +3.5209*(H10-L10+Abs(H10-C11)+Abs(L10-C11)) +3.1688*(H11-L11+Abs(H11-C12)+Abs(L11-C12)) +2.852*(H12-L12+Abs(H12-C13)+Abs(L12-C13)) +2.5668*(H13-L13+Abs(H13-C14)+Abs(L13-C14)) +2.3101*(H14-L14+Abs(H14-C15)+Abs(L14-C15)) +2.0791*(H15-L15+Abs(H15-C16)+Abs(L15-C16)) +1.8712*(H16-L16+Abs(H16-C17)+Abs(L16-C17)) +1.684*(H17-L17+Abs(H17-C18)+Abs(L17-C18)) +1.5156*(H18-L18+Abs(H18-C19)+Abs(L18-C19)) +1.3641*(H19-L19+Abs(H19-C20)+Abs(L19-C20)) +1.2277*(H20-L20+Abs(H20-C21)+Abs(L20-C21)) +1.1049*(H21-L21+Abs(H21-C22)+Abs(L21-C22)) +.9944*(H22-L22+Abs(H22-C23)+Abs(L22-C23)) +.895*(H23-L23+Abs(H23-C24)+Abs(L23-C24)) +.8055*(H24-L24+Abs(H24-C25)+Abs(L24-C25)) +.7249*(H25-L25+Abs(H25-C26)+Abs(L25-C26)) +.6524*(H26-L26+Abs(H26-C27)+Abs(L26-C27)) +.5872*(H27-L27+Abs(H27-C28)+Abs(L27-C28)) +.5285*(H28-L28+Abs(H28-C29)+Abs(L28-C29)) +.4756*(H29-L29+Abs(H29-C30)+Abs(L29-C30)) +.4281*(H30-L30+Abs(H30-C31)+Abs(L30-C31)) +.3853*(H31-L31+Abs(H31-C32)+Abs(L31-C32)) +.3467*(H32-L32+Abs(H32-C33)+Abs(L32-C33)) +.3121*(H33-L33+Abs(H33-C34)+Abs(L33-C34)) +.2809*(H34-L34+Abs(H34-C35)+Abs(L34-C35)) +.2528*(H35-L35+Abs(H35-C36)+Abs(L35-C36)) +.2275*(H36-L36+Abs(H36-C37)+Abs(L36-C37)) +.2047*(H37-L37+Abs(H37-C38)+Abs(L37-C38)) +.1843*(H38-L38+Abs(H38-C39)+Abs(L38-C39)) +.1658*(H39-L39+Abs(H39-C40)+Abs(L39-C40)) +.1493*(H40-L40+Abs(H40-C41)+Abs(L40-C41)) +.1343*(H41-L41+Abs(H41-C42)+Abs(L41-C42)) +.1209*(H42-L42+Abs(H42-C43)+Abs(L42-C43)) +.1088*(H43-L43+Abs(H43-C44)+Abs(L43-C44)) ) / 2
|
Thanks for the reply back. I am disapointed buy hopefully this feature will be avaiable someday. I have read some of the other posts and they are having the same problem only being about to buy and sell on the canned options OPEN CLOSE HIGH LOW and MIDDLE OF RANGE. A lot of traders buy on the crossover right away.
Greg V.
|
I may not have explained myself. What I really would like to be able to do in the Backscanner is set up a condition that would simulate me buying on a 20 Day High. The minute the stock crossed the 20 Day high I buy at that price Instead of limiting me to buying only on the OPEN CLOSE HIGH LOW and MIDDLE OF RANGE. Is there a formula in real code editor or something that would allow me to test this or is the program just not capable of doing this?
Thanks
Greg V
|
I have been trying out the new backscanner and was running some tests on the QLD ETF. One of my purchase dates was 08/24/2007. When I looked over the data using both Blocks and Backscanner and also my Telechart program I noticed that Telechart had totally different prices than Blocks did. In other words there significant price diferences between the data in Blocks and Telechart. Is this a bug? Upon further investigating I used a website to look up historical quotes and found out the data in Blocks is correct and the data in my Telechart Program is wrong. Do you have any idea what might be happening and what the problem is. Also Just in the last few days whenever I go to update Telechart everytime I do it says that Telechart Must Organize Your Data Files. Maybe my Telechart is corrupt or something. Any ideas?
Thanks
Greg V
|
I have been Trying out the new backscanner and have had one problem when trying to test a breakout strategy. I am trying to buy on a new 10 Day High Breakout. Here are my settings.
1) I drag the Prices over to the Condition Palette
2) I choose Price History & Making New High from the drop down menus. I then choose 10 Days as my High Period
3) I Select True Number Of Times to 1 & Within Number Of Bars To 0
4) I now drag this condition over to the Backscanner and choose the option BUY
5) I now go and edit the Buy condition. I Select Buy Long.
6) I am now confronted with when to buy. My choices are Open, Close, Middle of Range, High, Low.
These conditions limit me to what I really want to do. I would like to buy immediately as the price goes above the 10 Day high. I would normally have a Buy Stop order placed with my broker at .05 above the 10 day high. Is there someway to do this so that I can test this strategy?
Much Appreciated
Greg V.
|
Sorry about that last comment. My math wasn't too good. I can't even multiply 1.84 X 2 :-) Your formula and instructions worked perfectly. Thank you so much for your help. It is greatly appreciated.
Greg V
|
Thanks for the quick reply back. I did as instructed. I originally ran this on the symbol QID and came up with an ATR of 1.84. I wanted to times this by 2. so I took your formula as instructed and when I ran it after adding the parentheses and *2 the ATR came out to be 3.67 which is really not 2X1.84. What happened? Confused!! Here is the formula I used.
14-Period Average True Range (Wilder's Smoothed):
(XAVGH27 - XAVGL27 + .0357480060263825 * (ABS(H - C1) + ABS(L - C1) - H + L + 13 / 14 * (ABS(H1 - C2) + ABS(L1 - C2) - H1 + L1 + 13 / 14 * (ABS(H2 - C3) + ABS(L2 - C3) - H2 + L2 + 13 / 14 * (ABS(H3 - C4) + ABS(L3 - C4) - H3 + L3 + 13 / 14 * (ABS(H4 - C5) + ABS(L4 - C5) - H4 + L4 + 13 / 14 * (ABS(H5 - C6) + ABS(L5 - C6) - H5 + L5 + 13 / 14 * (ABS(H6 - C7) + ABS(L6 - C7) - H6 + L6 + 13 / 14 * (ABS(H7 - C8) + ABS(L7 - C8) - H7 + L7 + 13 / 14 * (ABS(H8 - C9) + ABS(L8 - C9) - H8 + L8 + 13 / 14 * (ABS(H9 - C10) + ABS(L9 - C10) - H9 + L9 + 13 / 14 * (ABS(H10 - C11) + ABS(L10 - C11) - H10 + L10 + 13 / 14 * (ABS(H11 - C12) + ABS(L11 - C12) - H11 + L11 + 13 / 14 * (ABS(H12 - C13) + ABS(L12 - C13) - H12 + L12 + 13 / 14 * (ABS(H13 - C14) + ABS(L13 - C14) - H13 + L13 + 13 / 14 * (ABS(H14 - C15) + ABS(L14 - C15) - H14 + L14 + 13 / 14 * (ABS(H15 - C16) + ABS(L15 - C16) - H15 + L15 + 13 / 14 * (ABS(H16 - C17) + ABS(L16 - C17) - H16 + L16 + 13 / 14 * (ABS(H17 - C18) + ABS(L17 - C18) - H17 + L17 + 13 / 14 * (ABS(H18 - C19) + ABS(L18 - C19) - H18 + L18 + 13 / 14 * (ABS(H19 - C20) + ABS(L19 - C20) - H19 + L19 + 13 / 14 * (ABS(H20 - C21) + ABS(L20 - C21) - H20 + L20 + 13 / 14 * (ABS(H21 - C22) + ABS(L21 - C22) - H21 + L21 + 13 / 14 * (ABS(H22 - C23) + ABS(L22 - C23) - H22 + L22 + 13 / 14 * (ABS(H23 - C24) + ABS(L23 - C24) - H23 + L23 + 13 / 14 * (ABS(H24 - C25) + ABS(L24 - C25) - H24 + L24 + 13 / 14 * (ABS(H25 - C26) + ABS(L25 - C26) - H25 + L25 + 13 / 14 * (ABS(H26 - C27) + ABS(L26 - C27) - H26 + L26 + 13 / 14 * (ABS(H27 - C28) + ABS(L27 - C28) - H27 + L27 + 13 / 14 * (ABS(H28 - C29) + ABS(L28 - C29) - H28 + L28 + 13 / 14 * (ABS(H29 - C30) + ABS(L29 - C30) - H29 + L29 + 13 / 14 * (ABS(H30 - C31) + ABS(L30 - C31) - H30 + L30 + 13 / 14 * (ABS(H31 - C32) + ABS(L31 - C32) - H31 + L31 + 13 / 14 * (ABS(H32 - C33) + ABS(L32 - C33) - H32 + L32 + 13 / 14 * (ABS(H33 - C34) + ABS(L33 - C34) - H33 + L33 + 13 / 14 * (ABS(H34 - C35) + ABS(L34 - C35) - H34 + L34 + 13 / 14 * (ABS(H35 - C36) + ABS(L35 - C36) - H35 + L35 + 13 / 14 * (ABS(H36 - C37) + ABS(L36 - C37) - H36 + L36 + 13 / 14 * (ABS(H37 - C38) + ABS(L37 - C38) - H37 + L37 + 13 / 14 * (ABS(H38 - C39) + ABS(L38 - C39) - H38 + L38 + 13 / 14 * (ABS(H39 - C40) + ABS(L39 - C40) - H39 + L39 + 13 / 14 * (ABS(H40 - C41) + ABS(L40 - C41) - H40 + L40 + 13 / 14 * (ABS(H41 - C42) + ABS(L41 - C42) - H41 + L41 + 13 / 14 * (ABS(H42 - C43) + ABS(L42 - C43) - H42 + L42 + 13 / 14 * (ABS(H43 - C44) + ABS(L43 - C44) - H43 + L43 + 13 / 14 * (ABS(H44 - C45) + ABS(L44 - C45) - H44 + L44 + 13 / 14 * (ABS(H45 - C46) + ABS(L45 - C46) - H45 + L45 + 13 / 14 * (ABS(H46 - C47) + ABS(L46 - C47) - H46 + L46 + 13 / 14 * (ABS(H47 - C48) + ABS(L47 - C48) - H47 + L47 + 13 / 14 * (ABS(H48 - C49) + ABS(L48 - C49) - H48 + L48 + 13 / 14 * (ABS(H49 - C50) + ABS(L49 - C50) - H49 + L49 + 13 / 14 * (ABS(H50 - C51) + ABS(L50 - C51) - H50 + L50 + 13 / 14 * (ABS(H51 - C52) + ABS(L51 - C52) - H51 + L51 + 13 / 14 * (ABS(H52 - C53) + ABS(L52 - C53) - H52 + L52 + 13 / 14 * (ABS(H53 - C54) + ABS(L53 - C54) - H53 + L53 + 13 / 14 * (ABS(H54 - C55) + ABS(L54 - C55) - H54 + L54 + 13 / 14 * (ABS(H55 - C56) + ABS(L55 - C56) - H55 + L55 + 13 / 14 * (ABS(H56 - C57) + ABS(L56 - C57) - H56 + L56 + 13 / 14 * (ABS(H57 - C58) + ABS(L57 - C58) - H57 + L57 + 13 / 14 * (ABS(H58 - C59) + ABS(L58 - C59) - H58 + L58 + 13 / 14 * (ABS(H59 - C60) + ABS(L59 - C60) - H59 + L59 + 13 / 14 * (ABS(H60 - C61) + ABS(L60 - C61) - H60 + L60 + 13 / 14 * (ABS(H61 - C62) + ABS(L61 - C62) - H61 + L61 + 13 / 14 * (ABS(H62 - C63) + ABS(L62 - C63) - H62 + L62 + 13 / 14 * (ABS(H63 - C64) + ABS(L63 - C64) - H63 + L63 + 13 / 14 * (ABS(H64 - C65) + ABS(L64 - C65) - H64 + L64 + 13 / 14 * (ABS(H65 - C66) + ABS(L65 - C66) - H65 + L65 + 13 / 14 * (ABS(H66 - C67) + ABS(L66 - C67) - H66 + L66 + 13 / 14 * (ABS(H67 - C68) + ABS(L67 - C68) - H67 + L67 + 13 / 14 * (ABS(H68 - C69) + ABS(L68 - C69) - H68 + L68 + 13 / 14 * (ABS(H69 - C70) + ABS(L69 - C70) - H69 + L69 + 13 / 14 * (ABS(H70 - C71) + ABS(L70 - C71) - H70 + L70 + 13 / 14 * (ABS(H71 - C72) + ABS(L71 - C72) - H71 + L71 + 13 / 14 * (ABS(H72 - C73) + ABS(L72 - C73) - H72 + L72 + 13 / 14 * (ABS(H73 - C74) + ABS(L73 - C74) - H73 + L73 + 13 / 14 * (ABS(H74 - C75) + ABS(L74 - C75) - H74 + L74 + 13 / 14 * (ABS(H75 - C76) + ABS(L75 - C76) - H75 + L75 + 13 / 14 * (ABS(H76 - C77) + ABS(L76 - C77) - H76 + L76 + 13 / 14 * (ABS(H77 - C78) + ABS(L77 - C78) - H77 + L77 + 13 / 14 * (ABS(H78 - C79) + ABS(L78 - C79) - H78 + L78 + 13 / 14 * (ABS(H79 - C80) + ABS(L79 - C80) - H79 + L79 + 13 / 14 * (ABS(H80 - C81) + ABS(L80 - C81) - H80 + L80 + 13 / 14 * (ABS(H81 - C82) + ABS(L81 - C82) - H81 + L81 + 13 / 14 * (ABS(H82 - C83) + ABS(L82 - C83) - H82 + L82 + 13 / 14 * (ABS(H83 - C84) + ABS(L83 - C84) - H83 + L83 + 13 / 14 * (ABS(H84 - C85) + ABS(L84 - C85) - H84 + L84 + 13 / 14 * (ABS(H85 - C86) + ABS(L85 - C86) - H85 + L85 + 13 / 14 * (ABS(H86 - C87) + ABS(L86 - C87) - H86 + L86 + 13 / 14 * (ABS(H87 - C88) + ABS(L87 - C88) - H87 + L87 + 13 / 14 * (ABS(H88 - C89) + ABS(L88 - C89) - H88 + L88 + 13 / 14 * (ABS(H89 - C90) + ABS(L89 - C90) - H89 + L89 + 13 / 14 * (ABS(H90 - C91) + ABS(L90 - C91) - H90 + L90 + 13 / 14 * (ABS(H91 - C92) + ABS(L91 - C92) - H91 + L91 + 13 / 14 * (ABS(H92 - C93) + ABS(L92 - C93) - H92 + L92 + 13 / 14 * (ABS(H93 - C94) + ABS(L93 - C94) - H93 + L93)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))*2
|
I know this is an old post but I am hopeful that someone can still answer my question. I took the formula from Bruce. The 14-Period Average True Range (Wilder's Smoothed) and pasted it into my Personal Criteria Formula's. What I am hopeful to do is to use this ATR with different multiples. I have tried adding the *2 numerous times to the formula in different places without any luck. Could someone please help me in getting this done. I would like to be able to easily change the ATR to any multiple I choose 1.5X 2.0X or even 3.0X.
I am in the process of testing the Blocks new BackScanner feature and would like to use this formula as a STOP LOSS to do some backtesting. Any help is greatly appreciated.
Greg V.
|
I have been trying to figure out how to rank a watchlist using the ROC of the 200 day Expotential Moving Average.
In other words I start with a 200 day expotential MA of the price. I then want to get the ROC of this MA and then somehow rank the stocks in the Watchlist from the Best ROC to the worst ROC
Any help would be appreciated.
Greg Vieth
|
I am getting ready to leave on vacation in a few weeks so I got my laptop ready to take with me. While installing the newer version of TeleChart on my laptop I noticed I couldn't find the option to update via the 1-800 number that used to be availiable. Has that option be completely removed? It was a usefull option while traveling in different parts of the country where I didn't have internet access.
Gotafish
|
|