+ Reply to Thread
Results 1 to 10 of 10

Thread: Independent variables Fama MacBeth regression drop for no reason

  1. #1
    Points: 64, Level: 1
    Level completed: 28%, Points required for next Level: 36

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Independent variables Fama MacBeth regression drop for no reason




    Hi all,

    I'm performing a Fama MacBeth analysis with the xtfmb function. The regression looks like this: excessreturn = Rm-Rf SMB HML Mom and eight dummy variables.

    For some reason the xtfmb function drops the first four factors (Rm-Rf, SMB, HML and Mom). The dummy variables are still included and the results look normal.

    Anyone has an idea what could be the problem? The four variables are all "float" whereas the dummies are "byte".

    This has cost me a lot of time so any help is highly appreciated!

  2. #2
    Points: 64, Level: 1
    Level completed: 28%, Points required for next Level: 36

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    When I used "tsset tickersymbol fiscalyear,y" the situation was as described above.

    I just found out that when I use "tsset fiscalyear tickersymbol" the function does not drop the variables. Does this make sense to anyone? The output is not as desired right now so I would like to run the test as it should (tsset tickersymbol fiscalyear).

    Thanks in advance!

  3. #3
    Points: 4, Level: 1
    Level completed: 7%, Points required for next Level: 46

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    I have similiar results. The command just works with tsset timeseries firm_id, but with tsset firm_id timeseries (as desired) it doesnt work. Did you find a solution yeT?
    Thank in advance..

  4. #4
    RoboStataRaptor
    Points: 10,313, Level: 67
    Level completed: 66%, Points required for next Level: 137
    bukharin's Avatar
    Location
    Sydney, Australia
    Posts
    1,293
    Thanks
    11
    Thanked 319 Times in 310 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    Suggest:
    1. Post your commands and output, verbatim, so that we can have a proper look for clues as to what is happening
    2. Post the result of -xtsum- after your -tsset- command

    Given that -xtfmb- is a user-written package, if we can't get it to work as desired then it would also be worth contacting the author for help.

  5. #5
    Points: 64, Level: 1
    Level completed: 28%, Points required for next Level: 36

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    The command I've used is:

    tsset tickersymbol2 year

    xtfmb excessreturn rmrf smb hml mom topa topb topc topd bota botb botc botd,
    verbose
    est store fmb

    xtfmb excessreturn rmrf smb hml mom topa topb topc topd bota botb botc botd,
    lag(2)
    est store FMB_newey

    reg excessreturn rmrf smb hml mom topa topb topc topd bota botb botc botd
    est store OLS

    est table *, b se t
    estout *, cells(b(star) possig negsig) stats(r2 N)


    This is the output for xtsum with all variables, if that is what you mean. Hope this helps, otherwise I'd be happy to send you my data.

    . xtsum tickersymbol2 year excessreturn rmrf smb hml mom topa topb topc topd bota botb botc botd
    Variable | Mean Std. Dev. Min Max | Observations
    -----------------+--------------------------------------------+----------------
    ticker~2 overall | 357.9455 205.9949 1 709 | N = 4510
    between | 204.815 1 709 | n = 709
    within | 0 357.9455 357.9455 | T-bar = 6.36107
    | |
    year overall | 2006.416 2.712656 2001 2011 | N = 4510
    between | 1.82086 2002.5 2009.5 | n = 709
    within | 2.173731 2001.416 2011.416 | T-bar = 6.36107
    | |
    excess~n overall | -.058488 .5697788 -3.50329 3.065695 | N = 4510
    between | .1914536 -1.142335 .7137356 | n = 709
    within | .5412637 -3.128807 3.104281 | T-bar = 6.36107
    | |
    rmrf overall | 3.486967 21.48309 -38.39 30.74 | N = 4510
    between | 2.433829 -5.9425 13.805 | n = 709
    within | 21.36101 -42.95178 36.73072 | T-bar = 6.36107
    | |
    smb overall | 6.940842 11.06455 -7.01 28.41 | N = 4510
    between | 3.116954 -2.1275 16.79 | n = 709
    within | 10.70478 -8.966158 30.70584 | T-bar = 6.36107
    | |
    hml overall | 4.729435 14.59005 -21.55 27.24 | N = 4510
    between | 4.291604 -3.7525 14.825 | n = 709
    within | 14.09024 -24.44485 30.51143 | T-bar = 6.36107
    | |
    mom overall | -4.658962 32.6745 -83.29 25.59 | N = 4510
    between | 5.105839 -14.0575 10.645 | n = 709
    within | 32.34542 -85.96442 30.81604 | T-bar = 6.36107
    | |
    topa overall | .2031042 .4023541 0 1 | N = 4510
    between | .2796421 0 1 | n = 709
    within | .2950633 -.6857847 1.112195 | T-bar = 6.36107
    | |
    topb overall | .2019956 .4015334 0 1 | N = 4510
    between | .3013692 0 1 | n = 709
    within | .2714717 -.6980044 1.111086 | T-bar = 6.36107
    | |
    topc overall | .2026608 .4020264 0 1 | N = 4510
    between | .2436636 0 1 | n = 709
    within | .3277509 -.6723392 1.111752 | T-bar = 6.36107
    | |
    topd overall | .2004435 .4003766 0 1 | N = 4510
    between | .2870976 0 1 | n = 709
    within | .2916293 -.6995565 1.109534 | T-bar = 6.36107
    | |
    bota overall | .1973392 .3980347 0 1 | N = 4510
    between | .2611859 0 1 | n = 709
    within | .3063772 -.7026608 1.10643 | T-bar = 6.36107
    | |
    botb overall | .1984479 .3988754 0 1 | N = 4510
    between | .2990017 0 1 | n = 709
    within | .270834 -.7015521 1.107539 | T-bar = 6.36107
    | |
    botc overall | .2002217 .4002106 0 1 | N = 4510
    between | .264158 0 1 | n = 709
    within | .3040437 -.6997783 1.109313 | T-bar = 6.36107
    | |
    botd overall | .1997783 .3998779 0 1 | N = 4510
    between | .2918464 0 1 | n = 709
    within | .2779055 -.7002217 1.108869 | T-bar = 6.36107

  6. #6
    Points: 64, Level: 1
    Level completed: 28%, Points required for next Level: 36

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    It might have something to do with the timevariable. I've generated a new variable that starts at one for each firm and increases with every observation of that specific firm. When I use this as time variable instead of years, the variables dont drop. This causes a bias though, and I'd like to run the regression as it should be.

  7. #7
    RoboStataRaptor
    Points: 10,313, Level: 67
    Level completed: 66%, Points required for next Level: 137
    bukharin's Avatar
    Location
    Sydney, Australia
    Posts
    1,293
    Thanks
    11
    Thanked 319 Times in 310 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    It looks like your minimum year is 2002.5 and maximum is 2009.5 - is this right? If so, that might be the problem - if the time unit is years then they all need to be integers (if you want to use monthly data you should store the dates in monthly format).

  8. #8
    Points: 64, Level: 1
    Level completed: 28%, Points required for next Level: 36

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    The minimum is 2001 and the maximum is 2011, and the fiscalyear variable is integer. Some variables are %9.0g and some are %8.0g, does that make a difference?

  9. #9
    RoboStataRaptor
    Points: 10,313, Level: 67
    Level completed: 66%, Points required for next Level: 137
    bukharin's Avatar
    Location
    Sydney, Australia
    Posts
    1,293
    Thanks
    11
    Thanked 319 Times in 310 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason

    Ah yes sorry, I got mixed up with the next line. The %9.0g and %8.0g should not make a difference - this simply controls the way the values are displayed (see -help format-).

    I'm really not sure what the problem is. Since it works when you rescale the time variable it seems that there must be some kind of problem with structure of the data, but I'm finding it a bit hard without looking at it. Feel free to send me your data (send me a private message for email address), otherwise suggest check with the author of -xtfmb-

  10. #10
    RoboStataRaptor
    Points: 10,313, Level: 67
    Level completed: 66%, Points required for next Level: 137
    bukharin's Avatar
    Location
    Sydney, Australia
    Posts
    1,293
    Thanks
    11
    Thanked 319 Times in 310 Posts

    Re: Independent variables Fama MacBeth regression drop for no reason


    Okay - thanks for sending me the data because now the problem is clear.

    The Fama MacBeth model (at least as implemented in -xtfmb-) works by running a cross-sectional regression for each year, and then averaging the coefficients from the first step. The four variables that are being omitted do not vary within each year, eg in 2001 rmrf never changes. Therefore the first stage of the model (the cross-sectional regression) omits them simply because it's impossible to include them in the cross-sectional regression since they don't vary.

    So my take is that omitting those variables is correct, and if you don't want to omit them then you need to use a different model (ie not Fama MacBeth).

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats