| grainmerchant |
|
Gold User, Member, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Monday, January 15, 2007 |
| Thursday, June 18, 2009 2:50:31 AM |
4
[0.00% of all post / 0.00 posts per day] |
|
Thanks Jim! What about a TSI crossing above of a 5 period SMA instead of the zero line...is that much different ?
GM
|
Here's the TSI 25,13 code. What I want to do is create a PCF that shows a crossing up through 0. I looked at the stochastic crossing upward through 20.
That formula was a lot simpler it because it has a function for stochastic (STOC) and that sure shortens things up. How do I do it with a humdinger like this though? Where do I put my ".1's" to compare yesterdays indicator close with todays value and the zero line?
100 * (XAVG(XAVGC25,13) - XAVG(XAVGC25.1,13)) / (0.01113441 * ABS(C - C1) + 0.01969708 * ABS(C1 - C2) + 0.02625549 * ABS(C2 - C3) + 0.03115604 * ABS(C3 - C4) + 0.03469103 * ABS(C4 - C5) + 0.03710672 * ABS(C5 - C6) + 0.03861027 * ABS(C6 - C7) + 0.0393756 * ABS(C7 - C8) + 0.03954844 * ABS(C8 - C9) + 0.03925059 * ABS(C9 - C10) + 0.03858361 * ABS(C10 - C11) + 0.03763189 * ABS(C11 - C12) + 0.03646535 * ABS(C12 - C13) + 0.03514165 * ABS(C13 - C14) + 0.03370815 * ABS(C14 - C15) + 0.03220354 * ABS(C15 - C16) + 0.03065919 * ABS(C16 - C17) + 0.02910038 * ABS(C17 - C18) + 0.02754724 * ABS(C18 - C19) + 0.02601567 * ABS(C19 - C20) + 0.02451799 * ABS(C20 - C21) + 0.02306359 * ABS(C21 - C22) + 0.02165941 * ABS(C22 - C23) + 0.02031039 * ABS(C23 - C24) + 0.01901984 * ABS(C24 - C25) + 0.01778974 * ABS(C25 - C26) + 0.01662098 * ABS(C26 - C27) + 0.01551361 * ABS(C27 - C28) + 0.01446696 * ABS(C28 - C29) + 0.01347986 * ABS(C29 - C30) + 0.01255073 * ABS(C30 - C31) + 0.01167768 * ABS(C31 - C32) + 0.01085859 * ABS(C32 - C33) + 0.01009119 * ABS(C33 - C34) + 0.00937312 * ABS(C34 - C35) + 0.00870198 * ABS(C35 - C36) + 0.00807534 * ABS(C36 - C37) + 0.0074908 * ABS(C37 - C38) + 0.00694599 * ABS(C38 - C39) + 0.0064386 * ABS(C39 - C40) + 0.00596639 * ABS(C40 - C41) + 0.00552721 * ABS(C41 - C42) + 0.005119 * ABS(C42 - C43) + 0.00473976 * ABS(C43 - C44) + 0.00438761 * ABS(C44 - C45) + 0.00406078 * ABS(C45 - C46) + 0.00375756 * ABS(C46 - C47) + 0.00347636 * ABS(C47 - C48) + 0.00321567 * ABS(C48 - C49) + 0.00297407 * ABS(C49 - C50) + 0.00275024 * ABS(C50 - C51) + 0.00254291 * ABS(C51 - C52) + 0.00235093 * ABS(C52 - C53) + 0.0021732 * ABS(C53 - C54) + 0.0020087 * ABS(C54 - C55) + 0.00185647 * ABS(C55 - C56) + 0.00171562 * ABS(C56 - C57) + 0.00158533 * ABS(C57 - C58) + 0.00146482 * ABS(C58 - C59) + 0.00135338 * ABS(C59 - C60) + 0.00125033 * ABS(C60 - C61) + 0.00115505 * ABS(C61 - C62) + 0.00106698 * ABS(C62 - C63) + 0.00098557 * ABS(C63 - C64) + 0.00091033 * ABS(C64 - C65) + 0.00084079 * ABS(C65 - C66) + 0.00077653 * ABS(C66 - C67) + 0.00071716 * ABS(C67 - C68) + 0.0006623 * ABS(C68 - C69) + 0.00061162 * ABS(C69 - C70) + 0.0005648 * ABS(C70 - C71) + 0.00052155 * ABS(C71 - C72) + 0.00048159 * ABS(C72 - C73) + 0.00044469 * ABS(C73 - C74) + 0.00041061 * ABS(C74 - C75) + 0.00037913 * ABS(C75 - C76) + 0.00035005 * ABS(C76 - C77) + 0.0003232 * ABS(C77 - C78) + 0.00029841 * ABS(C78 - C79) + 0.00027551 * ABS(C79 - C80) + 0.00025436 * ABS(C80 - C81) + 0.00023484 * ABS(C81 - C82) + 0.00021681 * ABS(C82 - C83) + 0.00020016 * ABS(C83 - C84) + 0.00018479 * ABS(C84 - C85) + 0.0001706 * ABS(C85 - C86) + 0.0001575 * ABS(C86 - C87))
|
Thanks Bruce! That's fairly simple (even though it's long)
|
I'm trying to write a scan that shows when the current indicator's value is greater than it's maximum value over the last 200 days. I'm trying to do this on an average daily range indicator. What am I doing wrong ?
(
avgh10-avgl10)>MAX(avgh10-avgl10)200
Thanks
GM
|
|