## 一、数据简介 **请注意:该表不是日频数据,不能直接作为因子使用。该表适合对财务数据有深入研究的用户,日频财务数据的加工方法见文末“通用文档”。** 盈利能力财务指标是用来衡量企业盈利能力的关键指标,帮助投资者和管理层评估公司在经营活动中的盈利效果。 - 数据起始时间: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 滚动十二期。不是每个指标都有三种后缀,具体字段以表结构为准。 | 中文名 | 英文字段 | 中文公式 | 英文公式 | | --- | --- | --- | --- | | 净资产收益率(平均) | `roe_avg` | `归属于母公司所有者的净利润 / 平均归属于母公司所有者权益合计` | `net_profit_to_parent_shareholders / avg_total_equity_to_parent_shareholders` | | 净资产收益率(摊薄) | `roe_period` | `归属于母公司所有者的净利润 / 期末归属于母公司所有者权益合计` | `net_profit_to_parent_shareholders / ending_total_equity_to_parent_shareholders` | | 净资产收益率(扣除,平均) | `roe_avg_deduct` | `扣非归母净利润 / 平均归属于母公司所有者权益合计` | `deducted_net_profit / avg_total_equity_to_parent_shareholders` | | 净资产收益率(扣除,摊薄) | `roe_period_deduct` | `扣非归母净利润 / 期末归属于母公司所有者权益合计` | `deducted_net_profit / ending_total_equity_to_parent_shareholders` | | 资产总计报酬率(平均) | `roa2_avg` | `息税前利润 / 平均资产总计` | `EBIT / avg_total_assets` | | 资产总计报酬率(摊薄) | `roa2_period` | `息税前利润 / 期末资产总计` | `EBIT / ending_total_assets` | | 资产总计净利率(平均) | `roa_avg` | `净利润 / 平均资产总计` | `net_profit / avg_total_assets` | | 资产总计净利率(摊薄) | `roa_period` | `净利润 / 期末资产总计` | `net_profit / ending_total_assets` | | 投入资本回报率 | `roic` | `EBIT(反推法)*(1-有效税率) / 平均全部投入资本` | `EBIT(Back Calculation)*(1-effective_tax_rate) / avg_total_invested_capital` | | 销售净利率 | `net_profit_rate` | `净利润 / 营业收入` | `net_profit / operating_revenue` | | 销售毛利率 | `gross_profit_rate` | `(营业收入-营业成本) / 营业收入` | `(operating_revenue - operating_cost) / operating_revenue` | | 销售成本率 | `cogs` | `营业成本 / 营业收入` | `operating_cost / operating_revenue` | | 销售期间费用率 | `period_expense_rate` | `(销售费用+管理费用+研发费用+财务费用) / 营业收入` | `(selling_expense + administrative_expense + R&D_expense + finance_expense) / operating_revenue` | | 成本费用利润率 | `profit_rate_to_expense` | `净利润 / (营业成本+销售费用+管理费用+财务费用+研发费用)` | `net_profit / (operating_cost + selling_expense + administrative_expense + finance_expense + R&D_expense)` | | 主营业务比率 | `prime_operating_rate` | `营业利润 / 利润总额` | `operating_profit / total_profit` | | 归属于母公司股东的净利润 / 营业总收入 | `profit_of_parent_to_total_revenue` | `归属于母公司股东的净利润 / 营业总收入` | `net_profit_to_parent_shareholders / total_operating_revenue` | | 息税前利润 / 营业总收入 | `ebit_to_total_revenue` | `EBIT(反推法) / 营业总收入` | `EBIT(Back Calculation) / total_operating_revenue` | | 息税前利润 / 资产总计 | `ebit_to_total_assets` | `EBIT(反推法) / 资产总计` | `EBIT(Back Calculation) / total_assets` | | 息税折旧摊销前利润/营业总收入 | `ebitda_to_total_revenue` | `EBITDA(反推法) / 营业总收入` | `EBITDA(Back Calculation) / total_operating_revenue` | | 销售费用 / 营业总收入 | `sales_to_total_revenue` | `销售费用 / 营业总收入` | `selling_expense / total_operating_revenue` | | 管理费用 / 营业总收入 | `admin_to_total_revenue` | `管理费用 / 营业总收入` | `administrative_expense / total_operating_revenue` | | 研发费用 / 营业总收入 | `research_develop_to_total_revenue` | `研发费用 / 营业总收入` | `R&D_expense / total_operating_revenue` | | 财务费用 / 营业总收入 | `finance_to_total_revenue` | `财务费用 / 营业总收入` | `finance_expense / total_operating_revenue` | | 资产减值损失 / 营业总收入 | `asset_impair_to_total_revenue` | `资产减值损失 / 营业总收入` | `asset_impairment_loss / total_operating_revenue` | | 资产减值损失 / 营业利润 | `asset_impair_to_operating_profit` | `资产减值损失 / 营业利润` | `asset_impairment_loss / operating_profit` | | 信用减值损失 / 营业总收入 | `credit_impair_to_total_revenue` | `信用减值损失 / 营业总收入` | `credit_impairment_loss / total_operating_revenue` | | 信用减值损失 / 营业利润 | `credit_impair_to_operating_profit` | `信用减值损失 / 营业利润` | `credit_impairment_loss / operating_profit` | ## 四、示例数据 2026-11-15 至 2026-11-22 的数据,字段较多,只展示 7 个字段,按日期、股票代码、报告期排序,展示前 5 行和后 5 行。 | date | instrument | report_date | shift | roe_avg_lf | roe_period_lf | roe_avg_deduct_lf | roe_period_deduct_lf | roa2_avg_lf | roa2_period_lf | roa_avg_lf | roa_period_lf | roic_lf | net_profit_rate_lf | gross_profit_rate_lf | cogs_lf | period_expense_rate_lf | profit_rate_to_expense_lf | prime_operating_rate_lf | profit_of_parent_to_total_revenue_lf | ebit_to_total_revenue_lf | ebit_to_total_assets_lf | ebitda_to_total_revenue_lf | sales_to_total_revenue_lf | admin_to_total_revenue_lf | research_develop_to_total_revenue_lf | finance_to_total_revenue_lf | asset_impair_to_total_revenue_lf | asset_impair_to_operating_profit_lf | credit_impair_to_total_revenue_lf | credit_impair_to_operating_profit_lf | roe_avg_mrq | roe_period_mrq | roe_avg_deduct_mrq | roe_period_deduct_mrq | roa2_avg_mrq | roa2_period_mrq | roa_avg_mrq | roa_period_mrq | roic_mrq | net_profit_rate_mrq | gross_profit_rate_mrq | cogs_mrq | period_expense_rate_mrq | profit_rate_to_expense_mrq | prime_operating_rate_mrq | profit_of_parent_to_total_revenue_mrq | ebit_to_total_revenue_mrq | ebit_to_total_assets_mrq | ebitda_to_total_revenue_mrq | sales_to_total_revenue_mrq | admin_to_total_revenue_mrq | research_develop_to_total_revenue_mrq | finance_to_total_revenue_mrq | asset_impair_to_total_revenue_mrq | asset_impair_to_operating_profit_mrq | credit_impair_to_total_revenue_mrq | credit_impair_to_operating_profit_mrq | roe_avg_ttm | roe_period_ttm | roe_avg_deduct_ttm | roe_period_deduct_ttm | roa2_avg_ttm | roa2_period_ttm | roa_avg_ttm | roa_period_ttm | roic_ttm | net_profit_rate_ttm | gross_profit_rate_ttm | cogs_ttm | period_expense_rate_ttm | profit_rate_to_expense_ttm | prime_operating_rate_ttm | profit_of_parent_to_total_revenue_ttm | ebit_to_total_revenue_ttm | ebit_to_total_assets_ttm | ebitda_to_total_revenue_ttm | sales_to_total_revenue_ttm | admin_to_total_revenue_ttm | research_develop_to_total_revenue_ttm | finance_to_total_revenue_ttm | asset_impair_to_total_revenue_ttm | asset_impair_to_operating_profit_ttm | credit_impair_to_total_revenue_ttm | credit_impair_to_operating_profit_ttm | |:--------------------|:-------------|:--------------------|--------:|-------------:|----------------:|--------------------:|-----------------------:|--------------:|-----------------:|-------------:|----------------:|------------:|---------------------:|-----------------------:|-----------:|-------------------------:|----------------------------:|--------------------------:|---------------------------------------:|---------------------------:|--------------------------:|-----------------------------:|----------------------------:|----------------------------:|---------------------------------------:|------------------------------:|-----------------------------------:|--------------------------------------:|------------------------------------:|---------------------------------------:|--------------:|-----------------:|---------------------:|------------------------:|---------------:|------------------:|--------------:|-----------------:|------------:|----------------------:|------------------------:|-----------:|--------------------------:|-----------------------------:|---------------------------:|----------------------------------------:|----------------------------:|---------------------------:|------------------------------:|-----------------------------:|-----------------------------:|----------------------------------------:|-------------------------------:|------------------------------------:|---------------------------------------:|-------------------------------------:|----------------------------------------:|--------------:|-----------------:|---------------------:|------------------------:|---------------:|------------------:|--------------:|-----------------:|------------:|----------------------:|------------------------:|-----------:|--------------------------:|-----------------------------:|---------------------------:|----------------------------------------:|----------------------------:|---------------------------:|------------------------------:|-----------------------------:|-----------------------------:|----------------------------------------:|-------------------------------:|------------------------------------:|---------------------------------------:|-------------------------------------:|----------------------------------------:| | 2026-11-16 00:00:00 | 301378.SZ | 2018-12-31 00:00:00 | 31 | nan | 0.39556 | nan | nan | nan | 0.17152 | nan | 0.164559 | 0.39159 | 0.204172 | 0.562814 | 0.437186 | 0.417415 | 0.489133 | 1.00616 | 0.205513 | 0.212808 | 0.17152 | 0.216341 | 0.103303 | 0.080432 | 0.233695 | -1.39872e-05 | 0.00501037 | 0.0233983 | 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-16 00:00:00 | 301378.SZ | 2019-12-31 00:00:00 | 27 | 0.403282 | 0.346244 | nan | nan | 0.180956 | 0.159597 | 0.176836 | 0.155964 | 0.34763 | 0.176389 | 0.564942 | 0.435058 | 0.41714 | 0.422853 | 0.999998 | 0.17468 | 0.180498 | 0.159597 | 0.186192 | 0.0990997 | 0.081829 | 0.236189 | 2.20185e-05 | nan | nan | 0.01567 | 0.086826 | 0.072885 | 0.0625764 | nan | nan | 0.0323906 | 0.0285675 | 0.0343002 | 0.0302516 | 0.0674865 | 0.112675 | 0.569821 | 0.430179 | 0.416509 | 0.270524 | 0.971694 | 0.103969 | 0.106403 | 0.0285675 | 0.117049 | 0.0894609 | 0.0850326 | 0.241911 | 0.00010459 | 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-16 00:00:00 | 301378.SZ | 2020-12-31 00:00:00 | 23 | 0.394448 | 0.288813 | nan | nan | 0.218796 | 0.172541 | 0.20674 | 0.163034 | 0.287044 | 0.232196 | 0.586613 | 0.413387 | 0.363376 | 0.638997 | 0.999998 | 0.228055 | 0.245737 | 0.172541 | 0.250693 | 0.0948403 | 0.0621238 | 0.210424 | -0.00401173 | 0.0013243 | 0.00530256 | 0.0148972 | 0.0596486 | 0.174845 | 0.128021 | nan | nan | 0.101984 | 0.0804241 | 0.0925872 | 0.0730136 | 0.126212 | 0.380699 | 0.644279 | 0.355721 | 0.22031 | 1.72802 | 0.999997 | 0.370087 | 0.419338 | 0.0804241 | 0.422333 | 0.0835062 | 0.00968833 | 0.141861 | -0.0147456 | nan | nan | 0.0128406 | 0.029581 | 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-16 00:00:00 | 301378.SZ | 2021-03-31 00:00:00 | 22 | nan | nan | nan | nan | nan | nan | nan | nan | nan | 0.00531158 | nan | nan | 0.277768 | 0.0191223 | 1.00031 | 0.00150603 | 0.001375 | nan | 0.001375 | nan | nan | 0.281078 | -0.00330943 | 0.0282656 | 6.03205 | -0.0138899 | -2.96418 | nan | nan | nan | nan | nan | nan | nan | nan | nan | 0.00531158 | nan | nan | 0.277768 | 0.0191223 | 1.00031 | 0.00150603 | 0.001375 | nan | 0.001375 | nan | nan | 0.281078 | -0.00330943 | 0.0282656 | 6.03205 | -0.0138899 | -2.96418 | 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-16 00:00:00 | 301378.SZ | 2021-06-30 00:00:00 | 21 | nan | 0.0270533 | nan | nan | nan | 0.0102607 | nan | 0.0181055 | 0.0256934 | 0.0564052 | 0.498494 | 0.501506 | 0.496856 | 0.113524 | 0.937571 | 0.0504969 | 0.0319659 | 0.0102607 | 0.0520975 | 0.126878 | 0.0917328 | 0.282678 | -0.00443219 | 0.00638646 | 0.187144 | -0.00184625 | -0.0541012 | nan | 0.0266781 | nan | nan | nan | 0.0100555 | nan | 0.0173126 | nan | 0.10082 | nan | nan | 0.27866 | 0.361801 | 0.933577 | 0.0930835 | 0.0585579 | 0.0100555 | 0.0585579 | nan | nan | 0.284069 | -0.00540819 | -0.0126325 | -0.211539 | 0.00862299 | 0.144397 | nan | 0.180236 | nan | nan | nan | 0.112392 | nan | 0.113452 | nan | 0.165281 | nan | nan | 0.225125 | 0.734175 | 0.989544 | 0.157322 | 0.163738 | 0.112392 | 0.163738 | nan | nan | 0.231515 | -0.00638959 | nan | nan | nan | nan | | 2026-11-16 00:00:00 | 301378.SZ | 2025-09-30 00:00:00 | 4 | -0.0385598 | -0.0386548 | -0.0428643 | -0.0429698 | -0.0296806 | -0.0297424 | -0.0304124 | -0.0304757 | -0.0374312 | -0.192943 | 0.40096 | 0.59904 | 0.618381 | -0.312013 | 1.00326 | -0.200974 | -0.1883 | -0.0297424 | -0.1883 | 0.137708 | 0.162132 | 0.324318 | -0.00577783 | 0.00184142 | -0.010056 | -0.0143409 | 0.0783158 | -0.00491388 | -0.00492598 | -0.00689879 | -0.00691578 | -0.00250283 | -0.00250804 | -0.00336862 | -0.00337563 | -0.0041499 | -0.0548055 | 0.468741 | 0.531259 | 0.554341 | -0.098866 | 1.03332 | -0.0656786 | -0.0407196 | -0.00250804 | -0.0407196 | 0.167153 | 0.108326 | 0.280148 | -0.00128596 | -0.00885049 | 0.217202 | -0.0114593 | 0.281225 | -0.03977 | -0.0398679 | -0.0467546 | -0.0468698 | -0.0251573 | -0.0252096 | -0.03123 | -0.0312949 | -0.0403063 | -0.122443 | 0.415346 | 0.584654 | 0.531936 | -0.230184 | 1.00403 | -0.1281 | -0.0986343 | -0.0252096 | -0.0986343 | 0.130293 | 0.127614 | 0.28149 | -0.00745962 | -0.00095235 | 0.0104034 | 0.00963711 | -0.105275 | | 2026-11-16 00:00:00 | 301378.SZ | 2025-12-31 00:00:00 | 3 | -0.0991788 | -0.102403 | -0.101747 | -0.105055 | -0.0702117 | -0.0697055 | -0.0771846 | -0.0766281 | -0.100122 | -0.334542 | 0.354836 | 0.645164 | 0.577911 | -0.578881 | 0.992296 | -0.33976 | -0.304319 | -0.0697055 | -0.253719 | 0.123663 | 0.155221 | 0.304331 | -0.00530374 | 0.0939719 | -0.316711 | -0.00081423 | 0.00274418 | -0.0593068 | -0.061235 | -0.0574243 | -0.0592913 | -0.0406854 | -0.0403921 | -0.0469302 | -0.0465919 | -0.0602863 | -0.634946 | 0.256983 | 0.743017 | 0.492055 | -1.2904 | 0.984522 | -0.634193 | -0.550456 | -0.0403921 | -0.550456 | 0.0938644 | 0.140559 | 0.26193 | -0.00429795 | 0.289427 | -0.538264 | 0.0278828 | -0.0518552 | -0.0991788 | -0.102403 | -0.101747 | -0.105055 | -0.0702117 | -0.0697055 | -0.0771846 | -0.0766281 | -0.100122 | -0.334542 | 0.354836 | 0.645164 | 0.577911 | -0.578881 | 0.992296 | -0.33976 | -0.304319 | -0.0697055 | -0.304319 | 0.123663 | 0.155221 | 0.304331 | -0.00530374 | 0.0939719 | -0.316711 | -0.00081423 | 0.00274418 | | 2026-11-16 00:00:00 | 301378.SZ | 2026-03-31 00:00:00 | 2 | -0.034018 | -0.0345542 | -0.0345148 | -0.0350587 | -0.0239834 | -0.0247102 | -0.025259 | -0.0260244 | -0.0325953 | -0.575232 | 0.293129 | 0.706871 | 0.85881 | -0.6698 | 0.999484 | -0.596807 | -0.546182 | -0.0247102 | -0.546182 | 0.168749 | 0.293542 | 0.398744 | -0.00222463 | -0.00212244 | 0.00390386 | -0.0349521 | 0.0642884 | -0.034018 | -0.0345542 | -0.0345148 | -0.0350587 | -0.0239834 | -0.0247102 | -0.025259 | -0.0260244 | -0.0325953 | -0.575232 | 0.293129 | 0.706871 | 0.85881 | -0.6698 | 0.999484 | -0.596807 | -0.546182 | -0.0247102 | -0.546182 | 0.168749 | 0.293542 | 0.398744 | -0.00222463 | -0.00212244 | 0.00390386 | -0.0349521 | 0.0642884 | -0.113192 | -0.114976 | -0.115454 | -0.117273 | -0.0767182 | -0.0790431 | -0.0851102 | -0.0876894 | -0.110822 | -0.35265 | 0.34836 | 0.65164 | 0.589603 | -0.598113 | 0.992486 | -0.361308 | -0.317878 | -0.0790431 | -0.317878 | 0.127692 | 0.168262 | 0.297778 | -0.0041291 | 0.0894346 | -0.28721 | -0.00473436 | 0.0152039 | | 2026-11-16 00:00:00 | 301378.SZ | 2026-06-30 00:00:00 | 1 | -0.0544852 | -0.0549729 | -0.0566676 | -0.0571748 | -0.0387432 | -0.0395117 | -0.0407967 | -0.0416059 | -0.0508238 | -0.323284 | 0.31674 | 0.68326 | 0.628258 | -0.514573 | 0.993641 | -0.34091 | -0.307012 | -0.0395117 | -0.221714 | 0.131873 | 0.198726 | 0.298496 | -0.00083712 | 0.00909536 | -0.0298966 | -0.0174 | 0.0571941 | -0.0196245 | -0.0198002 | -0.0212978 | -0.0214885 | -0.0135525 | -0.0138213 | -0.0142662 | -0.0145491 | -0.017728 | -0.178164 | 0.330339 | 0.669661 | 0.495461 | -0.359593 | 0.982823 | -0.193515 | -0.169251 | -0.0138213 | -0.169251 | 0.110632 | 0.144113 | 0.240753 | -3.79259e-05 | 0.0155567 | -0.0935425 | -0.00729012 | 0.0438354 | -0.12367 | -0.124777 | -0.126035 | -0.127164 | -0.0850893 | -0.0867769 | -0.0947708 | -0.0966505 | -0.118481 | -0.349487 | 0.336047 | 0.663953 | 0.570516 | -0.612581 | 0.990183 | -0.360101 | -0.313784 | -0.0867769 | -0.313784 | 0.129292 | 0.159826 | 0.283356 | -0.00195834 | 0.0867722 | -0.28103 | -0.00271305 | 0.0087868 | | 2026-11-16 00:00:00 | 301378.SZ | 2026-09-30 00:00:00 | 0 | -0.0766203 | -0.0773328 | -0.0795739 | -0.0803139 | -0.0560262 | -0.0562578 | -0.0591247 | -0.059369 | -0.0732557 | -0.309779 | 0.337195 | 0.662805 | 0.625232 | -0.495463 | 0.995422 | -0.318779 | -0.293545 | -0.0562578 | -0.293545 | 0.13387 | 0.189312 | 0.302542 | -0.000491785 | 0.00626739 | -0.0214848 | -0.00733573 | 0.0251472 | -0.0211409 | -0.0213375 | -0.0218724 | -0.0220757 | -0.0163519 | -0.0164195 | -0.0173475 | -0.0174192 | -0.0214388 | -0.281464 | 0.380086 | 0.619914 | 0.618887 | -0.45479 | 0.999727 | -0.272378 | -0.265311 | -0.0164195 | -0.265311 | 0.138058 | 0.169572 | 0.311025 | 0.000232286 | 0.000337939 | -0.00127298 | 0.0137662 | -0.0518559 | -0.141509 | -0.142825 | -0.142403 | -0.143727 | -0.100749 | -0.101166 | -0.110712 | -0.11117 | -0.137548 | -0.406869 | 0.313245 | 0.686755 | 0.585467 | -0.694948 | 0.9906 | -0.412957 | -0.370255 | -0.101166 | -0.370255 | 0.121925 | 0.174755 | 0.290416 | -0.00162824 | 0.0908145 | -0.248697 | 0.00317996 | -0.00870837 | ## 通用文档 ## 【财务数据通用】一、数据体系 平台的财务数据分四类,从原始披露到加工指标逐层派生: | 类别 | 数据表 | 说明 | | --- | --- | --- | | 原始数据 | 资产负债表、利润表、现金流量表 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_profitability)
数据描述: 该表详细记录了上市公司的盈利能力相关指标,如净资产收益率(包括平均和摊薄,以及扣除非经常性损益后的数据)、总资产报酬率、总资产净利率、投入资本回报率、销售净利率等。此外,还包括了与营业总收入、营业利润相关的各种比率,涵盖最新一期、单季度和滚动十二期数据。数据非日频,根据财报的发布进行更新。
文档
用例
表结构
| 字段 | 字段类型 | 字段描述 |
| research_develop_to_total_revenue_ttm | DOUBLE | 研发费用/营业总收入(滚动十二期) |
| research_develop_to_total_revenue_mrq | DOUBLE | 研发费用/营业总收入(单季度) |
| profit_of_parent_to_total_revenue_ttm | DOUBLE | 归属于母公司股东的净利润/营业总收入(滚动十二期) |
| profit_of_parent_to_total_revenue_mrq | DOUBLE | 归属于母公司股东的净利润/营业总收入(单季度) |
| credit_impair_to_operating_profit_ttm | DOUBLE | 信用减值损失/营业利润(滚动十二期) |
| credit_impair_to_operating_profit_mrq | DOUBLE | 信用减值损失/营业利润(单季度) |
| research_develop_to_total_revenue_lf | DOUBLE | 研发费用/营业总收入(最新一期) |
| profit_of_parent_to_total_revenue_lf | DOUBLE | 归属于母公司股东的净利润/营业总收入(最新一期) |
| credit_impair_to_operating_profit_lf | DOUBLE | 信用减值损失/营业利润(最新一期) |
| instrument | VARCHAR | 证券代码 |
| asset_impair_to_operating_profit_ttm | DOUBLE | 资产减值损失/营业利润(滚动十二期) |
| asset_impair_to_operating_profit_mrq | DOUBLE | 资产减值损失/营业利润(单季度) |
| asset_impair_to_operating_profit_lf | DOUBLE | 资产减值损失/营业利润(最新一期) |
| credit_impair_to_total_revenue_ttm | DOUBLE | 信用减值损失/营业总收入(滚动十二期) |
| credit_impair_to_total_revenue_mrq | DOUBLE | 信用减值损失/营业总收入(单季度) |
| credit_impair_to_total_revenue_lf | DOUBLE | 信用减值损失/营业总收入(最新一期) |
| shift | TINYINT | 偏移报告期 |
| asset_impair_to_total_revenue_ttm | DOUBLE | 资产减值损失/营业总收入(滚动十二期) |
| cogs_lf | DOUBLE | 销售成本率(最新一期) |
| asset_impair_to_total_revenue_mrq | DOUBLE | 资产减值损失/营业总收入(单季度) |
| roic_lf | DOUBLE | 投入资本回报率(最新一期) |
| cogs_mrq | DOUBLE | 销售成本率(单季度) |
| cogs_ttm | DOUBLE | 销售成本率(滚动十二期) |
| roic_mrq | DOUBLE | 投入资本回报率(单季度) |
| roic_ttm | DOUBLE | 投入资本回报率(滚动十二期) |
| ebit_to_total_revenue_mrq | DOUBLE | 息税前利润/营业总收入(单季度) |
| roa_avg_lf | DOUBLE | 总资产净利率(平均)(最新一期) |
| date | TIMESTAMP_NS | 日期 |
| report_date | TIMESTAMP_NS | 报告期 |
| roa2_avg_lf | DOUBLE | 总资产报酬率(平均)(最新一期) |
| roa_avg_mrq | DOUBLE | 总资产净利率(平均)(单季度) |
| roa_avg_ttm | DOUBLE | 总资产净利率(平均)(滚动十二期) |
| roe_avg_mrq | DOUBLE | 净资产收益率(平均)(单季度) |
| roe_avg_ttm | DOUBLE | 净资产收益率(平均)(滚动十二期) |
| roa2_avg_mrq | DOUBLE | 总资产报酬率(平均)(单季度) |
| roa2_avg_ttm | DOUBLE | 总资产报酬率(平均)(滚动十二期) |
| roa_period_lf | DOUBLE | 总资产净利率(摊薄)(最新一期) |
| roe_period_lf | DOUBLE | 净资产收益率(摊薄)(最新一期) |
| roa2_period_lf | DOUBLE | 总资产报酬率(摊薄)(最新一期) |
| roa_period_mrq | DOUBLE | 总资产净利率(摊薄)(单季度) |
| roa_period_ttm | DOUBLE | 总资产净利率(摊薄)(滚动十二期) |
| roe_period_mrq | DOUBLE | 净资产收益率(摊薄)(单季度) |
| roe_period_ttm | DOUBLE | 净资产收益率(摊薄)(滚动十二期) |
| roa2_period_mrq | DOUBLE | 总资产报酬率(摊薄)(单季度) |
| roa2_period_ttm | DOUBLE | 总资产报酬率(摊薄)(滚动十二期) |
| roe_avg_deduct_lf | DOUBLE | 净资产收益率(扣除,平均)(最新一期) |
| net_profit_rate_lf | DOUBLE | 销售净利率(最新一期) |
| roe_avg_deduct_mrq | DOUBLE | 净资产收益率(扣除,平均)(单季度) |
| roe_avg_deduct_ttm | DOUBLE | 净资产收益率(扣除,平均)(滚动十二期) |
| net_profit_rate_mrq | DOUBLE | 销售净利率(单季度) |
| net_profit_rate_ttm | DOUBLE | 销售净利率(滚动十二期) |
| gross_profit_rate_lf | DOUBLE | 销售毛利率(最新一期) |
| roe_period_deduct_lf | DOUBLE | 净资产收益率(扣除,摊薄)(最新一期) |
| gross_profit_rate_mrq | DOUBLE | 销售毛利率(单季度) |
| gross_profit_rate_ttm | DOUBLE | 销售毛利率(滚动十二期) |
| roe_period_deduct_mrq | DOUBLE | 净资产收益率(扣除,摊薄)(单季度) |
| roe_period_deduct_ttm | DOUBLE | 净资产收益率(扣除,摊薄)(滚动十二期) |
| period_expense_rate_lf | DOUBLE | 销售期间费用率(最新一期) |
| ebit_to_total_assets_lf | DOUBLE | 息税前利润/资产总计(最新一期) |
| period_expense_rate_mrq | DOUBLE | 销售期间费用率(单季度) |
| period_expense_rate_ttm | DOUBLE | 销售期间费用率(滚动十二期) |
| prime_operating_rate_lf | DOUBLE | 主营业务比率(最新一期) |
| ebit_to_total_assets_mrq | DOUBLE | 息税前利润/资产总计(单季度) |
| ebit_to_total_assets_ttm | DOUBLE | 息税前利润/资产总计(滚动十二期) |
| ebit_to_total_revenue_lf | DOUBLE | 息税前利润/营业总收入(最新一期) |
| prime_operating_rate_mrq | DOUBLE | 主营业务比率(单季度) |
| prime_operating_rate_ttm | DOUBLE | 主营业务比率(滚动十二期) |
| asset_impair_to_total_revenue_lf | DOUBLE | 资产减值损失/营业总收入(最新一期) |
| finance_to_total_revenue_ttm | DOUBLE | 财务费用/营业总收入(滚动十二期) |
| finance_to_total_revenue_mrq | DOUBLE | 财务费用/营业总收入(单季度) |
| finance_to_total_revenue_lf | DOUBLE | 财务费用/营业总收入(最新一期) |
| roe_avg_lf | DOUBLE | 净资产收益率(平均)(最新一期) |
| admin_to_total_revenue_lf | DOUBLE | 管理费用/营业总收入(最新一期) |
| ebit_to_total_revenue_ttm | DOUBLE | 息税前利润/营业总收入(滚动十二期) |
| profit_rate_to_expense_lf | DOUBLE | 成本费用利润率(最新一期) |
| sales_to_total_revenue_lf | DOUBLE | 销售费用/营业总收入(最新一期) |
| admin_to_total_revenue_mrq | DOUBLE | 管理费用/营业总收入(单季度) |
| admin_to_total_revenue_ttm | DOUBLE | 管理费用/营业总收入(滚动十二期) |
| ebitda_to_total_revenue_lf | DOUBLE | 息税折旧摊销前利润/营业总收入(最新一期) |
| profit_rate_to_expense_mrq | DOUBLE | 成本费用利润率(单季度) |
| profit_rate_to_expense_ttm | DOUBLE | 成本费用利润率(滚动十二期) |
| sales_to_total_revenue_mrq | DOUBLE | 销售费用/营业总收入(单季度) |
| sales_to_total_revenue_ttm | DOUBLE | 销售费用/营业总收入(滚动十二期) |
| ebitda_to_total_revenue_mrq | DOUBLE | 息税折旧摊销前利润/营业总收入(单季度) |
| ebitda_to_total_revenue_ttm | DOUBLE | 息税折旧摊销前利润/营业总收入(滚动十二期) |
表名:cn_stock_financial_profitability
起始时间:
最近更新时间: