Skip to main content

INSIDER_TRADING

Get data about trading by a company's management team and board of directors.

Syntax

=OBB.EQUITY.OWNERSHIP.INSIDER_TRADING(symbol,[limit],[transactionType])

Examples

=OBB.EQUITY.OWNERSHIP.INSIDER_TRADING("AAPL")
=OBB.EQUITY.OWNERSHIP.INSIDER_TRADING("AAPL",500)

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for.True
limitNumberThe number of data entries to return.False
transactionTypeTextType of the transaction. Options: award, conversion, return, expire_short, in_kind, gift, expire_long, discretionary, other, small, exempt, otm, purchase, sale, tender, will, itm, trust.False

Data

NameDescription
symbolSymbol representing the entity requested in the data.
company_cikCIK number of the company.
filing_dateFiling date of the trade.
transaction_dateDate of the transaction.
owner_cikReporting individual's CIK.
owner_nameName of the reporting individual.
owner_titleThe title held by the reporting individual.
transaction_typeType of transaction being reported.
acquisition_or_dispositionAcquisition or disposition of the shares.
security_typeThe type of security transacted.
securities_ownedNumber of securities owned by the reporting individual.
securities_transactedNumber of securities transacted by the reporting individual.
transaction_priceThe price of the transaction.
filing_urlURL of the filing.
company_nameName of the company.
conversion_exercise_priceConversion/Exercise price of the shares.
deemed_execution_dateDeemed execution date of the trade.
exercise_dateExercise date of the trade.
expiration_dateExpiration date of the derivative.
underlying_security_titleName of the underlying non-derivative security related to this derivative transaction.
underlying_sharesNumber of underlying shares related to this derivative transaction.
nature_of_ownershipNature of ownership of the insider trading.
directorWhether the owner is a director.
officerWhether the owner is an officer.
ten_percent_ownerWhether the owner is a 10% owner.
other_relationWhether the owner is having another relation.
derivative_transactionWhether the owner is having a derivative transaction.
report_line_numberReport line number of the insider trading.