掘金社区

主要财务指标中的净资产收益率_摊薄/净资产收益率_扣除摊薄有问题Pinned highlighted

jjtest 发表在问题反馈 2018-11-05 18:15:46

问题反馈
293
1
0
get_fundamentals(table="prim_finance_indicator", symbols=["SZSE.000002"], start_date="2017-01-01", end_date="2018-10-01", fields= "ROEDILUTED, ROEDILUTEDCUT", limit = 100, df = True)

返回结果如下:

        symbol   pub_date   end_date  ROEDILUTED
0  SZSE.000002 2017-04-28 2017-03-31         NaN
1  SZSE.000002 2017-08-25 2017-06-30        6.48
2  SZSE.000002 2017-10-27 2017-09-30         NaN
3  SZSE.000002 2018-03-27 2017-12-31       21.14
4  SZSE.000002 2018-04-26 2018-03-31         NaN
5  SZSE.000002 2018-08-21 2018-06-30        6.76
6  SZSE.000002 2018-10-26 2018-09-30         NaN

上面代码返回的结果有两个问题:

  1. 净资产收益率_扣除摊薄/ROEDILUTEDCUT列丢失了, 返回的结果里没有该列了.

  2. 净资产收益率_摊薄/ROEDILUTED列有不少为NaN的数据, 如果从衍生财务指标查询这些NaN数据是有值的.

get_fundamentals(table="deriv_finance_indicator", symbols=["SZSE.000002"], start_date="2017-01-01", end_date="2018-10-01", fields= "ROEDILUTED, ROEDILUTEDCUT", limit = 100, df = True)

返回的结果如下:

        symbol   pub_date   end_date  ROEDILUTED  ROEDILUTEDCUT
0  SZSE.000002 2017-04-28 2017-03-31      0.6102         0.5933
1  SZSE.000002 2017-08-25 2017-06-30      6.4800         6.3241
2  SZSE.000002 2017-10-27 2017-09-30      9.5305         9.1048
3  SZSE.000002 2018-03-27 2017-12-31     21.1400        20.5611
4  SZSE.000002 2018-04-26 2018-03-31      0.6571         0.6065
5  SZSE.000002 2018-08-21 2018-06-30      6.7600         6.7436
6  SZSE.000002 2018-10-26 2018-09-30      9.9889         9.9616

可以看到衍生财务指标净资产收益率_摊薄/ROEDILUTED列没有为NaN的数据.

评论: 1

Looks like your connection to 掘金量化社区 - 量化交易者的策略交流学习社区 was lost, please wait while we try to reconnect.