Registered User
Joined: 1/10/2008
Posts: 98
|
In a down day like today (probably the worst day of this year) where the S&P 500 index drop 3 % how can I build a pcf that:
1- Give me a list of stocks that close at maximum at half of the S&P 500 index? In this case, stocks that end positive or negative until -1,5 %?
2-On the other hand if the S&P 500 Index ended on the green, another list of stocks that double the net change of the index. For example if tomorrow the S&P 500 index ends at 1%, I will want those stocks that climb at least 2%.
Of couse that I may do this at the the end of the day. But is it possible to do this automatically with 2 pcf's?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I do not know of a practical automated method of writing these types of formulas in TeleChart because the Personal Criteria Formula Language does not have syntax for referencing other symbols or fundamentals. A semi-automated method of creating PCFs for Relative Strength is outlined in the following topics:
Indexes in PCF's
RSMA PCFs
The same basic technique could be used to set arbitrary percent change ranges for specific dates or date ranges.
That said, it would probably be just as easy to just use a Custom Date Sort or have a simpler Price Percent Change Personal Criteria Formula. The basic technique would be to find out the Price Percent Change for the SP-500 and then Flag stocks within the desired range.
How to use the Flagging feature
Sorting Stocks by their Absolute or Relative Performance
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
vitorleite,
As Bruce implied, a PCF for accomplishing what you wish must be modified after each data update. But, as you will see, the modification is trivial.
Copy and paste the two PCFs:
1) Gain vs SP-500:
C0/C1-1 >= (0.50-1.50*(1236.83>1274.98))*(1236.83/1274.98-1.00)
2) Cain vs SP-500 Template:
(0.5-1.5*(C0>C1))*(C0/C1-1)
PCF 1) will return True for the stocks you desire on 09/04/08.
After each data download and before updating your PCFs:
1) Test PCF 2) on the Symbol SP-500.
2) Copy the test window. Do not pay any attention to the "Result" of the test.
3) Delete the right-side of PCF 1) and paste 2) in its place.
That is all there is to it.
Thanks,
Jim Murphy
|