研究数据高级数据

上市公司超额现金持有指标

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

数据摘要

资料按货币资金、短期投资及现金等价物等不同口径计算现金持有水平,再减去同行业均值形成四类超额现金指标。可用于企业现金储备、融资环境、治理与产品市场竞争研究。

基本信息

数据频率年度
年份范围2000-2025
观测层级上市公司
当前预览样本量69297 行
文件格式Excel / Stata / Stata代码 / PDF
文件包大小154.24 MB
包含内容数据表8份、代码1份、文档4份
所属分类

样本年份分布

合计 69,297 行 · 26 个年份

查看年份明细
年份样本量
2000994
20011,071
20021,111
20031,142
20041,219
20051,234
20061,283
20071,361
20081,420
20091,584
20101,910
20112,152
20122,322
20132,419
20142,540
20152,720
20163,127
20173,492
20183,562
20193,714
20204,080
20214,535
20224,884
20235,119
20245,132
20255,170

测算方法

分别采用四种口径计算企业现金持有水平。现金持有水平1=(货币资金+短期投资净额)/(总资产-货币资金-短期投资净额),现金持有水平2=(货币资金+短期投资净额)/总资产,现金持有水平3=现金及现金等价物/总资产,现金持有水平4=货币资金/总资产。各口径下,企业现金持有水平减去对应行业均值,得到相应的超额现金持有水平。

参考文献

[1]罗进辉,李小荣,向元高.媒体报道与公司的超额现金持有水平[J].管理科学学报,2018,21(07):91-112. [2]张会丽,吴有红.超额现金持有水平与产品市场竞争优势——来自中国上市公司的经验证据[J].金融研究,2012,(02):183-195. [3]支晓强,周艳坤.媒体报道语调与公司超额现金持有[J].厦门大学学报(哲学社会科学版),2021,(05):118-131.

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

字段列表共 23 个字段

字段含义 / 说明类型均值标准差最小值最大值缺失率
证券代码—文本————0.0000%
证券简称—文本————0.0000%
stkcd—整数340820.1729288273.632229209920.0000%
year—整数2016.415796.821093411200020250.0000%
超额现金持有水平1—数值-1.96311049446.40188819-1121.6354463.9716673650.0000%
超额现金持有水平2—数值0.0016872077540.1276023522-0.29595807820.54103456420.0000%
超额现金持有水平3—数值9.419383103e-060.1360162327-2.9921087660.5446414110.1660%
超额现金持有水平4—数值0.0016496950190.1270119399-0.29595807820.54103456420.0000%
现金持有水平1—数值0.28783961450.35883682640.00050667368265.6573921560.0000%
现金持有水平2—数值0.18845093420.137669120.00050641709440.8574111860.0000%
现金持有水平3—数值0.16749782390.13330569890.0011215044080.85300816580.1660%
现金持有水平4—数值0.18735583180.13718554170.00045501073670.8574111860.0000%
现金持有水平1行业均值—数值2.2523000946.446351740.084628440321121.9287870.0000%
现金持有水平2行业均值—数值0.18689907140.050754757590.074264164150.47838483030.0000%
现金持有水平3行业均值—数值0.16769348990.075360089610.053672503223.0639662790.0000%
现金持有水平4行业均值—数值0.18584292050.050996052510.074179167370.47838483030.0000%
行业代码—文本————0.0000%
行业名称—文本————0.0000%
所属省份—文本————0.0000%
所属省份代码—文本————0.0216%
所属城市—文本————0.0000%
所属城市代码—文本————0.1443%
丘知数据分析会员之家www.qqrdata.com文本————0.0000%

数据样本预览

资料样本(部分数据)

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

证券代码证券简称stkcdyear超额现金持有水平1超额现金持有水平2超额现金持有水平3超额现金持有水平4现金持有水平1现金持有水平2现金持有水平3现金持有水平4现金持有水平1行业均值现金持有水平2行业均值现金持有水平3行业均值现金持有水平4行业均值行业代码行业名称所属省份所属省份代码所属城市所属城市代码丘知数据分析会员之家
000002深万科A220000.03549381967590.05015634657780.06925880449070.07016529381540.2153846288730.1772151990050.1771080356270.1771080356270.1798908091970.1270588524270.1078492311360.106942741812K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002深万科A22001-0.0561973766261-0.0212651115131-0.00733063718241-0.01152485303140.1418541842820.1242314353570.1242314353570.1242314353570.1980515609080.145496546870.131562072540.135756288388K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22002-0.0278920620036-0.0009690231585740.01350788724790.007626753120390.1689435344950.144526685430.144526685430.144526685430.1968355964990.1454957085890.1310187981820.13689993231K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22003-0.0847106610641-0.0503854723293-0.0367104031183-0.04147782944660.1009965522260.09173194232210.09173194232210.09173194232210.185707213290.1421174146510.128442345440.133209771769K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A220040.06990808812660.05918087609440.07471009904140.07114729478380.2525312609940.2016167331380.2016167331380.2016167331380.1826231728680.1424358570430.1269066340960.130469438354K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002G 万科A220050.01272703222580.02718081671830.03292151301270.02965388284070.1733432623390.1477344847860.1477344847860.1477344847860.1606162301130.1205536680680.1148129717730.118080601945K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A220060.144844511730.1089235410950.1143934296050.1096759215250.2845283361150.2215041335530.2214833317150.2214833317150.1396838243850.1125805924580.107089902110.11180741019K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22007-0.004338405918130.01371947865170.02047935490240.01371947865170.2052609588730.1703041630630.1703041630630.1703041630630.2095993647910.1565846844110.149824808160.156584684411K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A220080.009099552065420.04666568227660.05289614039570.04666568227660.2012757339150.1675516521580.1675516521580.1675516521580.1921761818490.1208859698810.1146555117620.120885969881K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22009-0.0589597221215-0.00554218847642-0.00730496680734-0.005542188476420.2007032545180.167154751820.1598939467440.167154751820.259662976640.1726969402960.1671989135510.172696940296K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22010-0.01013586572680.01367236272620.007691049018930.01367236272620.2126689984580.1753726686580.1627589217750.1753726686580.2228048641850.1617003059320.1550678727560.161700305932K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22011-0.0460762558651-0.0163093992193-0.0109022569937-0.01630939921930.1307006706960.1155926356850.113481275280.1155926356850.1767769265610.1319020349040.1243835322740.131902034904K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22012-0.04119910873820.001120091788570.007231225961290.001120091788570.1601529213840.1380446650030.134952497340.1380446650030.2013520301220.1369245732140.1277212713790.136924573214K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22013-0.0705827965914-0.0397654326127-0.034846462853-0.03976543261270.1020269952180.09258121231220.08974054974870.09258121231220.1726097918090.1323466449250.1245870126020.132346644925K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22014-0.002680916266530.006836752050980.01596428478050.006836752050980.1407138607340.123355966450.1212672264380.123355966450.1433947770.1165192143990.1053029416580.116519214399K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22015-0.0879239970443-0.0565497243595-0.0461058275355-0.05654972435950.09528567271810.0869961829060.08465237423780.0869961829060.1832096697620.1435459072650.1307582017730.143545907265K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22016-0.124114710188-0.069787032393-0.0700546823877-0.0697870323930.1170349536590.1047728661270.0956933700520.1047728661270.2411496638470.174559898520.165748052440.17455989852K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22017-0.0543752274747-0.0101792220392-0.00648763394271-0.01017922203920.1756622861530.149415600230.1410103762760.149415600230.2300375136280.1595948222690.1474980102180.159594822269K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22018-0.0828428336931-0.0295694236324-0.0235634293498-0.02956942363240.1405930473630.1232631109650.1149225015990.1232631109650.2234358810560.1528325345980.1384859309490.152832534598K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22019-0.120436018639-0.0529435124957-0.0314475727391-0.05294351249570.1062805470060.09607015805640.09233824618390.09607015805640.2267165656450.1490136705520.1237858189230.149013670552K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22020-0.098606191047-0.0447752112068-0.0369241051338-0.04477521120680.1166290191820.1044474191320.09932840515880.1044474191320.2152352102290.1492226303390.1362525102930.149222630339K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22021-0.0821109093495-0.0492510314498-0.0402137782969-0.04925103144980.08347042933950.07703987767380.07258108523780.07703987767380.1655813386890.1262909091240.1127948635350.126290909124K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22022-0.076002527072-0.0431842995836-0.0324503973337-0.04318429958360.08470042050270.07808646415340.07650264655760.07808646415340.1607029475750.1212707637370.1089530438910.121270763737K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22023-0.108398860288-0.0622285454825-0.0497221982463-0.06222854548250.07103997751490.06632803537330.06442008596250.06632803537330.1794388378030.1285565808560.1141422842090.128556580856K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22024-0.102246330975-0.0563786593039-0.0472609380051-0.05637865930390.07358574924130.06854203243040.06531292352610.06854203243040.1758320802160.1249206917340.1125738615310.124920691734K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000002万科A22025-0.119077985781-0.0697329982859-0.0635237939557-0.06973299828590.07052887307660.06588227076390.06027766220010.06588227076390.1896068588570.135615269050.1238014561560.13561526905K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004北大高科420010.3706733865170.212317415478—0.04250153378490.7020306029070.412466498374—0.2203475504780.331357216390.2001490828970.1675843345830.177846016693G54道路运输业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004北大高科420020.1090780833110.0901028423407-0.0530039048971-0.05869213102690.3749002580970.2726745128520.09818492566930.09818492566930.2658221747860.1825716705120.1511888305660.156877056696G54道路运输业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004北大高科42003-0.03426531814580.001779386278690.01967377019050.01522807458040.2088831850150.1727902146410.1727902146410.1727902146410.2431485031610.1710108283630.1531164444510.157562140061G54道路运输业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004北大高科42004-0.102405283901-0.0564687130813-0.173192331257-0.04535355740270.1116062471130.100400881520.100400881520.100400881520.2140115310150.1568695946010.2735932127770.145754438923G54道路运输业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技420050.05520739539740.05806001688520.07125564924090.06192731031720.2574003108130.2047083244690.2047083244690.2047083244690.2021929154160.1466483075840.1334526752280.142781014152G54道路运输业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42011-0.1387471738390.02240404002670.03580145802920.02240404002670.4104673657370.2910151455530.2910151455530.2910151455530.5492145395760.2686111055260.2552136875230.268611105526C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42012-0.07360500863240.03401961720740.04852481925690.03401961720740.4113803870470.2914737875220.2914737875220.2914737875220.4849853956790.2574541703150.2429489682650.257454170315C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42013-0.02757963895540.01857513335110.02563673636280.01857513335110.3041185814860.2331985647650.2331985647650.2331985647650.3316982204420.2146234314140.2075618284030.214623431414C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42014-0.151200078475-0.074014072784-0.0670175658507-0.0740140727840.1338771540030.1180702455560.1180702455560.1180702455560.2850772324780.192084318340.1850878114060.19208431834C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42015-0.161222046432-0.0742499702768-0.0620002204041-0.07424997027680.1483964506950.1292205758780.1292205758780.1292205758780.3096184971270.2034705461550.1912207962820.203470546155C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技420160.5164697194510.2571109516830.2419890430360.2571109516830.8249637103090.4520438985440.4282986183120.4520438985440.3084939908580.1949329468610.1863095752760.194932946861C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技420170.3406902234620.2076529115580.1936230575150.2076529115580.6490549320520.3935920626030.3723207933490.3935920626030.308364708590.1859391510450.1786977358340.185939151045C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42018-0.121638144258-0.0381730780169-0.0266124381624-0.03817307801690.1621690420980.1395399775970.1395399775970.1395399775970.2838071863560.1777130556140.1661524157590.177713055614C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国农科技42019-0.141432540087-0.0789467827609-0.0605436882905-0.07894678276090.1097864584920.09892575067210.09882799158780.09892575067210.2512189985790.1778725334330.1593716798780.177872533433C27医药制造业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国华网安42020-0.333206270377-0.140563502733-0.116007704608-0.1405635027330.1302432809220.1152347314250.1151230597080.1152347314250.4634495512990.2557982341580.2311307643160.255798234158I65软件和信息技术服务业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国华网安42021-0.320277127303-0.104433538484-0.0865003719456-0.1044335384840.1800490710360.152577613470.147928081990.152577613470.5003261983390.2570111519540.2344284539350.257011151954I65软件和信息技术服务业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国华网安42023-0.194913963581-0.0402446569857-0.0206586061448-0.04024465698570.2930651376620.2266437545380.2174408439520.2266437545380.4879791012430.2668884115240.2380994500970.266888411524I65软件和信息技术服务业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000004国华网安42024-0.127675697432-0.01312573397040.0104751748383-0.01312573397040.3023745672780.2321717383580.2261787065010.2321717383580.430050264710.2452974723280.2157035316630.245297472328I65软件和信息技术服务业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52000-0.181118310852-0.133669524305-0.119345013348-0.117361777330.01462263930360.01441189929850.01441011770860.01441011770860.1957409501560.1480814236030.1337551310570.131771895039S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52001-0.144783526472-0.108286451909-0.0975413057902-0.09860966313650.03076237165210.02984429049620.02984241970060.02984241970060.1755458981240.1381307424050.1273837254910.128452082837S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52002-0.168973242723-0.127543999045-0.117446198401-0.1207822043150.01533062019990.01509914100380.01509716357810.01509716357810.1843038629230.1426431400480.1325433619790.135879367893S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52008-0.124208777256-0.0985442495621-0.099081483237-0.09854424956210.02365547415230.02310882396430.01676591017240.02310882396430.1478642514080.1216530735260.1158473934090.121653073526S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52009-0.188671451168-0.13055821715-0.133837607082-0.130558217150.03452670304050.0333743952080.02186357761470.0333743952080.2231981542090.1639326123580.1557011846960.163932612358S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52010-0.353533991416-0.163134681179-0.15815643091-0.1631346811790.01483521836260.01461835191980.009929752266090.01461835191980.3683692097790.1777530330990.1680861831760.177753033099S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52011-0.263973639922-0.153646981761-0.142794892244-0.1536469817610.01309397603750.01292473980420.008106532475450.01292473980420.277067615960.1665717215650.150901424720.166571721565S90综合广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52012-0.191317040576-0.126989284189-0.117786902508-0.1269892841890.01003498954660.009935289025060.009934368870650.009935289025060.2013520301220.1369245732140.1277212713790.136924573214K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52013-0.132838243526-0.0940963693242-0.115791246174-0.09409636932420.03977154828360.03825027560070.00964794669970.03825027560070.1726097918090.1323466449250.1245870126020.132346644925K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52014-0.100743332976-0.0756125007812-0.0942354783338-0.07561250078120.04265144402390.04090671361780.01106746332420.04090671361780.1433947770.1165192143990.1053029416580.116519214399K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52015-0.102957598973-0.0692557735459-0.0728172689718-0.06925577354590.08025207078980.07429013371960.05794093280160.07429013371960.1832096697620.1435459072650.1307582017730.143545907265K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52016-0.172310892853-0.117861763939-0.12380787407-0.1178617639390.03116230585210.0302205634120.01464872866980.0302205634120.2034731987050.1480823273510.138456602740.148082327351N77生态保护和环境治理业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52017-0.136750433675-0.0997767513385-0.101604457899-0.09977675133850.0308214235970.02989986712680.01696566231820.02989986712680.1675718572720.1296766184650.1185701202170.129676618465N77生态保护和环境治理业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52018-0.162952616596-0.115763866033-0.113121962125-0.1157638660330.02217500941320.02169394595740.01127740965510.02169394595740.1851276260090.1374578119910.124399371780.137457811991N77生态保护和环境治理业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52019-0.120072401371-0.0874378609625-0.0887506440734-0.08743786096250.03844717169110.037023714580.02159180548410.037023714580.1585195730620.1244615755430.1103424495580.124461575543N77生态保护和环境治理业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000005世纪星源52020-0.177267239998-0.10475795436-0.102117372567-0.104757954360.05931760696480.05599605498370.0398918930.05599605498370.2365848469630.1607540093440.1420092655670.160754009344N77生态保护和环境治理业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62000-0.0563728839794-0.01712030810530.002089313184930.002995802509670.1235179252170.1099385443210.1099385443210.1099385443210.1798908091970.1270588524270.1078492311360.106942741812K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62001-0.0490485257199-0.0158162669885-0.00260311585341-0.006797331702370.1490030351880.1296802798820.1289589566860.1289589566860.1980515609080.145496546870.131562072540.135756288388K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62002-0.01438407904610.008803655706690.02267915885460.01679802472710.1824515174530.1542993642950.1536979570370.1536979570370.1968355964990.1454957085890.1310187981820.13689993231K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62003-0.0744832045832-0.0420259768899-0.0364786243751-0.03419002881030.1112240087070.1000914377610.09196372106530.09901974295840.185707213290.1421174146510.128442345440.133209771769K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62004-0.01400219607920.001854704343060.01725782494620.01369502068860.1686209767890.1442905613860.1441644590420.1441644590420.1826231728680.1424358570430.1269066340960.130469438354K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006G 深振业620050.0613541527940.06109589235690.06683388994170.06356625976970.2219703829070.1816495604250.1816468617150.1816468617150.1606162301130.1205536680680.1148129717730.118080601945K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62006-0.0151758010653-0.001858373729610.00363231661889-0.001085191461020.124508023320.1107222187280.1107222187280.1107222187280.1396838243850.1125805924580.107089902110.11180741019K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62007-0.0894667079082-0.0493360865376-0.0425762102869-0.04933608653760.1201326568830.1072485978730.1072485978730.1072485978730.2095993647910.1565846844110.149824808160.156584684411K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62008-0.165156369069-0.0945770200018-0.0883465618826-0.09457702000180.02701981277970.02630894987950.02630894987950.02630894987950.1921761818490.1208859698810.1146555117620.120885969881K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62009-0.142719904228-0.0679977167634-0.0624996900182-0.06799771676340.1169430724120.1046992235330.1046992235330.1046992235330.259662976640.1726969402960.1671989135510.172696940296K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620100.01830103802650.03256667948990.03919911266540.03256667948990.2411059022120.1942669854220.1942669854220.1942669854220.2228048641850.1617003059320.1550678727560.161700305932K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62011-0.0888602131394-0.0510900459555-0.0435715433254-0.05109004595550.08791671342180.08081198894840.08081198894840.08081198894840.1767769265610.1319020349040.1243835322740.131902034904K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620120.042436853950.05908046204110.06828376387620.05908046204110.2437888840720.1960050352550.1960050352550.1960050352550.2013520301220.1369245732140.1277212713790.136924573214K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620130.08645558508050.07341342253870.07669137518810.07341342253870.259065376890.2057600674640.201278387790.2057600674640.1726097918090.1323466449250.1245870126020.132346644925K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62014-0.0122559087755-0.0005839637338170.00157118182935-0.0005839637338170.1311388682250.1159352506650.1068741234870.1159352506650.1433947770.1165192143990.1053029416580.116519214399K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62015-0.0203964001795-0.003529213406040.00563860569313-0.003529213406040.1628132695830.1400166938590.1363968074660.1400166938590.1832096697620.1435459072650.1307582017730.143545907265K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深圳业A620160.04222706735910.04624567190650.03954266832460.04624567190650.2833767312060.2208055704270.2052907207640.2208055704270.2411496638470.174559898520.165748052440.17455989852K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620170.06891333395470.07055310683760.07639600878450.07055310683760.2989508475830.2301479291070.2238940190030.2301479291070.2300375136280.1595948222690.1474980102180.159594822269K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620180.145710419150.1167853288480.1267401288040.1167853288480.3691463002060.2696178634460.2652260597530.2696178634460.2234358810560.1528325345980.1384859309490.152832534598K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620190.01228164867010.04388266420720.06548609627950.04388266420720.2389982143150.1928963347590.1892719152020.1928963347590.2267165656450.1490136705520.1237858189230.149013670552K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62020-0.0708176023427-0.0230295283709-0.0149359964981-0.02302952837090.1444176078860.1261931019680.1213165137950.1261931019680.2152352102290.1492226303390.1362525102930.149222630339K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62021-0.0228046669988-0.00135252419927-0.00204309874146-0.001352524199270.142776671690.1249383849240.1107517647930.1249383849240.1655813386890.1262909091240.1127948635350.126290909124K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620220.04835015482670.05163570495850.06063617678540.05163570495850.2090531024010.1729064686950.1695892206770.1729064686950.1607029475750.1212707637370.1089530438910.121270763737K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62023-0.004638759750960.02023475931970.02344822561310.02023475931970.1748000780520.1487913401760.1375905098220.1487913401760.1794388378030.1285565808560.1141422842090.128556580856K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A620240.02993153263580.04572935165610.04251149485670.04572935165610.2057636128520.170650043390.1550853563880.170650043390.1758320802160.1249206917340.1125738615310.124920691734K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000006深振业A62025-0.006302084628130.01929391260910.02001416462070.01929391260910.1833047742290.1549091816590.1438156207760.1549091816590.1896068588570.135615269050.1238014561560.13561526905K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007深达声A72000-0.144746289164-0.093107535144-0.0741060263019-0.07319953697710.03514452003310.03395131728280.03374320483460.03374320483460.1798908091970.1270588524270.1078492311360.106942741812K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007深达声A72002-0.106500695601-0.0626451084437-0.12748266617-0.05455710148620.09033490089830.08285060014480.003536132012340.08234283082330.1968355964990.1454957085890.1310187981820.13689993231K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007深达声A72003-0.104679717276-0.067163265647-0.103730710081-0.05937047873260.08102749601410.07495414900440.02471163535910.0738392930360.185707213290.1421174146510.128442345440.133209771769K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007深达声A72004-0.107295722324-0.0723851478331-0.121661481169-0.0607048739350.07532745054370.07005070921010.005245152927370.06976456441880.1826231728680.1424358570430.1269066340960.130469438354K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007深达声A72005-0.136783085795-0.0972753199794-0.109823615681-0.09515342335230.02383314431790.02327834808840.004989356092860.02292717859310.1606162301130.1205536680680.1148129717730.118080601945K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007深达声A72006-0.11063189618-0.0843488507853-0.0875998048238-0.08394793349220.0290519282050.02823174167280.01949009728580.02785947669730.1396838243850.1125805924580.107089902110.11180741019K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007零七股份720120.1768774730010.113474115799-0.01458514451960.1134741157990.4005607240980.2860002549020.1453588558220.2860002549020.2236832510960.1725261391030.1599440003410.172526139103H61住宿业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007零七股份720130.2935475623960.1761585562390.04153991575360.1761585562390.5226737677130.3432605058260.1942137784520.3432605058260.2291262053170.1671019495860.1526738626980.167101949586H61住宿业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007零七股份72014-0.17853759127-0.0953303147672-0.0929523947815-0.09533031476720.1232603096870.1097344120720.1093488660210.1097344120720.3017979009570.2050647268390.2023012608020.205064726839H61住宿业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007全新好720150.4318091176330.2030587250410.2074292407020.2030587250410.8372956818550.45572179270.4551466901030.45572179270.4054865642230.2526630676590.24771744940.252663067659H61住宿业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007全新好72016-0.116559735075-0.0640499158013-0.0576886664707-0.06404991580130.1280831268890.1135405040960.1135405040960.1135405040960.2446428619640.1775904198970.1712291705670.177590419897H61住宿业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007全新好72017-0.209602912782-0.139569432275-0.12752034009-0.1395694322750.02043460084570.02002538999430.01997767012830.02002538999430.2300375136280.1595948222690.1474980102180.159594822269K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007全新好72018-0.211039568667-0.14058800917-0.126335956201-0.140588009170.01304899131290.01288090845040.01214997474810.01288090845040.2234358810560.1528325345980.1384859309490.152832534598K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com
000007全新好72019-0.0530992583576-0.00108017791444-0.0417954685885-0.001080177914440.1736173072870.1479334926380.08199035033450.1479334926380.2267165656450.1490136705520.1237858189230.149013670552K70房地产业广东省440000深圳市440300更多数据尽在丘知数据分析会员之家:www.qqrdata.com

代码公开披露

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

//更多数据尽在丘知数据分析会员之家:www.qqrdata.com
//导入数据
use 原始数据,clear
label data "更多数据尽在丘知数据分析会员之家:www.qqrdata.com"

//剔除B股
drop if substr(证券代码, 1, 3)=="200" |  substr(证券代码, 1, 3)=="900" 
label variable 丘知数据分析会员之家 "www.qqrdata.com"

///更多stata学习资料尽在丘知数据分析会员之家,网址:www.qqrdata.com
//公司实际持有的现金水平等于货币资金与短期投资净额之和占净资产的比值,净资产等于总资产减去货币资金和短期投资净额的差额/////////
gen 现金持有水平1=(货币资金+短期投资净额)/(资产总计-货币资金-短期投资净额)

//公司实际持有的现金水平等于货币资金与短期投资净额之和占总资产的比值/////////
gen 现金持有水平2=(货币资金+短期投资净额)/资产总计

//更多数据尽在丘知数据分析会员之家:www.qqrdata.com
//公司实际持有的现金水平现金及现金等价物除以总资产,现金及现金等价物来自于现金流量表,包括库存现金、银行存款以及两者的等价物/////////
gen 现金持有水平3=现金及现金等价物/资产总计

//公司实际持有的现金水平货币资金除以总资产,货币资金除了包括现金及现金等价物之外,还包括一些限制使用的现金或特殊的货币等价物
gen 现金持有水平4=货币资金/资产总计

///更多stata学习资料尽在丘知数据分析会员之家,网址:www.qqrdata.com
//行业以证监会2012行业划分标准,除了制造业用二级行业分类,其余行业用一级分类
gen Industry=substr(行业代码, 1, 1)
replace Industry=substr(行业代码, 1, 3) if Industry=="C"
label variable 丘知数据分析会员之家 "www.qqrdata.com"

//计算行业均值