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
|