| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 19
|
Hi,
I am looking for a scan and a sort that would show the percentage amount a stock is over its 50 day simple moving average. A point amount would secondarily be useful too. I am only interested in stocks above its 50 day MA.
Thanks,
RonS
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
This would guarantee its above the 50:
C>AVGC50
This would show the percent:
(C/AVGC50*100)-100
Ths would show points:
C-AVGC50
Thanks
diceman
|
|
Registered User
Joined: 10/7/2004
Posts: 19
|
Thanks,
The expression (C/AVGC50*100)-100 doesn't make sense to me. The expression (C-AVGC50)/(AVGC50) * 100 makes better sense to me to create the % difference of the close over its 50 sma.
What would you suggest to show the point difference of the close over the 50 sma for a 5 day week, one day at a time?
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
QUOTE (RonS)
What would you suggest to show the point difference of the close over the 50 sma for a 5 day week, one day at a time?
You mean all at once?
This is today:
C-AVGC50
This is the day before that:
C1-AVGC50.1
The last 5 values would be:
C-AVGC50
C1-AVGC50.1
C2-AVGC50.2
C3-AVGC50.3
C4-AVGC50.4
I would guess putting them in watchlist columns would be the easiest way to see them all at once.
(unless you have something else in mind)
If you just want the week ago value than use:
C5-AVGC50.5
Thanks
diceman
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Just a note that the following formulas are all the same:
(C / AVGC50 * 100) - 100
100 * C / AVGC50 - 100
100 * (C / AVGC50 - 1)
(C - AVGC50) / (AVGC50) * 100
The advantage of the first three forms over the fourth is that they only require one reference to AVGC50.
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |