“Finance-delivery-database-factor-4.47-mysql”版本间的差异
| （相同用户的24个中间修订版本未显示） | |||
| 第1行： | 第1行： | ||
| − | |||
INTRODUCTION | INTRODUCTION | ||
------------ | ------------ | ||
| − | FactorDB v4.47 Mysql is the mysql data format version of the | + | FactorDB v4.47 Mysql is the mysql data format version of the [http://cslt.riit.tsinghua.edu.cn/mediawiki/index.php/Finance-delivery-database-factor-4.47 factor DB 4.47] |
| − | [ | + | |
| − | + | This database was organized by Yaodong Wang when he worked in CSLT@Tsinghua University | |
| − | CSLT@Tsinghua University | + | |
| − | + | as an intern. This version was released in 2017.01.16. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | released in 2017.01. | + | |
The total data amount is from the starting of China A market | The total data amount is from the starting of China A market | ||
| − | to 2016.12 | + | |
| − | + | to 2016.12. | |
| 第20行： | 第15行： | ||
---------- | ---------- | ||
| − | + | The present database involves 16 data sets, listed as follows: | |
| − | database involves | + | |
| − | 1. 4. | + | 1. 4_28_ASHAREODPRICES (中国A股日行情) |
| − | + | ||
| − | + | 2. 4_29_ASHARECALENDAR (中国A股交易日历) | |
| − | + | ||
| − | + | 3. 4_30_ASHARETRADINGSUSPENSION (中国A股停复牌信息) | |
| − | + | ||
| − | + | 4. 4_31_ASHAREWEEKLYYIELD (中国A股周收益率) | |
| − | + | ||
| − | + | 5. 4_32_ASHAREMONTHLYYIELD (中国A股月收益率) | |
| + | |||
| + | 6. 4_33_ASHAREEODDERIVATIVEINDICATOR (中国 A 股日行情估值指标) | ||
| + | |||
| + | 7. 4_36_ASHAREMARGINTRADE (中国 A 股融资融券交易明细) | ||
| + | |||
| + | 8. 4_37_ASHAREMARGINTRADESUM (中国 A 股融资融券交易汇总) | ||
| + | |||
| + | 9. 4_45_ASHAREMONEYFLOW (中国 A 股资金流向数据) | ||
| + | |||
| + | 10. 4_47_ASHAREL2INDICATORS (中国 A 股LEVEL2指标) | ||
| + | |||
| + | 11. 4_51_ASHAREBALANCESHEET (中国 A 股资产负债表) | ||
| + | |||
| + | 12. 4_52_ASHAREINCOME (中国 A 股利润表) | ||
| + | |||
| + | 13. 4_53_ASHARECASHFLOW (中国 A 股现金流量表) | ||
| + | |||
| + | 14. 4_54_ASHAREFINANCIALINDICATOR (中国 A 股财务指标) | ||
| + | |||
| + | 15. shsz_m1 (中国A股1分钟行情) | ||
| + | |||
| + | 16 sp500_day (标普500天行情) | ||
| + | |||
| + | |||
| + | HOW TO USE | ||
| + | ------------------- | ||
| + | You can access the website http://192.168.0.103/phpmyadmin/index.php | ||
| + | |||
| + | to visualize the mysql database. You can also connect the | ||
| + | |||
| + | mysql database with program : | ||
| + | |||
| + | host='192.168.0.103' | ||
| + | |||
| + | port=3306 | ||
| + | |||
| + | username: usemysql | ||
| + | |||
| + | passwd: 123456 | ||
| 第38行： | 第71行： | ||
All the copy right are reserved by Wind. Any usage of this dataset | All the copy right are reserved by Wind. Any usage of this dataset | ||
| + | |||
should refer to Wind's licence files. | should refer to Wind's licence files. | ||
| 第44行： | 第78行： | ||
-------- | -------- | ||
Yang Wang: wangyang@cslt.riit.tsinghua.edu.cn | Yang Wang: wangyang@cslt.riit.tsinghua.edu.cn | ||
| − | |||
| − | + | Dong Wang: wangdong99@mails.tsinghua.edu.cn | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | ... | + | |
| − | + | ||
| − | + | ||
2017年1月16日 (一) 06:29的最后版本
INTRODUCTION
FactorDB v4.47 Mysql is the mysql data format version of the factor DB 4.47
This database was organized by Yaodong Wang when he worked in CSLT@Tsinghua University
as an intern. This version was released in 2017.01.16.
The total data amount is from the starting of China A market
to 2016.12.
Data Sets
The present database involves 16 data sets, listed as follows:
1. 4_28_ASHAREODPRICES (中国A股日行情)
2. 4_29_ASHARECALENDAR (中国A股交易日历)
3. 4_30_ASHARETRADINGSUSPENSION (中国A股停复牌信息)
4. 4_31_ASHAREWEEKLYYIELD (中国A股周收益率)
5. 4_32_ASHAREMONTHLYYIELD (中国A股月收益率)
6. 4_33_ASHAREEODDERIVATIVEINDICATOR (中国 A 股日行情估值指标)
7. 4_36_ASHAREMARGINTRADE (中国 A 股融资融券交易明细)
8. 4_37_ASHAREMARGINTRADESUM (中国 A 股融资融券交易汇总)
9. 4_45_ASHAREMONEYFLOW (中国 A 股资金流向数据)
10. 4_47_ASHAREL2INDICATORS (中国 A 股LEVEL2指标)
11. 4_51_ASHAREBALANCESHEET (中国 A 股资产负债表)
12. 4_52_ASHAREINCOME (中国 A 股利润表)
13. 4_53_ASHARECASHFLOW (中国 A 股现金流量表)
14. 4_54_ASHAREFINANCIALINDICATOR (中国 A 股财务指标)
15. shsz_m1 (中国A股1分钟行情)
16 sp500_day (标普500天行情)
HOW TO USE
You can access the website http://192.168.0.103/phpmyadmin/index.php
to visualize the mysql database. You can also connect the
mysql database with program :
host='192.168.0.103'
port=3306
username: usemysql
passwd: 123456
LINCENCE
All the copy right are reserved by Wind. Any usage of this dataset
should refer to Wind's licence files.
CONTACT
Yang Wang: wangyang@cslt.riit.tsinghua.edu.cn
Dong Wang: wangdong99@mails.tsinghua.edu.cn
