| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/3/2005
Posts: 15
|
I would like to know what the formula would be for a stock whose closing price is:
1. Above a Weekly 50 Simple Period Moving Average
2. Below a Weekly 50 Simple Period Moving Average
thanks,
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Check out this great video by Doug:
Create PCFs and EasyScans to find moving average crossovers
You will use price (C and C1) instead of one of the averages.
- Craig
Here to Help!
|
|
Registered User
Joined: 3/3/2005
Posts: 15
|
I appriciate the video...it's not talking about WEEKLY closing prices.
Again, looking for the PCF that will:
1. Show a closing price above a WEEKLY 50 SMA
2. Show a closing price below a WEEKLY 50SMA
thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Sorry, missed the weekly reference in your original post.
Visual Difference sorting is your best bet here. It will allow you to find your conditions based on any time frame:
Comparing indicators using Visual Difference sorts
Here is a topic you might also find interesting....
Weekly Moving Average in a PCF
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Close vs. 50 week moving average today:
(C/(C+C5+C10+C15+C20+C25+C30+C35+C40+C45+
C50+C55+C60+C65+C70+C75+C80+C85+C90+C95+
C100+C105+C110+C115+C120+C125+C130+C135+C140+C145+
C150+C155+C160+C165+C170+C175+C180+C185+C190+C195+
C200+C205+C210+C215+C220+C225+C230+C235+C240+C245)/50))*100
Close vs. 50 week moving average 3 days ago:
(C3/(C3+C8+C13+C18+C23+C28+C33+C38+C43+C48+
C53+C58+C63+C68+C73+C78+C83+C88+C93+C98+
C103+C108+C113+C118+C123+C128+C133+C138+C143+C148+
C153+C158+C163+C168+C173+C178+C183+C188+C193+C198+
C203+C208+C213+C218+C223+C228+C233+C238+C243+C248)/50))*100
I agree that Craig's suggestion to use Visual Sorting on a weekly chart is your best bet.
- Doug
Teaching Online!
|
|
Registered User
Joined: 3/3/2005
Posts: 15
|
thanks guys!!!
|
|
 Gold Customer
Joined: 6/22/2014
Posts: 2
|
Is there a user group for TC2000 that focuses on Personal Criteriaf Formulas and Easyscan?
I want to really learn how to build PCF's and Easyscans.
Are there any books on PCF's or Easysans?
Tks,
J Ruvolo
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
There really isn't a book of which I am aware on creating PCFs and EasyScans. I do not know if there are any user groups devoted to PCFs and/or EasyScans.
The PCF Formula Descriptions topic lists all of the syntax which is valid in the Personal Criteria Formula Language and the Handy PCF example formulas to help you learn the syntax of PCFs! topic has basic examples of this syntax in use.
I'm not quite sure how useful it would be to anybody else, but the Personal Criteria Formulas topic has a list of topics I find useful.
You are generally better off not creating formulas unless absolutely necessary. So I would check out the following videos as well.
Create Conditions from Your Chart (5:25)
Building a Scan with Multiple Conditions (7:29)
Creating Conditions from Your Charts (57:04)
Writing Custom Conditions: The Basics (40:36)
Writing Custom Condtions: Useful Examples (51:30)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |