Registered User Joined: 11/27/2013 Posts: 2
|
What would the formula be to look for stocks above or below the 2nd Standard Deviation , thx.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you mean at least two standard deviations above or below the moving average then:
ABS(C - AVGC20) >= 2 * STDDEV20
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 4/1/2011 Posts: 90
|
Hi Bruce,
I wasnt to add the following values as columns the stocks and options in my watch list.
Can you write the PCF's for each of these that will tell me the value of XX?
XX price is 1 standard deviation above the current price.
XX price is 2 standard deviations above from the current price.
XX price is 1 standard deviation below the current price.
XX price is 2 standard deviations below the current price.
Thanks in advance.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (thomasjenkinsjr) XX price is 1 standard deviation above the current price.
C + STDDEV20
QUOTE (thomasjenkinsjr) XX price is 2 standard deviations above from the current price.
C + 2 * STDDEV20
QUOTE (thomasjenkinsjr) XX price is 1 standard deviation below the current price.
C - STDDEV20
QUOTE (thomasjenkinsjr) XX price is 2 standard deviations below the current price.
C - 2 * STDDEV20
-Bruce Personal Criteria Formulas TC2000 Support Articles
|