Katelynn's Report

Katelynn's Report

(US Market)

Help










Font Size:

Insider trading

Insider trading dataportal provides information filed in Form 3,4,5 as well as their amendments (check Form 3, Form 4, Form 5 for more readings).The trading history can be traced back to 2013. For each security, there is an associated shares outstanding at the time of transaction.

CREATE TABLE `form345s` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fdate` date NOT NULL,
`recid` smallint(3) DEFAULT NULL,
`derive` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
`formtype` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`reporter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`rcik` int(11) NOT NULL,
`relation` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`trandate` date DEFAULT NULL,
`origsubdate` date DEFAULT NULL,
`sectype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`acname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`operation` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`symbol` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`mysymbol` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`icik` int(11) NOT NULL,
`companyname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`code` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`oprdatesta` date DEFAULT NULL,
`oprdateend` date DEFAULT NULL,
`exsdate` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`amount` decimal(20,7) DEFAULT NULL,
`cost` decimal(20,7) DEFAULT NULL,
`remain` decimal(20,7) DEFAULT NULL,
`metainfo` text COLLATE utf8_unicode_ci,
`shares_outstanding` decimal(20,7) DEFAULT NULL,
`doclink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`footnote_ownership` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`doclinkcik` int(11) NOT NULL,
`void` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_form345s_on_fdate` (`fdate`),
KEY `index_form345s_on_derive` (`derive`),
KEY `index_form345s_on_rcik` (`rcik`),
KEY `index_form345s_on_trandate` (`trandate`),
KEY `index_form345s_on_symbol` (`symbol`),
KEY `index_form345s_on_mysymbol` (`mysymbol`),
KEY `index_form345s_on_icik` (`icik`),
KEY `index_form345s_on_operation` (`operation`)
) ENGINE=InnoDB AUTO_INCREMENT=16786578 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPRESSED

Field definition

fdate: Filing date.

derive: Whether a derivative security transaction. Possible values are 'd' from derivative, and 'n' for non-derivative.

formtype: The submited form type. Possible values are '3','4','5','3/A','4/A','5/A'.

reporter: Name of the reporter.

rcik: Central index key of the reporter.

relation: Relationship of the reporter with the security issuer. E.g. "10% OWNER", "PRESIDENT & CEO"

trandate: The transaction date.

sectype: The security type. E.g. "common stock", "stock units", "option to buy"

acname: The transaction account. The value is "Direct" if it is direct account of the reporter. If not direct account, the values could be "Wife's Ira", "With Spouse And Children", "Profit Sharing Trust" and et ac.

operation: The operation type. Possible values are "acq" for acquisition, "dsp" for disposition, and "holding" for holding report.

symbol: The symbol as appeared in the submitted form.

mysymbol: The symbol for the specific class of security.

icik: Central index key of security issuer.

companyname: Name of the security issuer.

code: Transaction code. Check Form 4 for more readings about transcation code.

oprdate: Date of operation.

exsdate: Exercisable date. For derivative security only. NULL for non-derivative stock.

amount: Transaction share amount.

cost: Cost of the transaction in US dollar.

remain: Remaining share amount after transaction

shares_outstanding: Shares outstanding of the corresponding security.

doclink: Http link to the original filing.


Insider holding

Insider holding table maintains for each class of security the holding shares amount reported by insiders in the latest insider forms (i.e. Form 3, Form 4). It also keep records of the shares amount in previous report.

CREATE TABLE `insiderholdings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fdate` date NOT NULL,
`icik` bigint(20) NOT NULL,
`issuername` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`rcik` bigint(20) NOT NULL,
`reporter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`relation` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`symbol` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`sharesnew` decimal(20,7) NOT NULL,
`fdateold` date DEFAULT NULL,
`sharesold` decimal(20,7) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_insiderholdings_on_icik_and_rcik_and_symbol` (`icik`,`rcik`,`symbol`),
KEY `index_insiderholdings_on_rcik` (`rcik`),
KEY `index_insiderholdings_on_symbol` (`symbol`)
) ENGINE=InnoDB AUTO_INCREMENT=2075433 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

fdate: Filing date of the latest report.

icik: Issuer CIK

issuername: Full name of the issuer

rcik: Reporter CIK

reporter: Full name of the insider

relation: Relationship of the reporter with the security issuer. E.g. "10% OWNER", "PRESIDENT & CEO"

symbol: The trading symbol for the class of security appeared in the submitted form.

sharesnew: The latest holding shares amount, which includes shares with both direct and indirect ownership.

fdateold: Filing date of previous report.

sharesold: The previous holding shares amount.


Insider trading rank

Insider trading rank table provides at per security level the count of certain type of insider transactions in the past three or six months. It also provides statistical summary of the quantile rankings of the count at industry, sector, or market level. The table is updated daily to reflect the most up-to-date trend of insider trading.

CREATE TABLE `isdranks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`companyname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`operation` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
`monthback` int(11) NOT NULL,
`count` int(11) NOT NULL,
`idscode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`seccode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`isd_idsqt` decimal(3,2) DEFAULT NULL,
`isd_secqt` decimal(3,2) DEFAULT NULL,
`isd_allqt` decimal(3,2) DEFAULT NULL,
`amount` bigint(20) DEFAULT NULL,
`shares_outstanding` decimal(17,7) DEFAULT NULL,
`pctso` decimal(7,2) DEFAULT NULL,
`totalcost` decimal(17,3) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_isdranks_on_monthback_and_operation_and_symbol` (`monthback`,`operation`,`symbol`),
KEY `index_isdranks_on_symbol` (`symbol`),
KEY `index_isdranks_on_operation` (`operation`),
KEY `index_isdranks_on_idscode` (`idscode`),
KEY `index_isdranks_on_seccode` (`seccode`),
KEY `index_isdranks_on_monthback` (`monthback`)
) ENGINE=InnoDB AUTO_INCREMENT=31064082 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

symbol: The symbol for the specific class of security filed in the form.

companyname: Name of the security issuer.

operation: "acq" for acqusition, "dsp" for disposition.

monthback: Trace back time in month. Possible values are "3" or "6".

count: Count of transactions. For acquisitions code P (open market purchase) and code L (small acquisition) are counted. For dispositions code S (open market sell) and code D (sell back to issuer) are counted. Same code appeared multiple times in a single filing is counted only once.

idscode: Internal industry classification code.

seccode: Internal sector classification code.

isd_idsqt: Industry quantile [0~1] of the count of transactions.

isd_secqt: Sector quantile [0~1] of the count of transactions.

isd_allqt: Market quantile [0~1] of the count of transactions.

amount: The total amount of shares reported in corresponding transactions.

shares_outstanding: The most recently reported shares outstanding (Million) in XBRL filing.

pctso: The percentage (0~100) of transaction amount relative to shares outstanding.