手工整理了最新的中国证券期货统计年鉴2020及其他的各个excel指标表的数据合并处理,形成各个指标文件的多年度数据,便于多年度之间的分析比对。同时,excel指标文件可以下载、复制copy、黏贴等再利用来进行数据分析挖掘,减轻大量的数据查找和数据合并表处理工作,省时省力!
其excel文件的表头信息大致如下:
行业 Industry | 资产规模 | 经营情况 | 每股指标 | |||||
Asset Size | Business Circumstance | Share Index | ||||||
总资产 | 归属母公司 | 营业收入 | 归属母公司 | 资产负债率 | 平均净资产 | 每股净资产 | 每股收益 | |
(亿元) | 股东净资产 | (亿元) | 股东净利润 | (%) | 收益率 | (元) | (元) | |
Total Asset | (亿元) | Revernue | (亿元) | Asset-liability | (%) | BPS | EPS | |
(100 million | Net Asset | (100 million | Net Profit | Ratio (%) | Average | (yuan) | (yuan) | |
yuan) | Attributable | yuan) | Attributable | ROE | ||||
to Parent | to Parent | (%) | ||||||
Company | Company | |||||||
Shareholders | Shareholders | |||||||
(100 million | (100 million | |||||||
yuan) | yuan) |
农、林、牧、渔 |
Agriculture,Forestry,Animal Husbandry and Fishery |
采矿业 |
Mining |
制造业 |
Manufacturing |
电力、热力、燃气及水生产和供应业 |
Production and Supply of Electricity,Gas and Water |
建筑业 |
Construction |
批发和零售业 |
Wholesale and Retail Trades |
交通运输、仓储和邮政业 |
Transport,Storage and Post |
住宿和餐饮业 |
Hotels and Catering Services |
信息传输、软件和信息技术服务业 |
Information Transmission,Computer Services and Software |
金融业 |
Financial Intermediation |
房地产业 |
Real Estate |
租赁和商务服务业 |
Leasing and Business Services |
科学研究和技术服务业 |
Scientific Research,Technical Service |
水利、环境和公共设施管理业 |
Management of Water Conservancy,Environment and Public Facilities |
教育 |
Education |
卫生和社会工作 |
Health and Social Works |
文化、体育和娱乐业 |
Culture,Sports and Entertainment |
综合 |
Others |