BookmarkSubscribeRSS Feed
Jaaa
Fluorite | Level 6

Hello everyone!

I am replicating a paper about calculating the idiosyncratic volatility with respect to the FF three factors' models. The excess returns and FF three factors are daily recorded but the idiosyncratic volatility needs to be computed based on monthly basis. However, I still couldn't get the same result as the paper did after trying many many times. May I ask that, is there anyone who is able to have a look for me? Many thanks for your help and time, I will be very grateful if you can give some tips!

Here is my code:

/*Step three: Calculate idiosyncratic volatility w.r.t R-FF model*/
data L_FF;
set AngGFF;
exret=RET-RF;
run;

data L_FF;
set L_FF;
y=year(date);
m=month(date);
ym= y*100+m;
run;


proc reg data=L_FF outest=test;
model exret=Mkt_RF SMB HML;
output out=L_FF1 residual=r predicted=p stdr= st_r;
quit;run;

proc summary data=L_FF1 nway; 
var st_r;
class permno ym;
where ym>198000 and ym<200400;
output out=idio_vol(drop=_type_ _freq_) mean=;
label std="Idrisk_Std";
run;
 


May I also ask that, does the Root MSE out of the regression analysis mean the idiosyncratic volatility?

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 3262 views
  • 0 likes
  • 1 in conversation