Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/12/2005 Posts: 123
|
What would the formula be in TC2000 V7 for creating a wilders RSI(7) of the difference between a 3-day simple moving average and 10-day simple moving average? Thank you
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Do you want the RSI to be Wilder's Smoothed or unsmoothed?
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/12/2005 Posts: 123
|
Wilder's smoothed. Thanks Bruce!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Personal Criteria Formula:
50 * (AVGC3 - AVGC10 - XAVG(AVGC3.1,13) + XAVG(AVGC10.1,13)) / 7 / (.142870887591952 * (ABS(AVGC3 - AVGC10 - AVGC3.1 + AVGC10.1) + 6 / 7 * (ABS(AVGC3.1 - AVGC10.1 - AVGC3.2 + AVGC10.2) + 6 / 7 * (ABS(AVGC3.2 - AVGC10.2 - AVGC3.3 + AVGC10.3) + 6 / 7 * (ABS(AVGC3.3 - AVGC10.3 - AVGC3.4 + AVGC10.4) + 6 / 7 * (ABS(AVGC3.4 - AVGC10.4 - AVGC3.5 + AVGC10.5) + 6 / 7 * (ABS(AVGC3.5 - AVGC10.5 - AVGC3.6 + AVGC10.6) + 6 / 7 * (ABS(AVGC3.6 - AVGC10.6 - AVGC3.7 + AVGC10.7) + 6 / 7 * (ABS(AVGC3.7 - AVGC10.7 - AVGC3.8 + AVGC10.8) + 6 / 7 * (ABS(AVGC3.8 - AVGC10.8 - AVGC3.9 + AVGC10.9) + 6 / 7 * (ABS(AVGC3.9 - AVGC10.9 - AVGC3.10 + AVGC10.10) + 6 / 7 * (ABS(AVGC3.10 - AVGC10.10 - AVGC3.11 + AVGC10.11) + 6 / 7 * (ABS(AVGC3.11 - AVGC10.11 - AVGC3.12 + AVGC10.12) + 6 / 7 * (ABS(AVGC3.12 - AVGC10.12 - AVGC3.13 + AVGC10.13) + 6 / 7 * (ABS(AVGC3.13 - AVGC10.13 - AVGC3.14 + AVGC10.14) + 6 / 7 * (ABS(AVGC3.14 - AVGC10.14 - AVGC3.15 + AVGC10.15) + 6 / 7 * (ABS(AVGC3.15 - AVGC10.15 - AVGC3.16 + AVGC10.16) + 6 / 7 * (ABS(AVGC3.16 - AVGC10.16 - AVGC3.17 + AVGC10.17) + 6 / 7 * (ABS(AVGC3.17 - AVGC10.17 - AVGC3.18 + AVGC10.18) + 6 / 7 * (ABS(AVGC3.18 - AVGC10.18 - AVGC3.19 + AVGC10.19) + 6 / 7 * (ABS(AVGC3.19 - AVGC10.19 - AVGC3.20 + AVGC10.20) + 6 / 7 * (ABS(AVGC3.20 - AVGC10.20 - AVGC3.21 + AVGC10.21) + 6 / 7 * (ABS(AVGC3.21 - AVGC10.21 - AVGC3.22 + AVGC10.22) + 6 / 7 * (ABS(AVGC3.22 - AVGC10.22 - AVGC3.23 + AVGC10.23) + 6 / 7 * (ABS(AVGC3.23 - AVGC10.23 - AVGC3.24 + AVGC10.24) + 6 / 7 * (ABS(AVGC3.24 - AVGC10.24 - AVGC3.25 + AVGC10.25) + 6 / 7 * (ABS(AVGC3.25 - AVGC10.25 - AVGC3.26 + AVGC10.26) + 6 / 7 * (ABS(AVGC3.26 - AVGC10.26 - AVGC3.27 + AVGC10.27) + 6 / 7 * (ABS(AVGC3.27 - AVGC10.27 - AVGC3.28 + AVGC10.28) + 6 / 7 * (ABS(AVGC3.28 - AVGC10.28 - AVGC3.29 + AVGC10.29) + 6 / 7 * (ABS(AVGC3.29 - AVGC10.29 - AVGC3.30 + AVGC10.30) + 6 / 7 * (ABS(AVGC3.30 - AVGC10.30 - AVGC3.31 + AVGC10.31) + 6 / 7 * (ABS(AVGC3.31 - AVGC10.31 - AVGC3.32 + AVGC10.32) + 6 / 7 * (ABS(AVGC3.32 - AVGC10.32 - AVGC3.33 + AVGC10.33) + 6 / 7 * (ABS(AVGC3.33 - AVGC10.33 - AVGC3.34 + AVGC10.34) + 6 / 7 * (ABS(AVGC3.34 - AVGC10.34 - AVGC3.35 + AVGC10.35) + 6 / 7 * (ABS(AVGC3.35 - AVGC10.35 - AVGC3.36 + AVGC10.36) + 6 / 7 * (ABS(AVGC3.36 - AVGC10.36 - AVGC3.37 + AVGC10.37) + 6 / 7 * (ABS(AVGC3.37 - AVGC10.37 - AVGC3.38 + AVGC10.38) + 6 / 7 * (ABS(AVGC3.38 - AVGC10.38 - AVGC3.39 + AVGC10.39) + 6 / 7 * (ABS(AVGC3.39 - AVGC10.39 - AVGC3.40 + AVGC10.40) + 6 / 7 * (ABS(AVGC3.40 - AVGC10.40 - AVGC3.41 + AVGC10.41) + 6 / 7 * (ABS(AVGC3.41 - AVGC10.41 - AVGC3.42 + AVGC10.42) + 6 / 7 * (ABS(AVGC3.42 - AVGC10.42 - AVGC3.43 + AVGC10.43) + 6 / 7 * (ABS(AVGC3.43 - AVGC10.43 - AVGC3.44 + AVGC10.44) + 6 / 7 * (ABS(AVGC3.44 - AVGC10.44 - AVGC3.45 + AVGC10.45) + 6 / 7 * (ABS(AVGC3.45 - AVGC10.45 - AVGC3.46 + AVGC10.46) + 6 / 7 * (ABS(AVGC3.46 - AVGC10.46 - AVGC3.47 + AVGC10.47) + 6 / 7 * (ABS(AVGC3.47 - AVGC10.47 - AVGC3.48 + AVGC10.48) + 6 / 7 * (ABS(AVGC3.48 - AVGC10.48 - AVGC3.49 + AVGC10.49) + 6 / 7 * (ABS(AVGC3.49 - AVGC10.49 - AVGC3.50 + AVGC10.50) + 6 / 7 * (ABS(AVGC3.50 - AVGC10.50 - AVGC3.51 + AVGC10.51) + 6 / 7 * (ABS(AVGC3.51 - AVGC10.51 - AVGC3.52 + AVGC10.52) + 6 / 7 * (ABS(AVGC3.52 - AVGC10.52 - AVGC3.53 + AVGC10.53) + 6 / 7 * (ABS(AVGC3.53 - AVGC10.53 - AVGC3.54 + AVGC10.54) + 6 / 7 * (ABS(AVGC3.54 - AVGC10.54 - AVGC3.55 + AVGC10.55) + 6 / 7 * (ABS(AVGC3.55 - AVGC10.55 - AVGC3.56 + AVGC10.56) + 6 / 7 * (ABS(AVGC3.56 - AVGC10.56 - AVGC3.57 + AVGC10.57) + 6 / 7 * (ABS(AVGC3.57 - AVGC10.57 - AVGC3.58 + AVGC10.58) + 6 / 7 * (ABS(AVGC3.58 - AVGC10.58 - AVGC3.59 + AVGC10.59) + 6 / 7 * (ABS(AVGC3.59 - AVGC10.59 - AVGC3.60 + AVGC10.60)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Cascades of Moving Averages
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/12/2005 Posts: 123
|
Bruce,
This produces the result I was looking for, excellent! Thanks again!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |