怎样处理得到第四季度财务数据

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

急~~~国泰安中第四季度的数据需要用年末的值减去前三个季度的值，请问stata命令怎么实现这种横向的减法呀，望大神指点迷津！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：财务数据 四季度 stata命令 Stata 指点迷津 stata操作

怎么实现用当年期末数据减去当年前三季度的数据

罗拉购 发表于 2017-9-17 22:03
怎么实现用当年期末数据减去当年前三季度的数据

建議用 dataex (先 ssc install dataex 并见说明) 将原始 Stata 资料中具有”代表性”的一部分资料列出，以供有意回答者实验之用，并能提供具体操作指令。并请参考 https://bbs.pinggu.org/thread-5048204-1-1.html 与https://bbs.pinggu.org/thread-5917273-1-1.html。

----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 证券代码 str10 会计期间 double(营业总收入 营业收入 营业成本 营业利润) str4 year str2 quarter long quarter1
   
4. "000002" "2016-12-31" 240477236923.34 240477236923.34 169742403431.77 39023778797.86 "2016" "12" 201612
   
5. "000002" "2016-09-30" 117054800129.06 117054800129.06  86003585977.58 15787300604.87 "2016" "09" 201609
   
6. "000002" "2016-06-30"  74795294306.29  74795294306.29   55117487905.7     9904605249 "2016" "06" 201606
   
7. "000002" "2016-03-31"  14611312019.58  14611312019.58   9967696885.63  1646600783.53 "2016" "03" 201603
   
8. "000002" "2015-12-31"  195549130020.9  195549130020.9 138150628676.24 33122777302.51 "2015" "12" 201512
   
9. "000002" "2015-09-30"  79596209996.91  79596209996.91  56467158104.29 12353698401.73 "2015" "09" 201509
   
10. "000002" "2015-06-30"  50266797992.53  50266797992.53  34960814798.91   8718934358.8 "2015" "06" 201506
    
11. "000002" "2015-03-31"   8894338157.14   8894338157.14   5870110226.47  1169822711.92 "2015" "03" 201503
    
12. "000002" "2014-12-31" 146388004498.44 146388004498.44 102557063731.11 24979358867.78 "2014" "12" 201412
    
13. "000002" "2014-09-30"  63139592563.49  63139592563.49  44157105583.25  9557660289.88 "2014" "09" 201409
    
14. "000002" "2014-06-30"  40961902094.71  40961902094.71  28298414139.65  6856260391.03 "2014" "06" 201406
    
15. "000002" "2014-03-31"   9497216581.95   9497216581.95   5706277172.09  2017750434.26 "2014" "03" 201403
    
16. "000002" "2013-12-31" 135418791080.35 135418791080.35  92797650762.81 24261338387.14 "2013" "12" 201312
    
17. "000002" "2013-09-30"  63415318186.37  63415318186.37  43030790288.57  9970471509.73 "2013" "09" 201309
    
18. "000002" "2013-06-30"  41390345567.72  41390345567.72   27488879049.6  7105211007.75 "2013" "06" 201306
    
19. "000002" "2013-03-31"  13999905876.13  13999905876.13    8801586374.7  2395144445.56 "2013" "03" 201303
    
20. "000002" "2012-12-31" 103116245136.42 103116245136.42     65421614348 21013040794.06 "2012" "12" 201212
    
21. "000002" "2012-09-30"  46128221600.95  46128221600.95  28885540216.07  8152930727.08 "2012" "09" 201209
    
22. "000002" "2012-06-30"  30722991215.82  30722991215.82  19274445195.45   6012329738.2 "2012" "06" 201206
    
23. "000002" "2012-03-31"  10345911610.85  10345911610.85   6022296925.45  2036895217.18 "2012" "03" 201203
    
24. "000002" "2011-12-31"  71782749800.68  71782749800.68  43228163602.13 15763216697.19 "2011" "12" 201112
    
25. "000002" "2011-09-30"  29308369223.23  29308369223.23  17044419257.51  5603083790.69 "2011" "09" 201109
    
26. "000002" "2011-06-30"  19988838077.14  19988838077.14  10992730405.83  4417871993.33 "2011" "06" 201106
    
27. "000002" "2011-03-31"   7970255508.29   7970255508.29   4068773609.46  1648888822.88 "2011" "03" 201103
    
28. "000002" "2010-12-31"  50713851442.63  50713851442.63  30073495231.18 11894885308.23 "2010" "12" 201012
    
29. "000002" "2010-09-30"  22380429859.16  22380429859.16  13696153473.17  5008143982.91 "2010" "09" 201009
    
30. "000002" "2010-06-30"  16766330449.76  16766330449.76  10239748864.29  4118305474.26 "2010" "06" 201006
    
31. "000002" "2010-03-31"   7504969754.53   7504969754.53   4749115444.95   1541948905.4 "2010" "03" 201003
    
32. "000002" "2009-12-31"  48881013143.49  48881013143.49     34514717705     8685082798 "2009" "12" 200912
    
33. "000002" "2009-09-30"  29543838457.46  29543838457.46  20618995957.09  5022741585.01 "2009" "09" 200909
    
34. "000002" "2009-06-30"  21808652427.82  21808652427.82   15007303368.2  4190846869.84 "2009" "06" 200906
    
35. "000002" "2009-03-31"   8164318688.66   8164318688.66   5404078573.96  1231593896.34 "2009" "03" 200903
    
36. "000002" "2008-12-31"  40991779214.96  40991779214.96  25005274464.91  6364789552.07 "2008" "12" 200812
    
37. "000002" "2008-09-30"  22541912977.14  22541912977.14  13416159543.85  3758330381.71 "2008" "09" 200809
    
38. "000002" "2008-06-30"  17255013019.21  17255013019.21  10171411545.62  3327479350.53 "2008" "06" 200806
    
39. "000002" "2008-03-31"   6400435839.58   6400435839.58   3925912602.33  1028143668.04 "2008" "03" 200803
    
40. "000002" "2007-12-31"  35526611301.94  35526611301.94  20607338964.44  7652897499.73 "2007" "12" 200712
    
41. "000002" "2007-09-30"  14173465879.06  14173465879.06    7516309610.3  2976200412.24 "2007" "09" 200709
    
42. "000002" "2007-06-30"  11096520942.19  11096520942.19   6046315357.92  2541192210.72 "2007" "06" 200706
    
43. "000002" "2007-03-31"   4114138824.22   4114138824.22   2280512837.18   829587980.15 "2007" "03" 200703
    
44. end

复制代码

------------------ copy up to and including the previous line ------------------

----------------------- copy starting from the next line -----------------------

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input str6 证券代码 str10 会计期间 double(营业总收入 营业收入 营业成本 营业利润) str4 year str2 quarter long quarter1
   
4. "000002" "2016-12-31" 240477236923.34 240477236923.34 169742403431.77 39023778797.86 "2016" "12" 201612
   
5. "000002" "2016-09-30" 117054800129.06 117054800129.06  86003585977.58 15787300604.87 "2016" "09" 201609
   
6. "000002" "2016-06-30"  74795294306.29  74795294306.29   55117487905.7     9904605249 "2016" "06" 201606
   
7. "000002" "2016-03-31"  14611312019.58  14611312019.58   9967696885.63  1646600783.53 "2016" "03" 201603
   
8. "000002" "2015-12-31"  195549130020.9  195549130020.9 138150628676.24 33122777302.51 "2015" "12" 201512
   
9. "000002" "2015-09-30"  79596209996.91  79596209996.91  56467158104.29 12353698401.73 "2015" "09" 201509
   
10. "000002" "2015-06-30"  50266797992.53  50266797992.53  34960814798.91   8718934358.8 "2015" "06" 201506
    
11. "000002" "2015-03-31"   8894338157.14   8894338157.14   5870110226.47  1169822711.92 "2015" "03" 201503
    
12. "000002" "2014-12-31" 146388004498.44 146388004498.44 102557063731.11 24979358867.78 "2014" "12" 201412
    
13. "000002" "2014-09-30"  63139592563.49  63139592563.49  44157105583.25  9557660289.88 "2014" "09" 201409
    
14. "000002" "2014-06-30"  40961902094.71  40961902094.71  28298414139.65  6856260391.03 "2014" "06" 201406
    
15. "000002" "2014-03-31"   9497216581.95   9497216581.95   5706277172.09  2017750434.26 "2014" "03" 201403
    
16. "000004" "2016-12-31"    287670026.58    287670026.58    188072713.09    51576371.77 "2016" "12" 201612
    
17. "000004" "2016-09-30"    217567647.19    217567647.19    151215210.21    27006893.96 "2016" "09" 201609
    
18. "000004" "2016-06-30"     102150497.7     102150497.7      73722303.9     4174096.07 "2016" "06" 201606
    
19. "000004" "2016-03-31"     13480946.58     13480946.58     10407534.77    -2771850.02 "2016" "03" 201603
    
20. "000004" "2015-12-31"    120454422.48    120454422.48     77957079.17    10137004.02 "2015" "12" 201512
    
21. "000004" "2015-09-30"     88894760.81     88894760.81     57009167.85     9352559.26 "2015" "09" 201509
    
22. "000004" "2015-06-30"     59545809.66     59545809.66        38136873     6535987.73 "2015" "06" 201506
    
23. "000004" "2015-03-31"     20937334.65     20937334.65      11505998.2    -1167452.51 "2015" "03" 201503
    
24. "000004" "2014-12-31"        80608820        80608820     49369034.66     3805326.19 "2014" "12" 201412
    
25. "000004" "2014-09-30"     48419079.33     48419079.33     20588296.94    -2201797.59 "2014" "09" 201409
    
26. "000004" "2014-06-30"     27430075.05     27430075.05     11323781.86    -3549201.71 "2014" "06" 201406
    
27. "000004" "2014-03-31"     11299314.74     11299314.74      5195871.13    -2972894.86 "2014" "03" 201403

复制代码

------------------ copy up to and including the previous line ------------------

还是论坛小白，试了很多次才把代码上传。大家可以试验第二组数据哦~辛苦大家啦

是不是其他数据库可以搜到第四季度数据，不需像国泰安这样自己处理？

罗拉购 发表于 2017-9-18 09:02
还是论坛小白，试了很多次才把代码上传。大家可以试验第二组数据哦~辛苦大家啦

1. 请用"回复"回复，我才会知道 ！ 2. 你确定是要用第四季资料减去前三季之资料吗？还是用第四季资料减去第三季之资料？

黃河泉 发表于 2017-9-18 15:51
1. 请用"回复"回复，我才会知道 ！ 2. 你确定是要用第四季资料减去前三季之资料吗？还是用第四季资料减去 ...

是的是的，您说得对！是我弄错了！国泰安中每一季的数据都是累计值，所以是用第四季度数据减去第三季度数据。除了第一季度，要得到每一季度期间的数据都是用当季数据减去前一季数据。

罗拉购 发表于 2017-9-18 16:15
是的是的，您说得对！是我弄错了！国泰安中每一季的数据都是累计值，所以是用第四季度数据减去第三季度数 ...

你只是想要第四季的资料吗？请试试

1. gen ymd = date(会计期间, "YMD")
   
2. format %td ymd
   
3. gen yq = qofd(ymd)
   
4. format %tq yq
   
5. 
   
6. format 营业收入 %16.2f
   
7. 
   
8. bys 证券代码 year (yq): gen tem = 营业收入[4]-营业收入[3]
   
9. format tem %16.2f

复制代码