New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: Bruce_L
About
User Name: Bruce_L
Groups: Gold User, Platinum User, TeleChart, Worden Staff, Worden Training Agent
Rank: Worden Trainer
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, October 07, 2004
Last Visit: Wednesday, January 17, 2018 4:47:53 PM
Number of Posts: 61,568
[21.46% of all post / 12.69 posts per day]
Avatar
Last 10 Posts
Topic: ALMA moving average ?
Posted: Wednesday, January 17, 2018 4:16:54 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Questions about data distribution
Posted: Wednesday, January 17, 2018 3:11:52 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: ALMA moving average ?
Posted: Wednesday, January 17, 2018 12:30:34 PM

I cannot think of a way to create a generalized version of this. That said, specific versions could be created for specific settings and there is a pattern for how this could be done.

I tried to follow the code exactly, but I may be missing something about the math, because the results seem "faster" than the examples with the same settings (more weight seems to be placed on recent values than in the examples).

Window: 9
Sigma: 6
Offset: 0.85

(EXP(-((0-(0.85-(9-1)))*(0-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C0 + EXP(-((1-(0.85-(9-1)))*(1-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C1 + EXP(-((2-(0.85-(9-1)))*(2-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C2 + EXP(-((3-(0.85-(9-1)))*(3-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C3 + EXP(-((4-(0.85-(9-1)))*(4-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C4 + EXP(-((5-(0.85-(9-1)))*(5-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C5 + EXP(-((6-(0.85-(9-1)))*(6-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C6 + EXP(-((7-(0.85-(9-1)))*(7-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C7 + EXP(-((8-(0.85-(9-1)))*(8-(0.85-(9-1))))/(2*(9/6)*(9/6))) * C8) / (EXP(-((0-(0.85-(9-1)))*(0-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((1-(0.85-(9-1)))*(1-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((2-(0.85-(9-1)))*(2-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((3-(0.85-(9-1)))*(3-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((4-(0.85-(9-1)))*(4-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((5-(0.85-(9-1)))*(5-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((6-(0.85-(9-1)))*(6-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((7-(0.85-(9-1)))*(7-(0.85-(9-1))))/(2*(9/6)*(9/6))) + EXP(-((8-(0.85-(9-1)))*(8-(0.85-(9-1))))/(2*(9/6)*(9/6))))

Window: 20
Sigma: 1
Offset: 0.2

(EXP(-((0-(0.2-(20-1)))*(0-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C0 + EXP(-((1-(0.2-(20-1)))*(1-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C1 + EXP(-((2-(0.2-(20-1)))*(2-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C2 + EXP(-((3-(0.2-(20-1)))*(3-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C3 + EXP(-((4-(0.2-(20-1)))*(4-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C4 + EXP(-((5-(0.2-(20-1)))*(5-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C5 + EXP(-((6-(0.2-(20-1)))*(6-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C6 + EXP(-((7-(0.2-(20-1)))*(7-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C7 + EXP(-((8-(0.2-(20-1)))*(8-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C8 + EXP(-((9-(0.2-(20-1)))*(9-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C9 + EXP(-((10-(0.2-(20-1)))*(10-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C10 + EXP(-((11-(0.2-(20-1)))*(11-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C11 + EXP(-((12-(0.2-(20-1)))*(12-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C12 + EXP(-((13-(0.2-(20-1)))*(13-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C13 + EXP(-((14-(0.2-(20-1)))*(14-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C14 + EXP(-((15-(0.2-(20-1)))*(15-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C15 + EXP(-((16-(0.2-(20-1)))*(16-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C16 + EXP(-((17-(0.2-(20-1)))*(17-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C17 + EXP(-((18-(0.2-(20-1)))*(18-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C18 + EXP(-((19-(0.2-(20-1)))*(19-(0.2-(20-1))))/(2*(20/1)*(20/1))) * C19) / (EXP(-((0-(0.2-(20-1)))*(0-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((1-(0.2-(20-1)))*(1-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((2-(0.2-(20-1)))*(2-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((3-(0.2-(20-1)))*(3-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((4-(0.2-(20-1)))*(4-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((5-(0.2-(20-1)))*(5-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((6-(0.2-(20-1)))*(6-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((7-(0.2-(20-1)))*(7-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((8-(0.2-(20-1)))*(8-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((9-(0.2-(20-1)))*(9-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((10-(0.2-(20-1)))*(10-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((11-(0.2-(20-1)))*(11-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((12-(0.2-(20-1)))*(12-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((13-(0.2-(20-1)))*(13-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((14-(0.2-(20-1)))*(14-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((15-(0.2-(20-1)))*(15-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((16-(0.2-(20-1)))*(16-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((17-(0.2-(20-1)))*(17-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((18-(0.2-(20-1)))*(18-(0.2-(20-1))))/(2*(20/1)*(20/1))) + EXP(-((19-(0.2-(20-1)))*(19-(0.2-(20-1))))/(2*(20/1)*(20/1))))

Window: 50
Sigma: 6
Offset: 0.85

(EXP(-((0-(0.85-(50-1)))*(0-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C0 + EXP(-((1-(0.85-(50-1)))*(1-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C1 + EXP(-((2-(0.85-(50-1)))*(2-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C2 + EXP(-((3-(0.85-(50-1)))*(3-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C3 + EXP(-((4-(0.85-(50-1)))*(4-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C4 + EXP(-((5-(0.85-(50-1)))*(5-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C5 + EXP(-((6-(0.85-(50-1)))*(6-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C6 + EXP(-((7-(0.85-(50-1)))*(7-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C7 + EXP(-((8-(0.85-(50-1)))*(8-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C8 + EXP(-((9-(0.85-(50-1)))*(9-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C9 + EXP(-((10-(0.85-(50-1)))*(10-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C10 + EXP(-((11-(0.85-(50-1)))*(11-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C11 + EXP(-((12-(0.85-(50-1)))*(12-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C12 + EXP(-((13-(0.85-(50-1)))*(13-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C13 + EXP(-((14-(0.85-(50-1)))*(14-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C14 + EXP(-((15-(0.85-(50-1)))*(15-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C15 + EXP(-((16-(0.85-(50-1)))*(16-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C16 + EXP(-((17-(0.85-(50-1)))*(17-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C17 + EXP(-((18-(0.85-(50-1)))*(18-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C18 + EXP(-((19-(0.85-(50-1)))*(19-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C19 + EXP(-((20-(0.85-(50-1)))*(20-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C20 + EXP(-((21-(0.85-(50-1)))*(21-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C21 + EXP(-((22-(0.85-(50-1)))*(22-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C22 + EXP(-((23-(0.85-(50-1)))*(23-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C23 + EXP(-((24-(0.85-(50-1)))*(24-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C24 + EXP(-((25-(0.85-(50-1)))*(25-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C25 + EXP(-((26-(0.85-(50-1)))*(26-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C26 + EXP(-((27-(0.85-(50-1)))*(27-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C27 + EXP(-((28-(0.85-(50-1)))*(28-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C28 + EXP(-((29-(0.85-(50-1)))*(29-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C29 + EXP(-((30-(0.85-(50-1)))*(30-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C30 + EXP(-((31-(0.85-(50-1)))*(31-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C31 + EXP(-((32-(0.85-(50-1)))*(32-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C32 + EXP(-((33-(0.85-(50-1)))*(33-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C33 + EXP(-((34-(0.85-(50-1)))*(34-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C34 + EXP(-((35-(0.85-(50-1)))*(35-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C35 + EXP(-((36-(0.85-(50-1)))*(36-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C36 + EXP(-((37-(0.85-(50-1)))*(37-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C37 + EXP(-((38-(0.85-(50-1)))*(38-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C38 + EXP(-((39-(0.85-(50-1)))*(39-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C39 + EXP(-((40-(0.85-(50-1)))*(40-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C40 + EXP(-((41-(0.85-(50-1)))*(41-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C41 + EXP(-((42-(0.85-(50-1)))*(42-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C42 + EXP(-((43-(0.85-(50-1)))*(43-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C43 + EXP(-((44-(0.85-(50-1)))*(44-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C44 + EXP(-((45-(0.85-(50-1)))*(45-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C45 + EXP(-((46-(0.85-(50-1)))*(46-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C46 + EXP(-((47-(0.85-(50-1)))*(47-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C47 + EXP(-((48-(0.85-(50-1)))*(48-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C48 + EXP(-((49-(0.85-(50-1)))*(49-(0.85-(50-1))))/(2*(50/6)*(50/6))) * C49) / (EXP(-((0-(0.85-(50-1)))*(0-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((1-(0.85-(50-1)))*(1-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((2-(0.85-(50-1)))*(2-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((3-(0.85-(50-1)))*(3-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((4-(0.85-(50-1)))*(4-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((5-(0.85-(50-1)))*(5-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((6-(0.85-(50-1)))*(6-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((7-(0.85-(50-1)))*(7-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((8-(0.85-(50-1)))*(8-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((9-(0.85-(50-1)))*(9-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((10-(0.85-(50-1)))*(10-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((11-(0.85-(50-1)))*(11-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((12-(0.85-(50-1)))*(12-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((13-(0.85-(50-1)))*(13-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((14-(0.85-(50-1)))*(14-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((15-(0.85-(50-1)))*(15-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((16-(0.85-(50-1)))*(16-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((17-(0.85-(50-1)))*(17-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((18-(0.85-(50-1)))*(18-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((19-(0.85-(50-1)))*(19-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((20-(0.85-(50-1)))*(20-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((21-(0.85-(50-1)))*(21-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((22-(0.85-(50-1)))*(22-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((23-(0.85-(50-1)))*(23-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((24-(0.85-(50-1)))*(24-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((25-(0.85-(50-1)))*(25-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((26-(0.85-(50-1)))*(26-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((27-(0.85-(50-1)))*(27-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((28-(0.85-(50-1)))*(28-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((29-(0.85-(50-1)))*(29-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((30-(0.85-(50-1)))*(30-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((31-(0.85-(50-1)))*(31-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((32-(0.85-(50-1)))*(32-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((33-(0.85-(50-1)))*(33-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((34-(0.85-(50-1)))*(34-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((35-(0.85-(50-1)))*(35-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((36-(0.85-(50-1)))*(36-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((37-(0.85-(50-1)))*(37-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((38-(0.85-(50-1)))*(38-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((39-(0.85-(50-1)))*(39-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((40-(0.85-(50-1)))*(40-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((41-(0.85-(50-1)))*(41-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((42-(0.85-(50-1)))*(42-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((43-(0.85-(50-1)))*(43-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((44-(0.85-(50-1)))*(44-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((45-(0.85-(50-1)))*(45-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((46-(0.85-(50-1)))*(46-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((47-(0.85-(50-1)))*(47-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((48-(0.85-(50-1)))*(48-(0.85-(50-1))))/(2*(50/6)*(50/6))) + EXP(-((49-(0.85-(50-1)))*(49-(0.85-(50-1))))/(2*(50/6)*(50/6))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Relative Strength Indicator - PCF
Posted: Wednesday, January 17, 2018 10:47:38 AM

No, there isn't a way to create a Personal Criteria Formula for this.

About the best you can do is add both the plain Relative Strength indicator and a Rate of Change Percent indicator to the chart. Change the data source of the ROC% indicator to use the RS indicator instead of price and change the period to 60.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Questions about data distribution
Posted: Wednesday, January 17, 2018 9:43:15 AM

It applies no matter what the period.

Stock data quite simply is not normally distributed. Bollinger Bands can be a useful tool, but the lines are not statistically valid in the sense of predicting the percentage of values which should fall inside or outside of certain bands.

That said, 99.7% of bars falling outside a 3 standard deviation range of the average would definitely be a demonstration of this.

You can in fact (at least mathematically but not in TC2000) calculate a value at which a certain percentage of the data falls within that range. That is kind of what median and percentile rank type calculations are all about. It isn't standard deviation however and it may or may not be overfitting the data (depending rather specifically on the underlying data).

I have no idea what measures those who manage large assets do or do not use.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: PCF to Indicate The Up Slope in Linear Regression
Posted: Wednesday, January 17, 2018 8:55:25 AM

I am going to give the TC2000 v17+ version of this as well.

FAVGC252 > AVGC252

Since the TC2000 v7 version of this is quite long.

125.5 * C + 124.5 * C1 + 123.5 * C2 + 122.5 * C3 + 121.5 * C4 + 120.5 * C5 + 119.5 * C6 + 118.5 * C7 + 117.5 * C8 + 116.5 * C9 + 115.5 * C10 + 114.5 * C11 + 113.5 * C12 + 112.5 * C13 + 111.5 * C14 + 110.5 * C15 + 109.5 * C16 + 108.5 * C17 + 107.5 * C18 + 106.5 * C19 + 105.5 * C20 + 104.5 * C21 + 103.5 * C22 + 102.5 * C23 + 101.5 * C24 + 100.5 * C25 + 99.5 * C26 + 98.5 * C27 + 97.5 * C28 + 96.5 * C29 + 95.5 * C30 + 94.5 * C31 + 93.5 * C32 + 92.5 * C33 + 91.5 * C34 + 90.5 * C35 + 89.5 * C36 + 88.5 * C37 + 87.5 * C38 + 86.5 * C39 + 85.5 * C40 + 84.5 * C41 + 83.5 * C42 + 82.5 * C43 + 81.5 * C44 + 80.5 * C45 + 79.5 * C46 + 78.5 * C47 + 77.5 * C48 + 76.5 * C49 + 75.5 * C50 + 74.5 * C51 + 73.5 * C52 + 72.5 * C53 + 71.5 * C54 + 70.5 * C55 + 69.5 * C56 + 68.5 * C57 + 67.5 * C58 + 66.5 * C59 + 65.5 * C60 + 64.5 * C61 + 63.5 * C62 + 62.5 * C63 + 61.5 * C64 + 60.5 * C65 + 59.5 * C66 + 58.5 * C67 + 57.5 * C68 + 56.5 * C69 + 55.5 * C70 + 54.5 * C71 + 53.5 * C72 + 52.5 * C73 + 51.5 * C74 + 50.5 * C75 + 49.5 * C76 + 48.5 * C77 + 47.5 * C78 + 46.5 * C79 + 45.5 * C80 + 44.5 * C81 + 43.5 * C82 + 42.5 * C83 + 41.5 * C84 + 40.5 * C85 + 39.5 * C86 + 38.5 * C87 + 37.5 * C88 + 36.5 * C89 + 35.5 * C90 + 34.5 * C91 + 33.5 * C92 + 32.5 * C93 + 31.5 * C94 + 30.5 * C95 + 29.5 * C96 + 28.5 * C97 + 27.5 * C98 + 26.5 * C99 + 25.5 * C100 + 24.5 * C101 + 23.5 * C102 + 22.5 * C103 + 21.5 * C104 + 20.5 * C105 + 19.5 * C106 + 18.5 * C107 + 17.5 * C108 + 16.5 * C109 + 15.5 * C110 + 14.5 * C111 + 13.5 * C112 + 12.5 * C113 + 11.5 * C114 + 10.5 * C115 + 9.5 * C116 + 8.5 * C117 + 7.5 * C118 + 6.5 * C119 + 5.5 * C120 + 4.5 * C121 + 3.5 * C122 + 2.5 * C123 + 1.5 * C124 + 0.5 * C125 - 0.5 * C126 - 1.5 * C127 - 2.5 * C128 - 3.5 * C129 - 4.5 * C130 - 5.5 * C131 - 6.5 * C132 - 7.5 * C133 - 8.5 * C134 - 9.5 * C135 - 10.5 * C136 - 11.5 * C137 - 12.5 * C138 - 13.5 * C139 - 14.5 * C140 - 15.5 * C141 - 16.5 * C142 - 17.5 * C143 - 18.5 * C144 - 19.5 * C145 - 20.5 * C146 - 21.5 * C147 - 22.5 * C148 - 23.5 * C149 - 24.5 * C150 - 25.5 * C151 - 26.5 * C152 - 27.5 * C153 - 28.5 * C154 - 29.5 * C155 - 30.5 * C156 - 31.5 * C157 - 32.5 * C158 - 33.5 * C159 - 34.5 * C160 - 35.5 * C161 - 36.5 * C162 - 37.5 * C163 - 38.5 * C164 - 39.5 * C165 - 40.5 * C166 - 41.5 * C167 - 42.5 * C168 - 43.5 * C169 - 44.5 * C170 - 45.5 * C171 - 46.5 * C172 - 47.5 * C173 - 48.5 * C174 - 49.5 * C175 - 50.5 * C176 - 51.5 * C177 - 52.5 * C178 - 53.5 * C179 - 54.5 * C180 - 55.5 * C181 - 56.5 * C182 - 57.5 * C183 - 58.5 * C184 - 59.5 * C185 - 60.5 * C186 - 61.5 * C187 - 62.5 * C188 - 63.5 * C189 - 64.5 * C190 - 65.5 * C191 - 66.5 * C192 - 67.5 * C193 - 68.5 * C194 - 69.5 * C195 - 70.5 * C196 - 71.5 * C197 - 72.5 * C198 - 73.5 * C199 - 74.5 * C200 - 75.5 * C201 - 76.5 * C202 - 77.5 * C203 - 78.5 * C204 - 79.5 * C205 - 80.5 * C206 - 81.5 * C207 - 82.5 * C208 - 83.5 * C209 - 84.5 * C210 - 85.5 * C211 - 86.5 * C212 - 87.5 * C213 - 88.5 * C214 - 89.5 * C215 - 90.5 * C216 - 91.5 * C217 - 92.5 * C218 - 93.5 * C219 - 94.5 * C220 - 95.5 * C221 - 96.5 * C222 - 97.5 * C223 - 98.5 * C224 - 99.5 * C225 - 100.5 * C226 - 101.5 * C227 - 102.5 * C228 - 103.5 * C229 - 104.5 * C230 - 105.5 * C231 - 106.5 * C232 - 107.5 * C233 - 108.5 * C234 - 109.5 * C235 - 110.5 * C236 - 111.5 * C237 - 112.5 * C238 - 113.5 * C239 - 114.5 * C240 - 115.5 * C241 - 116.5 * C242 - 117.5 * C243 - 118.5 * C244 - 119.5 * C245 - 120.5 * C246 - 121.5 * C247 - 122.5 * C248 - 123.5 * C249 - 124.5 * C250 - 125.5 * C251 > 0



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Correlated stocks
Posted: Wednesday, January 17, 2018 8:49:22 AM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: LR
Posted: Tuesday, January 16, 2018 3:05:26 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Accuracy of Bollinger Band Standard Deviations, especially in current circumstances
Posted: Tuesday, January 16, 2018 12:31:15 PM

The 1.3 is related to Bollinger Bands of period 40 and a steady rise (or fall). This is just the width at which the price (or other indicator) to which the Bollinger Bands are applied would line up when rising or falling at a steady rate.

This width can change a bit based on period. The CCI Clone & Bollinger Bands topic explores this in greater detail.

The percentage of data which falls within Bollinger Bands is based on statistics. It applies to something called "normal distribution". This is a statistical term which applies to data distributed ino a "bell curve". It does not apply to stock data because stock data is not normally distributed. It was not experimentally derived from stock data and just based on the underlying math.

I cannot make any suggestions as to adjustments you might want to make to an indicator for specific market conditions or about how to interpret an indicator.

I have sent you a copy of me interpretation of the RealMotion indicator via TCMail.

How to Receive Messages with TC Mail



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Correlated stocks
Posted: Tuesday, January 16, 2018 12:19:24 PM

It isn't really a correlation, but you can sort by percent changes over the same period of time using Custom Date Sort.

How to Use Custom Date Sort



-Bruce
Personal Criteria Formulas
TC2000 Support Articles