| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 5/26/2005
Posts: 11
|
I currently am trying to set up a grid to refine a sort of Sectors according to certain variables. As long as I choose an existing Worden feature (ex=Moneystrea vs. Price), I have no problem with the column giving what appears to be an appropriate value. I am trying to write a PCF that confirms that the 20 day Mov av for today is > 20 d MA of 5 days ago, and that today's 20 day MA > 50 day MA. (ps- the Test function says I need 246 days to calculate and I assume the Worden data is sufficient? I am not getting any values ...what am I doing wrong?
Thanks, Gwen
mine = (XAVG19 > XAVGC19.10) and (XAVGC19 > XAVGC49)
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
(XAVG19 > XAVGC19.10) and (XAVGC19 > XAVGC49)
Should be XAVGC19.
|
|
Registered User
Joined: 5/26/2005
Posts: 11
|
Thanks StockGuy, but I made a typo when I wrote it ...my formula does have the C in the XAGVC19....still does not work...please advise....Gwen
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Hmmm...working fine here. What list are you using to calculate your PCFs? All Stocks? All Items in System?
You won't get "values" from this formula. If used in a Sort, stocks that pass will show "True" in the column.
|
|
Registered User
Joined: 5/26/2005
Posts: 11
|
Dear Stockguy...I created it as a PCF and then created a column under Tab 8 in the grid section. I do a general "update" then switch to Media General Ind Groups, and when go to tab 8, all my columns are filled in but this on. I realize it would give me a true false, but I would rather try to create the formula so that it detects the crossover point in the averages and comes up with a numberic value....can that be done with the Worden formulas? Thanks, Gwen
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
The original formula above has nothing for crossovers.
I will assume you are looking for the 19 to cross the 49
If this is the case, try these TWO seperate PCFs:
19 as % of 49 today
100*XAVGC19/XAVGC49
and create a second one:
19 as % of 49 yesterday
100*XAVGC19.1/XAVGC49.1
Now go to EasyScan and add both PCFs (be sure they are calculated against ALL ITEMS IN THE SYSTEM)
For cross ups limit the values as:
19 as % of 49 today (VALUES 100 to MAX)
19 as % of 49 yesterday (VALUES MIN to 100)
For cross downs limit the values as:
19 as % of 49 today (VALUES MIN to 100)
19 as % of 49 yesterday (VALUES 100 to MAX)
You can then use either as a sort condition or in your WatchList tabs.
To see this type of crossover scan in action, watch this short video:
Create PCFs and EasyScans to find moving average crossovers
- Craig
Here to Help!
|
|
Registered User
Joined: 5/26/2005
Posts: 11
|
Dear StockGuy
Thanks for the input...I just got back...will try it and see how and if it works, but most of all, thanks for the help, Gwen
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (Gwen) ...but I would rather try to create the formula so that it detects the crossover point in the averages and comes up with a numberic value....can that be done with the Worden formulas?
Gwen,
I have three questions to ask:
1) You referred to periods of 20 and 50 and then used periods of 19 and 49. What are the periods you are interested in?
2) Let us assume that the short period EMA upcrossed the long period EMA N days ago and has remained above ever since. Are you requesting a PCF which gives the number N?
3) Are you asking something other than 2)?
I will give a qualified yes to "Can 2) be done?".
Thanks,
Jim Murphy
|
|
|
Guest-1 |