Registered User
Joined: 1/18/2014
Posts: 10
|
Hi.
It'd be smashing to be able to reference my own variables in the PCF language. For example, creating a Wilder's RSI 25 formula (because it doesn't exist in TC2000 for some reason) then referencing it. I'm a developer, so this request doesn't seem hard, but I won't hold my breath since I haven't seen any reference to it.
Also, I've been looking through several formulas for Wilder's RSI. I've seen WRSI3, WRSI14, but nothing as high as 25, which is what I'd like to run a PCF on. I'm going to take a shot at writing it myself, but figured i'd ask if anyone here had it.
I know it'll be huge, that's fine. It doesn't have to be fast, it just has to accurately give me Wilder's RSI25 value.
Thanks!
David
|
Registered User
Joined: 1/18/2014
Posts: 10
|
Got it, for anyone interested... I had to use a scripting language to write it
(50 * (C - XAVGC49.1) / 25 / (0.04000356 * ( ABS(C0 - C1) + 24 / 25 * ( ABS(C1 - C2) + 24 / 25 * ( ABS(C2 - C3) + 24 / 25 * ( ABS(C3 - C4) + 24 / 25 * ( ABS(C4 - C5) + 24 / 25 * ( ABS(C5 - C6) + 24 / 25 * ( ABS(C6 - C7) + 24 / 25 * ( ABS(C7 - C8) + 24 / 25 * ( ABS(C8 - C9) + 24 / 25 * ( ABS(C9 - C10) + 24 / 25 * ( ABS(C10 - C11) + 24 / 25 * ( ABS(C11 - C12) + 24 / 25 * ( ABS(C12 - C13) + 24 / 25 * ( ABS(C13 - C14) + 24 / 25 * ( ABS(C14 - C15) + 24 / 25 * ( ABS(C15 - C16) + 24 / 25 * ( ABS(C16 - C17) + 24 / 25 * ( ABS(C17 - C18) + 24 / 25 * ( ABS(C18 - C19) + 24 / 25 * ( ABS(C19 - C20) + 24 / 25 * ( ABS(C20 - C21) + 24 / 25 * ( ABS(C21 - C22) + 24 / 25 * ( ABS(C22 - C23) + 24 / 25 * ( ABS(C23 - C24) + 24 / 25 * ( ABS(C24 - C25) + 24 / 25 * ( ABS(C25 - C26) + 24 / 25 * ( ABS(C26 - C27) + 24 / 25 * ( ABS(C27 - C28) + 24 / 25 * ( ABS(C28 - C29) + 24 / 25 * ( ABS(C29 - C30) + 24 / 25 * ( ABS(C30 - C31) + 24 / 25 * ( ABS(C31 - C32) + 24 / 25 * ( ABS(C32 - C33) + 24 / 25 * ( ABS(C33 - C34) + 24 / 25 * ( ABS(C34 - C35) + 24 / 25 * ( ABS(C35 - C36) + 24 / 25 * ( ABS(C36 - C37) + 24 / 25 * ( ABS(C37 - C38) + 24 / 25 * ( ABS(C38 - C39) + 24 / 25 * ( ABS(C39 - C40) + 24 / 25 * ( ABS(C40 - C41) + 24 / 25 * ( ABS(C41 - C42) + 24 / 25 * ( ABS(C42 - C43) + 24 / 25 * ( ABS(C43 - C44) + 24 / 25 * ( ABS(C44 - C45) + 24 / 25 * ( ABS(C45 - C46) + 24 / 25 * ( ABS(C46 - C47) + 24 / 25 * ( ABS(C47 - C48) + 24 / 25 * ( ABS(C48 - C49) + 24 / 25 * ( ABS(C49 - C50) + 24 / 25 * ( ABS(C50 - C51) + 24 / 25 * ( ABS(C51 - C52) + 24 / 25 * ( ABS(C52 - C53) + 24 / 25 * ( ABS(C53 - C54) + 24 / 25 * ( ABS(C54 - C55) + 24 / 25 * ( ABS(C55 - C56) + 24 / 25 * ( ABS(C56 - C57) + 24 / 25 * ( ABS(C57 - C58) + 24 / 25 * ( ABS(C58 - C59) + 24 / 25 * ( ABS(C59 - C60) + 24 / 25 * ( ABS(C60 - C61) + 24 / 25 * ( ABS(C61 - C62) + 24 / 25 * ( ABS(C62 - C63) + 24 / 25 * ( ABS(C63 - C64) + 24 / 25 * ( ABS(C64 - C65) + 24 / 25 * ( ABS(C65 - C66) + 24 / 25 * ( ABS(C66 - C67) + 24 / 25 * ( ABS(C67 - C68) + 24 / 25 * ( ABS(C68 - C69) + 24 / 25 * ( ABS(C69 - C70) + 24 / 25 * ( ABS(C70 - C71) + 24 / 25 * ( ABS(C71 - C72) + 24 / 25 * ( ABS(C72 - C73) + 24 / 25 * ( ABS(C73 - C74) + 24 / 25 * ( ABS(C74 - C75) + 24 / 25 * ( ABS(C75 - C76) + 24 / 25 * ( ABS(C76 - C77) + 24 / 25 * ( ABS(C77 - C78) + 24 / 25 * ( ABS(C78 - C79) + 24 / 25 * ( ABS(C79 - C80) + 24 / 25 * ( ABS(C80 - C81) + 24 / 25 * ( ABS(C81 - C82) + 24 / 25 * ( ABS(C82 - C83) + 24 / 25 * ( ABS(C83 - C84) + 24 / 25 * ( ABS(C84 - C85) + 24 / 25 * ( ABS(C85 - C86) + 24 / 25 * ( ABS(C86 - C87) + 24 / 25 * ( ABS(C87 - C88) + 24 / 25 * ( ABS(C88 - C89) + 24 / 25 * ( ABS(C89 - C90) + 24 / 25 * ( ABS(C90 - C91) + 24 / 25 * ( ABS(C91 - C92) + 24 / 25 * ( ABS(C92 - C93) + 24 / 25 * ( ABS(C93 - C94) + 24 / 25 * ( ABS(C94 - C95) + 24 / 25 * ( ABS(C95 - C96) + 24 / 25 * ( ABS(C96 - C97) + 24 / 25 * ( ABS(C97 - C98) + 24 / 25 * ( ABS(C98 - C99) + 24 / 25 * ( ABS(C99 - C100) + 24 / 25 * ( ABS(C100 - C101) + 24 / 25 * ( ABS(C101 - C102) + 24 / 25 * ( ABS(C102 - C103) + 24 / 25 * ( ABS(C103 - C104) + 24 / 25 * ( ABS(C104 - C105) + 24 / 25 * ( ABS(C105 - C106) + 24 / 25 * ( ABS(C106 - C107) + 24 / 25 * ( ABS(C107 - C108) + 24 / 25 * ( ABS(C108 - C109) + 24 / 25 * ( ABS(C109 - C110) + 24 / 25 * ( ABS(C110 - C111) + 24 / 25 * ( ABS(C111 - C112) + 24 / 25 * ( ABS(C112 - C113) + 24 / 25 * ( ABS(C113 - C114) + 24 / 25 * ( ABS(C114 - C115) + 24 / 25 * ( ABS(C115 - C116) + 24 / 25 * ( ABS(C116 - C117) + 24 / 25 * ( ABS(C117 - C118) + 24 / 25 * ( ABS(C118 - C119) + 24 / 25 * ( ABS(C119 - C120) + 24 / 25 * ( ABS(C120 - C121) + 24 / 25 * ( ABS(C121 - C122) + 24 / 25 * ( ABS(C122 - C123) + 24 / 25 * ( ABS(C123 - C124) + 24 / 25 * ( ABS(C124 - C125) + 24 / 25 * ( ABS(C125 - C126) + 24 / 25 * ( ABS(C126 - C127) + 24 / 25 * ( ABS(C127 - C128) + 24 / 25 * ( ABS(C128 - C129) + 24 / 25 * ( ABS(C129 - C130) + 24 / 25 * ( ABS(C130 - C131) + 24 / 25 * ( ABS(C131 - C132) + 24 / 25 * ( ABS(C132 - C133) + 24 / 25 * ( ABS(C133 - C134) + 24 / 25 * ( ABS(C134 - C135) + 24 / 25 * ( ABS(C135 - C136) + 24 / 25 * ( ABS(C136 - C137) + 24 / 25 * ( ABS(C137 - C138) + 24 / 25 * ( ABS(C138 - C139) + 24 / 25 * ( ABS(C139 - C140) + 24 / 25 * ( ABS(C140 - C141) + 24 / 25 * ( ABS(C141 - C142) + 24 / 25 * ( ABS(C142 - C143) + 24 / 25 * ( ABS(C143 - C144) + 24 / 25 * ( ABS(C144 - C145) + 24 / 25 * ( ABS(C145 - C146) + 24 / 25 * ( ABS(C146 - C147) + 24 / 25 * ( ABS(C147 - C148) + 24 / 25 * ( ABS(C148 - C149) + 24 / 25 * ( ABS(C149 - C150) + 24 / 25 * ( ABS(C150 - C151) + 24 / 25 * ( ABS(C151 - C152) + 24 / 25 * ( ABS(C152 - C153) + 24 / 25 * ( ABS(C153 - C154) + 24 / 25 * ( ABS(C154 - C155) + 24 / 25 * ( ABS(C155 - C156) + 24 / 25 * ( ABS(C156 - C157) + 24 / 25 * ( ABS(C157 - C158) + 24 / 25 * ( ABS(C158 - C159) + 24 / 25 * ( ABS(C159 - C160) + 24 / 25 * ( ABS(C160 - C161) + 24 / 25 * ( ABS(C161 - C162) + 24 / 25 * ( ABS(C162 - C163) + 24 / 25 * ( ABS(C163 - C164) + 24 / 25 * ( ABS(C164 - C165) + 24 / 25 * ( ABS(C165 - C166) + 24 / 25 * ( ABS(C166 - C167) + 24 / 25 * ( ABS(C167 - C168) + 24 / 25 * ( ABS(C168 - C169) + 24 / 25 * ( ABS(C169 - C170) + 24 / 25 * ( ABS(C170 - C171) + 24 / 25 * ( ABS(C171 - C172) + 24 / 25 * ( ABS(C172 - C173) + 24 / 25 * ( ABS(C173 - C174) + 24 / 25 * ( ABS(C174 - C175) + 24 / 25 * ( ABS(C175 - C176) + 24 / 25 * ( ABS(C176 - C177) + 24 / 25 * ( ABS(C177 - C178) + 24 / 25 * ( ABS(C178 - C179) + 24 / 25 * ( ABS(C179 - C180) + 24 / 25 * ( ABS(C180 - C181) + 24 / 25 * ( ABS(C181 - C182) + 24 / 25 * ( ABS(C182 - C183) + 24 / 25 * ( ABS(C183 - C184) + 24 / 25 * ( ABS(C184 - C185) + 24 / 25 * ( ABS(C185 - C186) + 24 / 25 * ( ABS(C186 - C187) + 24 / 25 * ( ABS(C187 - C188) + 24 / 25 * ( ABS(C188 - C189) + 24 / 25 * ( ABS(C189 - C190) + 24 / 25 * ( ABS(C190 - C191) + 24 / 25 * ( ABS(C191 - C192) + 24 / 25 * ( ABS(C192 - C193) + 24 / 25 * ( ABS(C193 - C194) + 24 / 25 * ( ABS(C194 - C195) + 24 / 25 * ( ABS(C195 - C196) + 24 / 25 * ( ABS(C196 - C197) + 24 / 25 * ( ABS(C197 - C198) + 24 / 25 * ( ABS(C198 - C199) + 24 / 25 * ( ABS(C199 - C200) + 24 / 25 * ( ABS(C200 - C201))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50)
Here is the PHP code I used to create it:
$period = 25;
$pminus1 = $period - 1;
$days = round($period * 8);
$xavg = round($period*2) - 0.9;
$parts = array();
for ($i=0; $i
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Awesome! I am really happy to read you were able to figure the formula out on your own.
Thank you for your suggestion.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|