This is read-only version of AFL library entry. Ability to add user formulas
and comment is only available from members-only area.
Details:
Formula name:
Alpha and Beta and R_Squared Indicator
Author/Uploader:
Anthony Faragasso - ajf1111 [at] epix.net
Date/Time added:
2002-02-12 13:38:37
Origin:
Keywords:
Level:
semi-advanced
Flags:
indicator
DISCLAIMER: Most formulas present in AFL on-line library are submitted
by the users and are provided here on an "as is" and "as available" basis.
AmiBroker.com
makes no representations or warranties of any kind to the contents or the operation
of material presented here. We do not maintain nor provide technical support
for 3rd party formulas. Description:
Alpha, Beta and R_Squared, Indicator plots the Alpha and Beta and produces a read
out of values in the title bar of the Alpha, Beta and R_Squared. If you want to Plot the
R_Squared remove the slashes // in front of all Graph2 references....
Formula:
///Alpha AND Beta Indicators
//Ver.1.00, 2/10/02
//coded by Anthony Faragasso
//e-mail: ajf1111@epix.net
//Insert your Stock_index,Composite_index, S&P,etc.
//as the **Base Market**.
MaxGraph=5;
/***Base Market************/
Mkt="^ndx";//Must be enclosed in "....."Quotations.
P=Foreign(Mkt,"C",1);
/**************************/
Periods=21;//Set the period of Observation
//****Beta***********************/
Beta=(( Periods * Sum(ROC( C,1) * ROC(P,1),Periods )) - (Sum(ROC(C,1),Periods)
* Sum(ROC( P,1),Periods))) / ((Periods * Sum((ROC(P,1)^2 ),Periods)) -
(Sum(ROC(P,1 ),Periods)^2 ));
/******************************************/
//*****Alpha*********************/
Alpha=(Sum(ROC( C,1) ,Periods) - ( Beta ) * Sum( ROC( P,1) ,Periods ) ) /
Periods;
/******************************************/
/***R-Squared*****************/
R2=Correlation(P,C,Periods)^2;
/************************************/
Graph0=Beta;
Graph0Style=1;
Graph1=Alpha;
Graph1=(LastValue(Highest(Graph0))/LastValue(Highest(Graph1))) * Graph1;
Graph1Style=1;
/**R_squared graphing*****/
//Graph2=r2;
//Graph2Style=1;
//Graph2Color=2;
/*************************/
Title=Name()+" "+"ALPHA "+"("+WriteVal(Alpha,format=1.2)+")"+" "+" BETA
"+"("+WriteVal(Beta,format=1.2)+")"+" "+" R_SQUARED
"+"("+WriteVal(r2,format=1.2)+")";
/**Notes***/
//You've got to start with r-squared, which is an
//indicator of the validity of the beta AND alpha
//measures. Because the r-squared measures just how
//closely the Stock OR fund tracks the
//index with which it is being compared.
//An r-squared of 1.0 indicates
//A perfect match. AND, in that case, you can
//trust that the beta AND alpha measures are
//valid, too. But, the lower the r-squared, the less
//reliable beta AND alpha measures are.
//"[Betas and alphas on] a Stock or fund with an r-squared that's below //0.50
are completely meaningless.
//Assuming the r-squared is, say, 0.75 OR higher, you can move on to the
//beta.
Comments:
michael mroman59 [at] yahoo.com 2007-04-17 04:11:58
I used your formula for calculating Beta and I was getting values higher than 2. Isn't beta values supposed to be between 0 and 2? thanks