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

来自cslt Wiki
跳转至: 导航搜索
 
(相同用户的12个中间修订版本未显示)
第1行: 第1行:
 
INTRODUCTION
 
INTRODUCTION
 
------------
 
------------
FactorDB v4.47 Mysql is the mysql data format version of the factor DB 4.47
+
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]
 
+
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  
 
This database was organized by Yaodong Wang when he worked in CSLT@Tsinghua University  
  
as a intern. This version was released in 2017.01.16.
+
as an intern. This version was released in 2017.01.16.
  
 
The total data amount is from the starting of China A market
 
The total data amount is from the starting of China A market
第29行: 第27行:
 
5. 4_32_ASHAREMONTHLYYIELD (中国A股月收益率)
 
5. 4_32_ASHAREMONTHLYYIELD (中国A股月收益率)
  
6. 4.33 ASHAREEODDERIVATIVEINDICATOR (中国 A 股日行情估值指标)
+
6. 4_33_ASHAREEODDERIVATIVEINDICATOR (中国 A 股日行情估值指标)
  
7. 4.36 ASHAREMARGINTRADE (中国 A 股融资融券交易明细)
+
7. 4_36_ASHAREMARGINTRADE (中国 A 股融资融券交易明细)
  
8. 4.37 ASHAREMARGINTRADESUM (中国 A 股融资融券交易汇总)
+
8. 4_37_ASHAREMARGINTRADESUM (中国 A 股融资融券交易汇总)
  
9. 4.45 ASHAREMONEYFLOW (中国 A 股资金流向数据)
+
9. 4_45_ASHAREMONEYFLOW (中国 A 股资金流向数据)
  
10. 4.47 ASHAREL2INDICATORS (中国 A 股LEVEL2指标)
+
10. 4_47_ASHAREL2INDICATORS (中国 A 股LEVEL2指标)
  
11. 4.51 ASHAREBALANCESHEET (中国 A 股资产负债表)
+
11. 4_51_ASHAREBALANCESHEET (中国 A 股资产负债表)
  
12. 4.52 ASHAREINCOME (中国 A 股利润表)
+
12. 4_52_ASHAREINCOME (中国 A 股利润表)
  
13. 4.53 ASHARECASHFLOW (中国 A 股现金流量表)
+
13. 4_53_ASHARECASHFLOW (中国 A 股现金流量表)
  
14. 4.54 ASHAREFINANCIALINDICATOR (中国 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
  
  
第61行: 第80行:
  
 
Dong Wang: wangdong99@mails.tsinghua.edu.cn
 
Dong Wang: wangdong99@mails.tsinghua.edu.cn
 
 
 
LOCATION
 
--------
 
 
.../corpora/finance/factordb/v4.47
 

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