- Introduction
- Function Introduction
- Performance Monitor
- Fusion Hunter
- Quantitative Chart
- SEC Filing
- Insider Trading (Search by Ticker)
- Insider Trading (Search by Reporter)
- Insider Trading (Top Insider Trading)
- Institutional Holdings
- Investment Trends (Investment Company List)
- Investment Trends (Sector & Industry Sentiment)
- Investment Trends (Investment Company Sentiment)
- Investment Trends (Top Institutional Trading)
- Investment Trends (Top Institutional Hldg Change)
- Key Ratio Distribution
- Screener
- Financial Statement
- Key Metrics
- High Current Difference
- Low Current Difference
- Relative Strength Index
- KDJ
- Bollinger Bands
- Price Earnings Ratio
- Price to Book Value
- Debt Equity Ratio
- Leverage Ratio
- Return on Equity
- Return on Assets
- Gross Margin
- Net Profit Margin
- Operating Margin
- Income Growth
- Sales Growth
- Quick Ratio
- Current Ratio
- Interest Coverage
- Institutional Ownership
- Sector & Industry Classification
- Data Portal
- API
- 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: |
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=16789272 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=2076582 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=31088654 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.