|
楼主 |
发表于 2017-11-13 15:57
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
文接53楼
一般以接近数据的地方使用split。
虽然快要接近数据,但是每只股票的数据,不容易取
.
这样就可以啦。
这是每只股票的数据是这样的:
2017-11-14T00:00:00+08:00","ATTACHTYPE":"0","ATTACHSIZE":148,"ENDDATE":"2017-11-14T00:00:00+08:00","NOTICETITLE":"600446:金证股份2017年公开发行公司债券(面向合格投资者)(第一期)票面利率公告","INFOCODE":"AN201711131034598817","CDSY_SECUCODES":[{"SECURITYVARIETYCODE":"1000001753","SECURITYTYPECODE":"058001001","SECURITYCODE":"600446","SECURITYFULLNAME":"金证股份","SECURITYSHORTNAME":"金证股份","SECURITYTYPE":"A股","TRADEMARKETCODE":"069001001001","TRADEMARKET":"上交所主板","LISTINGSTATE":"0","COMPANYCODE":"10001321","Eid":0},{"SECURITYVARIETYCODE":"1001023435","SECURITYTYPECODE":"060","SECURITYCODE":"143367","SECURITYFULLNAME":"深圳市金证科技股份有限公司2017年公开发行公司债券(面向合格投资者)(第一期)","SECURITYSHORTNAME":"17金证01","SECURITYTYPE":"债券","TRADEMARKETCODE":"069001001","TRADEMARKET":"上海证券交易所","LISTINGSTATE":"9","COMPANYCODE":"10001321","Eid":0}],"ANN_RELCOLUMNS":[{"COLUMNCODE":"001002008","COLUMNNAME":"其他","NodeName":null,"Eid":0,"Order":999},{"COLUMNCODE":"003006005","COLUMNNAME":"票面利率
公告","NodeName":null,"Eid":0,"Order":999}],"ANN_RELCODES":[{"CODETYPE":"058001001","CODEMARKET":"069001001001","SECURITYCODE":"600446","COMPANYCODE":null,"Eid":0},{"CODETYPE":"060","CODEMARKET":"069001001","SECURITYCODE":"143367","COMPANYCODE":null,"Eid":0},{"CODETYPE":"058001001","CODEMARKET":"069001001001","SECURITYCODE":"600446","COMPANYCODE":null,"Eid":0},{"CODETYPE":"060","CODEMARKET":"069001001","SECURITYCODE":"143367","COMPANYCODE":null,"Eid":0}],"EUTIME":"2017-11-13T15:37:20+08:00","TABLEID":207000003488873539,"Order":999,"Url":"http://data.eastmoney.com/notices/detail/600446/AN201711131034598817,JWU5JTg3JTkxJWU4JWFmJTgxJWU4JTgyJWExJWU0JWJiJWJk.html"},{"
怪不得这磨难弄,里面有嵌套,看来用split需要多走几步,方可取得数据。
|
|