-
Notifications
You must be signed in to change notification settings - Fork 950
历史财务数据 #133
Comments
这个办法, 应该也能拿到 一些历史数据, 再计算出其他数据. |
这个是tdx的问题 没办法 考虑其他办法吧 |
我这边的历史财务数据是这样拿的, 看看是否有帮助,这里直接贴我的笔记: 数据获取财务数据列表http://down.tdx.com.cn:8001/fin/gpcw.txt
是逗号分隔的csv,第一项是文件名,第二项目是hash,第三项是字节数 下载流程,直接拼接就可以了http://down.tdx.com.cn:8001/fin/gpcw20160930.zip 数据解析
遍历财务数据的代码
取出数据的含义为:
|
卧槽 帅啊 |
@yssource 666 |
@datochan @yutiansut 💥 💥 👍 👏 先祝贺, 我也 ollydbg 一下, 发现了问题再给你们 feedback |
@yutiansut @datochan cool |
@yutiansut @yssource @datochan 根据 @datochan 的代码,创建了一个新的分支 增加了
|
我尝试一下 |
咦 为啥我解析出来有279列
|
完整的结果 In [7]: HistoryFinancialReader().get_df('C://Users//P8XXTMX-G//Downloads//gpcw20160930.zip')
Out[7]:
report_date col1 col2 col3 col4 col5 \
code
000001 20160930 1.0900 1.0895 4.050000e+00 10.3800 3.290000e+00
000002 20160930 0.7480 0.7331 4.790000e+00 9.1000 7.300000e-01
000004 20160930 0.1750 0.1749 1.000000e-02 1.1458 1.000000e-02
000005 20160930 0.1260 -0.0048 -4.100000e-01 1.2116 6.000000e-01
000006 20160930 0.0848 0.0840 1.040000e+00 3.2185 3.600000e-01
000007 20160930 0.0753 -0.0597 -1.200000e+00 1.6630 1.830000e+00
000008 20160930 0.0367 0.0356 1.400000e-01 2.1056 9.500000e-01
000009 20160930 0.0980 0.0109 8.000000e-01 2.1112 1.600000e-01
000010 20160930 0.0268 0.0291 -1.600000e-01 2.6804 1.820000e+00
000011 20160930 -0.0121 -0.0135 1.980000e+00 3.4324 2.000000e-01
000012 20160930 0.3400 0.3108 1.800000e+00 3.8356 6.100000e-01
000014 20160930 -0.0869 -0.1374 1.290000e+00 3.4212 5.000000e-02
000016 20160930 -0.0184 -0.0507 -2.400000e-01 1.1418 3.000000e-02
000017 20160930 0.0038 0.0030 -2.170000e+00 0.0251 1.140000e+00
000018 20160930 0.1785 0.1668 6.200000e-01 0.9490 -7.700000e-01
000019 20160930 -0.0610 -0.0781 9.000000e-02 2.0107 8.100000e-01
000020 20160930 0.0159 0.0106 -6.700000e-01 1.1167 5.200000e-01
000021 20160930 0.2063 0.0769 1.290000e+00 3.6503 4.600000e-01
000022 20160930 0.6630 0.6593 5.080000e+00 7.1455 2.600000e-01
000023 20160930 0.0600 0.0684 6.900000e-01 2.7794 7.400000e-01
000025 20160930 0.0882 0.0776 1.000000e-01 3.0085 1.900000e+00
000026 20160930 0.2469 0.2447 1.600000e+00 5.4081 2.420000e+00
000027 20160930 0.3375 0.3352 2.070000e+00 5.4015 1.090000e+00
000028 20160930 1.9930 1.5955 1.009000e+01 16.7316 5.140000e+00
000029 20160930 0.2341 0.2265 5.200000e-01 2.5371 9.700000e-01
000030 20160930 0.4000 0.3815 2.190000e+00 3.8788 4.100000e-01
000031 20160930 0.0400 0.0275 1.330000e+00 3.0353 1.500000e-01
000032 20160930 0.1352 0.1282 1.170000e+00 3.3854 6.200000e-01
000034 20160930 0.5670 0.1883 -8.300000e-01 3.9394 3.640000e+00
000035 20160930 0.1091 0.1052 5.200000e-01 1.6031 7.600000e-01
... ... ... ... ... ... ...
603889 20160930 0.4400 0.4229 1.730000e+00 3.5646 7.800000e-01
603898 20160930 0.5200 0.4845 1.590000e+00 3.5222 1.030000e+00
603899 20160930 0.4297 0.3858 1.070000e+00 2.5351 3.000000e-01
603900 20160930 0.9600 0.9576 2.700000e+00 6.3975 2.420000e+00
603901 20160930 0.1800 0.1471 7.200000e-01 2.1865 4.000000e-01
603909 20160930 0.4659 0.3680 2.280000e+00 5.5729 2.150000e+00
603918 20160930 0.0205 0.0044 7.900000e-01 2.5953 6.900000e-01
603919 20160930 0.6200 0.5505 1.860000e+00 5.6434 2.640000e+00
603928 20160930 0.5600 0.5400 -4.039810e+34 3.8900 -4.039810e+34
603929 20160930 0.9500 0.9500 2.310000e+00 4.1500 6.600000e-01
603936 20160930 0.2340 0.1867 2.250000e+00 5.4979 2.050000e+00
603939 20160930 0.4840 0.4317 1.390000e+00 7.9859 5.530000e+00
603955 20160930 0.6097 0.5808 3.880000e+00 10.4726 4.740000e+00
603958 20160930 0.3150 0.1797 1.910000e+00 5.2711 2.130000e+00
603959 20160930 0.2700 0.1911 1.310000e+00 3.6657 1.210000e+00
603966 20160930 0.3044 0.2761 -4.039810e+34 4.1232 -4.039810e+34
603968 20160930 0.5000 0.4351 2.410000e+00 6.0316 1.940000e+00
603969 20160930 0.2500 0.2424 1.050000e+00 3.8704 1.680000e+00
603977 20160930 0.5200 0.3129 2.060000e+00 3.9563 5.800000e-01
603979 20160930 0.4200 0.3482 2.860000e+00 8.1284 3.870000e+00
603986 20160930 1.8600 1.2464 4.380000e+00 12.3687 6.620000e+00
603987 20160930 0.4800 0.4600 1.750000e+00 4.2100 1.270000e+00
603988 20160930 0.3100 0.2431 2.680000e+00 8.0847 4.100000e+00
603989 20160930 0.6690 0.5477 1.370000e+00 5.7263 3.090000e+00
603990 20160930 0.3600 0.3300 -4.039810e+34 3.4700 -4.039810e+34
603993 20160930 0.0346 0.0391 1.900000e-01 1.0560 6.300000e-01
603996 20160930 0.2029 0.1966 1.430000e+00 4.4599 1.860000e+00
603997 20160930 0.4200 0.3964 1.330000e+00 3.4661 9.700000e-01
603998 20160930 0.1300 0.1190 7.700000e-01 2.1109 3.900000e-01
603999 20160930 0.2200 0.1883 2.360000e+00 5.6306 1.970000e+00
col6 col7 col8 col9 ... col269 \
code ...
000001 9.443 -8.910 4.270140e+11 1.598400e+10 ... -4.039810e+34
000002 8.229 3.894 7.518702e+10 -4.039810e+34 ... -1.323910e+08
000004 15.276 1.600 1.404810e+08 -4.039810e+34 ... -4.039810e+34
000005 10.431 -0.092 1.440327e+08 -4.039810e+34 ... -4.039810e+34
000006 2.635 1.124 2.287849e+09 -4.039810e+34 ... -5.466768e+05
000007 4.527 -0.138 2.016645e+07 2.139842e+08 ... -4.039810e+34
000008 3.735 -0.036 1.327967e+09 5.238800e+05 ... -4.039810e+34
000009 4.636 0.012 2.128161e+09 3.582522e+08 ... -5.688474e+07
000010 0.999 -0.228 4.671235e+08 -4.039810e+34 ... -4.039810e+34
000011 -0.352 3.525 2.717239e+09 -4.039810e+34 ... 6.211395e+05
000012 8.981 0.767 3.069944e+08 -4.039810e+34 ... 7.055550e+05
000014 -2.541 0.825 2.034572e+08 -4.039810e+34 ... -4.039810e+34
000016 -1.612 -0.171 2.337841e+09 1.216953e+07 ... -2.369660e+07
000017 15.027 -0.010 1.808437e+07 -4.039810e+34 ... -4.039810e+34
000018 18.812 -0.993 9.742814e+08 5.700000e+07 ... -4.039810e+34
000019 -3.035 -0.003 1.225161e+08 2.709116e+06 ... -4.039810e+34
000020 1.426 -0.251 4.236820e+07 -4.039810e+34 ... -4.039810e+34
000021 5.652 0.039 2.976159e+09 -4.039810e+34 ... -6.325504e+07
000022 9.273 0.889 4.582775e+08 -4.039810e+34 ... 4.500000e+04
000023 2.144 0.362 1.890150e+08 -4.039810e+34 ... -4.039810e+34
000025 2.931 0.116 1.640584e+08 -4.039810e+34 ... -4.039810e+34
000026 4.565 0.663 4.780246e+08 -4.039810e+34 ... 9.198679e+06
000027 6.248 0.512 5.245121e+09 1.939415e+07 ... -7.888285e+08
000028 11.913 1.462 2.095024e+09 -4.039810e+34 ... -4.039810e+34
000029 9.229 0.545 1.329914e+09 -4.039810e+34 ... -2.717649e+06
000030 10.349 0.244 9.903030e+08 -4.039810e+34 ... 1.348427e+05
000031 1.394 2.002 1.462336e+10 -4.039810e+34 ... -2.042459e+06
000032 3.993 -0.115 6.154804e+08 -4.039810e+34 ... -2.995117e+05
000034 12.956 1.479 1.410261e+09 1.399109e+07 ... 2.164345e+07
000035 6.807 0.071 1.883278e+08 -4.039810e+34 ... 2.507310e+04
... ... ... ... ... ... ...
603889 12.241 0.483 2.707596e+08 -4.039810e+34 ... 3.241688e+05
603898 14.553 0.747 2.130302e+08 -4.039810e+34 ... -4.039810e+34
603899 16.948 0.431 3.915420e+08 -4.039810e+34 ... -4.039810e+34
603900 14.951 0.284 9.300240e+07 -4.039810e+34 ... -4.039810e+34
603901 8.039 0.090 2.312585e+08 -4.039810e+34 ... -2.405524e+06
603909 6.967 -0.020 2.498567e+08 -4.039810e+34 ... -4.039810e+34
603918 0.921 -0.410 2.041037e+08 -4.039810e+34 ... 1.811435e+05
603919 10.150 0.424 3.157980e+08 -4.039810e+34 ... -4.039810e+34
603928 14.276 0.500 -4.039810e+34 -4.039810e+34 ... -4.039810e+34
603929 22.875 1.630 4.799040e+08 -4.039810e+34 ... 4.487524e+05
603936 4.261 0.284 7.251769e+07 -4.039810e+34 ... -4.039810e+34
603939 5.502 0.496 8.293762e+08 -4.039810e+34 ... -4.039810e+34
603955 5.823 -0.315 1.074242e+08 -4.039810e+34 ... -4.039810e+34
603958 4.853 -0.345 3.023830e+08 -4.039810e+34 ... 9.406000e+01
603959 6.364 -0.624 2.122187e+08 -4.039810e+34 ... -4.039810e+34
603966 7.384 0.071 -4.039810e+34 -4.039810e+34 ... -4.039810e+34
603968 8.293 0.731 5.611996e+08 -4.039810e+34 ... 8.682933e+07
603969 6.414 -0.372 1.905104e+08 -4.039810e+34 ... -4.039810e+34
603977 12.978 0.138 1.331134e+08 -4.039810e+34 ... -4.039810e+34
603979 4.502 0.039 1.077638e+09 -4.039810e+34 ... 8.011324e+06
603986 11.692 0.341 9.135201e+08 -4.039810e+34 ... 4.080189e+06
603987 11.505 0.950 1.647707e+08 -4.039810e+34 ... 2.212053e+04
603988 3.807 0.312 1.255832e+08 -4.039810e+34 ... -4.039810e+34
603989 11.679 0.871 1.253851e+08 -4.039810e+34 ... -4.039810e+34
603990 10.387 -0.430 -4.039810e+34 -4.039810e+34 ... -4.039810e+34
603993 3.272 0.051 1.379868e+10 -4.039810e+34 ... 4.327319e+08
603996 4.550 -1.612 3.998874e+08 -4.039810e+34 ... -4.039810e+34
603997 12.163 0.232 2.511757e+08 -4.039810e+34 ... -3.578334e+05
603998 6.225 0.095 1.402175e+08 -4.039810e+34 ... -4.039810e+34
603999 3.841 -0.091 7.934580e+08 -4.039810e+34 ... -4.039810e+34
col270 col271 col272 col273 col274 \
code
000001 -4.039810e+34 1.982280e+11 -4.039810e+34 -4.039810e+34 3.000000e+00
000002 1.115786e+10 1.004035e+11 -4.039810e+34 -4.039810e+34 3.000000e+00
000004 2.049414e+07 9.622171e+07 -4.039810e+34 -4.039810e+34 3.000000e+00
000005 1.418844e+08 1.282481e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000006 1.192260e+08 4.345017e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000007 2.610958e+07 3.840931e+08 -4.039810e+34 -4.039810e+34 5.000000e+00
000008 2.192151e+08 5.806598e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
000009 3.095417e+08 4.537704e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000010 2.120866e+07 2.197508e+09 -4.039810e+34 -4.039810e+34 5.000000e+00
000011 -6.581346e+06 2.045647e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000012 7.193658e+08 7.960068e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
000014 -1.807685e+07 6.900746e+08 -4.039810e+34 -4.039810e+34 2.000000e+00
000016 -7.290796e+07 2.749445e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
000017 2.908600e+06 1.384561e+07 -4.039810e+34 -4.039810e+34 1.000000e+00
000018 3.021527e+08 1.611590e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000019 -3.457629e+07 9.080634e+08 -4.039810e+34 -4.039810e+34 4.000000e+00
000020 4.509368e+06 3.162196e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
000021 2.382927e+08 5.370609e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000022 5.357717e+08 4.607139e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000023 1.327638e+07 3.856641e+08 -4.039810e+34 -4.039810e+34 4.000000e+00
000025 2.645007e+07 8.943844e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
000026 1.172294e+08 2.372769e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
000027 6.491590e+08 2.141429e+10 -4.039810e+34 -4.039810e+34 6.000000e+00
000028 7.414438e+08 6.067417e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000029 2.341457e+08 2.566677e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000030 5.261127e+08 5.016260e+09 -4.039810e+34 -4.039810e+34 7.000000e+00
000031 5.697928e+08 5.505274e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
000032 4.932095e+07 1.429495e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
000034 3.550317e+08 2.576659e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
000035 1.351716e+08 1.985543e+09 -4.039810e+34 -4.039810e+34 5.000000e+00
... ... ... ... ... ...
603889 1.471138e+08 1.157132e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
603898 1.537245e+08 1.056298e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603899 3.915385e+08 2.332281e+09 -4.039810e+34 -4.039810e+34 3.000000e+00
603900 1.744737e+08 1.169201e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603901 6.799456e+07 8.745853e+08 -4.039810e+34 -4.039810e+34 2.000000e+00
603909 3.882492e+07 5.572858e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603918 4.387192e+06 4.567674e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603919 1.603764e+08 1.580145e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603928 -4.039810e+34 5.885758e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603929 1.523837e+08 6.642006e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603936 3.920257e+07 9.200745e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603939 1.621174e+08 2.896458e+09 -4.039810e+34 -4.039810e+34 2.000000e+00
603955 -4.039810e+34 6.833366e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603958 5.319241e+07 1.145718e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603959 5.225857e+07 8.211226e+08 -4.039810e+34 -4.039810e+34 7.000000e+00
603966 -4.039810e+34 4.947879e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603968 1.891111e+08 1.233334e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
603969 1.012892e+08 1.548160e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
603977 8.681725e+07 6.559561e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603979 1.721269e+08 3.657779e+09 -4.039810e+34 -4.039810e+34 4.000000e+00
603986 1.500086e+08 1.236874e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603987 9.139743e+07 6.644750e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603988 2.462353e+07 6.467779e+08 -4.039810e+34 -4.039810e+34 1.000000e+00
603989 2.000954e+08 1.717886e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
603990 -4.039810e+34 2.082668e+08 -4.039810e+34 -4.039810e+34 -4.039810e+34
603993 1.000944e+09 1.783349e+10 -4.039810e+34 -4.039810e+34 5.000000e+00
603996 6.090624e+07 1.338631e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603997 1.775536e+08 1.455776e+09 -4.039810e+34 -4.039810e+34 1.000000e+00
603998 6.093081e+07 9.145565e+08 -4.039810e+34 -4.039810e+34 2.000000e+00
603999 6.124773e+07 1.621625e+09 -4.039810e+34 -4.039810e+34 -4.039810e+34
col275 col276 col277 col278
code
000001 8.899357e+08 2.284400e+10 -4.039810e+34 -4.039810e+34
000002 2.928035e+09 1.952733e+10 -4.039810e+34 -4.039810e+34
000004 3.416154e+07 1.356895e+07 -4.039810e+34 -4.039810e+34
000005 2.188648e+08 1.083661e+08 -4.039810e+34 -4.039810e+34
000006 2.149200e+08 2.544113e+08 -4.039810e+34 -4.039810e+34
000007 5.980906e+07 4.306942e+07 1.000000e+00 9.205418e+06
000008 7.099678e+07 3.067550e+08 2.000000e+00 4.555090e+07
000009 3.758013e+08 2.810229e+08 -4.039810e+34 -4.039810e+34
000010 8.164534e+07 5.262458e+07 1.000000e+00 2.180000e+06
000011 3.111445e+07 1.031617e+08 -4.039810e+34 -4.039810e+34
000012 1.914432e+08 8.534831e+08 -4.039810e+34 -4.039810e+34
000014 8.952402e+07 3.641715e+07 -4.039810e+34 -4.039810e+34
000016 5.237469e+08 -4.489407e+08 -4.039810e+34 -4.039810e+34
000017 6.350875e+07 1.404106e+06 -4.039810e+34 -4.039810e+34
000018 1.178959e+08 4.072863e+08 -4.039810e+34 -4.039810e+34
000019 1.348447e+08 -5.458496e+07 -4.039810e+34 -4.039810e+34
000020 1.164899e+08 -1.968603e+07 -4.039810e+34 -4.039810e+34
000021 7.654823e+08 3.438597e+08 1.000000e+00 2.131809e+07
000022 3.708780e+08 5.374819e+08 -4.039810e+34 -4.039810e+34
000023 6.011656e+07 7.755122e+06 1.000000e+00 2.751968e+06
000025 1.399252e+08 5.028900e+07 -4.039810e+34 -4.039810e+34
000026 1.629773e+08 1.234085e+08 -4.039810e+34 -4.039810e+34
000027 1.131110e+09 1.539587e+09 -4.039810e+34 -4.039810e+34
000028 1.204936e+08 9.100522e+08 -4.039810e+34 -4.039810e+34
000029 6.440498e+08 3.040127e+08 -4.039810e+34 -4.039810e+34
000030 8.882511e+08 6.595002e+08 -4.039810e+34 -4.039810e+34
000031 8.941296e+08 2.848329e+08 -4.039810e+34 -4.039810e+34
000032 1.312180e+08 5.270708e+07 -4.039810e+34 -4.039810e+34
000034 1.225682e+08 3.286727e+08 -4.039810e+34 -4.039810e+34
000035 1.796981e+08 2.424095e+08 -4.039810e+34 -4.039810e+34
... ... ... ... ...
603889 6.820970e+06 1.603828e+08 -4.039810e+34 -4.039810e+34
603898 2.413832e+06 2.107529e+08 -4.039810e+34 -4.039810e+34
603899 5.653920e+07 4.925784e+08 -4.039810e+34 -4.039810e+34
603900 -4.039810e+34 2.144446e+08 -4.039810e+34 -4.039810e+34
603901 6.581622e+06 8.803580e+07 -4.039810e+34 -4.039810e+34
603909 1.898310e+05 5.396724e+07 -4.039810e+34 -4.039810e+34
603918 5.747000e+06 3.381602e+07 -4.039810e+34 -4.039810e+34
603919 -4.039810e+34 2.090605e+08 -4.039810e+34 -4.039810e+34
603928 -4.039810e+34 1.115636e+08 -4.039810e+34 -4.039810e+34
603929 -4.039810e+34 7.947659e+07 -4.039810e+34 -4.039810e+34
603936 2.000000e+05 5.622046e+07 -4.039810e+34 -4.039810e+34
603939 7.600800e+07 2.100408e+08 -4.039810e+34 -4.039810e+34
603955 -4.039810e+34 6.541915e+07 -4.039810e+34 -4.039810e+34
603958 8.297000e+05 9.853183e+07 3.000000e+00 1.389280e+06
603959 1.974217e+06 8.938431e+07 -4.039810e+34 -4.039810e+34
603966 -4.039810e+34 6.442945e+07 -4.039810e+34 -4.039810e+34
603968 4.077678e+07 1.181551e+08 -4.039810e+34 -4.039810e+34
603969 3.383830e+07 1.305681e+08 -4.039810e+34 -4.039810e+34
603977 -4.039810e+34 1.145088e+08 -4.039810e+34 -4.039810e+34
603979 5.604840e+07 1.792680e+08 -4.039810e+34 -4.039810e+34
603986 -4.039810e+34 1.814127e+08 -4.039810e+34 -4.039810e+34
603987 -4.039810e+34 1.016679e+08 -4.039810e+34 -4.039810e+34
603988 1.693000e+05 3.177139e+07 1.000000e+00 1.170000e+05
603989 -4.039810e+34 2.780564e+08 -4.039810e+34 -4.039810e+34
603990 -4.039810e+34 5.574688e+07 -4.039810e+34 -4.039810e+34
603993 1.084705e+10 7.037434e+08 -4.039810e+34 -4.039810e+34
603996 3.500000e+05 8.817671e+07 -4.039810e+34 -4.039810e+34
603997 1.699990e+07 2.242684e+08 -4.039810e+34 -4.039810e+34
603998 6.733272e+07 7.479159e+07 -4.039810e+34 -4.039810e+34
603999 -4.039810e+34 1.010977e+08 -4.039810e+34 -4.039810e+34
[3118 rows x 279 columns]
|
|
这个很重要 留存 |
@yutiansut @yssource @datochan 因为我看到官方的文档有更新,然后对照了一下字段数量,感觉多了一些,对照了具体代码 header 里面的一个字段,感觉有点像字节长度么,然后除以 sizeof(float) , 得出来的字段数,我不确定是否准确,但是感觉是差不多的,不过我看官方文档只更新到 276 个,不知道后面的2个是否有实际的用途 |
@rainx 而且有重复的 |
对照中文字段说明和实际数值, 感觉那些重复的数值不太对. 比如 col256 ~ col263 |
这个 float In [3]: struct.pack("f", -4.03981033463327e+34)
Out[3]: b'\xf8\xf8\xf8\xf8' 另外,我把代码更新到主干了 ,并提交了1.65版本 文档简单写了一下 |
我建议是 有一种直接 request.get()然后就直接parse 不用先下载到本地 @rainx |
直接下载到本地版本 @yssource @datochan @rainx import requests
from pytdx.reader.history_financial_reader import HistoryFinancialReader
from pytdx.crawler.history_financial_crawler import HistoryFinancialCrawler, HistoryFinancialListCrawler
"""
参见PYTDX 1.65
"""
FINANCIAL_URL = 'http://down.tdx.com.cn:8001/fin/gpcw.txt'
def get_filename():
"""
get_filename
"""
return [l[0] for l in [line.strip().split(",") for line in requests.get(FINANCIAL_URL).text.strip().split('\n')]]
def download():
result = get_filename()
for item in result:
r = requests.get('http://down.tdx.com.cn:8001/fin/{}'.format(item))
with open(item, "wb") as code:
code.write(r.content) |
@rainx @yssource @yutiansut 我上面贴的是我2016年的笔记,里面的字段比较久,少一些都正常的。 |
@yutiansut @datochan 春节没碰电脑,刚看到, 的确,主要是考虑到更新的问题,本地可以维护一个历史信息的列表,所以才进行下载,如果不加下载参数,我默认使用临时文件的形式来维护的 |
@rainx 我是本地维护zip文件,代码直接操作zip文件查询财务数据。每次要更新财务数据的时候,就对这些zip文件计算下md5的hash值,与 |
嗯,这样更新比较好,可以减少下载次数 |
导出的数据很多是科学计算法,能否导出是普通的数字? |
导出的数据很多是科学计算法,能否导出是普通的数字?比如有很多数据不知道是不是重复还是什么问题,数据都是-4.03981033463327e+30 |
现在已经有284列了,持续扩张中,是不是现有的数据含义保持不变?否则用起来也很痛苦的 |
已经自动扩展了 @gzadigo |
研究了下通达信财务数据,有个问题,那些没有的数据,他默认填了0,但是也有真实情况下就是0的情况吧,这个容易混淆,不过关系应该不大。有一个比较麻烦的是,他有些数据的单位是万元,有的是元,这个就不好处理了,也不知道他会不会变化 |
没有数据 是一个很大的负数吧 |
这个数据源好像停更了 |
@testttt0 是的 通达信的软件上2018年年报也没 不过确实部分公司年报没出完 |
@yutiansut 财务数据的文件包好像好几个月都没有更新了, 知道啥情况不? |
年度报告最迟4月份要出,估计要等到4月底 |
期待更新中... |
4月底也不会出的,官网针对性的升级了。不允许这样使用财报数据了,大家再想别的办法吧~ |
不存在,数据无影响 |
我也发现财务数据不再更新了。 |
打开通达信金融终端,可以看到最新的文件为20180930。这说明通达信官方并没有新的文件产生。至于为何2019年的没有产生,就不清楚了。 |
@rainx @yutiansut @JaysonAlbert
get_finance_info, 只能拿到当前的财务.
有没有办法拿到历史的财务数据呢?
谢谢.
The text was updated successfully, but these errors were encountered: