Description:
Provides insider activity as reported on forms 3, 4, 5, and 144. 2 years of history is available.
Data Source:
B&B (Wealth Mgmt) -- TFN2 database
Update Schedule:
Daily (expect Sunday)
Request Syntax:
CUSIP=xxxxx to back all (derivative transactions, stock transactions, proposed transactions) CUSIP=xxxxx/ACTUAL to get back the "actual" transactions (stock and derivative transactions) Example:CUSIP=56418H100/ACTUAL CUSIP=xxxxx /PROPOSED to get back the "proposed" transactons only Example: CUSIP=56418H100/PROPOSED
Field Listing:
The following fields are available. More fields can be enable if needed.:
Insiders
Field
Description
ACQDISFLAG
Acquisition/Disposition Flag
ACQDISFLAGALT
As reported Acquisition/Disposition Flag code
AMEND
Amendment Indicator
BROKERNAME
Name of Broker Used in Selling
BROKID
Thomson Broker ID
CLEANSE
Cleanse Code: TF level of confidence concerning the accuracy of a particular record contained in the database
CNVRPRICE
Conversion Price of Derivatives
COMPANY
Company
CUSIP
CUSIP
CUSIPCHK
CUSIP number at the time of the transaction
DCNNUM
Internal Thomson Document Control Number
DERVPRICE
Price of Derivative Security
EXERDATE
Exercisable Date of Derivatives
EXPIRDATE
Expiration Date of Derivatives
FULLNAME
The insider’s last, first and middle name
FUNCAREA1
Insider's functional area in the company (eg: Corporate Affairs/Public Relations, Finance/Accounting...)
FUNCAREA2
Insider's functional area in the company (eg: Corporate Affairs/Public Relations, Finance/Accounting...)
HOLDINGS
Resulting Shares Held
HOLDINGSRC
Source of Holdings: AP (adjusted from Proxy) and AR (as reported in insider filing)
MKTVAL
Market Value of Proposed Transaction
MKTVALALT
Market Value of Proposed Transaction, As-reported
NATACQ
Nature of the Acquisition Transaction
NRDERVS
Number of Derivatives
NRSHARES
Number of Shares
OPTSELLIND
...
OWNTYPE
Form of Ownership: Direct (d) or Indirect (I)
PERSID
TF ID for each individual insider
PROPNRALT
Proposed Number of Shares to be Sold, As-Reported
RECORDTYPE
...
RELATION1
The roles reported by the insider on Forms 3, 4, and 5
RELATION2
The roles reported by the insider on Forms 3, 4, and 5
RELATION3
The roles reported by the insider on Forms 3, 4, and 5
RELATION4
The roles reported by the insider on Forms 3, 4, and 5
ROWNUMBER
...
SCYTYPE
Type of Security: common or preferred
SECRPTDATE
Date of SEC Receipt
SECURITYID
Thomson Permanent Security ID
TICKER
Ticker
TRANCODE
Transaction Code: describes the nature of the underlying transaction. Eg: “P” for open market purchase, “S” for open market sale, “X” for an conversion.
TRANCODEALT
Transaction Code, As-Reported
TRANDATE
Transaction date or holdings report date
TRANDATEALT
As-reported transaction date
TRANPRICE
Transaction Price
TRANPRICEALT
Transaction Price, As-Reported
UNDSHARES
Number of Shares Underlying the Derivatives