Dimson Beta Calculation
Moderators: EViews Gareth, EViews Moderator
Dimson Beta Calculation
Hello, I would like to know if there is a simple way to estimate this equation (dimson beta) on eviews 6
rit = c + b1*rm(t1) + b2*rm(t) + b3*rm(t+1)
it's a dimson beta equation. ex. If I want to have beta for year 2006, then it would be
ri(2006) = c + b1*rm(2005) + b2*rm(2006) + b3*rm(2007)
how should I manage the structure of the data? should it be time series daily or panel data?
I actually have made a beta for one company in which I put the series (2005,2006,2007,etc) in a different object. But this won't be helpful because I'd have to work with 277 Companies and 20052010 data span. Any suggestion?
rit = c + b1*rm(t1) + b2*rm(t) + b3*rm(t+1)
it's a dimson beta equation. ex. If I want to have beta for year 2006, then it would be
ri(2006) = c + b1*rm(2005) + b2*rm(2006) + b3*rm(2007)
how should I manage the structure of the data? should it be time series daily or panel data?
I actually have made a beta for one company in which I put the series (2005,2006,2007,etc) in a different object. But this won't be helpful because I'd have to work with 277 Companies and 20052010 data span. Any suggestion?

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
The general part of the answer is
The other part depends on how you want to handle the panel nature of your data. Do you want the coefficients to be restricted across crosssections? Different intercepts?
Code: Select all
equation eq01.ls rit c rm(1) rm rm(1)
The other part depends on how you want to handle the panel nature of your data. Do you want the coefficients to be restricted across crosssections? Different intercepts?
Re: Dimson Beta Calculation
Thanks Glenn. But I actually have separated my data into "unstructured data". So, I have different series for different company and different year. (ex. comp1_2005, comp1_2006, company2_2005, company2_2006, etc)
Is it possible to process all data with the same equation at once?
I want to process the data like this:
"genr rcomp1_2005=d(log(comp1_5))"
but I want to apply that equation for all series. Is there any way to do that? thanks a lot
Is it possible to process all data with the same equation at once?
I want to process the data like this:
"genr rcomp1_2005=d(log(comp1_5))"
but I want to apply that equation for all series. Is there any way to do that? thanks a lot

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
I'm very confused about the structure of your data. You have
. 277 companies observed over the period 20052010
. your workfile is unstructured
. you have different series for companies and year (eg., comp1_2005, comp1_2006)
These things don't seem to add up. Are these data nonannual? How many observations are in your unstructured workfile? What does the COMP1_2005 series look like?
. 277 companies observed over the period 20052010
. your workfile is unstructured
. you have different series for companies and year (eg., comp1_2005, comp1_2006)
These things don't seem to add up. Are these data nonannual? How many observations are in your unstructured workfile? What does the COMP1_2005 series look like?
Re: Dimson Beta Calculation
My data is indeed a timeseries data (could be panel data). It consist of 277 companies within 20052010 period (daily stock price). But the problem is, if I use timeseries for my workfile structure (which is 1 series for 1 company, 20052010) it would be impossible for me to apply the equation, wouldn't it?
Rit = c + b1*Rm(t1) + b2*Rm(t) + b3*Rm(t+1)
ex. Ri(2006) = c + b1*Rm(2005) + b2*Rm(2006) + b3*Rm(2007)
How could I recall only "some" part of the data (2005 only, 2006 only, etc) for the equation, meanwhile each of the series consist of daily price from 20052010? (if I used timeseries data). Or there is a way to do that?
Therefore, I treat the data as an unstructured data so that I could separate the series base on their company AND the year..
Is my explanation clear enough? Sorry if it makes you confuse, glenn. Really appreciate your feedback..
Rit = c + b1*Rm(t1) + b2*Rm(t) + b3*Rm(t+1)
ex. Ri(2006) = c + b1*Rm(2005) + b2*Rm(2006) + b3*Rm(2007)
How could I recall only "some" part of the data (2005 only, 2006 only, etc) for the equation, meanwhile each of the series consist of daily price from 20052010? (if I used timeseries data). Or there is a way to do that?
Therefore, I treat the data as an unstructured data so that I could separate the series base on their company AND the year..
Is my explanation clear enough? Sorry if it makes you confuse, glenn. Really appreciate your feedback..

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
That helps.
Do you want to estimate this for each firm, assuming the same relationship across firms? Or different relationships for each firm?
Do you want to estimate this for each firm, assuming the same relationship across firms? Or different relationships for each firm?
Re: Dimson Beta Calculation
Yes,exactly. I want to estimate the beta for each company (20062009)

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
To confirm: a separate relationship (different coefficients) for each company?
Re: Dimson Beta Calculation
"ex. Ri(t) = c + b1*Rm(t1) + b2*Rm(t) + b3*Rm(t+1)"
i: Company
t: period (year)
so I'll have different coefficients (b1,b2,b3) for EACH company and EACH year. Is it also what you mean?
i: Company
t: period (year)
so I'll have different coefficients (b1,b2,b3) for EACH company and EACH year. Is it also what you mean?

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
I'm still confused, you write
and
but then say that your data are daily. Are the lags in your equation really over years? How does the daily nature of the data come into play? How can you have different coefficients for each firm and year if the lags are over year?
Let's make this easier. Suppose you have R as the economic variable of interest. There are two firms A and B, and daily data for 2010 and 2001. What series do you have?
R_A_2010
R_A_2011
R_B_2010
R_B_2011
or something different? How many observations are in the workfile?
"ex. Ri(t) = c + b1*Rm(t1) + b2*Rm(t) + b3*Rm(t+1)"
i: Company
t: period (year)
so I'll have different coefficients (b1,b2,b3) for EACH company and EACH year.
and
ex. Ri(2006) = c + b1*Rm(2005) + b2*Rm(2006) + b3*Rm(2007)
but then say that your data are daily. Are the lags in your equation really over years? How does the daily nature of the data come into play? How can you have different coefficients for each firm and year if the lags are over year?
Let's make this easier. Suppose you have R as the economic variable of interest. There are two firms A and B, and daily data for 2010 and 2001. What series do you have?
R_A_2010
R_A_2011
R_B_2010
R_B_2011
or something different? How many observations are in the workfile?

 Posts: 5
 Joined: Sat Mar 21, 2009 11:50 am
Re: Dimson Beta Calculation
were you able to calculate Dimson beta for more one company
Last edited by jasimalajmi on Sun Aug 26, 2012 11:37 am, edited 1 time in total.

 Posts: 5
 Joined: Sat Mar 21, 2009 11:50 am
Re: Dimson Beta Calculation
I have 150 columns of rate of return of 150 companies and one column of market rate of return
I would like to know if it possible to run regression for each company (that is running 150 regressions) using the same independents variables but different dependents (company's rate of return.
If yes, how?
Thanks
I would like to know if it possible to run regression for each company (that is running 150 regressions) using the same independents variables but different dependents (company's rate of return.
If yes, how?
Thanks

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
There are a number of examples in the programming section of this kind of loop. Basically, you'll loop over the dependent variables and estimate specifications with the same independent variables. See the programming reference under loops or perhaps even better, look at Gareth's introduction to programming posts in the forum...
viewtopic.php?f=5&t=1638
viewtopic.php?f=5&t=1638

 Posts: 5
 Joined: Sat Mar 21, 2009 11:50 am
Re: Dimson Beta Calculation
Thanks a lot.
It looks that the examples cover different situations. I want regress each y against one or more x.
It would be highly appreciated if you can direct to a sample suitable for my case.
It looks that the examples cover different situations. I want regress each y against one or more x.
It would be highly appreciated if you can direct to a sample suitable for my case.

 EViews Developer
 Posts: 2646
 Joined: Wed Oct 15, 2008 9:17 am
Re: Dimson Beta Calculation
Not exactly what you want, but it should be enough...
viewtopic.php?f=5&t=5333&hilit=loop+regressions
viewtopic.php?f=5&t=5333&hilit=loop+regressions
Who is online
Users browsing this forum: No registered users and 22 guests