Registered User
Joined: 3/22/2005
Posts: 9
|
this is what I think it should look like
((XYZ/XYZ5)-1) > (((SP-500/SP-5005)-1)*(BetaXYZ))
This criteria should filter out all stocls that have created excess alpha over the past 5 days, reflecting
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Beta is available as a built in Fundamental Criteria:
Beta - The coefficient which measures the volatility of a stock's returns relative to the market (S&P 500). It is based on a 36/60-month historical regression of the return on the stock onto the return on the S&P 500:
Ri = a + (Rm) + e
where Ri is the monthly total returns on the stock, a is the stock's Alpha, Rm is the monthly total returns on the market (S&P 500), and e is a random error term. A minimum of 12 monthly returns are required for this calculation.
A beta of 1 means that the market and the stock move up or down together, at the same rate. That is, a 5% up or down move in the market should theoretically result in a 5% up or down move in the stock. A beta coefficient of 2 suggests that the stock will tend to fluctuate twice as much as the market. That is, if the market moves up 5%, then the stock should move up 10%. A beta coefficient of 0.5 indicates that the stock will move one-half as much as the market, either up or down.
A negative beta indicates the stock tends to move in the opposite direction from the general market. That is, the stock price declines when the overall market is rising, or rises when the overall market is declining. Negative beta stocks are rare.
That said, TeleChart's Personal Criteria Formula Language does not have syntax for referencing either other symbols or Fundamental Data. You may wish to review the following:
Definitions of all built in scanning and sorting criteria
Handy PCF example formulas to help you learn the syntax of PCFs!
How to create a Personal Criteria Forumula (PCF)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|