New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

RSMA PCFs Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bustermu
Posted : Monday, July 30, 2007 12:58:14 PM
Registered User
Joined: 1/1/2005
Posts: 2,645
We will show how to write PCFs for RSMA. We will write a PCF for RSMA10 upcrossing RSMA40. Unfortunately, the PCF has to be rewritten before each use after a data update. Fortunately, this is essentially as simple as typing 41 C's.

1) Write the PCF:

1000000*
(0/C0+1/C1+2/C2+3/C3+4/C4+5/C5+6/C6+7/C7+8/C8+9/C9
+10/C10+11/C11+12/C12+13/C13+14/C14+15/C15+16/C16+17/C17+18/C18+19/C19
+20/C20+21/C21+22/C22+23/C23+24/C24+25/C25+26/C26+27/C27+28/C28+29/C29
+30/C30+31/C31+32/C32+33/C33+34/C34+35/C35+36/C36+37/C37+38/C38+39/C39+40/C40)
/41

Check "Do not update this criteria". The 1000000 is solely for the purpose of moving the decimal point in the result when testing.

2) Test the PCF in 1) on the Symbol SP-500 and copy the test window. The result for 07/27/07 is:

1000000.00 * (0.00 / 1458.95 + 1.00 / 1482.66 + 2.00 / 1518.09 + 3.00 / 1511.04 + 4.00 / 1541.57 + 5.00 / 1534.10 + 6.00 / 1553.08 + 7.00 / 1546.17 + 8.00 / 1549.37 + 9.00 / 1549.52 + 10.00 / 1552.50 + 11.00 / 1547.70 + 12.00 / 1518.76 + 13.00 / 1510.12 + 14.00 / 1531.85 + 15.00 / 1530.44 + 16.00 / 1525.40 + 17.00 / 1524.87 + 18.00 / 1519.43 + 19.00 / 1503.35 + 20.00 / 1505.71 + 21.00 / 1506.34 + 22.00 / 1492.89 + 23.00 / 1497.74 + 24.00 / 1504.07 + 25.00 / 1522.19 + 26.00 / 1512.84 + 27.00 / 1533.70 + 28.00 / 1531.05 + 29.00 / 1532.91 + 30.00 / 1522.97 + 31.00 / 1515.67 + 32.00 / 1493.00 + 33.00 / 1509.12 + 34.00 / 1507.67 + 35.00 / 1490.72 + 36.00 / 1517.38 + 37.00 / 1530.95 + 38.00 / 1539.18 + 39.00 / 1536.34 + 40.00 / 1530.62) / 41.00

3) Place a C in front of each of the 41 integers in the numerators. The result for 07/27/07 is the PCF:

1000000*
(C0.00/1458.95 + C1.00/1482.66 + C2.00/1518.09
+ C3.00/1511.04 + C4.00/1541.57 + C5.00/1534.10
+ C6.00/1553.08 + C7.00/1546.17 + C8.00/1549.37
+ C9.00/1549.52 + C10.00/1552.50 + C11.00/1547.70
+ C12.00/1518.76 + C13.00/1510.12 + C14.00/1531.85
+ C15.00/1530.44 + C16.00/1525.40 + C17.00/1524.87
+ C18.00/1519.43 + C19.00/1503.35 + C20.00/1505.71
+ C21.00/1506.34 + C22.00/1492.89 + C23.00/1497.74
+ C24.00/1504.07 + C25.00/1522.19 + C26.00/1512.84
+ C27.00/1533.70 + C28.00/1531.05 + C29.00/1532.91
+ C30.00/1522.97 + C31.00/1515.67 + C32.00/1493.00
+ C33.00/1509.12 + C34.00/1507.67 + C35.00/1490.72
+ C36.00/1517.38 + C37.00/1530.95 + C38.00/1539.18
+ C39.00/1536.34 + C40.00/1530.62)
/41.00

This is 1000000 times RSMA41. The .00's are unnecessary, but they do no harm. The RSMA10, RSMA40, RSMA10.1, and RSMA40.1 are obtained from the RSMA41 by deletion or by copying just the portion required.

4) Construct the PCF for RSMA10 upcrossing RSMA40 from the PCF in 3). The result for 07/27/07 is:

(C0.00/1458.95 + C1.00/1482.66 + C2.00/1518.09
+ C3.00/1511.04 + C4.00/1541.57 + C5.00/1534.10
+ C6.00/1553.08 + C7.00/1546.17 + C8.00/1549.37
+ C9.00/1549.52)/10
> (C0.00/1458.95 + C1.00/1482.66 + C2.00/1518.09
+ C3.00/1511.04 + C4.00/1541.57 + C5.00/1534.10
+ C6.00/1553.08 + C7.00/1546.17 + C8.00/1549.37
+ C9.00/1549.52 + C10.00/1552.50 + C11.00/1547.70
+ C12.00/1518.76 + C13.00/1510.12 + C14.00/1531.85
+ C15.00/1530.44 + C16.00/1525.40 + C17.00/1524.87
+ C18.00/1519.43 + C19.00/1503.35 + C20.00/1505.71
+ C21.00/1506.34 + C22.00/1492.89 + C23.00/1497.74
+ C24.00/1504.07 + C25.00/1522.19 + C26.00/1512.84
+ C27.00/1533.70 + C28.00/1531.05 + C29.00/1532.91
+ C30.00/1522.97 + C31.00/1515.67 + C32.00/1493.00
+ C33.00/1509.12 + C34.00/1507.67 + C35.00/1490.72
+ C36.00/1517.38 + C37.00/1530.95 + C38.00/1539.18
+ C39.00/1536.34)/40
AND
(C1.00/1482.66 + C2.00/1518.09
+ C3.00/1511.04 + C4.00/1541.57 + C5.00/1534.10
+ C6.00/1553.08 + C7.00/1546.17 + C8.00/1549.37
+ C9.00/1549.52 + C10.00/1552.50)/10
<= (C1.00/1482.66 + C2.00/1518.09
+ C3.00/1511.04 + C4.00/1541.57 + C5.00/1534.10
+ C6.00/1553.08 + C7.00/1546.17 + C8.00/1549.37
+ C9.00/1549.52 + C10.00/1552.50 + C11.00/1547.70
+ C12.00/1518.76 + C13.00/1510.12 + C14.00/1531.85
+ C15.00/1530.44 + C16.00/1525.40 + C17.00/1524.87
+ C18.00/1519.43 + C19.00/1503.35 + C20.00/1505.71
+ C21.00/1506.34 + C22.00/1492.89 + C23.00/1497.74
+ C24.00/1504.07 + C25.00/1522.19 + C26.00/1512.84
+ C27.00/1533.70 + C28.00/1531.05 + C29.00/1532.91
+ C30.00/1522.97 + C31.00/1515.67 + C32.00/1493.00
+ C33.00/1509.12 + C34.00/1507.67 + C35.00/1490.72
+ C36.00/1517.38 + C37.00/1530.95 + C38.00/1539.18
+ C39.00/1536.34 + C40.00/1530.62)/40

Repeat Steps 2), 3), and 4) before use after an update. If you do not mind typing 41 C's, obtaining the PCF is easy.

Thanks,
Jim Murphy
diceman
Posted : Saturday, August 25, 2007 1:46:10 PM
Registered User
Joined: 1/28/2005
Posts: 6,048
If one desires a PCF that does not require
updating.

One of the FX symbols can be used
in place of the SP-500.

(FX10, FX20 and so on)

However you should be aware that your
reference symbol never declines in value.


Thanks
diceman
kcaughron31
Posted : Tuesday, July 28, 2009 11:07:11 PM
Registered User
Joined: 3/4/2009
Posts: 160
How would you write this for a rsma per industry? 
StockGuy
Posted : Tuesday, July 28, 2009 11:59:58 PM

Administration

Joined: 9/30/2004
Posts: 9,043
There is an indicator in the StockFinder libary called Industry RSMA which plots two RSMAs using the active symbol's main or sub-industry average. 

You can then drag one average onto the other and create a rule for crossing up, crossing down, above, below, etc. and check the Scan Watchlist option and it will light up the stocks that pass the rule. 

I created a rule for the short RSMA crossing up through the long RSMA and ADSK, ALTR and NWSA from the Nas 100 passed the rule when I ran it tonight.

Bruce_L
Posted : Wednesday, July 29, 2009 7:41:41 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,210
kcaughron31,
If you want to do this in TeleChart, you would need to create a different PCF for each Industry and Sub Industry of interest every day. The basic technique is the same as what was outlined by bustermu in his post except that you would choose the symbol for the Industry or Sub Industry in step 2 instead of the symbol for the Standard & Poors 500 (SP-500).

In addition to making a different PCF for each Industry and Sub Industry of interest each day, you would need to choose the correct formula when making the comparison as the correct Industry or Sub Industry will not be chosen automatically.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.