Katelynn's Report

Katelynn's Report

(US Market)

Help










Font Size:

SCHEDULE 13G/D

SC 13G/D is filed when there is acquisition of beneficial ownership of more than 5% but less than 20% of a voting class of a company’s equity security with (13D) or without (13G) the intention of controlling the subject company. SC 13G/D amendment is filed when there is change (either acquisition or disposition) in previously reported holding (check Schedule 13D for details). SC 13G/D is filed more frequently than , thus reflects more up-to-date change in institutional holding. The dataportal provides two tables (form13gds, form13gdqtls) that keep record of the 13G/D (and amendment) filings parsed from original filing, and summary statistics evaluating the relative investment company (IVC) trading activity on the market.


form13gds: SC 13G/D holding

form13gds table contains 13G/D and any amendments filed to the SEC. The table is constructed as shown below.

CREATE TABLE `form13gds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fdate` date NOT NULL,
`reqdate` date DEFAULT NULL,
`ftype` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`rcik` bigint(20) NOT NULL,
`reporter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`scik` bigint(20) DEFAULT NULL,
`issuername` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`gstidcpn` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`gstidsec` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`svp` int(11) NOT NULL,
`shvp` int(11) NOT NULL,
`sdp` int(11) NOT NULL,
`shdp` int(11) NOT NULL,
`shamount` int(11) NOT NULL,
`percentage` decimal(4,1) DEFAULT NULL,
`numentity` int(11) NOT NULL,
`fingerprint` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `record_unique_index` (`fdate`,`rcik`,`gstidsec`,`svp`,`shvp`,`sdp`,`shdp`,`shamount`),
KEY `index_form13gds_on_fdate` (`fdate`),
KEY `index_form13gds_on_rcik` (`rcik`),
KEY `index_form13gds_on_scik` (`scik`),
KEY `index_form13gds_on_gstidcpn` (`gstidcpn`),
KEY `index_form13gds_on_gstidsec` (`gstidsec`),
KEY `index_form13gds_on_rcik_and_scik` (`rcik`,`scik`),
KEY `index_form13gds_on_fdate_and_rcik` (`fdate`,`rcik`),
KEY `index_form13gds_on_fdate_and_scik` (`fdate`,`scik`),
KEY `index_form13gds_on_fdate_and_rcik_and_scik` (`fdate`,`rcik`,`scik`)
) ENGINE=InnoDB AUTO_INCREMENT=455226 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

fdate: The filing date of the 13G/D report.

reqdate: The required date of report. SC 13G/D is required to be filed within 10 days after transaction (frequently violated).

ftype: The form type. Possible values are "sc 13g", "sc 13g/a", "sc 13d", "sc 13d/a";

rcik: Central index key of the acquirer.

reporter: Full name of the acquirer.

scik: Central index key of the subject company.

issuername: Full name of the subject company.

gstidsec: Same as gstidsec in 13F holding.

gstidcpn: Same as gstidcpn in 13F holding.

svp: Sole voting power.

shvp: Shared voting power.

sdp: Sole disposition power.

shdp: Shared disposition power.

shamount: Aggregated amount of shares.

percentage: Percentage of holding share amount relative to shares outstanding.

numentity: Number of entity(s) with the shared voting/disposition power.

fingerprint: A string for identifying the filing.


form13gdqtls: SC 13G/D holding quantile ranking

form13gdqtls table provides for certain security the quantile ranking of the number of 13G/D (and amendment) reports on the whole market during the past three or six months. The quantile ranking can serve as a short term indicator of the level of trading activity amount IVCs.

CREATE TABLE `form13gdqtls` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gstidcpn` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`gstidsec` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`count3m` int(11) NOT NULL DEFAULT '0',
`count6m` int(11) NOT NULL DEFAULT '0',
`count3m_allqt` decimal(3,2) DEFAULT NULL,
`count6m_allqt` decimal(3,2) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_form13gdqtls_on_gstidsec` (`gstidsec`),
KEY `index_form13gdqtls_on_gstidcpn` (`gstidcpn`)
) ENGINE=InnoDB AUTO_INCREMENT=32768 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

gstidsec: Same as gstidsec in 13F holding.

gstidcpn: Same as gstidcpn in 13F holding.

count3m: The count of 13G/D and amendment(s) filing in the past three months.

count6m: The count of 13G/D and amendment(s) filing in the past six months.

count3m_allqt: Quantile ranking [0~1] of count3m on the whole market.

count6m_allqt: Quantile ranking [0~1] of count6m on the whole market.