Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • event study with multiple events per ID

    Dear Statalist member,

    I run into an problem of tackling the following problem: I want to perform an event study in stata but my ID's have multiple event dates, so not only one event. How can I take care of this?

    My goal is to create Cumulative Abnormal Returns, starting at t=-6(months) till t=24(months). The CAR has to be formed from every event (if possible) at every ID level.

    My data is as following:
    where event is equal to 0 --> the event is occurring
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input long date_stock float(ID ret event)
    15736 1            . .
    15764 1    -.1990291 .
    15795 1  -.003787893 .
    15825 1      .218251 .
    15855 1    .13171028 .
    15886 1    .07832323 0
    15917 1    .11150897 .
    15946 1    .11919007 .
    15978 1   -.09087168 .
    16009 1    .12709178 .
    16037 1    .13483149 0
    16070 1    .03394622 .
    16100 1    .26060194 .
    16128 1  -.072436295 .
    16161 1   -.07487568 .
    16191 1   -.14606383 .
    16219 1   -.04850053 .
    16252 1     .1392996 0
    16282 1   -.18681698 .
    16314 1    -.1390172 .
    16344 1    .05219511 .
    16373 1     .1617988 .
    16405 1   -.08659218 .
    16436 1    .05286156 .
    19023 2            . .
    19052 2  .0005063407 .
    19082 2    .00708499 .
    19113 2  .0080401935 0
    19144 2  -.009471612 .
    19173 2    .00654258 .
    19205 2   .005500031 .
    19236 2 -.0004972764 .
    19264 2   .008457715 .
    19297 2            0 .
    19996 2     .8253576 0
    20027 2    .17729734 0
    20055 2     .3250689 .
    20088 2    .07137905 .
    20118 2   -.17464423 .
    20146 2     .4102665 .
    20178 2   -.15031958 .
    20208 2    .13342053 0
    20237 2    .12117717 .
    20269 2      .120947 0
    20300 2   -.12741053 0
    20331 2    -.3788476 .
    20361 2   -.05760273 0
    20391 2    .04269666 .
    20422 2    .05775863 .
    20453 2   -.22330894 .
    20482 2  -.062959015 0
    20513 2    .14221719 .
    20544 2    -.0299019 0
    20573 2    .04042442 .
    20605 2    .04468189 .
    20635 2    .06090188 .
    20664 2  -.006573165 0
    20697 2   -.13718574 .
    20727 2    -.1109407 .
    20758 2   -.05750431 .
    20788 2    -.4881025 .
    20818 2     -.137068 0
    20088 3            . .
    20118 3   -.17464423 .
    20146 3     .4102665 0
    20178 3   -.15031958 .
    20208 3    .13342053 0
    20237 3    .12117717 .
    20269 3      .120947 0
    20300 3   -.12741053 .
    20331 3    -.3788476 .
    20361 3   -.05760273 .
    20391 3    .04269666 .
    20422 3    .05775863 .
    20453 3   -.22330894 .
    20482 3  -.062959015 0
    20513 3    .14221719 .
    20544 3    -.0299019 .
    20573 3    .04042442 .
    20605 3    .04468189 .
    20635 3    .06090188 .
    20664 3  -.006573165 .
    20697 3   -.13718574 .
    20727 3    -.1109407 .
    20758 3   -.05750431 .
    20788 3    -.4881025 .
    20818 3     -.137068 0
    19754 4            . .
    19782 4    -.2311508 .
    19813 4     .3866452 .
    19843 4   -.08970364 0
    19873 4    .00501914 .
    19904 4    -.2645551 .
    19935 4    -.1521865 .
    19964 4     .2143649 .
    19996 4   -.09325253 .
    20027 4   -.20001186 .
    20055 4   -.08333334 .
    20088 4   -.37349495 .
    20118 4    -.4840707 .
    20146 4    .10656252 .
    20178 4    .04563684 0
    20208 4    .20996054 .
    20237 4   -.23933037 .
    20269 4   -.15317804 .
    20300 4   -.08122522 .
    20331 4    -.7096628 .
    20361 4    -.3777605 .
    20391 4    .02713986 .
    20422 4    -.3105692 .
    20453 4     .0117925 .
    20482 4   -.09965035 .
    20513 4    .10032364 .
    20544 4    -.3058823 .
    20573 4     .4194915 0
    20605 4    .13910447 .
    20635 4   -.23637317 .
    20664 4   -.11736445 .
    20697 4    .09875587 .
    20727 4      .309271 0
    20758 4      .845946 .
    20788 4    -.1551977 .
    20818 4     .8544194 0
    19600 5            . .
    19631 5  .0040160604 .
    19662 5    .26800004 0
    19691 5    .04022076 0
    19723 5    .13798337 0
    19754 5   -.09193871 .
    19782 5     .7358767 .
    19813 5    .04268809 .
    19843 5    -.0879611 .
    19873 5   -.04844445 .
    19904 5    .08360583 .
    19935 5   -.22413796 .
    19964 5          .18 .
    19996 5    -.2419962 0
    20027 5    .00248441 .
    20055 5    -.3277571 .
    20088 5    .03410137 0
    20118 5    -.2032086 .
    20146 5     .3959732 0
    20178 5    .11217954 .
    20208 5   .028818415 .
    20237 5    .25070035 0
    20269 5   -.02799552 .
    20300 5    .12039171 .
    20331 5    .05964009 0
    20361 5   -.08879184 .
    20391 5    .09797657 .
    20422 5    -.0906887 0
    20453 5       -.0848 0
    20482 5   -.04603724 .
    20513 5    .09896144 .
    20544 5    -.1712062 .
    20573 5    -.2488263 .
    20605 5   -.05803568 0
    20635 5    .05687198 0
    20664 5    .06188346 .
    20697 5     .4231419 .
    20727 5     .3181008 .
    20758 5   -.13417378 0
    20788 5    .28809157 .
    20818 5   -.05369398 .
    19600 6            . .
    19631 6  .0040160604 .
    19662 6    .26800004 0
    19691 6    .04022076 .
    19723 6    .13798337 0
    19754 6   -.09193871 0
    19782 6     .7358767 0
    19813 6    .04268809 0
    19843 6    -.0879611 .
    19873 6   -.04844445 .
    19904 6    .08360583 0
    19935 6   -.22413796 .
    19964 6          .18 0
    19996 6    -.2419962 .
    20027 6    .00248441 .
    20055 6    -.3277571 .
    20088 6    .03410137 .
    20118 6    -.2032086 .
    20146 6     .3959732 .
    20178 6    .11217954 0
    20208 6   .028818415 .
    20237 6    .25070035 0
    20269 6   -.02799552 .
    20300 6    .12039171 .
    20331 6    .05964009 .
    20361 6   -.08879184 .
    20391 6    .09797657 .
    20422 6    -.0906887 .
    20453 6       -.0848 0
    20482 6   -.04603724 .
    20513 6    .09896144 .
    20544 6    -.1712062 .
    20573 6    -.2488263 .
    20605 6   -.05803568 .
    20635 6    .05687198 0
    20664 6    .06188346 .
    20697 6     .4231419 0
    20727 6     .3181008 .
    20758 6   -.13417378 .
    20788 6    .28809157 .
    20818 6   -.05369398 .
    19600 7            . .
    19631 7  .0040160604 .
    19662 7    .26800004 .
    19691 7    .04022076 .
    19723 7    .13798337 .
    19754 7   -.09193871 0
    19782 7     .7358767 .
    19813 7    .04268809 .
    19843 7    -.0879611 .
    19873 7   -.04844445 .
    19904 7    .08360583 0
    19935 7   -.22413796 .
    19964 7          .18 .
    19996 7    -.2419962 .
    20027 7    .00248441 .
    20055 7    -.3277571 .
    20088 7    .03410137 0
    20118 7    -.2032086 .
    20146 7     .3959732 .
    20178 7    .11217954 0
    20208 7   .028818415 .
    20237 7    .25070035 .
    20269 7   -.02799552 .
    20300 7    .12039171 .
    20331 7    .05964009 .
    20361 7   -.08879184 .
    20391 7    .09797657 0
    20422 7    -.0906887 .
    20453 7       -.0848 .
    20482 7   -.04603724 .
    20513 7    .09896144 .
    20544 7    -.1712062 0
    20573 7    -.2488263 .
    20605 7   -.05803568 .
    20635 7    .05687198 .
    20664 7    .06188346 .
    20697 7     .4231419 .
    20727 7     .3181008 .
    20758 7   -.13417378 .
    20788 7    .28809157 .
    20818 7   -.05369398 .
    19600 8            . .
    19631 8  .0040160604 .
    19662 8    .26800004 .
    19691 8    .04022076 .
    end
    format %d date_stock
    The following code I tried is at basic event study level, but does not counter the multiple events problem:
    Code:
    sort ID date_stock
    // variable t will calibrate the events at t=0 and the months before till t=-6 and t=+24 which will be needed for the CAR later on.
    by ID: gen t=0 if event==0
    //Filling in t for before and after t=0
    by ID date_stock: replace t= t[_n-1]+1 if t==.
    gsort ID -date
    by ID: replace t= t[_n-1]-1 if t==.
    sort ID date
    
    //Deleting the dates I do not need (t<-6 and t>24) or ID's which do not have enough of data (e.g. t goes only down till t=-3 where we need at least t=-6) 
    gen neg=.
    bys ID: replace neg=_N if t<0
    gen negg=.
    bys ID neg: replace negg=_N if t<0
    drop neg
    ren negg neg
    bys ID: replace neg=neg[_n-1] if neg==.
    drop if neg<6
    drop if t<-6
    drop if t>24
    
    //Generating the NR & AR
    bysort ID (t): egen NR_MARM = mean(cond(t<0 & t>-6,ret,.))
    gen AR_MARM = ret- NR_MARM
    As you can imagine, this code does not work for multiple events.
    Can somebody help me out here? Thansk in advance!

    Best,
    Arslan


  • #2
    What i have found in the forums is the following:
    Creating a new variable for each event. But then one company may have overlapping windows. and then I am puzzled for collapsing all the variables for AR's I have created.
    the following code I have used:
    Code:
    by ID: egen count=count(event)
    by ID: gen fakedate = _n
    forval i=1/61 {
    by ID: generate datezero_`i'=fakedate if event==`i'
    by ID: egen datezero`i'=min(datezero_`i')
    by ID: gen tau`i'=fakedate-datezero`i'
    by ID: generate event_window`i'=1 if tau`i'>=0 & tau`i'<=24
    by ID: generate estimation_window`i'=1 if tau`i'>=-12 & tau`i'<0
    }
    //
    
    gen NR_MARM=.
    forval i=1/61 {
    by ID: egen NR_MARM`i' = mean(cond(tau`i'<0 & tau`i'>-11,ret,.))
    }
    //
    
    egen NR_MARM=rowmean(NR_MARM1 NR_MARM2 NR_MARM3 NR_MARM4 NR_MARM5 NR_MARM6 NR_MARM7 NR_MARM8 NR_MARM9 NR_MARM10 NR_MARM11 NR_MARM12 NR_MARM13 NR_MARM14 NR_MARM15 NR_MARM16 NR_MARM17 NR_MARM18 NR_MARM19 NR_MARM20 NR_MARM21 NR_MARM22 NR_MARM23 NR_MARM24 NR_MARM25 NR_MARM26 NR_MARM27 NR_MARM28 NR_MARM29 NR_MARM30 NR_MARM31 NR_MARM32 NR_MARM33 NR_MARM34 NR_MARM35 NR_MARM36 NR_MARM37 NR_MARM38 NR_MARM39 NR_MARM40 NR_MARM41 NR_MARM42 NR_MARM43 NR_MARM44 NR_MARM45 NR_MARM46 NR_MARM47 NR_MARM48 NR_MARM49 NR_MARM50 NR_MARM51 NR_MARM52 NR_MARM53 NR_MARM54 NR_MARM55 NR_MARM56 NR_MARM57 NR_MARM58 NR_MARM59 NR_MARM60 NR_MARM61)
    perhaps someone can help me from here on?

    Comment


    • #3
      So I have created for every number of event per company a new variable with event =0 at every tau (which counts the months before &after event). With every variable I have calculated a new Normal Return.
      Now I have to get the Abnormal Returns, ofcourse I need 1 variable, which encounters all of these NRs.
      When I use rowmean for creating one variable. That variable is meaningless related to tau.
      Code:
      * Example generated by -dataex-. To install: ssc install dataex
      clear
      input float(date ID tau1 NR_MARM1 tau2 NR_MARM2 tau3 NR_MARM3 tau4 NR_MARM4)
        1 1 -5  .036786072 -10   .05470963 -17  .02429135   .           .
        2 1 -4  .036786072  -9   .05470963 -16  .02429135   .           .
        3 1 -3  .036786072  -8   .05470963 -15  .02429135   .           .
        4 1 -2  .036786072  -7   .05470963 -14  .02429135   .           .
        5 1 -1  .036786072  -6   .05470963 -13  .02429135   .           .
        6 1  0  .036786072  -5   .05470963 -12  .02429135   .           .
        7 1  1  .036786072  -4   .05470963 -11  .02429135   .           .
        8 1  2  .036786072  -3   .05470963 -10  .02429135   .           .
        9 1  3  .036786072  -2   .05470963  -9  .02429135   .           .
       10 1  4  .036786072  -1   .05470963  -8  .02429135   .           .
       11 1  5  .036786072   0   .05470963  -7  .02429135   .           .
       12 1  6  .036786072   1   .05470963  -6  .02429135   .           .
       13 1  7  .036786072   2   .05470963  -5  .02429135   .           .
       14 1  8  .036786072   3   .05470963  -4  .02429135   .           .
       15 1  9  .036786072   4   .05470963  -3  .02429135   .           .
       16 1 10  .036786072   5   .05470963  -2  .02429135   .           .
       17 1 11  .036786072   6   .05470963  -1  .02429135   .           .
       18 1 12  .036786072   7   .05470963   0  .02429135   .           .
       19 1 13  .036786072   8   .05470963   1  .02429135   .           .
       20 1 14  .036786072   9   .05470963   2  .02429135   .           .
       21 1 15  .036786072  10   .05470963   3  .02429135   .           .
       22 1 16  .036786072  11   .05470963   4  .02429135   .           .
       23 1 17  .036786072  12   .05470963   5  .02429135   .           .
       24 1 18  .036786072  13   .05470963   6  .02429135   .           .
      109 2 -3  .003795665 -10 .0029069956 -11  .08515206 -17    .1492366
      110 2 -2  .003795665  -9 .0029069956 -10  .08515206 -16    .1492366
      111 2 -1  .003795665  -8 .0029069956  -9  .08515206 -15    .1492366
      112 2  0  .003795665  -7 .0029069956  -8  .08515206 -14    .1492366
      113 2  1  .003795665  -6 .0029069956  -7  .08515206 -13    .1492366
      114 2  2  .003795665  -5 .0029069956  -6  .08515206 -12    .1492366
      115 2  3  .003795665  -4 .0029069956  -5  .08515206 -11    .1492366
      116 2  4  .003795665  -3 .0029069956  -4  .08515206 -10    .1492366
      117 2  5  .003795665  -2 .0029069956  -3  .08515206  -9    .1492366
      118 2  6  .003795665  -1 .0029069956  -2  .08515206  -8    .1492366
      141 2  7  .003795665   0 .0029069956  -1  .08515206  -7    .1492366
      142 2  8  .003795665   1 .0029069956   0  .08515206  -6    .1492366
      143 2  9  .003795665   2 .0029069956   1  .08515206  -5    .1492366
      144 2 10  .003795665   3 .0029069956   2  .08515206  -4    .1492366
      145 2 11  .003795665   4 .0029069956   3  .08515206  -3    .1492366
      146 2 12  .003795665   5 .0029069956   4  .08515206  -2    .1492366
      147 2 13  .003795665   6 .0029069956   5  .08515206  -1    .1492366
      148 2 14  .003795665   7 .0029069956   6  .08515206   0    .1492366
      149 2 15  .003795665   8 .0029069956   7  .08515206   1    .1492366
      150 2 16  .003795665   9 .0029069956   8  .08515206   2    .1492366
      151 2 17  .003795665  10 .0029069956   9  .08515206   3    .1492366
      152 2 18  .003795665  11 .0029069956  10  .08515206   4    .1492366
      153 2 19  .003795665  12 .0029069956  11  .08515206   5    .1492366
      154 2 20  .003795665  13 .0029069956  12  .08515206   6    .1492366
      155 2 21  .003795665  14 .0029069956  13  .08515206   7    .1492366
      156 2 22  .003795665  15 .0029069956  14  .08515206   8    .1492366
      157 2 23  .003795665  16 .0029069956  15  .08515206   9    .1492366
      158 2 24  .003795665  17 .0029069956  16  .08515206  10    .1492366
      159 2 25  .003795665  18 .0029069956  17  .08515206  11    .1492366
      160 2 26  .003795665  19 .0029069956  18  .08515206  12    .1492366
      161 2 27  .003795665  20 .0029069956  19  .08515206  13    .1492366
      162 2 28  .003795665  21 .0029069956  20  .08515206  14    .1492366
      163 2 29  .003795665  22 .0029069956  21  .08515206  15    .1492366
      164 2 30  .003795665  23 .0029069956  22  .08515206  16    .1492366
      165 2 31  .003795665  24 .0029069956  23  .08515206  17    .1492366
      166 2 32  .003795665  25 .0029069956  24  .08515206  18    .1492366
      167 2 33  .003795665  26 .0029069956  25  .08515206  19    .1492366
      168 2 34  .003795665  27 .0029069956  26  .08515206  20    .1492366
      144 3 -2  -.17464423  -4  .028434226  -6  .06798007 -13  -.04614894
      145 3 -1  -.17464423  -3  .028434226  -5  .06798007 -12  -.04614894
      146 3  0  -.17464423  -2  .028434226  -4  .06798007 -11  -.04614894
      147 3  1  -.17464423  -1  .028434226  -3  .06798007 -10  -.04614894
      148 3  2  -.17464423   0  .028434226  -2  .06798007  -9  -.04614894
      149 3  3  -.17464423   1  .028434226  -1  .06798007  -8  -.04614894
      150 3  4  -.17464423   2  .028434226   0  .06798007  -7  -.04614894
      151 3  5  -.17464423   3  .028434226   1  .06798007  -6  -.04614894
      152 3  6  -.17464423   4  .028434226   2  .06798007  -5  -.04614894
      153 3  7  -.17464423   5  .028434226   3  .06798007  -4  -.04614894
      154 3  8  -.17464423   6  .028434226   4  .06798007  -3  -.04614894
      155 3  9  -.17464423   7  .028434226   5  .06798007  -2  -.04614894
      156 3 10  -.17464423   8  .028434226   6  .06798007  -1  -.04614894
      157 3 11  -.17464423   9  .028434226   7  .06798007   0  -.04614894
      158 3 12  -.17464423  10  .028434226   8  .06798007   1  -.04614894
      159 3 13  -.17464423  11  .028434226   9  .06798007   2  -.04614894
      160 3 14  -.17464423  12  .028434226  10  .06798007   3  -.04614894
      161 3 15  -.17464423  13  .028434226  11  .06798007   4  -.04614894
      162 3 16  -.17464423  14  .028434226  12  .06798007   5  -.04614894
      163 3 17  -.17464423  15  .028434226  13  .06798007   6  -.04614894
      164 3 18  -.17464423  16  .028434226  14  .06798007   7  -.04614894
      165 3 19  -.17464423  17  .028434226  15  .06798007   8  -.04614894
      166 3 20  -.17464423  18  .028434226  16  .06798007   9  -.04614894
      167 3 21  -.17464423  19  .028434226  17  .06798007  10  -.04614894
      168 3 22  -.17464423  20  .028434226  18  .06798007  11  -.04614894
      133 4 -3    .0777472 -14  -.13249584 -27 -.18986724 -32  -.03003715
      134 4 -2    .0777472 -13  -.13249584 -26 -.18986724 -31  -.03003715
      135 4 -1    .0777472 -12  -.13249584 -25 -.18986724 -30  -.03003715
      136 4  0    .0777472 -11  -.13249584 -24 -.18986724 -29  -.03003715
      137 4  1    .0777472 -10  -.13249584 -23 -.18986724 -28  -.03003715
      138 4  2    .0777472  -9  -.13249584 -22 -.18986724 -27  -.03003715
      139 4  3    .0777472  -8  -.13249584 -21 -.18986724 -26  -.03003715
      140 4  4    .0777472  -7  -.13249584 -20 -.18986724 -25  -.03003715
      141 4  5    .0777472  -6  -.13249584 -19 -.18986724 -24  -.03003715
      142 4  6    .0777472  -5  -.13249584 -18 -.18986724 -23  -.03003715
      143 4  7    .0777472  -4  -.13249584 -17 -.18986724 -22  -.03003715
      144 4  8    .0777472  -3  -.13249584 -16 -.18986724 -21  -.03003715
      145 4  9    .0777472  -2  -.13249584 -15 -.18986724 -20  -.03003715
      146 4 10    .0777472  -1  -.13249584 -14 -.18986724 -19  -.03003715
      147 4 11    .0777472   0  -.13249584 -13 -.18986724 -18  -.03003715
      148 4 12    .0777472   1  -.13249584 -12 -.18986724 -17  -.03003715
      149 4 13    .0777472   2  -.13249584 -11 -.18986724 -16  -.03003715
      150 4 14    .0777472   3  -.13249584 -10 -.18986724 -15  -.03003715
      151 4 15    .0777472   4  -.13249584  -9 -.18986724 -14  -.03003715
      152 4 16    .0777472   5  -.13249584  -8 -.18986724 -13  -.03003715
      153 4 17    .0777472   6  -.13249584  -7 -.18986724 -12  -.03003715
      154 4 18    .0777472   7  -.13249584  -6 -.18986724 -11  -.03003715
      155 4 19    .0777472   8  -.13249584  -5 -.18986724 -10  -.03003715
      156 4 20    .0777472   9  -.13249584  -4 -.18986724  -9  -.03003715
      157 4 21    .0777472  10  -.13249584  -3 -.18986724  -8  -.03003715
      158 4 22    .0777472  11  -.13249584  -2 -.18986724  -7  -.03003715
      159 4 23    .0777472  12  -.13249584  -1 -.18986724  -6  -.03003715
      160 4 24    .0777472  13  -.13249584   0 -.18986724  -5  -.03003715
      161 4 25    .0777472  14  -.13249584   1 -.18986724  -4  -.03003715
      162 4 26    .0777472  15  -.13249584   2 -.18986724  -3  -.03003715
      163 4 27    .0777472  16  -.13249584   3 -.18986724  -2  -.03003715
      164 4 28    .0777472  17  -.13249584   4 -.18986724  -1  -.03003715
      165 4 29    .0777472  18  -.13249584   5 -.18986724   0  -.03003715
      166 4 30    .0777472  19  -.13249584   6 -.18986724   1  -.03003715
      167 4 31    .0777472  20  -.13249584   7 -.18986724   2  -.03003715
      168 4 32    .0777472  21  -.13249584   8 -.18986724   3  -.03003715
      128 5 -2 .0040160604  -3   .13600805  -4  .10407896 -13   .07678926
      129 5 -1 .0040160604  -2   .13600805  -3  .10407896 -12   .07678926
      130 5  0 .0040160604  -1   .13600805  -2  .10407896 -11   .07678926
      131 5  1 .0040160604   0   .13600805  -1  .10407896 -10   .07678926
      132 5  2 .0040160604   1   .13600805   0  .10407896  -9   .07678926
      133 5  3 .0040160604   2   .13600805   1  .10407896  -8   .07678926
      134 5  4 .0040160604   3   .13600805   2  .10407896  -7   .07678926
      135 5  5 .0040160604   4   .13600805   3  .10407896  -6   .07678926
      136 5  6 .0040160604   5   .13600805   4  .10407896  -5   .07678926
      137 5  7 .0040160604   6   .13600805   5  .10407896  -4   .07678926
      138 5  8 .0040160604   7   .13600805   6  .10407896  -3   .07678926
      139 5  9 .0040160604   8   .13600805   7  .10407896  -2   .07678926
      140 5 10 .0040160604   9   .13600805   8  .10407896  -1   .07678926
      141 5 11 .0040160604  10   .13600805   9  .10407896   0   .07678926
      142 5 12 .0040160604  11   .13600805  10  .10407896   1   .07678926
      143 5 13 .0040160604  12   .13600805  11  .10407896   2   .07678926
      144 5 14 .0040160604  13   .13600805  12  .10407896   3   .07678926
      145 5 15 .0040160604  14   .13600805  13  .10407896   4   .07678926
      146 5 16 .0040160604  15   .13600805  14  .10407896   5   .07678926
      147 5 17 .0040160604  16   .13600805  15  .10407896   6   .07678926
      148 5 18 .0040160604  17   .13600805  16  .10407896   7   .07678926
      149 5 19 .0040160604  18   .13600805  17  .10407896   8   .07678926
      150 5 20 .0040160604  19   .13600805  18  .10407896   9   .07678926
      151 5 21 .0040160604  20   .13600805  19  .10407896  10   .07678926
      152 5 22 .0040160604  21   .13600805  20  .10407896  11   .07678926
      153 5 23 .0040160604  22   .13600805  21  .10407896  12   .07678926
      154 5 24 .0040160604  23   .13600805  22  .10407896  13   .07678926
      155 5 25 .0040160604  24   .13600805  23  .10407896  14   .07678926
      156 5 26 .0040160604  25   .13600805  24  .10407896  15   .07678926
      157 5 27 .0040160604  26   .13600805  25  .10407896  16   .07678926
      158 5 28 .0040160604  27   .13600805  26  .10407896  17   .07678926
      159 5 29 .0040160604  28   .13600805  27  .10407896  18   .07678926
      160 5 30 .0040160604  29   .13600805  28  .10407896  19   .07678926
      161 5 31 .0040160604  30   .13600805  29  .10407896  20   .07678926
      162 5 32 .0040160604  31   .13600805  30  .10407896  21   .07678926
      163 5 33 .0040160604  32   .13600805  31  .10407896  22   .07678926
      164 5 34 .0040160604  33   .13600805  32  .10407896  23   .07678926
      165 5 35 .0040160604  34   .13600805  33  .10407896  24   .07678926
      166 5 36 .0040160604  35   .13600805  34  .10407896  25   .07678926
      167 5 37 .0040160604  36   .13600805  35  .10407896  26   .07678926
      168 5 38 .0040160604  37   .13600805  36  .10407896  27   .07678926
      128 6 -2 .0040160604  -4   .10407896  -5  .11255506  -6    .0716563
      129 6 -1 .0040160604  -3   .10407896  -4  .11255506  -5    .0716563
      130 6  0 .0040160604  -2   .10407896  -3  .11255506  -4    .0716563
      131 6  1 .0040160604  -1   .10407896  -2  .11255506  -3    .0716563
      132 6  2 .0040160604   0   .10407896  -1  .11255506  -2    .0716563
      133 6  3 .0040160604   1   .10407896   0  .11255506  -1    .0716563
      134 6  4 .0040160604   2   .10407896   1  .11255506   0    .0716563
      135 6  5 .0040160604   3   .10407896   2  .11255506   1    .0716563
      136 6  6 .0040160604   4   .10407896   3  .11255506   2    .0716563
      137 6  7 .0040160604   5   .10407896   4  .11255506   3    .0716563
      138 6  8 .0040160604   6   .10407896   5  .11255506   4    .0716563
      139 6  9 .0040160604   7   .10407896   6  .11255506   5    .0716563
      140 6 10 .0040160604   8   .10407896   7  .11255506   6    .0716563
      141 6 11 .0040160604   9   .10407896   8  .11255506   7    .0716563
      142 6 12 .0040160604  10   .10407896   9  .11255506   8    .0716563
      143 6 13 .0040160604  11   .10407896  10  .11255506   9    .0716563
      144 6 14 .0040160604  12   .10407896  11  .11255506  10    .0716563
      145 6 15 .0040160604  13   .10407896  12  .11255506  11    .0716563
      146 6 16 .0040160604  14   .10407896  13  .11255506  12    .0716563
      147 6 17 .0040160604  15   .10407896  14  .11255506  13    .0716563
      148 6 18 .0040160604  16   .10407896  15  .11255506  14    .0716563
      149 6 19 .0040160604  17   .10407896  16  .11255506  15    .0716563
      150 6 20 .0040160604  18   .10407896  17  .11255506  16    .0716563
      151 6 21 .0040160604  19   .10407896  18  .11255506  17    .0716563
      152 6 22 .0040160604  20   .10407896  19  .11255506  18    .0716563
      153 6 23 .0040160604  21   .10407896  20  .11255506  19    .0716563
      154 6 24 .0040160604  22   .10407896  21  .11255506  20    .0716563
      155 6 25 .0040160604  23   .10407896  22  .11255506  21    .0716563
      156 6 26 .0040160604  24   .10407896  23  .11255506  22    .0716563
      157 6 27 .0040160604  25   .10407896  24  .11255506  23    .0716563
      158 6 28 .0040160604  26   .10407896  25  .11255506  24    .0716563
      159 6 29 .0040160604  27   .10407896  26  .11255506  25    .0716563
      160 6 30 .0040160604  28   .10407896  27  .11255506  26    .0716563
      161 6 31 .0040160604  29   .10407896  28  .11255506  27    .0716563
      162 6 32 .0040160604  30   .10407896  29  .11255506  28    .0716563
      163 6 33 .0040160604  31   .10407896  30  .11255506  29    .0716563
      164 6 34 .0040160604  32   .10407896  31  .11255506  30    .0716563
      165 6 35 .0040160604  33   .10407896  32  .11255506  31    .0716563
      166 6 36 .0040160604  34   .10407896  33  .11255506  32    .0716563
      167 6 37 .0040160604  35   .10407896  34  .11255506  33    .0716563
      168 6 38 .0040160604  36   .10407896  35  .11255506  34    .0716563
      128 7 -5   .11255506 -10    .1111601 -16 .011435825 -19 -.034937955
      129 7 -4   .11255506  -9    .1111601 -15 .011435825 -18 -.034937955
      130 7 -3   .11255506  -8    .1111601 -14 .011435825 -17 -.034937955
      131 7 -2   .11255506  -7    .1111601 -13 .011435825 -16 -.034937955
      132 7 -1   .11255506  -6    .1111601 -12 .011435825 -15 -.034937955
      133 7  0   .11255506  -5    .1111601 -11 .011435825 -14 -.034937955
      134 7  1   .11255506  -4    .1111601 -10 .011435825 -13 -.034937955
      135 7  2   .11255506  -3    .1111601  -9 .011435825 -12 -.034937955
      136 7  3   .11255506  -2    .1111601  -8 .011435825 -11 -.034937955
      137 7  4   .11255506  -1    .1111601  -7 .011435825 -10 -.034937955
      138 7  5   .11255506   0    .1111601  -6 .011435825  -9 -.034937955
      139 7  6   .11255506   1    .1111601  -5 .011435825  -8 -.034937955
      140 7  7   .11255506   2    .1111601  -4 .011435825  -7 -.034937955
      141 7  8   .11255506   3    .1111601  -3 .011435825  -6 -.034937955
      142 7  9   .11255506   4    .1111601  -2 .011435825  -5 -.034937955
      143 7 10   .11255506   5    .1111601  -1 .011435825  -4 -.034937955
      144 7 11   .11255506   6    .1111601   0 .011435825  -3 -.034937955
      145 7 12   .11255506   7    .1111601   1 .011435825  -2 -.034937955
      146 7 13   .11255506   8    .1111601   2 .011435825  -1 -.034937955
      147 7 14   .11255506   9    .1111601   3 .011435825   0 -.034937955
      148 7 15   .11255506  10    .1111601   4 .011435825   1 -.034937955
      149 7 16   .11255506  11    .1111601   5 .011435825   2 -.034937955
      150 7 17   .11255506  12    .1111601   6 .011435825   3 -.034937955
      151 7 18   .11255506  13    .1111601   7 .011435825   4 -.034937955
      152 7 19   .11255506  14    .1111601   8 .011435825   5 -.034937955
      153 7 20   .11255506  15    .1111601   9 .011435825   6 -.034937955
      154 7 21   .11255506  16    .1111601  10 .011435825   7 -.034937955
      155 7 22   .11255506  17    .1111601  11 .011435825   8 -.034937955
      156 7 23   .11255506  18    .1111601  12 .011435825   9 -.034937955
      157 7 24   .11255506  19    .1111601  13 .011435825  10 -.034937955
      158 7 25   .11255506  20    .1111601  14 .011435825  11 -.034937955
      159 7 26   .11255506  21    .1111601  15 .011435825  12 -.034937955
      160 7 27   .11255506  22    .1111601  16 .011435825  13 -.034937955
      161 7 28   .11255506  23    .1111601  17 .011435825  14 -.034937955
      162 7 29   .11255506  24    .1111601  18 .011435825  15 -.034937955
      163 7 30   .11255506  25    .1111601  19 .011435825  16 -.034937955
      164 7 31   .11255506  26    .1111601  20 .011435825  17 -.034937955
      165 7 32   .11255506  27    .1111601  21 .011435825  18 -.034937955
      166 7 33   .11255506  28    .1111601  22 .011435825  19 -.034937955
      167 7 34   .11255506  29    .1111601  23 .011435825  20 -.034937955
      168 7 35   .11255506  30    .1111601  24 .011435825  21 -.034937955
      128 8 -8   .16240662 -12   .08558926 -14  .04856756 -21   -.0243543
      129 8 -7   .16240662 -11   .08558926 -13  .04856756 -20   -.0243543
      130 8 -6   .16240662 -10   .08558926 -12  .04856756 -19   -.0243543
      131 8 -5   .16240662  -9   .08558926 -11  .04856756 -18   -.0243543
      end

      Comment

      Working...
      X