掘金社区
主要财务指标中的净资产收益率_摊薄/净资产收益率_扣除摊薄有问题Pinned highlighted
jjtest
发表在问题反馈 2018-11-05 18:15:46
问题反馈
664
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
上面代码返回的结果有两个问题:
-
净资产收益率_扣除摊薄/ROEDILUTEDCUT列丢失了, 返回的结果里没有该列了.
-
净资产收益率_摊薄/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
工商网监