研究数据高级数据

上市公司股票收益率与波动率(Ret、Sigma)指标

覆盖年份 1991-2025数据格式 Excel / Stata / Stata代码 / PDF更新日期

数据摘要

股票收益率及其波动程度是资本市场实证研究中的常用控制变量。本资料整理上市公司Ret、Sigma指标,包含分市场和综合市场下的等权、流通市值与总市值加权口径,并提供全样本及剔除、缩尾版本,便于比较不同收益率处理方式。

基本信息

数据频率年度
年份范围1991-2025
当前预览样本量66121 行
文件格式Excel / Stata / Stata代码 / PDF
文件包大小667.58 MB
包含内容数据表7份、代码1份、文档2份
所属分类

样本年份分布

合计 66,121 行 · 35 个年份

查看年份明细
年份样本量
199110
199226
199385
1994259
1995291
1996339
1997593
1998725
1999800
2000881
20011,032
20021,057
20031,085
20041,147
20051,225
20061,177
20071,239
20081,369
20091,412
20101,624
20111,956
20122,230
20132,352
20142,379
20152,426
20162,568
20172,928
20183,259
20193,367
20203,498
20214,007
20224,420
20234,701
20244,820
20254,834

测算方法

以公司和年份为分组,将公司年内的周度市场调整收益率取算术平均,得到Ret;对同一组周度收益率计算样本标准差,得到Sigma。计算分别采用分市场和综合市场两组基准,每组包含等权、流通市值加权和总市值加权三种方式,因此共形成六组收益率与波动率指标。完成年度聚合后,每个公司年度保留一条记录。资料另提供排除金融业并仅保留正常交易状态的版本,在这一版本基础上,对十二个连续指标执行全样本1%和99%分位缩尾,分别保存处理前后的结果。

以下字段、样本量及样本仅对应当前展示的数据表,不代表资料包全部文件。查看文件结构

字段列表共 19 个字段

字段含义 / 说明类型均值标准差最小值最大值缺失率
证券代码—文本————0.0000%
stkcd—整数323970.4694276923.747928339940.0000%
year—整数2015.4490867.89389984199120250.0000%
Ret_分市场等权平均法—数值-0.0012385386920.001071348757-0.005980717949-0.000130620.0000%
Sigma_分市场等权平均法—数值0.046296985730.018669670960.016324828160.10841687190.0000%
Ret_分市场流通市值平均法—数值-0.0013386420530.001139591731-0.006273192308-0.00014107843140.0000%
Sigma_分市场流通市值平均法—数值0.048242292760.019270201360.016965038110.11127548690.0000%
Ret_分市场总市值平均法—数值-0.0013470980010.001147502318-0.00629272093-0.0001413725490.0000%
Sigma_分市场总市值平均法—数值0.048377992240.019376708520.016979376460.11133408780.0000%
Ret_综合市场等权平均法—数值-0.0012671754540.00108998034-0.006079807692-0.00014023529410.0000%
Sigma_综合市场等权平均法—数值0.046867000020.018798646970.016911236840.10936070730.0000%
Ret_综合市场流通市值平均法—数值-0.0013892568440.001183702397-0.00651578-0.000146280.0000%
Sigma_综合市场流通市值平均法—数值0.04913046070.019693050250.017253582190.11361757730.0000%
Ret_综合市场总市值平均法—数值-0.0013880311590.001180086121-0.006455519231-0.00014609803920.0000%
Sigma_综合市场总市值平均法—数值0.049105899010.019704971560.017257970350.11309914710.0000%
市场类型—整数5.8080035097.3379587291640.0000%
行业代码—文本————0.0076%
交易状态—文本————0.0000%
丘知数据分析会员之家www.qqrdata.com文本————0.0000%

数据样本预览

资料样本(部分数据)

仅可预览前100 行、100 列,滚动查看其余行列,完整数据以下载文件为准。

证券代码stkcdyearRet_分市场等权平均法Sigma_分市场等权平均法Ret_分市场流通市值平均法Sigma_分市场流通市值平均法Ret_分市场总市值平均法Sigma_分市场总市值平均法Ret_综合市场等权平均法Sigma_综合市场等权平均法Ret_综合市场流通市值平均法Sigma_综合市场流通市值平均法Ret_综合市场总市值平均法Sigma_综合市场总市值平均法市场类型行业代码交易状态丘知数据分析会员之家
00000221991-0.002077533333330.0652205594902-0.003016888888890.0768463628456-0.003580777777780.0837083399576-0.002538488888890.0723316731719-0.003511088888890.0827062733321-0.004542066666670.09390271681584K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221992-0.002653830188680.0771489848095-0.001547377358490.0576920764411-0.001956528301890.0652292512214-0.004216094339620.0948944669947-0.003264773584910.0836140720984-0.003901905660380.09135330527984K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221993-0.0003536078431370.0267966730965-0.0001965294117650.019971546981-0.0002732156862750.0235671811597-0.0009937254901960.0449879868521-0.0004550.0304699167094-0.001066215686270.04665443923764K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221994-0.001608764705880.05641557298-0.0014070.0526968623256-0.001483705882350.0540855313171-0.002301705882350.0674079907338-0.00206886274510.0639153448821-0.002353215686270.06804460123494K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221995-0.000136840.0167204191779-0.0001410784313720.0169650381137-0.000141372549020.0169793764635-0.00020910.0206600128092-0.000225040.021407641937-0.000270340.02345008715324K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221996-0.0006765882352940.0370041673741-0.0006861372549020.0372020271045-0.0007196470588240.038063004855-0.0009449607843140.0437321894595-0.0009757450980390.0445297890913-0.001232117647060.04999421156564K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221997-0.001333098039220.0517352569253-0.001062098039220.0462224942937-0.001141431372550.0478946046541-0.001634549019610.0574331571305-0.001290352941180.0510702186229-0.001370549019610.05257825235454K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221998-0.00029590.0245129523557-0.000243420.0222138932295-0.00025490.0227436591677-0.0003210.0255255608218-0.000272560.0235116519191-0.000278960.02378682591394K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000221999-0.001044080.0458377535782-0.000833260.0410301917049-0.000879720.0421570047372-0.000963780.0440250598184-0.000849140.0414258276584-0.000903480.04272739302394K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222000-0.0005411458333330.0332511555672-0.0005041666666670.0320630664302-0.0005133333333330.0323599725208-0.0005891666666670.0346426158472-0.0005235208333330.0326668262654-0.0005374166666670.03311478888294K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222001-0.000193260.0198579560489-0.000188420.0196101083348-0.000190320.019708819665-0.00020.0201938460519-0.000193860.0198919390052-0.00018780.01957584647114K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222002-0.00018650.0194804371303-0.000172280.0187440762104-0.000176020.0189462989962-0.000171980.0187342080452-0.000159880.0180767396991-0.000152680.01766701406634K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222003-0.0004613333333330.030687069156-0.0003502549019610.0267285051867-0.0003382941176470.0262725826331-0.0004455882352940.0301556778469-0.0003397450980390.0263330177495-0.000317627450980.02546549940524K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222004-0.0009529215686270.0443042475245-0.0008364901960780.0415265541746-0.0008372549019610.0415390809416-0.0009238431372550.0436327491127-0.0008133921568630.0409508315794-0.0008014313725490.04064242276214K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222005-0.0008325111111110.0415563759339-0.00074240.0391623872493-0.0007588666666670.0396090727018-0.0008238666666670.0413606390659-0.0007423333333330.0391767196432-0.0007555111111110.03952570408134K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222006-0.001606857142860.0572957724953-0.001556530612240.0563999586311-0.001560428571430.0564785694309-0.001603632653060.0572437399069-0.001554938775510.0563903791548-0.001525714285710.05586086628964K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222007-0.003393940.0831427089705-0.002658060.0730762244957-0.002724620.0739754373744-0.003315320.0821327218091-0.002498520.0707392019115-0.002157360.0657887099284K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222008-0.001841903846150.0609130204431-0.001432884615380.0536591871821-0.001534576923080.0555302987596-0.001701730769230.0585536421613-0.001301134615380.0510720166912-0.001365423076920.05232657856064K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222009-0.001124549019610.0477627002751-0.0008984117647060.042712597421-0.0009202549019610.0432293577694-0.001115980392160.0476099126088-0.0008115490196080.04056515245-0.0007854705882350.03990970565884K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222010-0.0009373921568630.0437005021724-0.0008805882352940.0423352846638-0.000881627450980.0423697429338-0.0009306666666670.0435281915451-0.0007864509803920.0399174452375-0.0007923921568630.04006789866574K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222011-0.0004955686274510.0317773097522-0.0004480980392160.0302288967144-0.0004636666666670.0307411398017-0.0004861960784310.0314842479224-0.0003780392156860.0277808868577-0.000398627450980.02851898241174K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222012-0.000526140.0326911220464-0.00039980.0285111384815-0.000415940.0290779485889-0.00052240.0325757289498-0.000373340.027548026507-0.00038570.02799764866534K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222013-0.0009984489795920.0448122591928-0.0008715714285710.0418083985502-0.0009005102040820.0425017201677-0.0009853469387760.044503012358-0.0007361020408160.0383889546567-0.0007652448979590.03914150478744K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222014-0.001059320754720.04613913826-0.0009402264150940.0434655486518-0.0009607547169810.0439482311725-0.001047528301890.0458546523932-0.0008484905660380.0413105569449-0.0008685471698110.04177576926124K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222015-0.00192980.0617069308617-0.00178210.0593651843613-0.001795760.0595750178434-0.001938020.0618348301874-0.001500640.0543011468221-0.001564480.05548322717584K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222017-0.0009160392156860.0430548514195-0.0008950784313730.0425573934643-0.0008925882352940.0425045983438-0.0008949019607840.042580934398-0.0009250.0432207235136-0.0008970196078430.04260860086954K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222018-0.001249882352940.0507083614871-0.0009452352941180.0439751410561-0.0009800588235290.0447958049091-0.001269901960780.0511261288843-0.0008469607843140.041599520464-0.0009005294117650.04292403776184K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222019-0.0004937115384620.0317324515459-0.0004509807692310.0303035273107-0.0004578076923080.0305393627224-0.0004954423076920.0317868684056-0.0004212692307690.0292309150113-0.0004377692307690.02981356378354K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222020-0.0004936923076920.0317663049266-0.000487250.0315009133032-0.0004980576923080.0318473621528-0.0005053076923080.0321226079659-0.0004587115384620.0305607148915-0.0004753269230770.03110734279544K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222021-0.0008649807692310.0419706492316-0.0008474423076920.0415248304901-0.0008532307692310.0416768170271-0.0008739615384620.0421850567214-0.0008797884615380.0423419307864-0.0008784230769230.04231975322194K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222022-0.001338620.0521374947747-0.001373140.0526609187244-0.001379840.0528047686198-0.00135190.0524433950758-0.001368460.0525950810671-0.001394140.05311110178884K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222023-0.00032480.0256823426001-0.00030830.0250213508088-0.000309180.0250564804365-0.000343440.0263937770257-0.000281040.0238901985871-0.000289940.02426473100434K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222024-0.001491673076920.0546330327817-0.001170865384620.0484960559791-0.001185346153850.0487943628783-0.001433750.0535077441677-0.001167269230770.0484016604703-0.001175826923080.04856288597914K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000222025-0.0005326415094340.0329385420425-0.0005139245283020.0323626262299-0.0005142452830190.032373358746-0.0005193018867920.0325353508236-0.0004970566037740.0318102403561-0.0004978113207550.03183953174854K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331992-0.002441547169810.0674192227526-0.002860169811320.0721525178671-0.002771886792450.071320042375-0.004126056603770.088612738979-0.003536886792450.0814493098036-0.003751113207550.08417149944654S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331993-0.0006068627450980.035078311261-0.000366686274510.0272548362662-0.0004700980392160.030862856159-0.00108713725490.0471040103206-0.0005845490196080.034530883222-0.001113607843140.04780228355054S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331994-0.0004091372549020.0288094326789-0.0002347450980390.0218326722147-0.0002737647058820.0235592037434-0.001045627450980.0459151454633-0.0007837254901960.0397594791038-0.001073254901960.04649236705354S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331995-0.000147480.0172778911497-0.0001410784313720.0169650381137-0.000141372549020.0169793764635-0.00020040.0201387544413-0.000200680.0201564885096-0.0002370.02189575299244S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331996-0.0009948627450980.044911487693-0.001205980392160.0494216373154-0.001259294117650.0504411876721-0.001540450980390.0558348862484-0.00161713725490.0571337173004-0.001815764705880.06053896126584S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331997-0.001094176470590.0469132854559-0.001021823529410.0452599849698-0.001076450980390.0464651093214-0.001019372549020.0453861295512-0.0009928039215690.0446695246185-0.001138549019610.04785123702914S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331998-0.00050330.0319426117025-0.000493180.0316516457229-0.000502220.0319296478555-0.000518060.0323710093532-0.00049320.0316269449375-0.000489360.03150926220084S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000331999-0.00116950.0486902031143-0.001268520.0508227101042-0.001287540.0512071090147-0.001186280.0490445652992-0.001284080.0511113218289-0.001298760.05138579883214S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441991-0.001907458333330.0643868678219-0.004189104166670.0955552509695-0.004042208333330.0937566034163-0.002661770833330.0767863113087-0.004332333333330.09730025819-0.004560145833330.1000121871714G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441992-0.0003309245283020.0260299417446-0.0003286037735850.0259095046893-0.0003446037735850.026532331626-0.002159037735850.0659553040793-0.001375490566040.0527395870479-0.001751339622640.0593304730174G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441993-0.0004235490196080.0293616136725-0.0003230196078430.0255867378026-0.0003772352941180.0276635640969-0.001120823529410.0476412177522-0.0006154509803920.0352714044848-0.001191176470590.04916035664714G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441994-0.0005486470588240.0334504490534-0.0005228235294120.0326991194693-0.0005208823529410.0326190141063-0.000992313725490.0448462101683-0.0008681176470590.0420183607556-0.001045411764710.04601875174334G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441995-0.000531480.0325302294045-0.000509220.0318244926114-0.00051890.0321289191744-0.000612920.0349905033162-0.00059330.0343952076576-0.00062690.03536874559654G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441996-0.00231072549020.0685348954478-0.002277686274510.0680660986646-0.002410901960780.0699599726516-0.002561509803920.0721564964311-0.002269294117650.0680662491654-0.002415333333330.0702311748374G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441997-0.001585764705880.0568591016438-0.001658313725490.0582267466591-0.001637764705880.0577941265644-0.001456294117650.054495253763-0.001570392156860.0566760936717-0.001523509803920.05578167374994G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000441998-0.001587040.055978573204-0.001703860.0580782354939-0.001695540.0579444150799-0.00173130.0583295046611-0.001738920.0586071157642-0.001766720.0590783668464G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442001-0.000589660.0347580759957-0.000572480.0342338681582-0.000581140.0344987672143-0.000580540.0344692952494-0.000576920.0343601216201-0.000592860.03484954467484G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442002-0.00081220.0406291125461-0.00082130.0408495575248-0.000823040.0408929996234-0.00080770.0405070277774-0.000819480.0407992523467-0.000825160.04093443750554G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442003-0.0008843333333330.0424853600402-0.0009141960784310.0432557540556-0.0009248431372550.0435146100851-0.0008830.0424772036886-0.0009138039215690.0432715566501-0.000964686274510.04448384799164G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442004-0.001319647058820.0512948337468-0.001468392156860.0543350985004-0.001487549019610.0546959157266-0.001325627450980.0514323255566-0.001521666666670.0553927894267-0.001592156862750.05678000988114G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442005-0.000697122448980.0377946341736-0.0008599183673470.0419546201637-0.0008618979591840.042010235246-0.000689122448980.0375972661022-0.0008986938775510.0428996548171-0.0009298163265310.04369429931154G54A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442011-0.0007565490196080.0392543766346-0.0008172352941180.0408186096934-0.0008231176470590.0409646457207-0.0007257450980390.0384173022592-0.000848313725490.0415722321198-0.0008395098039220.04134817885834C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442012-0.0008563529411760.0413097704597-0.0008658235294120.0415636730329-0.0008575686274510.0413824815806-0.0008595882352940.0413616135305-0.0009563333333330.0436773108113-0.0009393333333330.04328204968984C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442013-0.0009071176470590.0431370681348-0.001013019607840.0456452744711-0.0009744313725490.0447371144457-0.0009407450980390.043960685495-0.001259745098040.0510020079702-0.001197588235290.04970860729784C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442014-0.001264576923080.050200533024-0.001435096153850.0535435914443-0.001421019230770.0532732594679-0.001303384615380.0509973266989-0.001447884615380.0538247976609-0.001453461538460.05392110131814C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442015-0.001884865384620.0615262836317-0.002136057692310.0657058390014-0.002138250.0657567739064-0.001909057692310.0619485934441-0.003036384615380.0788504628604-0.002836480769230.07610954541144C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442017-0.001327878048780.0525196144798-0.001136707317070.0484706718131-0.00111821951220.0480609733955-0.001300878048780.0519297880104-0.001246365853660.0506542470731-0.001162341463410.04888848141824C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442018-0.00074643750.0389064984108-0.0008101666666670.0405539472137-0.0008033958333330.0403862421691-0.0007548750.039127821144-0.0008574166666670.0417425685336-0.0008443541666670.04141863921434C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442019-0.001223803921570.0499443630013-0.001263666666670.0507698608285-0.001255215686270.0505942145935-0.001230882352940.05008696702-0.001271450980390.0509587063985-0.001265254901960.0508218222754C27A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442020-0.003521019230770.0828887455398-0.003937903846150.0870934938772-0.003911115384620.0868300724986-0.003595365384620.0835249877539-0.004082480769230.0885324811223-0.004035269230770.08797384079624I65A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442021-0.003097730769230.077129658367-0.003570173076920.0832608274871-0.003551403846150.0830333801189-0.003129134615380.0775978347052-0.003485442307690.0823181460531-0.003498134615380.08249470608144I65A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442023-0.00172980.0589499745886-0.00166410.057770108596-0.001670980.0578878648171-0.001709820.0586394541194-0.001643840.0573869644916-0.001640980.05734652458474I65A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000442024-0.004796076923080.0989269430989-0.005691903846150.108018133291-0.005666019230770.107752124624-0.004714307692310.0980623669241-0.005788961538460.108839643544-0.0057240.1082108469474I65A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551991-0.0003543777777780.0271099002599-0.0003729555555560.0278212246127-0.00036840.027647035106-0.0003542222222220.0271407652266-0.0003631333333330.0274501888217-0.0003586666666670.02729348414674S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551994-0.00373786274510.087296438794-0.004614705882350.0979828872666-0.004456705882350.0959311102484-0.00398027450980.0893441844409-0.004139843137250.0918687118567-0.004255843137250.09278927169554S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551995-0.000258980.022892878107-0.000245860.0223053998551-0.000247440.0223801420845-0.000324760.0256388468058-0.000359040.0269119261651-0.000397020.02829411767854S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551996-0.001277254901960.0507555214501-0.001335784313730.0518238029312-0.00136927450980.0523026174141-0.00182186274510.0604451040108-0.001769705882350.0595816954711-0.001915176470590.06198010957744S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551997-0.001678490196080.0582438090263-0.001471196078430.0545817619624-0.001520568627450.0554720472286-0.001877490196080.0615450673502-0.001624607843140.05732190325-0.001616039215690.05718820331684S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551998-0.001871540.0617425800775-0.0017880.0603778799653-0.001831760.0611160795615-0.00185260.061422793087-0.001785080.0602662748949-0.001788640.06025897936334S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000551999-0.000553680.0334966238484-0.00068190.0371454856819-0.000661120.0365917707324-0.00051680.0324062076769-0.000700220.0376667014859-0.000686220.03729242725144S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552000-0.0006983750.0376914128081-0.0006883958333330.0373773180548-0.000680250.0371812385064-0.0006728333333330.0369802433282-0.0006821458333330.0372228035432-0.0006894791666670.03744649257954S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552001-0.00027930.0237964094678-0.000277260.0237077775973-0.000276480.0236679371451-0.000286220.024093187719-0.000274580.0235979813112-0.000272680.0235112949564S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552002-0.000397340.0284033859412-0.00039270.0282506518547-0.00039640.0283807544765-0.000408160.0287756742749-0.000408820.028806023081-0.000435620.02974980960254S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552008-0.001492250.0550384081642-0.001479884615380.0548327308073-0.001531173076920.0557889396093-0.001401346153850.053345348593-0.001530365384620.0558083441952-0.001847326923080.0614973352794S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552009-0.001418117647060.0529004792593-0.001364470588240.0519329948712-0.001356333333330.0517987070177-0.001426196078430.0530624699018-0.001477843137250.0541362337746-0.001506509803920.05467793923344S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552010-0.0005885882352940.0345770363728-0.0005784509803920.0342521812621-0.0005912549019610.0346335322939-0.0005712156862750.034050495949-0.0005730196078430.034051937564-0.0005851764705880.03441189657184S91A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552012-0.0007001111111110.0378386595314-0.0007891666666670.0401473992059-0.0007810555555560.0399504039622-0.0006825277777780.0373755539185-0.0007630555555560.0394878046389-0.0007646944444440.03953601325654K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552013-0.0006402307692310.035850765088-0.0006099615384620.0349801606421-0.0006248076923080.0353927768132-0.0006196730769230.0352972287351-0.0005709230769230.0339141293852-0.0005863653846150.03436265497694K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552014-0.001435980769230.0530923959747-0.001530942307690.0549110882329-0.001533557692310.0549257863568-0.001425730769230.0529583851155-0.001662903846150.0574224330562-0.001647519230770.05714793004184K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552015-0.005980717948720.108416871918-0.006273192307690.111275486858-0.006292720930230.111334087764-0.006079807692310.109360707282-0.006515780.113617577259-0.006455519230770.1130991470814K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552016-0.0003670.0271941440598-0.000354220.0267040872399-0.000365340.0271154206902-0.00037580.027518010523-0.000409580.0286839347777-0.000398940.02831108917694N77A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552017-0.000208686274510.0205079703554-0.0002065294117650.0203935274245-0.0002127450980390.0206991903531-0.0002210.0211120161766-0.0002664901960780.0231772589478-0.0002430980392160.0221413835464N77A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552018-0.000164313725490.0183219294066-0.0002604901960780.0230639676876-0.0002586470588240.0229815878684-0.0001898235294120.0196915059706-0.0003497254901960.026703230869-0.0003199411764710.02554439050554N77A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552019-0.0005314615384620.032828397528-0.0005461730769230.0332813680177-0.0005460.0332827492466-0.0005180.0324266454868-0.0006046346153850.034973934183-0.0005749038461540.03411822034144N77A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000552020-0.0001968653846150.0199875075652-0.0002336730769230.0217928730181-0.0002332692307690.0217782045292-0.0002083653846150.020570570831-0.000231250.0216872899164-0.0002279038461540.02153303045644N77A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661992-0.001539363636360.0568820668092-0.001352818181820.0533479255597-0.001629939393940.0585119184995-0.0033940.0837092522545-0.002060393939390.0656849041161-0.002327666666670.06968028472634K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661993-0.0004578039215690.0306509018849-0.0003557450980390.0269778238602-0.0003868627450980.0281775991355-0.001361745098040.0526240723825-0.0007969803921570.0402538166511-0.001389176470590.05324726710994K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661994-0.0005114509803920.0322759159829-0.0004304313725490.0297038957891-0.0004569607843140.0305694798019-0.0007422549019610.0386033344911-0.0006052549019610.0349283914762-0.0007316470588240.03834563314224K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661995-0.000259760.0230217164359-0.000230.0216709042944-0.00023440.0218770844894-0.000345660.0265056247482-0.00034330.0264214264583-0.000393160.0282576656054K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661996-0.001292392156860.0511036335616-0.001355450980390.0523755112858-0.001316490196080.0516151721029-0.001537313725490.0557151308865-0.001617294117650.0572152401317-0.001809960784310.06049692268114K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661997-0.0008099411764710.0405692238523-0.0007274901960780.0384440407316-0.0007536470588240.0391486258685-0.0008924117647060.0426509308485-0.0007381764705880.0388412650642-0.0008074117647060.04058741923464K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661998-0.00036990.0273946518535-0.000305180.0248888158865-0.000314240.0252540586357-0.000387520.0280581575415-0.000318440.0254206145458-0.000324860.02568174047684K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000661999-0.000458680.0304976957921-0.00034350.0264154958127-0.000354260.0268198687778-0.000434240.0296724465914-0.000339840.0262604621883-0.00035790.02695710272864K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000662000-0.0005983541666670.0348094011925-0.00055668750.0335918011388-0.00055150.0334385736602-0.0005926458333330.0346062765501-0.000549250.0333387906088-0.0005422708333330.03313000662174K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000662001-0.000223340.0213641988159-0.000202040.0203173841077-0.000210260.020714641783-0.000247620.0224897021122-0.00022420.0214029452208-0.000214280.02092389190984K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com
00000662002-0.00038130.027528546378-0.000326220.0255581665987-0.00033830.0260113649582-0.000334540.0258381165139-0.000269820.0232995855562-0.000243440.02218272261054K70A更多数据尽在丘知数据分析会员之家:www.qqrdata.com

代码公开披露

仅展示前 30 行,供了解变量构造与处理流程,完整代码请下载文件查看。

//更多数据尽在丘知数据分析会员之家:www.qqrdata.com
//控制变量Ret和Sigma计算
//导入数据
use 原始数据,clear
label variable 丘知数据分析会员之家 "www.qqrdata.com"

/*计算Ret和Sigma
更多数据尽在 丘知数据分析会员之家 :www.qqrdata.com
*/
foreach i in 分市场等权平均法 分市场流通市值平均法 分市场总市值平均法 综合市场等权平均法 综合市场流通市值平均法 综合市场总市值平均法 {
	bys stkcd year: egen Ret_`i'=mean(调整回报率`i')
	bys stkcd year: egen Sigma_`i'=sd(调整回报率`i')
}
gsort stkcd year -交易周份
bys stkcd year: keep if _n==1
sort stkcd year

/*整理指标
更多数据尽在 丘知数据分析会员之家 :www.qqrdata.com
*/
keep stkcd 证券代码 year Ret_分市场等权平均法 Sigma_分市场等权平均法 Ret_分市场流通市值平均法 Sigma_分市场流通市值平均法 Ret_分市场总市值平均法 Sigma_分市场总市值平均法 Ret_综合市场等权平均法 Sigma_综合市场等权平均法 Ret_综合市场流通市值平均法 Sigma_综合市场流通市值平均法 Ret_综合市场总市值平均法 Sigma_综合市场总市值平均法 市场类型 行业代码 交易状态
order stkcd 证券代码 year Ret_分市场等权平均法 Sigma_分市场等权平均法 Ret_分市场流通市值平均法 Sigma_分市场流通市值平均法 Ret_分市场总市值平均法 Sigma_分市场总市值平均法 Ret_综合市场等权平均法 Sigma_综合市场等权平均法 Ret_综合市场流通市值平均法 Sigma_综合市场流通市值平均法 Ret_综合市场总市值平均法 Sigma_综合市场总市值平均法 市场类型 行业代码 交易状态

/*输出结果表
更多数据尽在 丘知数据分析会员之家 :www.qqrdata.com
*/
label data "更多数据尽在丘知数据分析会员之家:www.qqrdata.com"
gen 丘知数据分析会员之家="更多数据尽在丘知数据分析会员之家:www.qqrdata.com"
label variable 丘知数据分析会员之家 "www.qqrdata.com"
order 证券代码 stkcd year