“Finance-delivery-database-factor-4.47-mysql”版本间的差异

来自cslt Wiki
跳转至: 导航搜索
第60行: 第60行:
 
mysql database with program :
 
mysql database with program :
  
host='192.168.0.103',
+
host='192.168.0.103'
  
port=3306,
+
port=3306
  
 
username: usemysql
 
username: usemysql

2017年1月16日 (一) 06:28的版本

INTRODUCTION


FactorDB v4.47 Mysql is the mysql data format version of the factor DB 4.47

http://cslt.riit.tsinghua.edu.cn/mediawiki/index.php/Finance-delivery-database-factor-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