Help

Introduction
Function Introduction
Key Metrics
Data Portal
API
- API access
SEC Forms
- Form 4
- Form 3
- Form 5
- CT ORDER
- Form 13F
- Form SC 13D
- Form SC 14D9
- Form SC 13G
- Form SC 13E1
- Form SC 13E3
- Form SC TO
- Form S-3D
- Form S-1
- Form F-1
- Form 8-k
- Form 1-E
- Form 144
- Form 20-F
- Form ARS
- Form 6-K
- Form 10-K
- Form 10-Q
- Form 10-KT
- Form 10-QT
- Form 11-K
- Form DEF 14A
- Form 10-D
- Form 13H
- Form 24F-2
- Form 15
- Form 25
- Form 40-F
- Form 424
- Form 425
- Form 8-A
- Form 8-M
- Form ADV-E
- Form ANNLRPT
- Form APP WD
- Form AW
- Form CB
- Form CORRESP
- Form DSTRBRPT
- Form EFFECT
- Form F-10
- Form F-3
- Form F-4
- Form F-6
- Form F-7
- Form F-9
- Form F-n
- Form X-17A-5
- Form F-X
- Form FWP
- Form G-405
- Form G-FIN
- Form MSD
- Form N-14
- Form N-18F1
- Form N-18F1
- Form N-30B-2
- Form N-54A
- Form N-8A
- Form N-CSR
- Form N-MFP
- Form N-PX
- Form N-Q
- Form TTW
- Form TA-1
- Form T-3
- Form SC 14F1
- Form SE
- Form SP 15D2
- Form SUPPL
- Form 10-12G
- Form 18-K
- Form SD
- Form STOP ORDER
- Form TH
- Form 1
- Form 19B-4(e)
- Form 40-APP
- Form 497
- Form ABS-15G
- Form DRS
- Form MA
- Form UNDER
AI sentiment
Access guide
Academy
Term of service
GDPR compliance
Contact Us
Question Center

Font Size:

IVC holding

The data portal provides longitudinal view of the holding share values at industry and sector levels by each investment company (IVC). The share values are summarized from calibrated share value in 13F report. The holding at per security level is available through 13F Holding table.

ivcidshlds: IVC industry level holding

IVC industry level holding tracks the IVC holding share values in more than 100 industrial categories that was generated according to industry classification of NAICS (North American Industry Classification System). The industrial category of each security was actively maintained by us to promptly reflect any changes, either caused by changes in the security issuer's business or changes in classification standard. The table is constructed as shown below

CREATE TABLE `ivcidshlds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`idscode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`value` int(11) NOT NULL,
`chg` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_ivcidshlds_on_cik_and_period_and_idscode` (`cik`,`period`,`idscode`),
KEY `index_ivcidshlds_on_cik` (`cik`),
KEY `index_ivcidshlds_on_period` (`period`),
KEY `index_ivcidshlds_on_idscode` (`idscode`)
) ENGINE=InnoDB AUTO_INCREMENT=16494432 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

cik: Central index key of the investment company.

period: The reporting period. There are four periods each year (Mar 31st, Jun 30th, Sep 30th, Dec 31st).

idscode: The internal industry classification code, which can be mapped to NAICS code and industry name through idscode2naics table.

value: Calibrated holding share values in 1000 US dollars.

IVC sector level holding

IVC sector level holding tracks the IVC holding share values in 12 major sectors generated according to NAICS. The table is constructed as shown below

CREATE TABLE `ivcsechlds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`seccode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`value` int(11) NOT NULL,
`chg` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_ivcsechlds_on_cik_and_period_and_seccode` (`cik`,`period`,`seccode`),
KEY `index_ivcsechlds_on_cik` (`cik`),
KEY `index_ivcsechlds_on_period` (`period`),
KEY `index_ivcsechlds_on_seccode` (`seccode`)
) ENGINE=InnoDB AUTO_INCREMENT=3759251 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

cik: Central index key of the investment company.

period: The reporting period. There are four periods each year (Mar 31st, Jun 30th, Sep 30th, Dec 31st).

seccode: The internal sector classification code, which can be mapped to sector name through seccode2sectors table.

value: Calibrated holding share values in 1000 US dollars.