Insider Statistics

The insiderStats data type summaries all insider trading activity into clear and understandable statistics per quarter for the last 20+ years. The data is collated from the insider trading transactions as reported by the SEC and includes all the detail required to understand how insiders are trading the stock. This data is currently only available for US companies.

=SF(symbol, "insiderStats", metrics, year, options)

• symbol is the ticker symbol of the financial asset (e.g., "AAPL"). You can use our Symbol Search to find the correct ticker symbol.

• metrics selects what metrics to display (see options below), display all metrics by leaving blank or using "all". Chain together as many metrics as you'd like using &, e.g., "year&quarter&purchases&sales".

• year is year or range of years for which you want to retrieve the data. You can enter a single year (e.g. 2024) or a range of years (e.g. 2022-2024). Defaults to the most recent year if not specified.

• options adjusts the formatting of the output. Available options include: "NH" for no header rows and "-" for reversing the output. You can chain together as many options as you'd like using &, e.g., "NH&-".

The Insider Statistics metrics options are:

• All ("all")

• Year ("year")

• Quarter ("quarter")

• Acquired Transactions ("acquiredTransactions")

• Disposed Transactions ("disposedTransactions")

• Acquired/Disposed Ratio ("acquiredDisposedRatio")

• Total Acquired ("totalAcquired")

• Total Disposed ("totalDisposed")

• Average Acquired ("averageAcquired")

• Average Disposed ("averageDisposed")

• Total Purchases ("totalPurchases")

• Total Sales ("totalSales")

• CIK ("cik")

Examples

Example 1 - Display the most recent year's insider trading statistics

=SF("AAPL", "insiderStats")

Example 2 - Display several selected metrics, specific year

=SF("AAPL", "insiderStats", "year&quarter&totalAcquired&totalDisposed&acquiredDisposedRatio", "2022")

Example 3 - Display all metrics, specific year range

=SF("AAPL", "insiderStats", "all", "2019-2022")