Registered User
Joined: 10/7/2004
Posts: 9
|
Dear Sirs/Madames:
I've been wrestling with this almost since starting my subscrip. to TC 6+ years ago, and I've failed to solve the problem on two attempts so far, but, with all the improvements to TC in the interim, there has GOT to be a solution now, right?
How is it that TC has only ONE pre-fab, non-editable PCF for RELATIVE STRENGTH vs. SP500 (a 1 year time frame is the only one available at TC, it's a system PCF, and non-editable)?
I need (we ALL need, imho) the same sorting capability as what is in IBD newspaper for industry groups every day: A running RELATIVE STRENGTH vs. SP500 (or any other benchmark; should be customizable) over any time frame I want.
Furthermore, it should be set up the same as the RSI pcf at TC, where you can check it for any point in time BACKWARDS. I need to know what was ranked where as of a day ago, a week ago, 3 months ago, etc....NOT how it has done over that entire duration of time. I need to know if a stock or group is PROGRESSING up or down in Relative Strength compared to other issues. And this should be applicable to all TC symbols, including the MG groups and sectors.
The formula for the 1 year PCF at TC is as follows, from your help file:
Relative Strength 1-Yr (vs SP-500)
The relative change in price of a stock over the past year compared to the change in the SP-500 over the same time. The calculation is : (Latest Close Price of Stock / Latest Close Price of SP-500) / (Close Price of Stock 1 year ago / Close Price of SP-500 1 year ago) * 100.
How do I duplicate this formula in my own PCF, and using a 1 day, 1 week, 1 month, 3 month, 6 month, etc. time frame?
Thank you.
TrilionDolarMan 
|
|
Registered User
Joined: 10/7/2004
Posts: 9
|
PS:
Relative Strength 1 yr. (vs. SP500)
is a SYSTEM SORT at TC.
If it is possible as a system sort, it MUST be possible as a pcf, right?
C'mon, guys SOMEBODY has GOT to know how to do it...
TDM
|
|
Registered User
Joined: 10/7/2004
Posts: 9
|
Geez...some guy posts 20 minutes AFTER me, and gets 107 views and 9 replies....I get 8 views and ZERO replies.
Is it my aftershave? 
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (TrilionDolarMan) If it is possible as a system sort, it MUST be possible as a pcf, right?
No, the value is calculated on the server, not in the program. Fundamental Criteria are available as well, but they cannot be calculated using PCFs. TeleChart's Personal Criteria Formula Language does not have syntax for referencing other symbols or fundamentals. This means there is no practical automated method of doing what you want using just TeleChart.
A semi-automated method involving adjusting the formulas before calculation is outlined in Indexes in PCF's.
QUOTE (TrilionDolarMan) Geez...some guy posts 20 minutes AFTER me, and gets 107 views and 9 replies....I get 8 views and ZERO replies.
The topic you are referencing, Volume Scans, was actually started on Sunday, May 20, 2007 at 1:38:33 AM ET. This is well before you asked your question. In any case, there are other considerations beyond when a question was asked that influence the order in which questions are answered.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 9
|
Hmm, Thanks Bruce. Well, fwiw, at least that the best answer I've ever gotten on the question. I guess I'll have to go keep a spreadcheat on it...
Thanks for the reply, tho!  
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Depending on the number of formulas involved, utilizing the method described in Indexes in PCF's could actually be quicker than exporting the data for use in a spreadsheet.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
You should also look into Blocks where you can calculate these things on the fly and on demand without having to do a "work around" in TeleChart.
To download Blocks, please check out the Blocks Web Site
For information on the Modular Tools by Worden for Blocks, check out the Web Site
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 9
|
Yes, Bruce!
I think it's going to work, and is DEFINITELY worth the "price" of admission to the thread.
I BELIEVE, but I'm not sure, that I now have the wherewithal to fairly well replicate the IBD-style sort at TC, as follows:
Firstly I use the above RS formula (in the threat, from TC help file) for a 5 day lookback, to establish the RS rank for the current WEEK.
((C/latest SP-500 close NUMBER)/(C#dayslookback/SP-500 close NUMBER@ days lookback))
From there I want only the RS at the EXACT point in time of the lookback, not over the entire period.
So, I simply use (C5/SP500 value)*100 (the multiplier is not important, save to get the value high enough to register), then C21 and C63 to get the lookback 5 days ago, 1 month ago, and 3 months ago.
I think it's going to work, but I'll hold off posting this note until I see that it does....
YES...it does....with one caveat. In attempting, as is necessary, to get the lookback to an exact point in time, I'm looking at the stock price/SP500 price AT THAT TIME, but not in a relative ratio. Hence, my 1 week RS scan will sort the entire market by "current position" but the other time frames give DIFFERENT number ranges, depending on the price of the stock vs. the SP500. In other words....a $100 stock yields quite a different number range than a $10 stock -- but, since I compare 4 fields across the TC watch list...it's the whether that number is rising or falling for each stock over each time frame that I need to know.
Bottom line: it works.
MUCH OBLIGED for solving a 6 year old problem!!!!
TDM 
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
TrilionDolarMan,
If you use the PCF method in:
Indexes in PCF's
the definition:
100*(Latest Close Price of Stock / Latest Close Price of SP-500) / (Close Price of Stock 1 year ago / Close Price of SP-500 1 year ago)
should be replaced by the equivalent Separation of Variables form:
100*(Latest Close Price of Stock / Close Price of Stock 1 year ago) / (Latest Close Price of SP-500 / Close Price of SP-500 1 year ago)
If all you are interested in is the sort order obtained by sorting by Relative Strength 1-Yr (vs SP-500), then a sort by Price Percent Change results in the same order.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 2/10/2012
Posts: 67
|
I am looking for Relative Strength scan (NOT RSI) for a long time.
I think that a lot of people like me looking for relative strength scan too. I see this forum from 2007.
The formula is pretty easy.
Relative Strength Formula = Stock Price / SPY
TC2000 Version 12.2 can do a lot of amazing things.
Would you guys add Relative Strength scan (NOT RSI) next-to-do-list?
Thank you
JJ
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Thank you for your suggestion. It has been assigned case number 8140.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |