Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » Create a RSI-TSV indicator

Create a RSI-TSV indicator

Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

kpatel3

Posted : Monday, September 22, 2008 11:19:31 AM

Registered User
Joined: 9/22/2008
Posts: 11

I would like to mix the Wilder's RSI with 14 parameter and TSV with 18 parameter into one indicator with a center line as the signal trigger. Mark Larson has mentioned that it can be done in Telechart. Please inform how the two indicators can be combined into one indicator. Thanks

Craig_S

Posted : Monday, September 22, 2008 11:25:19 AM

Worden Trainer

Joined: 10/1/2004
Posts: 18,819

How Mark does this is something he sells. We trainers do not have this information.

- Craig
Here to Help!

kpatel3

Posted : Thursday, September 25, 2008 4:51:45 PM

Registered User
Joined: 9/22/2008
Posts: 11

Craig, I might have not phrased the question properly. I realise you mention from other topics that one can do "Wilders RSI of any indicator" such as "Wilders RSI of Price". I would like to do "Wilders RSI of TSV" (parameters RSI - 14 of TSV - 18). What options do I select to create that indicator? The result of this indicator is a single line oscillating like an RSI with a center line.

Bruce_L

Posted : Thursday, September 25, 2008 4:56:38 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

kpatel3,
You can do so in Blocks:

- Select Indicators | Time Segmented Volume (TSV).
- Left-click on the TSV to bring up QuickEdit and change the MovAvg Period to 18.
- Select Indicators | Wilders RSI | TSV 18.
- You can optionally pin the TSV so it is shown as part of the Chart.

I do not know of a way to do the same in TeleChart.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

bustermu

Posted : Thursday, September 25, 2008 9:35:30 PM

Registered User
Joined: 1/1/2005
Posts: 2,645

QUOTE (Bruce_L)

I do not know of a way to do the same in TeleChart.

Bruce,

You do not know how to write a PCF for an RSI14 on a TSV18??? And on Daily bars???

Something caused you to make that statement, but I cannot figure what it is.

Thanks,
Jim Murphy

Bruce_L

Posted : Friday, September 26, 2008 8:43:06 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

bustermu,
Brain freeze? Really, I have no idea. Anyway, this should be the 14-Period Wilder's Smoothed RSI of Simple TSV18 (the formula would change if the RSI is not Wilder's Smoothed or if the TSV is Exponential):

Select Chart Template | Add Indicator | Indicator.
- Center Zero Line: Unchecked
- Plot using price scale: Unchecked
- Smoothing Average: 1
- Average Type: Doesn't matter (because the Smoothing Average is 1)
- Indicator Formula: 50 * (TSV18 - XAVG(TSV18.1,27)) / 14 / (.071435345156143 * (ABS(TSV18 - TSV18.1) + 13 / 14 * (ABS(TSV18.1 - TSV18.2) + 13 / 14 * (ABS(TSV18.2 - TSV18.3) + 13 / 14 * (ABS(TSV18.3 - TSV18.4) + 13 / 14 * (ABS(TSV18.4 - TSV18.5) + 13 / 14 * (ABS(TSV18.5 - TSV18.6) + 13 / 14 * (ABS(TSV18.6 - TSV18.7) + 13 / 14 * (ABS(TSV18.7 - TSV18.8) + 13 / 14 * (ABS(TSV18.8 - TSV18.9) + 13 / 14 * (ABS(TSV18.9 - TSV18.10) + 13 / 14 * (ABS(TSV18.10 - TSV18.11) + 13 / 14 * (ABS(TSV18.11 - TSV18.12) + 13 / 14 * (ABS(TSV18.12 - TSV18.13) + 13 / 14 * (ABS(TSV18.13 - TSV18.14) + 13 / 14 * (ABS(TSV18.14 - TSV18.15) + 13 / 14 * (ABS(TSV18.15 - TSV18.16) + 13 / 14 * (ABS(TSV18.16 - TSV18.17) + 13 / 14 * (ABS(TSV18.17 - TSV18.18) + 13 / 14 * (ABS(TSV18.18 - TSV18.19) + 13 / 14 * (ABS(TSV18.19 - TSV18.20) + 13 / 14 * (ABS(TSV18.20 - TSV18.21) + 13 / 14 * (ABS(TSV18.21 - TSV18.22) + 13 / 14 * (ABS(TSV18.22 - TSV18.23) + 13 / 14 * (ABS(TSV18.23 - TSV18.24) + 13 / 14 * (ABS(TSV18.24 - TSV18.25) + 13 / 14 * (ABS(TSV18.25 - TSV18.26) + 13 / 14 * (ABS(TSV18.26 - TSV18.27) + 13 / 14 * (ABS(TSV18.27 - TSV18.28) + 13 / 14 * (ABS(TSV18.28 - TSV18.29) + 13 / 14 * (ABS(TSV18.29 - TSV18.30) + 13 / 14 * (ABS(TSV18.30 - TSV18.31) + 13 / 14 * (ABS(TSV18.31 - TSV18.32) + 13 / 14 * (ABS(TSV18.32 - TSV18.33) + 13 / 14 * (ABS(TSV18.33 - TSV18.34) + 13 / 14 * (ABS(TSV18.34 - TSV18.35) + 13 / 14 * (ABS(TSV18.35 - TSV18.36) + 13 / 14 * (ABS(TSV18.36 - TSV18.37) + 13 / 14 * (ABS(TSV18.37 - TSV18.38) + 13 / 14 * (ABS(TSV18.38 - TSV18.39) + 13 / 14 * (ABS(TSV18.39 - TSV18.40) + 13 / 14 * (ABS(TSV18.40 - TSV18.41) + 13 / 14 * (ABS(TSV18.41 - TSV18.42) + 13 / 14 * (ABS(TSV18.42 - TSV18.43) + 13 / 14 * (ABS(TSV18.43 - TSV18.44) + 13 / 14 * (ABS(TSV18.44 - TSV18.45) + 13 / 14 * (ABS(TSV18.45 - TSV18.46) + 13 / 14 * (ABS(TSV18.46 - TSV18.47) + 13 / 14 * (ABS(TSV18.47 - TSV18.48) + 13 / 14 * (ABS(TSV18.48 - TSV18.49) + 13 / 14 * (ABS(TSV18.49 - TSV18.50) + 13 / 14 * (ABS(TSV18.50 - TSV18.51) + 13 / 14 * (ABS(TSV18.51 - TSV18.52) + 13 / 14 * (ABS(TSV18.52 - TSV18.53) + 13 / 14 * (ABS(TSV18.53 - TSV18.54) + 13 / 14 * (ABS(TSV18.54 - TSV18.55) + 13 / 14 * (ABS(TSV18.55 - TSV18.56) + 13 / 14 * (ABS(TSV18.56 - TSV18.57) + 13 / 14 * (ABS(TSV18.57 - TSV18.58) + 13 / 14 * (ABS(TSV18.58 - TSV18.59) + 13 / 14 * (ABS(TSV18.59 - TSV18.60) + 13 / 14 * (ABS(TSV18.60 - TSV18.61) + 13 / 14 * (ABS(TSV18.61 - TSV18.62) + 13 / 14 * (ABS(TSV18.62 - TSV18.63) + 13 / 14 * (ABS(TSV18.63 - TSV18.64) + 13 / 14 * (ABS(TSV18.64 - TSV18.65) + 13 / 14 * (ABS(TSV18.65 - TSV18.66) + 13 / 14 * (ABS(TSV18.66 - TSV18.67) + 13 / 14 * (ABS(TSV18.67 - TSV18.68) + 13 / 14 * (ABS(TSV18.68 - TSV18.69) + 13 / 14 * (ABS(TSV18.69 - TSV18.70) + 13 / 14 * (ABS(TSV18.70 - TSV18.71) + 13 / 14 * (ABS(TSV18.71 - TSV18.72) + 13 / 14 * (ABS(TSV18.72 - TSV18.73) + 13 / 14 * (ABS(TSV18.73 - TSV18.74) + 13 / 14 * (ABS(TSV18.74 - TSV18.75) + 13 / 14 * (ABS(TSV18.75 - TSV18.76) + 13 / 14 * (ABS(TSV18.76 - TSV18.77) + 13 / 14 * (ABS(TSV18.77 - TSV18.78) + 13 / 14 * (ABS(TSV18.78 - TSV18.79) + 13 / 14 * (ABS(TSV18.79 - TSV18.80) + 13 / 14 * (ABS(TSV18.80 - TSV18.81) + 13 / 14 * (ABS(TSV18.81 - TSV18.82) + 13 / 14 * (ABS(TSV18.82 - TSV18.83) + 13 / 14 * (ABS(TSV18.83 - TSV18.84) + 13 / 14 * (ABS(TSV18.84 - TSV18.85) + 13 / 14 * (ABS(TSV18.85 - TSV18.86) + 13 / 14 * (ABS(TSV18.86 - TSV18.87) + 13 / 14 * (ABS(TSV18.87 - TSV18.88) + 13 / 14 * (ABS(TSV18.88 - TSV18.89) + 13 / 14 * (ABS(TSV18.89 - TSV18.90) + 13 / 14 * (ABS(TSV18.90 - TSV18.91) + 13 / 14 * (ABS(TSV18.91 - TSV18.92) + 13 / 14 * (ABS(TSV18.92 - TSV18.93) + 13 / 14 * (ABS(TSV18.93 - TSV18.94) + 13 / 14 * (ABS(TSV18.94 - TSV18.95) + 13 / 14 * (ABS(TSV18.95 - TSV18.96) + 13 / 14 * (ABS(TSV18.96 - TSV18.97) + 13 / 14 * (ABS(TSV18.97 - TSV18.98) + 13 / 14 * (ABS(TSV18.98 - TSV18.99) + 13 / 14 * (ABS(TSV18.99 - TSV18.100) + 13 / 14 * (ABS(TSV18.100 - TSV18.101) + 13 / 14 * (ABS(TSV18.101 - TSV18.102) + 13 / 14 * (ABS(TSV18.102 - TSV18.103) + 13 / 14 * (ABS(TSV18.103 - TSV18.104) + 13 / 14 * (ABS(TSV18.104 - TSV18.105) + 13 / 14 * (ABS(TSV18.105 - TSV18.106) + 13 / 14 * (ABS(TSV18.106 - TSV18.107) + 13 / 14 * (ABS(TSV18.107 - TSV18.108) + 13 / 14 * (ABS(TSV18.108 - TSV18.109) + 13 / 14 * (ABS(TSV18.109 - TSV18.110) + 13 / 14 * (ABS(TSV18.110 - TSV18.111) + 13 / 14 * (ABS(TSV18.111 - TSV18.112) + 13 / 14 * (ABS(TSV18.112 - TSV18.113) + 13 / 14 * (ABS(TSV18.113 - TSV18.114) + 13 / 14 * (ABS(TSV18.114 - TSV18.115) + 13 / 14 * (ABS(TSV18.115 - TSV18.116) + 13 / 14 * (ABS(TSV18.116 - TSV18.117) + 13 / 14 * (ABS(TSV18.117 - TSV18.118) + 13 / 14 * (ABS(TSV18.118 - TSV18.119) + 13 / 14 * (ABS(TSV18.119 - TSV18.120) + 13 / 14 * (ABS(TSV18.120 - TSV18.121) + 13 / 14 * (ABS(TSV18.121 - TSV18.122) + 13 / 14 * (ABS(TSV18.122 - TSV18.123) + 13 / 14 * (ABS(TSV18.123 - TSV18.124) + 13 / 14 * (ABS(TSV18.124 - TSV18.125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

kpatel3

Posted : Saturday, September 27, 2008 10:37:15 AM

Registered User
Joined: 9/22/2008
Posts: 11

Bruce, Thanks for the reply. I do have not have blocks. I will try and use PCF formula that you have provided for Telechart.

kpatel3

Posted : Saturday, September 27, 2008 11:01:17 AM

Registered User
Joined: 9/22/2008
Posts: 11

Bruce, the formula you have provided works fine but it has a scale of 0-100 on right hand side. If it possible to update the formula so that we have a scale similar to TSV or MACD histogram with a zero crossing line and top has + and bottom has - sign? That will make it easy to interpret the signal. Also would like to thank bustermu for coming up with the PCF idea.

kpatel3

Posted : Sunday, September 28, 2008 12:05:48 PM

Registered User
Joined: 9/22/2008
Posts: 11

Bruce, I understand it may be a limitation since RSI has a scale of 0-100. Thanks a lot for the PCF formula

dulakovic

Posted : Sunday, September 28, 2008 7:54:29 PM

Registered User
Joined: 11/29/2006
Posts: 181

Hi Bruce,
Can you please post the same formula using exponential TSV 18.

Tx

diceman

Posted : Sunday, September 28, 2008 8:30:57 PM

Registered User
Joined: 1/28/2005
Posts: 6,049

"Bruce, the formula you have provided works fine but it has a scale of 0-100 on right hand side. If it possible to update the formula so that we have a scale similar to TSV or MACD histogram with a zero crossing line and top has + and bottom has - sign? That will make it easy to interpret the signal. Also would like to thank bustermu for coming up with the PCF idea."

--------------------------------------------------------------------------------------------------

You can just use:

(Formula)-50

This will make the max value 50 and the min -50

If you plot it this way be sure to check "center zero line".

Thanks

diceman

Bruce_L

Posted : Monday, September 29, 2008 8:57:57 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

kpatel3,
If you take the + 50 off the end of the formula and check Center Zero Line, it should do what you want.

dulakovic,
It is possible to write the formula based on an Exponential TSV18, but I wouldn't suggest using it as a Custom Indicator:

50 * (XAVG(TSV,18) - (26 * XAVG(TSV1.1,27) - 17 * XAVG(TSV1.1,18)) / 9) / 14 / (.071435345156143 * (ABS(XAVG(TSV,18) - XAVG(TSV1.1,18)) + 13 / 14 * (ABS(XAVG(TSV1.1,18) - XAVG(TSV1.2,18)) + 13 / 14 * (ABS(XAVG(TSV1.2,18) - XAVG(TSV1.3,18)) + 13 / 14 * (ABS(XAVG(TSV1.3,18) - XAVG(TSV1.4,18)) + 13 / 14 * (ABS(XAVG(TSV1.4,18) - XAVG(TSV1.5,18)) + 13 / 14 * (ABS(XAVG(TSV1.5,18) - XAVG(TSV1.6,18)) + 13 / 14 * (ABS(XAVG(TSV1.6,18) - XAVG(TSV1.7,18)) + 13 / 14 * (ABS(XAVG(TSV1.7,18) - XAVG(TSV1.8,18)) + 13 / 14 * (ABS(XAVG(TSV1.8,18) - XAVG(TSV1.9,18)) + 13 / 14 * (ABS(XAVG(TSV1.9,18) - XAVG(TSV1.10,18)) + 13 / 14 * (ABS(XAVG(TSV1.10,18) - XAVG(TSV1.11,18)) + 13 / 14 * (ABS(XAVG(TSV1.11,18) - XAVG(TSV1.12,18)) + 13 / 14 * (ABS(XAVG(TSV1.12,18) - XAVG(TSV1.13,18)) + 13 / 14 * (ABS(XAVG(TSV1.13,18) - XAVG(TSV1.14,18)) + 13 / 14 * (ABS(XAVG(TSV1.14,18) - XAVG(TSV1.15,18)) + 13 / 14 * (ABS(XAVG(TSV1.15,18) - XAVG(TSV1.16,18)) + 13 / 14 * (ABS(XAVG(TSV1.16,18) - XAVG(TSV1.17,18)) + 13 / 14 * (ABS(XAVG(TSV1.17,18) - XAVG(TSV1.18,18)) + 13 / 14 * (ABS(XAVG(TSV1.18,18) - XAVG(TSV1.19,18)) + 13 / 14 * (ABS(XAVG(TSV1.19,18) - XAVG(TSV1.20,18)) + 13 / 14 * (ABS(XAVG(TSV1.20,18) - XAVG(TSV1.21,18)) + 13 / 14 * (ABS(XAVG(TSV1.21,18) - XAVG(TSV1.22,18)) + 13 / 14 * (ABS(XAVG(TSV1.22,18) - XAVG(TSV1.23,18)) + 13 / 14 * (ABS(XAVG(TSV1.23,18) - XAVG(TSV1.24,18)) + 13 / 14 * (ABS(XAVG(TSV1.24,18) - XAVG(TSV1.25,18)) + 13 / 14 * (ABS(XAVG(TSV1.25,18) - XAVG(TSV1.26,18)) + 13 / 14 * (ABS(XAVG(TSV1.26,18) - XAVG(TSV1.27,18)) + 13 / 14 * (ABS(XAVG(TSV1.27,18) - XAVG(TSV1.28,18)) + 13 / 14 * (ABS(XAVG(TSV1.28,18) - XAVG(TSV1.29,18)) + 13 / 14 * (ABS(XAVG(TSV1.29,18) - XAVG(TSV1.30,18)) + 13 / 14 * (ABS(XAVG(TSV1.30,18) - XAVG(TSV1.31,18)) + 13 / 14 * (ABS(XAVG(TSV1.31,18) - XAVG(TSV1.32,18)) + 13 / 14 * (ABS(XAVG(TSV1.32,18) - XAVG(TSV1.33,18)) + 13 / 14 * (ABS(XAVG(TSV1.33,18) - XAVG(TSV1.34,18)) + 13 / 14 * (ABS(XAVG(TSV1.34,18) - XAVG(TSV1.35,18)) + 13 / 14 * (ABS(XAVG(TSV1.35,18) - XAVG(TSV1.36,18)) + 13 / 14 * (ABS(XAVG(TSV1.36,18) - XAVG(TSV1.37,18)) + 13 / 14 * (ABS(XAVG(TSV1.37,18) - XAVG(TSV1.38,18)) + 13 / 14 * (ABS(XAVG(TSV1.38,18) - XAVG(TSV1.39,18)) + 13 / 14 * (ABS(XAVG(TSV1.39,18) - XAVG(TSV1.40,18)) + 13 / 14 * (ABS(XAVG(TSV1.40,18) - XAVG(TSV1.41,18)) + 13 / 14 * (ABS(XAVG(TSV1.41,18) - XAVG(TSV1.42,18)) + 13 / 14 * (ABS(XAVG(TSV1.42,18) - XAVG(TSV1.43,18)) + 13 / 14 * (ABS(XAVG(TSV1.43,18) - XAVG(TSV1.44,18)) + 13 / 14 * (ABS(XAVG(TSV1.44,18) - XAVG(TSV1.45,18)) + 13 / 14 * (ABS(XAVG(TSV1.45,18) - XAVG(TSV1.46,18)) + 13 / 14 * (ABS(XAVG(TSV1.46,18) - XAVG(TSV1.47,18)) + 13 / 14 * (ABS(XAVG(TSV1.47,18) - XAVG(TSV1.48,18)) + 13 / 14 * (ABS(XAVG(TSV1.48,18) - XAVG(TSV1.49,18)) + 13 / 14 * (ABS(XAVG(TSV1.49,18) - XAVG(TSV1.50,18)) + 13 / 14 * (ABS(XAVG(TSV1.50,18) - XAVG(TSV1.51,18)) + 13 / 14 * (ABS(XAVG(TSV1.51,18) - XAVG(TSV1.52,18)) + 13 / 14 * (ABS(XAVG(TSV1.52,18) - XAVG(TSV1.53,18)) + 13 / 14 * (ABS(XAVG(TSV1.53,18) - XAVG(TSV1.54,18)) + 13 / 14 * (ABS(XAVG(TSV1.54,18) - XAVG(TSV1.55,18)) + 13 / 14 * (ABS(XAVG(TSV1.55,18) - XAVG(TSV1.56,18)) + 13 / 14 * (ABS(XAVG(TSV1.56,18) - XAVG(TSV1.57,18)) + 13 / 14 * (ABS(XAVG(TSV1.57,18) - XAVG(TSV1.58,18)) + 13 / 14 * (ABS(XAVG(TSV1.58,18) - XAVG(TSV1.59,18)) + 13 / 14 * (ABS(XAVG(TSV1.59,18) - XAVG(TSV1.60,18)) + 13 / 14 * (ABS(XAVG(TSV1.60,18) - XAVG(TSV1.61,18)) + 13 / 14 * (ABS(XAVG(TSV1.61,18) - XAVG(TSV1.62,18)) + 13 / 14 * (ABS(XAVG(TSV1.62,18) - XAVG(TSV1.63,18)) + 13 / 14 * (ABS(XAVG(TSV1.63,18) - XAVG(TSV1.64,18)) + 13 / 14 * (ABS(XAVG(TSV1.64,18) - XAVG(TSV1.65,18)) + 13 / 14 * (ABS(XAVG(TSV1.65,18) - XAVG(TSV1.66,18)) + 13 / 14 * (ABS(XAVG(TSV1.66,18) - XAVG(TSV1.67,18)) + 13 / 14 * (ABS(XAVG(TSV1.67,18) - XAVG(TSV1.68,18)) + 13 / 14 * (ABS(XAVG(TSV1.68,18) - XAVG(TSV1.69,18)) + 13 / 14 * (ABS(XAVG(TSV1.69,18) - XAVG(TSV1.70,18)) + 13 / 14 * (ABS(XAVG(TSV1.70,18) - XAVG(TSV1.71,18)) + 13 / 14 * (ABS(XAVG(TSV1.71,18) - XAVG(TSV1.72,18)) + 13 / 14 * (ABS(XAVG(TSV1.72,18) - XAVG(TSV1.73,18)) + 13 / 14 * (ABS(XAVG(TSV1.73,18) - XAVG(TSV1.74,18)) + 13 / 14 * (ABS(XAVG(TSV1.74,18) - XAVG(TSV1.75,18)) + 13 / 14 * (ABS(XAVG(TSV1.75,18) - XAVG(TSV1.76,18)) + 13 / 14 * (ABS(XAVG(TSV1.76,18) - XAVG(TSV1.77,18)) + 13 / 14 * (ABS(XAVG(TSV1.77,18) - XAVG(TSV1.78,18)) + 13 / 14 * (ABS(XAVG(TSV1.78,18) - XAVG(TSV1.79,18)) + 13 / 14 * (ABS(XAVG(TSV1.79,18) - XAVG(TSV1.80,18)) + 13 / 14 * (ABS(XAVG(TSV1.80,18) - XAVG(TSV1.81,18)) + 13 / 14 * (ABS(XAVG(TSV1.81,18) - XAVG(TSV1.82,18)) + 13 / 14 * (ABS(XAVG(TSV1.82,18) - XAVG(TSV1.83,18)) + 13 / 14 * (ABS(XAVG(TSV1.83,18) - XAVG(TSV1.84,18)) + 13 / 14 * (ABS(XAVG(TSV1.84,18) - XAVG(TSV1.85,18)) + 13 / 14 * (ABS(XAVG(TSV1.85,18) - XAVG(TSV1.86,18)) + 13 / 14 * (ABS(XAVG(TSV1.86,18) - XAVG(TSV1.87,18)) + 13 / 14 * (ABS(XAVG(TSV1.87,18) - XAVG(TSV1.88,18)) + 13 / 14 * (ABS(XAVG(TSV1.88,18) - XAVG(TSV1.89,18)) + 13 / 14 * (ABS(XAVG(TSV1.89,18) - XAVG(TSV1.90,18)) + 13 / 14 * (ABS(XAVG(TSV1.90,18) - XAVG(TSV1.91,18)) + 13 / 14 * (ABS(XAVG(TSV1.91,18) - XAVG(TSV1.92,18)) + 13 / 14 * (ABS(XAVG(TSV1.92,18) - XAVG(TSV1.93,18)) + 13 / 14 * (ABS(XAVG(TSV1.93,18) - XAVG(TSV1.94,18)) + 13 / 14 * (ABS(XAVG(TSV1.94,18) - XAVG(TSV1.95,18)) + 13 / 14 * (ABS(XAVG(TSV1.95,18) - XAVG(TSV1.96,18)) + 13 / 14 * (ABS(XAVG(TSV1.96,18) - XAVG(TSV1.97,18)) + 13 / 14 * (ABS(XAVG(TSV1.97,18) - XAVG(TSV1.98,18)) + 13 / 14 * (ABS(XAVG(TSV1.98,18) - XAVG(TSV1.99,18)) + 13 / 14 * (ABS(XAVG(TSV1.99,18) - XAVG(TSV1.100,18)) + 13 / 14 * (ABS(XAVG(TSV1.100,18) - XAVG(TSV1.101,18)) + 13 / 14 * (ABS(XAVG(TSV1.101,18) - XAVG(TSV1.102,18)) + 13 / 14 * (ABS(XAVG(TSV1.102,18) - XAVG(TSV1.103,18)) + 13 / 14 * (ABS(XAVG(TSV1.103,18) - XAVG(TSV1.104,18)) + 13 / 14 * (ABS(XAVG(TSV1.104,18) - XAVG(TSV1.105,18)) + 13 / 14 * (ABS(XAVG(TSV1.105,18) - XAVG(TSV1.106,18)) + 13 / 14 * (ABS(XAVG(TSV1.106,18) - XAVG(TSV1.107,18)) + 13 / 14 * (ABS(XAVG(TSV1.107,18) - XAVG(TSV1.108,18)) + 13 / 14 * (ABS(XAVG(TSV1.108,18) - XAVG(TSV1.109,18)) + 13 / 14 * (ABS(XAVG(TSV1.109,18) - XAVG(TSV1.110,18)) + 13 / 14 * (ABS(XAVG(TSV1.110,18) - XAVG(TSV1.111,18)) + 13 / 14 * (ABS(XAVG(TSV1.111,18) - XAVG(TSV1.112,18)) + 13 / 14 * (ABS(XAVG(TSV1.112,18) - XAVG(TSV1.113,18)) + 13 / 14 * (ABS(XAVG(TSV1.113,18) - XAVG(TSV1.114,18)) + 13 / 14 * (ABS(XAVG(TSV1.114,18) - XAVG(TSV1.115,18)) + 13 / 14 * (ABS(XAVG(TSV1.115,18) - XAVG(TSV1.116,18)) + 13 / 14 * (ABS(XAVG(TSV1.116,18) - XAVG(TSV1.117,18)) + 13 / 14 * (ABS(XAVG(TSV1.117,18) - XAVG(TSV1.118,18)) + 13 / 14 * (ABS(XAVG(TSV1.118,18) - XAVG(TSV1.119,18)) + 13 / 14 * (ABS(XAVG(TSV1.119,18) - XAVG(TSV1.120,18)) + 13 / 14 * (ABS(XAVG(TSV1.120,18) - XAVG(TSV1.121,18)) + 13 / 14 * (ABS(XAVG(TSV1.121,18) - XAVG(TSV1.122,18)) + 13 / 14 * (ABS(XAVG(TSV1.122,18) - XAVG(TSV1.123,18)) + 13 / 14 * (ABS(XAVG(TSV1.123,18) - XAVG(TSV1.124,18)) + 13 / 14 * (ABS(XAVG(TSV1.124,18) - XAVG(TSV1.125,18)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

dulakovic

Posted : Tuesday, September 30, 2008 12:40:11 AM

Registered User
Joined: 11/29/2006
Posts: 181

Thank you Bruce.

Bruce_L

Posted : Tuesday, September 30, 2008 7:16:01 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

dulakovic,
You're welcome. Our pleasure.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

kpatel3

Posted : Wednesday, October 1, 2008 3:22:30 PM

Registered User
Joined: 9/22/2008
Posts: 11

Bruce, Dulakovic, Diceman,

Thanks a lot for your valuable tips and formula. I do have the formula with a zero line in the center. This is very convenient for visualisation purposes.

You all are great!!!

Users browsing this topic

Guest-1

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.