## 一、数据简介 **请注意:该表不是日频数据,不能直接作为因子使用。该表适合对财务数据有深入研究的用户,日频财务数据的加工方法见文末“通用文档”。** 营运能力财务指标是用来衡量企业在日常经营活动中管理资源的效率和效果的指标。它们能够反映企业的资产使用效率和流动性,帮助投资者、管理层和分析师评估企业的运营状况。 - 数据起始时间:2010-01-04 - 数据结束时间:2026-11-16 - 数据更新频率:不定期,上市公司发布相关公告时更新 ## 二、主键说明 | 关键字 | 释意 | | --- | --- | | date | 公告日,表示站在这一天能看到的财务数据(`shift = 0` 为当时最新一期),不是报告期(报告期见 report_date),可能不是交易日;与 cn_stock_financial_changedate 中的 changedate 对应,详见文末“通用文档” | | instrument | 股票代码 | | report_date | 财务报告期,规则见文末“通用文档” | | shift | 偏移期,站在 date 这一天,向前偏移 n 期的财务数据,0 为当时最新一期,单位为季度 | ## 三、字段说明 字段名由下表的英文字段加后缀组成,后缀表示取数口径:_lf 最新一期,_mrq 单季度,_ttm 滚动十二期。不是每个指标都有三种后缀,具体字段以表结构为准。 | 中文名 | 英文字段 | 中文公式 | 英文公式 | | --- | --- | --- | --- | | 存货周转率 | `inventory_turnover` | `营业成本 / 平均存货` | `operating_costs / avg_inventory` | | 应收账款周转率 | `accounts_receivable_turnover` | `营业收入 / 平均应收账款` | `operating_revenue / avg_accounts_receivable` | | 应收票据及应收账款周转率 | `notes_and_accounts_receivable_turnover` | `营业收入 / 平均应收账款及应收票据` | `operating_revenue / avg_notes_and_accounts_receivable` | | 应收账款及合同资产周转率 | `accounts_receivable_contract_assets_turnover` | `营业收入 / 平均应收账款及合同资产` | `operating_revenue / avg_accounts_receivable_and_contract_assets` | | 应付账款周转率 | `accounts_payable_turnover` | `营业成本 / 平均应付账款` | `operating_costs / avg_accounts_payable` | | 应付票据及应付账款周转率 | `notes_and_accounts_payable_turnover` | `营业成本 / 平均应付票据及应付账款` | `operating_costs / avg_notes_and_accounts_payable` | | 预收款项及合同负债周转率 | `advances_and_contract_liab_turnover` | `营业成本 / 平均预收款项及合同负债` | `operating_costs / avg_advances_and_contract_liabilities` | | 流动资产周转率 | `current_assets_turnover` | `营业总收入 / 平均流动资产` | `total_operating_revenue / avg_current_assets` | | 非流动资产周转率 | `noncurr_assets_turnover` | `营业总收入 / 平均非流动资产` | `total_operating_revenue / avg_noncurrent_assets` | | 营运资本周转率 | `working_capital_turnover` | `营业总收入 / 平均营运资本` | `total_operating_revenue / avg_working_capital` | | 固定资产周转率 | `fix_assets_turnover` | `营业总收入 / 平均固定资产` | `total_operating_revenue / avg_fixed_assets` | | 无形资产周转率 | `intangible_assets_turnover` | `营业总收入 / 平均无形资产` | `total_operating_revenue / avg_intangible_assets` | | 总资产周转率 | `total_assets_turnover` | `营业总收入 / 平均总资产` | `total_operating_revenue / avg_total_assets` | | 净资产周转率 | `net_assets_turnover` | `营业总收入 / 平均净资产` | `total_operating_revenue / avg_net_assets` | | 存货周转天数 | `inventory_turnover_days` | `天数 / 存货周转率` | `days / inventory_turnover` | | 应收账款周转天数 | `accounts_receivable_turnover_days` | `天数 / 应收账款周转率` | `days / accounts_receivable_turnover` | | 应收账款及应收票据周转天数 | `notes_and_accounts_receivable_turnover_days` | `天数 / 应收账款及应收票据周转率` | `days / notes_and_accounts_receivable_turnover` | | 应收账款及合同资产周转天数 | `accounts_receivable_contract_assets_turnover_days` | `天数 / 应收账款及合同资产周转率` | `days / accounts_receivable_contract_assets_turnover` | | 应付账款周转天数 | `accounts_payable_turnover_days` | `天数 / 应付账款周转率` | `days / accounts_payable_turnover` | | 应付票据及应付账款周转天数 | `notes_and_accounts_payable_turnover_days` | `天数 / 应付票据及应付账款周转率` | `days / notes_and_accounts_payable_turnover` | | 预收款项及合同负债周转天数 | `advances_and_contract_liab_turnover_days` | `天数 / 预收款项及合同负债周转率` | `days / advances_and_contract_liab_turnover` | | 流动资产周转天数 | `current_assets_turnover_days` | `天数 / 流动资产周转率` | `days / current_assets_turnover` | | 非流动资产周转天数 | `noncurr_assets_turnover_days` | `天数 / 非流动资产周转率` | `days / noncurr_assets_turnover` | | 固定资产周转天数 | `fix_assets_turnover_days` | `天数 / 固定资产周转率` | `days / fix_assets_turnover` | | 无形资产周转天数 | `intangible_assets_turnover_days` | `天数 / 无形资产周转率` | `days / intangible_assets_turnover` | | 总资产周转天数 | `total_assets_turnover_days` | `天数 / 总资产周转率` | `days / total_assets_turnover` | | 营运资本周转天数 | `working_capital_turnover_days` | `天数 / 营运资本周转率` | `days / working_capital_turnover` | | 净资产周转天数 | `net_assets_turnover_days` | `天数 / 净资产周转率` | `days / net_assets_turnover` | | 营业周期 | `operating_cycle` | `存货周转天数 + 应收账款周转天数` | `inventory_turnover_days + accounts_receivable_turnover_days` | | 净营业周期 | `net_operating_cycle` | `应收账款周转天数 + 存货周转天数 - 应付账款周转天数` | `accounts_receivable_turnover_days + inventory_turnover_days - accounts_payable_turnover_days` | ## 四、示例数据 2026-11-12 至 2026-11-19 的数据,字段较多,只展示 7 个字段,按日期、股票代码、报告期排序,展示前 5 行和后 5 行。 | date | instrument | report_date | shift | inventory_turnover_lf | accounts_receivable_turnover_lf | notes_and_accounts_receivable_turnover_lf | accounts_receivable_contract_assets_turnover_lf | accounts_payable_turnover_lf | notes_and_accounts_payable_turnover_lf | advances_and_contract_liab_turnover_lf | current_assets_turnover_lf | noncurr_assets_turnover_lf | working_capital_turnover_lf | fix_assets_turnover_lf | intangible_assets_turnover_lf | total_assets_turnover_lf | net_assets_turnover_lf | inventory_turnover_days_lf | accounts_receivable_turnover_days_lf | notes_and_accounts_receivable_turnover_days_lf | accounts_receivable_contract_assets_turnover_days_lf | accounts_payable_turnover_days_lf | notes_and_accounts_payable_turnover_days_lf | advances_and_contract_liab_turnover_days_lf | current_assets_turnover_days_lf | noncurr_assets_turnover_days_lf | working_capital_turnover_days_lf | fix_assets_turnover_days_lf | intangible_assets_turnover_days_lf | total_assets_turnover_days_lf | net_assets_turnover_days_lf | operating_cycle_lf | net_operating_cycle_lf | inventory_turnover_mrq | accounts_receivable_turnover_mrq | notes_and_accounts_receivable_turnover_mrq | accounts_receivable_contract_assets_turnover_mrq | accounts_payable_turnover_mrq | notes_and_accounts_payable_turnover_mrq | advances_and_contract_liab_turnover_mrq | current_assets_turnover_mrq | noncurr_assets_turnover_mrq | working_capital_turnover_mrq | fix_assets_turnover_mrq | intangible_assets_turnover_mrq | total_assets_turnover_mrq | net_assets_turnover_mrq | inventory_turnover_days_mrq | accounts_receivable_turnover_days_mrq | notes_and_accounts_receivable_turnover_days_mrq | accounts_receivable_contract_assets_turnover_days_mrq | accounts_payable_turnover_days_mrq | notes_and_accounts_payable_turnover_days_mrq | advances_and_contract_liab_turnover_days_mrq | current_assets_turnover_days_mrq | noncurr_assets_turnover_days_mrq | working_capital_turnover_days_mrq | fix_assets_turnover_days_mrq | intangible_assets_turnover_days_mrq | total_assets_turnover_days_mrq | net_assets_turnover_days_mrq | operating_cycle_mrq | net_operating_cycle_mrq | inventory_turnover_ttm | accounts_receivable_turnover_ttm | notes_and_accounts_receivable_turnover_ttm | accounts_receivable_contract_assets_turnover_ttm | accounts_payable_turnover_ttm | notes_and_accounts_payable_turnover_ttm | advances_and_contract_liab_turnover_ttm | current_assets_turnover_ttm | noncurr_assets_turnover_ttm | working_capital_turnover_ttm | fix_assets_turnover_ttm | intangible_assets_turnover_ttm | total_assets_turnover_ttm | net_assets_turnover_ttm | inventory_turnover_days_ttm | accounts_receivable_turnover_days_ttm | notes_and_accounts_receivable_turnover_days_ttm | accounts_receivable_contract_assets_turnover_days_ttm | accounts_payable_turnover_days_ttm | notes_and_accounts_payable_turnover_days_ttm | advances_and_contract_liab_turnover_days_ttm | current_assets_turnover_days_ttm | noncurr_assets_turnover_days_ttm | working_capital_turnover_days_ttm | fix_assets_turnover_days_ttm | intangible_assets_turnover_days_ttm | total_assets_turnover_days_ttm | net_assets_turnover_days_ttm | operating_cycle_ttm | net_operating_cycle_ttm | |:--------------------|:-------------|:--------------------|--------:|------------------------:|----------------------------------:|--------------------------------------------:|--------------------------------------------------:|-------------------------------:|-----------------------------------------:|-----------------------------------------:|-----------------------------:|-----------------------------:|------------------------------:|-------------------------:|--------------------------------:|---------------------------:|-------------------------:|-----------------------------:|---------------------------------------:|-------------------------------------------------:|-------------------------------------------------------:|------------------------------------:|----------------------------------------------:|----------------------------------------------:|----------------------------------:|----------------------------------:|-----------------------------------:|------------------------------:|-------------------------------------:|--------------------------------:|------------------------------:|---------------------:|-------------------------:|-------------------------:|-----------------------------------:|---------------------------------------------:|---------------------------------------------------:|--------------------------------:|------------------------------------------:|------------------------------------------:|------------------------------:|------------------------------:|-------------------------------:|--------------------------:|---------------------------------:|----------------------------:|--------------------------:|------------------------------:|----------------------------------------:|--------------------------------------------------:|--------------------------------------------------------:|-------------------------------------:|-----------------------------------------------:|-----------------------------------------------:|-----------------------------------:|-----------------------------------:|------------------------------------:|-------------------------------:|--------------------------------------:|---------------------------------:|-------------------------------:|----------------------:|--------------------------:|-------------------------:|-----------------------------------:|---------------------------------------------:|---------------------------------------------------:|--------------------------------:|------------------------------------------:|------------------------------------------:|------------------------------:|------------------------------:|-------------------------------:|--------------------------:|---------------------------------:|----------------------------:|--------------------------:|------------------------------:|----------------------------------------:|--------------------------------------------------:|--------------------------------------------------------:|-------------------------------------:|-----------------------------------------------:|-----------------------------------------------:|-----------------------------------:|-----------------------------------:|------------------------------------:|-------------------------------:|--------------------------------------:|---------------------------------:|-------------------------------:|----------------------:|--------------------------:| | 2026-11-13 00:00:00 | 688981.SH | 2016-12-31 00:00:00 | 39 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | | 2026-11-13 00:00:00 | 688981.SH | 2017-12-31 00:00:00 | 35 | nan | nan | 16.0548 | nan | nan | 15.4349 | 84.0033 | 1.3835 | 0.748942 | 2.41047 | 1.3993 | nan | 0.485904 | 0.866496 | nan | nan | 22.4232 | nan | nan | 23.3237 | 4.28555 | 260.209 | 480.678 | 149.349 | 257.272 | nan | 740.887 | 415.466 | nan | nan | nan | nan | 13.8674 | nan | nan | 13.455 | 73.2275 | 1.19514 | 0.646973 | 2.08228 | 1.20878 | nan | 0.419748 | 0.748522 | nan | nan | 6.49002 | nan | nan | 6.68898 | 1.22905 | 75.3051 | 139.109 | 43.2219 | 74.4552 | nan | 214.414 | 120.237 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | | 2026-11-13 00:00:00 | 688981.SH | 2018-06-30 00:00:00 | 33 | nan | nan | nan | nan | nan | nan | 6.70059 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | 26.8633 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | -77.3027 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | -1.16425 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | | 2026-11-13 00:00:00 | 688981.SH | 2018-12-31 00:00:00 | 31 | nan | nan | nan | nan | nan | nan | 80.8105 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | 4.45486 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | 74.9556 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | 1.20071 | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | | 2026-11-13 00:00:00 | 688981.SH | 2019-03-31 00:00:00 | 30 | nan | nan | 3.04944 | nan | nan | 3.43833 | 17.1324 | 0.194357 | 0.139383 | 0.338178 | 0.29649 | nan | 0.0811713 | 0.132035 | nan | nan | 29.5136 | nan | nan | 26.1755 | 5.25319 | 463.065 | 645.701 | 266.132 | 303.551 | nan | 1108.77 | 681.637 | nan | nan | nan | nan | 3.04944 | nan | nan | 3.43833 | 17.1324 | 0.194357 | 0.139383 | 0.338178 | 0.29649 | nan | 0.0811713 | 0.132035 | nan | nan | 29.5136 | nan | nan | 26.1755 | 5.25319 | 463.065 | 645.701 | 266.132 | 303.551 | nan | 1108.77 | 681.637 | nan | nan | nan | nan | 16.3051 | nan | nan | 17.7666 | 88.5271 | 1.03929 | 0.745328 | 1.80835 | 1.58543 | nan | 0.434049 | 0.706034 | nan | nan | 22.079 | nan | nan | 20.2627 | 4.06655 | 346.39 | 483.009 | 199.077 | 227.068 | nan | 829.399 | 509.89 | nan | nan | | 2026-11-16 00:00:00 | 301378.SZ | 2025-09-30 00:00:00 | 4 | 2.47217 | 1.98903 | 1.94179 | 1.43482 | 1.10681 | 1.10681 | 2.20123 | 0.252769 | 0.418757 | 0.340912 | 1.87807 | 1.53688 | 0.157624 | 0.188877 | 84.9457 | 105.579 | 108.148 | 146.36 | 189.735 | 189.735 | 95.401 | 830.797 | 501.485 | 615.995 | 111.817 | 136.64 | 1332.28 | 1111.84 | 190.525 | 0.789765 | 0.854937 | 0.775615 | 0.757193 | 0.559503 | 0.382761 | 0.382761 | 0.761241 | 0.0985666 | 0.163293 | 0.132938 | 0.732347 | 0.599304 | 0.0614651 | 0.0736519 | 105.271 | 116.037 | 118.86 | 160.857 | 235.134 | 235.134 | 118.228 | 913.088 | 551.157 | 677.01 | 122.893 | 150.174 | 1464.25 | 1221.97 | 221.308 | -13.8259 | 3.90421 | 3.2185 | 3.14206 | 2.32172 | 1.74794 | 1.74794 | 3.47633 | 0.409013 | 0.677602 | 0.551639 | 3.03895 | 2.48687 | 0.255056 | 0.305626 | 92.2082 | 111.853 | 114.575 | 155.058 | 205.957 | 205.957 | 103.557 | 880.168 | 531.286 | 652.601 | 118.462 | 144.76 | 1411.45 | 1177.91 | 204.062 | -1.89507 | | 2026-11-16 00:00:00 | 301378.SZ | 2025-12-31 00:00:00 | 3 | 3.57079 | 3.0685 | 3.06707 | 2.35181 | 1.66567 | 1.66567 | 2.32737 | 0.365487 | 0.625692 | 0.525584 | 1.47836 | 2.28905 | 0.230717 | 0.286802 | 100.818 | 117.321 | 117.376 | 153.074 | 216.129 | 216.129 | 154.681 | 984.988 | 575.363 | 684.952 | 243.513 | 157.27 | 1560.35 | 1255.22 | 218.139 | 2.01051 | 1.31743 | 0.983017 | 0.98256 | 0.75342 | 0.614545 | 0.614545 | 0.858678 | 0.117087 | 0.200445 | 0.168375 | 0.473604 | 0.733317 | 0.0739121 | 0.0918792 | 68.3147 | 91.5549 | 91.5975 | 119.455 | 146.45 | 146.45 | 104.812 | 768.662 | 449 | 534.521 | 190.032 | 122.73 | 1217.66 | 979.547 | 159.87 | 13.4198 | 3.57079 | 3.0685 | 3.06707 | 2.35181 | 1.66567 | 1.66567 | 2.32737 | 0.365487 | 0.625692 | 0.525584 | 1.47836 | 2.28905 | 0.230717 | 0.286802 | 100.818 | 117.321 | 117.376 | 153.074 | 216.129 | 216.129 | 154.681 | 984.988 | 575.363 | 684.952 | 243.513 | 157.27 | 1560.35 | 1255.22 | 218.139 | 2.01051 | | 2026-11-16 00:00:00 | 301378.SZ | 2026-03-31 00:00:00 | 2 | 0.621763 | 0.617913 | 0.617779 | 0.48101 | 0.344253 | 0.344253 | 0.373007 | 0.0695813 | 0.119024 | 0.104508 | 0.289474 | 0.431871 | 0.043911 | 0.0558623 | 144.75 | 145.652 | 145.683 | 187.106 | 261.435 | 261.435 | 241.282 | 1293.45 | 756.151 | 861.178 | 310.909 | 208.396 | 2049.6 | 1611.1 | 290.401 | 28.9661 | 0.621763 | 0.617913 | 0.617779 | 0.48101 | 0.344253 | 0.344253 | 0.373007 | 0.0695813 | 0.119024 | 0.104508 | 0.289474 | 0.431871 | 0.043911 | 0.0558623 | 144.75 | 145.652 | 145.683 | 187.106 | 261.435 | 261.435 | 241.282 | 1293.45 | 756.151 | 861.178 | 310.909 | 208.396 | 2049.6 | 1611.1 | 290.401 | 28.9661 | 3.15034 | 3.39619 | 3.39546 | 2.64374 | 1.74426 | 1.74426 | 1.88995 | 0.382435 | 0.654183 | 0.5744 | 1.59101 | 2.37366 | 0.241345 | 0.307032 | 114.273 | 106.001 | 106.024 | 136.17 | 206.391 | 206.391 | 190.481 | 941.336 | 550.305 | 626.74 | 226.271 | 151.664 | 1491.64 | 1172.51 | 220.274 | 13.8832 | | 2026-11-16 00:00:00 | 301378.SZ | 2026-06-30 00:00:00 | 1 | 1.58654 | 1.7159 | 1.71515 | 1.24433 | 1.1425 | 1.1425 | 1.10904 | 0.20453 | 0.329488 | 0.295572 | 0.802184 | 1.19587 | 0.126195 | 0.15634 | 113.454 | 104.901 | 104.947 | 144.656 | 157.549 | 157.549 | 162.302 | 880.066 | 546.302 | 608.988 | 224.387 | 150.518 | 1426.37 | 1151.34 | 218.355 | 60.8062 | 0.986655 | 1.08878 | 1.0883 | 0.789554 | 0.710511 | 0.710511 | 0.689705 | 0.129779 | 0.209067 | 0.187547 | 0.509002 | 0.758802 | 0.0800731 | 0.0992008 | 91.2173 | 82.6616 | 82.6978 | 113.988 | 126.669 | 126.669 | 130.491 | 693.489 | 430.484 | 479.881 | 176.816 | 118.608 | 1123.97 | 907.251 | 173.879 | 47.2094 | 3.31287 | 3.68719 | 3.68558 | 2.67386 | 2.38567 | 2.38567 | 2.31581 | 0.439501 | 0.708015 | 0.635135 | 1.72376 | 2.56972 | 0.271171 | 0.335948 | 108.667 | 97.6353 | 97.678 | 134.637 | 150.901 | 150.901 | 155.453 | 819.11 | 508.464 | 566.808 | 208.846 | 140.093 | 1327.57 | 1071.59 | 206.302 | 55.4011 | | 2026-11-16 00:00:00 | 301378.SZ | 2026-09-30 00:00:00 | 0 | 2.18568 | 2.38525 | 2.38476 | 1.6704 | 1.98687 | 1.98687 | 1.63199 | 0.311487 | 0.492849 | 0.446286 | 1.19732 | 1.78853 | 0.19086 | 0.234923 | 96.08 | 88.0411 | 88.0592 | 125.719 | 105.694 | 105.694 | 128.677 | 674.186 | 426.094 | 470.55 | 175.391 | 117.415 | 1100.28 | 893.911 | 184.121 | 78.4272 | 0.660132 | 0.770251 | 0.770092 | 0.539409 | 0.600087 | 0.600087 | 0.492905 | 0.100586 | 0.159152 | 0.144116 | 0.386642 | 0.577557 | 0.0616332 | 0.0758618 | 136.336 | 116.845 | 116.869 | 166.849 | 149.978 | 149.978 | 182.591 | 894.756 | 565.497 | 624.497 | 232.773 | 155.829 | 1460.25 | 1186.37 | 253.181 | 103.203 | 3.22869 | 3.40062 | 3.39992 | 2.38147 | 2.93501 | 2.93501 | 2.41079 | 0.444083 | 0.702649 | 0.636265 | 1.70701 | 2.54989 | 0.272107 | 0.334926 | 111.5 | 105.863 | 105.885 | 151.167 | 122.657 | 122.657 | 149.329 | 810.66 | 512.347 | 565.802 | 210.895 | 141.183 | 1323.01 | 1074.86 | 217.363 | 94.7061 | ## 通用文档 ## 【财务数据通用】一、数据体系 平台的财务数据分四类,从原始披露到加工指标逐层派生: | 类别 | 数据表 | 说明 | | --- | --- | --- | | 原始数据 | 资产负债表、利润表、现金流量表 PIT(`cn_stock_financial_*_pit`),财报变更日期(`cn_stock_financial_changedate`),财务附注(`cn_stock_financial_note_*`) | 公司披露什么就记录什么,只在披露财报时有记录,不是日频 | | 衍生数据 | `cn_stock_financial_lf_shift`、`ly_shift`、`mrq_shift`、`ttm_shift`、`notes_shift` | 把原始数据加工成最新一期(LF)、最新年报(LY)、单季度(MRQ)、滚动十二期(TTM),并用 `shift` 带出历史各期 | | 财务分析 | `cn_stock_financial_profitability`、`growth`、`operating`、`debt_repay`、`capital`、`cash_flow`、`earning_quality`、`xps`、`derivative` | 在衍生数据的基础上做加减乘除得到的财务指标 | | 盈利预期 | `cn_stock_financial_earnings_preview`、`cn_stock_financial_forecast_consensus_rolling` | 业绩快报和机构一致预期,口径独立,见各表文档 | 以上财务表都不是日频数据,不能直接当作每日因子使用,需要先按公告日对齐到交易日,做法见本文五。衍生数据和财务分析适合对财务数据有较深了解、希望构建复杂财务因子的用户。 ## 【财务数据通用】二、date 与 report_date 财务表里有两个时间概念,含义不同,使用时不要混淆: - `date`:公告日,即这条财务数据对外公布(首次披露或更正)的日期,也是这条数据可以被使用的最早日期。`date` 不是报告期。 - `report_date`:报告期,即这条数据属于哪一期财报。 关于 `date` 的几点说明: - `date` 就是公告日,原样记录,公告日不是交易日(周末、节假日)时也不会顺延,所以 `date` 可能不是交易日。按交易日使用时,用 `date <= 交易日` 取最新的记录即可(见本文五的 `ASOF JOIN`)。 - `date` 来自 `cn_stock_financial_changedate` 的 `changedate`,二者约等于同一个日期。数据入库时会去重,所有字段的取值完全相同的记录只保留一条。 - 原始表(三大报表 PIT、财务附注)中,一行是某个公司某个报告期在某个公告日的版本。同一个 `report_date` 首次披露和后来更正,会有不同的 `date`。 - 衍生表和财务分析表中,`date` 同样是公告日,表里只有公司有公告的日期。站在这一天,`shift = 0` 是当时能看到的最新一期,`shift = 1, 2…` 是更早的各期,数值是当时能看到的版本,示例见本文四。 报告期的取值: - xxxx-03-31 表示 xxxx 年一季报,比如 2024-03-31 指 2024 年一季报 - xxxx-06-30 表示 xxxx 年半年报,比如 2024-06-30 指 2024 年半年报 - xxxx-09-30 表示 xxxx 年三季报,比如 2024-09-30 指 2024 年三季报 - xxxx-12-31 表示 xxxx 年年报,比如 2024-12-31 指 2024 年年报 上市公司一年内披露四次财务报告,披露时限如下: - 一季报:应在 4 月 30 日前披露 - 半年报:应在 8 月 31 日前披露 - 三季报:应在 10 月 31 日前披露 - 年报:应在次年 4 月 30 日前披露 判断某一天能看到哪些数据要用 `date`,不能用 `report_date`,否则会用到当时还没有公布的数据。 ## 【财务数据通用】三、PIT (Point in Time) 上市公司除了正常披露财务报表外,后续会时常对历史财务数据进行修正。因此在量化投资领域,加工财务数据时不能只用最新修正后的数据,而要基于历史时间节点获取当时能获取的最新数据。PIT(Point In Time)数据指的是在某个时间点上,基于已公布的财务报表获取的某个财务指标的取值。 以 002473.SZ 的财务数据为例,在平台上调用以下代码: ```python import dai import pandas as pd pd.set_option('display.float_format', '{:.2f}'.format) dai.query(""" SELECT date, instrument, report_date, change_type, total_current_assets FROM cn_stock_financial_balance_general_pit WHERE instrument='002473.SZ' AND report_date='2019-12-31' AND date>'2020-01-01' """).df() ``` 运行上述代码,能得到以下数据: | date | instrument | report_date | change_type | total_current_assets | | --- | --- | --- | --- | --- | | 2020-04-30 | 002473.SZ | 2019-12-31 | 0 | 223449880.95 | | 2020-08-27 | 002473.SZ | 2019-12-31 | 1 | 228470428.90 | | 2020-10-26 | 002473.SZ | 2019-12-31 | 1 | 228470428.90 | | 2021-04-29 | 002473.SZ | 2019-12-31 | 1 | 228470428.90 | 该公司于 2020 年 4 月 30 日首次公布 2019 年年报,披露的流动资产(total_current_assets)为 223449880.95,又于 2020 年 8 月 27 日对 2019 年年报的流动资产进行修正,修正为 228470428.90,因此 2019 年年报在表中有多条记录。 date 为 2020-08-27、2020-10-26、2021-04-29 的 total_current_assets 取值相同,这些重复记录是必要的:公司每披露某一期财报,都会附带上年同期或上年年末的数据作对比,极少部分公司即使不发布修正公告,也会通过这种方式修改历史财务数据,所以每次披露都保留一条记录。 原始数据表里与此相关的字段: | 字段 | 释意 | | --- | --- | | change_type | 0 表示首次披露的财务数据,1 表示非首次披露或有更改的财务数据 | | fs_quarter_index | 对应季度,1 指一季报,2 指半年报,3 指三季报,4 指年报,仅报表 PIT 表有 | ## 【财务数据通用】四、衍生数据:LF、LY、MRQ、TTM 与 shift 原始财务数据只在公司披露财报时才有记录,这类非规整的数据很难直接用于量化投资。衍生数据把原始数据加工成四类,字段名就是原始财务字段加上对应的后缀。要查具体字段,先在原始财报的文档里找到财务字段,再加上后缀,比如利润表的 `net_profit` 对应 `net_profit_lf`、`net_profit_ttm`。 - lf(last file):取自最新一期财务数据,表为 `cn_stock_financial_lf_shift` - ly(last year):取自最新一期年报财务数据,表为 `cn_stock_financial_ly_shift` - mrq(most recent quarter):最新一个单季度的财务数据,表为 `cn_stock_financial_mrq_shift` - ttm(trailing twelve months):最新滚动十二个月的财务数据,表为 `cn_stock_financial_ttm_shift` - shift(偏移期):站在历史节点上向前偏移 n 期,shift=0 为当期,shift=1 为上一期。LF、MRQ、TTM 以季为单位,LY 以年为单位 在平台加工的“衍生数据”和“财务分析”两大类财务数据中,我们同样进行 PIT 处理,以 002473.SZ 这只股票的流动资产(total_current_assets)数据举例: ```python import dai import pandas as pd pd.set_option('display.float_format', '{:.2f}'.format) dai.query(""" SELECT date, instrument, report_date, shift, total_current_assets_lf FROM cn_stock_financial_lf_shift WHERE instrument='002473.SZ' AND shift < 3 AND ((date='2020-04-30') OR (date='2020-08-27')) """).df().sort_values("date") ``` 通过上述代码,我们得到以下数据,可以看出,站在 2020 年 4 月 30 日这一天,我们能获取到的 2019 年年报的流动资产为 223449880.95,但站在 2020-08-27 这一天时,我们能获取到的 2019 年年报的流动资产为 228470428.90。 | date | instrument | report_date | shift | total_current_assets_lf | | --- | --- | --- | --- | --- | | 2020-04-30 | 002473.SZ | 2019-09-30 | 2 | 268546184.69 | | 2020-04-30 | 002473.SZ | 2019-12-31 | 1 | **223449880.95** | | 2020-04-30 | 002473.SZ | 2020-03-31 | 0 | 213964081.16 | | 2020-08-27 | 002473.SZ | 2019-12-31 | 2 | **228470428.90** | | 2020-08-27 | 002473.SZ | 2020-03-31 | 1 | 233220236.75 | | 2020-08-27 | 002473.SZ | 2020-06-30 | 0 | 222315509.19 | ## 【财务数据通用】五、日频财务数据与日频 ROE 因子 衍生数据按公告日存储,不是日频。要得到日频数据,把财务表按公告日对齐到交易日:某一天只使用当天及之前已经公告的最新一期(`shift = 0`),在下一次公告之前沿用上一期的值。DAI SQL 用 `ASOF JOIN` 完成。 下面以日频 ROE 为例,ROE = 滚动十二期归属母公司股东的净利润 / 最新一期归属母公司股东的所有者权益: ```python import dai df = dai.query(""" SELECT b.date, b.instrument, t.net_profit_to_parent_shareholders_ttm / l.total_equity_to_parent_shareholders_lf AS roe_ttm FROM cn_stock_bar1d b ASOF JOIN (SELECT * FROM cn_stock_financial_ttm_shift WHERE shift = 0) t ON b.instrument = t.instrument AND b.date >= t.date ASOF JOIN (SELECT * FROM cn_stock_financial_lf_shift WHERE shift = 0) l ON b.instrument = l.instrument AND b.date >= l.date WHERE b.date >= '2024-01-01' ORDER BY b.date, b.instrument """, filters={"date": ["2023-01-01", "2024-12-31"]}).pl() ``` - `filters` 的起点要早于第一个需要的交易日,这里提前一年,这样起点之前已经公告的财报也能取到。 - 所有者权益为 0 或负数时,ROE 会是无穷值或负值,使用前需要处理。 - 其他财务科目的日频因子写法相同,只需替换字段和后缀。现成的 ROE 指标见 `cn_stock_financial_profitability` 的 `roe_avg_ttm`、`roe_period_ttm` 等字段。 平台还提供过已按日频处理好的财务表 `cn_stock_factors_financial_items`,以 002473.SZ 的流动资产(total_current_assets)数据举例(该表已不建议使用,建议基于衍生数据自行计算): ```python import dai import pandas as pd pd.set_option('display.float_format', '{:.2f}'.format) dai.query(""" SELECT date, instrument, total_current_assets_ly FROM cn_stock_factors_financial_items WHERE instrument='002473.SZ' AND ((date>'2020-04-25' and date<'2020-05-05') OR (date>'2020-08-25' and date<'2020-09-01')) """).df().sort_values("date") ``` 通过上述代码,我们得到以下数据。可以看出,当日期来到 2020 年 4 月 30 日这一天时,我们能获取到最新的流动资产(年报)数据是 223449880.95,这个数值一直保持到 2020 年 8 月 27 日,最新一期年报的流动资产变为了 228470428.90,符合预期。 | date | instrument | total_current_assets_ly | | --- | --- | --- | | 2020-04-27 | 002473.SZ | 330113974.90 | | 2020-04-28 | 002473.SZ | 330113974.90 | | 2020-04-29 | 002473.SZ | 330113974.90 | | 2020-04-30 | 002473.SZ | **223449880.95** | | 2020-08-26 | 002473.SZ | 223449880.95 | | 2020-08-27 | 002473.SZ | **228470428.90** | | 2020-08-28 | 002473.SZ | 228470428.90 | | 2020-08-31 | 002473.SZ | 228470428.90 | ## 【财务数据通用】六、财务分析与财务附注 - 财务分析表在衍生数据(LF、MRQ、TTM)的基础上通过加减乘除计算各类财务指标,所以数据结构、`shift` 的含义都与衍生数据相同,字段名带 `_lf`、`_mrq`、`_ttm` 后缀。各指标的计算公式见各表文档的“字段说明”。 - 财务附注是对资产负债表、利润表和现金流量表有关项目的说明,主要包括非经常性项目、收入明细、费用明细、投资收益等。多数附注科目只在半年报和年报中披露,一季报、三季报对应的记录大部分附注字段为空,使用时建议按 `report_date` 的月份筛选出 06-30 和 12-31 的记录。非经常性损益等少数科目在一季报、三季报中也有数据。 ## 【财务数据通用】七、收录范围 - 目前只收录合并报表的数据,没有母公司报表。 - 报表 PIT 表目前只收录一般企业的财务科目,针对金融类企业的特殊字段后续会逐渐加入。
财务分析(营运能力) (cn_stock_financial_operating)
数据描述: 该表记录了中国股票市场上各上市公司的营运能力相关的财务指标。它详细列出了与公司资产管理和使用效率相关的各种周转率和周转天数,如存货周转率、应收账款周转率、应付账款周转天数、营业周期等,覆盖了最新一期、单季度以及滚动十二期的数据。数据非日频,按照财报的发布进行更新。
文档
用例
表结构
| 字段 | 字段类型 | 字段描述 |
| accounts_receivable_turnover_days_mrq | DOUBLE | 应收账款周转天数(单季度) |
| accounts_receivable_turnover_days_ttm | DOUBLE | 应收账款周转天数(滚动十二期) |
| advances_and_contract_liab_turnover_lf | DOUBLE | 预收款项及合同负债周转率(最新一期) |
| notes_and_accounts_payable_turnover_lf | DOUBLE | 应付票据及应付账款周转率(最新一期) |
| advances_and_contract_liab_turnover_mrq | DOUBLE | 预收款项及合同负债周转率(单季度) |
| advances_and_contract_liab_turnover_ttm | DOUBLE | 预收款项及合同负债周转率(滚动十二期) |
| notes_and_accounts_payable_turnover_mrq | DOUBLE | 应付票据及应付账款周转率(单季度) |
| notes_and_accounts_payable_turnover_ttm | DOUBLE | 应付票据及应付账款周转率(滚动十二期) |
| notes_and_accounts_receivable_turnover_lf | DOUBLE | 应收票据及应收账款周转率(最新一期) |
| notes_and_accounts_receivable_turnover_mrq | DOUBLE | 应收票据及应收账款周转率(单季度) |
| notes_and_accounts_receivable_turnover_ttm | DOUBLE | 应收票据及应收账款周转率(滚动十二期) |
| advances_and_contract_liab_turnover_days_lf | DOUBLE | 预收款项及合同负债周转天数(最新一期) |
| notes_and_accounts_payable_turnover_days_lf | DOUBLE | 应付票据及应付账款周转天数(最新一期) |
| advances_and_contract_liab_turnover_days_mrq | DOUBLE | 预收款项及合同负债周转天数(单季度) |
| advances_and_contract_liab_turnover_days_ttm | DOUBLE | 预收款项及合同负债周转天数(滚动十二期) |
| notes_and_accounts_payable_turnover_days_mrq | DOUBLE | 应付票据及应付账款周转天数(单季度) |
| notes_and_accounts_payable_turnover_days_ttm | DOUBLE | 应付票据及应付账款周转天数(滚动十二期) |
| notes_and_accounts_receivable_turnover_days_lf | DOUBLE | 应收票据及应收账款周转天数(最新一期) |
| accounts_receivable_contract_assets_turnover_lf | DOUBLE | 应收账款及合同资产周转率(最新一期) |
| notes_and_accounts_receivable_turnover_days_mrq | DOUBLE | 应收票据及应收账款周转天数(单季度) |
| notes_and_accounts_receivable_turnover_days_ttm | DOUBLE | 应收票据及应收账款周转天数(滚动十二期) |
| accounts_receivable_contract_assets_turnover_mrq | DOUBLE | 应收账款及合同资产周转率(单季度) |
| accounts_receivable_contract_assets_turnover_ttm | DOUBLE | 应收账款及合同资产周转率(滚动十二期) |
| accounts_receivable_contract_assets_turnover_days_lf | DOUBLE | 应收账款及合同资产周转天数(最新一期) |
| accounts_receivable_contract_assets_turnover_days_mrq | DOUBLE | 应收账款及合同资产周转天数(单季度) |
| accounts_receivable_contract_assets_turnover_days_ttm | DOUBLE | 应收账款及合同资产周转天数(滚动十二期) |
| shift | TINYINT | 偏移报告期 |
| report_date | TIMESTAMP_NS | 报告期 |
| operating_cycle_lf | DOUBLE | 营业周期(最新一期) |
| operating_cycle_mrq | DOUBLE | 营业周期(单季度) |
| operating_cycle_ttm | DOUBLE | 营业周期(滚动十二期) |
| inventory_turnover_lf | DOUBLE | 存货周转率(最新一期) |
| fix_assets_turnover_lf | DOUBLE | 固定资产周转率(最新一期) |
| inventory_turnover_mrq | DOUBLE | 存货周转率(单季度) |
| inventory_turnover_ttm | DOUBLE | 存货周转率(滚动十二期) |
| net_assets_turnover_lf | DOUBLE | 净资产周转率(最新一期) |
| instrument | VARCHAR | 证券代码 |
| date | TIMESTAMP_NS | 日期 |
| net_operating_cycle_lf | DOUBLE | 净营业周期(最新一期) |
| fix_assets_turnover_mrq | DOUBLE | 固定资产周转率(单季度) |
| fix_assets_turnover_ttm | DOUBLE | 固定资产周转率(滚动十二期) |
| net_assets_turnover_mrq | DOUBLE | 净资产周转率(单季度) |
| net_assets_turnover_ttm | DOUBLE | 净资产周转率(滚动十二期) |
| net_operating_cycle_mrq | DOUBLE | 净营业周期(单季度) |
| net_operating_cycle_ttm | DOUBLE | 净营业周期(滚动十二期) |
| total_assets_turnover_lf | DOUBLE | 总资产周转率(最新一期) |
| total_assets_turnover_mrq | DOUBLE | 总资产周转率(单季度) |
| total_assets_turnover_ttm | DOUBLE | 总资产周转率(滚动十二期) |
| current_assets_turnover_lf | DOUBLE | 流动资产周转率(最新一期) |
| inventory_turnover_days_lf | DOUBLE | 存货周转天数(最新一期) |
| noncurr_assets_turnover_lf | DOUBLE | 非流动资产周转率(最新一期) |
| current_assets_turnover_mrq | DOUBLE | 流动资产周转率(单季度) |
| current_assets_turnover_ttm | DOUBLE | 流动资产周转率(滚动十二期) |
| fix_assets_turnover_days_lf | DOUBLE | 固定资产周转天数(最新一期) |
| inventory_turnover_days_mrq | DOUBLE | 存货周转天数(单季度) |
| inventory_turnover_days_ttm | DOUBLE | 存货周转天数(滚动十二期) |
| net_assets_turnover_days_lf | DOUBLE | 净资产周转天数(最新一期) |
| noncurr_assets_turnover_mrq | DOUBLE | 非流动资产周转率(单季度) |
| noncurr_assets_turnover_ttm | DOUBLE | 非流动资产周转率(滚动十二期) |
| working_capital_turnover_lf | DOUBLE | 营运资本周转率(最新一期) |
| accounts_payable_turnover_lf | DOUBLE | 应付账款周转率(最新一期) |
| fix_assets_turnover_days_mrq | DOUBLE | 固定资产周转天数(单季度) |
| fix_assets_turnover_days_ttm | DOUBLE | 固定资产周转天数(滚动十二期) |
| net_assets_turnover_days_mrq | DOUBLE | 净资产周转天数(单季度) |
| net_assets_turnover_days_ttm | DOUBLE | 净资产周转天数(滚动十二期) |
| working_capital_turnover_mrq | DOUBLE | 营运资本周转率(单季度) |
| working_capital_turnover_ttm | DOUBLE | 营运资本周转率(滚动十二期) |
| accounts_payable_turnover_mrq | DOUBLE | 应付账款周转率(单季度) |
| accounts_payable_turnover_ttm | DOUBLE | 应付账款周转率(滚动十二期) |
| intangible_assets_turnover_lf | DOUBLE | 无形资产周转率(最新一期) |
| total_assets_turnover_days_lf | DOUBLE | 总资产周转天数(最新一期) |
| intangible_assets_turnover_mrq | DOUBLE | 无形资产周转率(单季度) |
| intangible_assets_turnover_ttm | DOUBLE | 无形资产周转率(滚动十二期) |
| total_assets_turnover_days_mrq | DOUBLE | 总资产周转天数(单季度) |
| total_assets_turnover_days_ttm | DOUBLE | 总资产周转天数(滚动十二期) |
| accounts_receivable_turnover_lf | DOUBLE | 应收账款周转率(最新一期) |
| current_assets_turnover_days_lf | DOUBLE | 流动资产周转天数(最新一期) |
| noncurr_assets_turnover_days_lf | DOUBLE | 非流动资产周转天数(最新一期) |
| accounts_receivable_turnover_mrq | DOUBLE | 应收账款周转率(单季度) |
| accounts_receivable_turnover_ttm | DOUBLE | 应收账款周转率(滚动十二期) |
| current_assets_turnover_days_mrq | DOUBLE | 流动资产周转天数(单季度) |
| current_assets_turnover_days_ttm | DOUBLE | 流动资产周转天数(滚动十二期) |
| noncurr_assets_turnover_days_mrq | DOUBLE | 非流动资产周转天数(单季度) |
| noncurr_assets_turnover_days_ttm | DOUBLE | 非流动资产周转天数(滚动十二期) |
| working_capital_turnover_days_lf | DOUBLE | 营运资本周转天数(最新一期) |
| accounts_payable_turnover_days_lf | DOUBLE | 应付账款周转天数(最新一期) |
| working_capital_turnover_days_mrq | DOUBLE | 营运资本周转天数(单季度) |
| working_capital_turnover_days_ttm | DOUBLE | 营运资本周转天数(滚动十二期) |
| accounts_payable_turnover_days_mrq | DOUBLE | 应付账款周转天数(单季度) |
| accounts_payable_turnover_days_ttm | DOUBLE | 应付账款周转天数(滚动十二期) |
| intangible_assets_turnover_days_lf | DOUBLE | 无形资产周转天数(最新一期) |
| intangible_assets_turnover_days_mrq | DOUBLE | 无形资产周转天数(单季度) |
| intangible_assets_turnover_days_ttm | DOUBLE | 无形资产周转天数(滚动十二期) |
| accounts_receivable_turnover_days_lf | DOUBLE | 应收账款周转天数(最新一期) |
表名:cn_stock_financial_operating
起始时间:
最近更新时间: