求助各位,我的数据是2006-05-08至2021-03-31的A股交易公告的数据,现在想在每个季度,根据公告发布前(-30<=dif<-60)的换手率TO将数据分为3:4:3的三组,再分别对每一组按照事件期间(-2<=dif<=2)的换手率TO高中低也分为三组,一共构成9个投资组合(注:第二次分组的样本量是第一次一个组的样本量),然后计算每个组合的等值加权平均收益率,得到2006-05-08至2021-03-31一共59个季度的收益率时间序列,最后计算每个组合在样本期间的加权平均收益率(%)。数据附上dataex,十分感谢~~~~
- ----------------------- copy starting from the next line -----------------------
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input str6 Stkcd float(Pstdt Date TO dif id estimation_window count_est_obs event_window count_event_obs predicted_return AR CAR)
- "000063" 17456 17365 -.13729477 -59 14 1 30 0 5 . . .08798753
- "000063" 17456 17366 -.4360738 -58 14 1 30 0 5 . . .08798753
- "000063" 17456 17367 -.691313 -57 14 1 30 0 5 . . .08798753
- "000063" 17456 17370 .0769955 -56 14 1 30 0 5 . . .08798753
- "000063" 17456 17371 -.10349119 -55 14 1 30 0 5 . . .08798753
- "000063" 17456 17372 2.863846 -54 14 1 30 0 5 . . .08798753
- "000063" 17456 17373 1.813321 -53 14 1 30 0 5 . . .08798753
- "000063" 17456 17374 1.233391 -52 14 1 30 0 5 . . .08798753
- "000063" 17456 17377 1.90861 -51 14 1 30 0 5 . . .08798753
- "000063" 17456 17378 . -50 14 1 30 0 5 . . .08798753
- "000063" 17456 17379 .5608332 -49 14 1 30 0 5 . . .08798753
- "000063" 17456 17380 .2171458 -48 14 1 30 0 5 . . .08798753
- "000063" 17456 17381 1.6330545 -47 14 1 30 0 5 . . .08798753
- "000063" 17456 17384 -.13442755 -46 14 1 30 0 5 . . .08798753
- "000063" 17456 17385 .2767706 -45 14 1 30 0 5 . . .08798753
- "000063" 17456 17386 .7885827 -44 14 1 30 0 5 . . .08798753
- "000063" 17456 17387 -.0587678 -43 14 1 30 0 5 . . .08798753
- "000063" 17456 17388 1.6578645 -42 14 1 30 0 5 . . .08798753
- "000063" 17456 17391 .6156418 -41 14 1 30 0 5 . . .08798753
- "000063" 17456 17392 -.3609335 -40 14 1 30 0 5 . . .08798753
- "000063" 17456 17393 -.07132006 -39 14 1 30 0 5 . . .08798753
- "000063" 17456 17394 .4304098 -38 14 1 30 0 5 . . .08798753
- "000063" 17456 17395 -.14592278 -37 14 1 30 0 5 . . .08798753
- "000063" 17456 17398 .6443621 -36 14 1 30 0 5 . . .08798753
- "000063" 17456 17399 1.2733654 -35 14 1 30 0 5 . . .08798753
- "000063" 17456 17400 .12828529 -34 14 1 30 0 5 . . .08798753
- "000063" 17456 17401 1.0398934 -33 14 1 30 0 5 . . .08798753
- "000063" 17456 17402 .01204455 -32 14 1 30 0 5 . . .08798753
- "000063" 17456 17405 .7103462 -31 14 1 30 0 5 . . .08798753
- "000063" 17456 17406 .08128488 -30 14 1 30 0 5 . . .08798753
- "000063" 17456 17451 .27294493 -2 14 0 30 1 5 -.007685606 -.030291393 .08798753
- "000063" 17456 17454 -.17745543 -1 14 0 30 1 5 .005328896 .013350105 .08798753
- "000063" 17456 17456 4.3063617 0 14 0 30 1 5 -.011218712 .11121871 .08798753
- "000063" 17456 17457 .9115375 1 14 0 30 1 5 -.029882135 .014587135 .08798753
- "000063" 17456 17458 .4818393 2 14 0 30 1 5 -.005125971 -.02087703 .08798753
- "000063" 17611 17517 1.068334 -59 15 1 30 0 5 . . .01966791
- "000063" 17611 17518 -.27780986 -58 15 1 30 0 5 . . .01966791
- "000063" 17611 17519 -.13581419 -57 15 1 30 0 5 . . .01966791
- end
- format %tdCCYY-NN-DD Pstdt
- format %tdCCYY-NN-DD Date
复制代码