BACKTEST_TRADES_BY_TICKER

insider_txn_share.backtest_trades_by_ticker

This model backtests the average returns (both absolute and normalized) and hit rates over various horizons to look at the differences in forward returns for different tickers. This analysis shows tickers where insider buying and selling has historically been predictive of future returns.

Column Name	Data Type	Column Description
AVG_RETURN_12MO_AFTER_BUYS	Float	Average return 12 months after buys
AVG_RETURN_12MO_AFTER_BUYS_NORMALIZED	Float	Normalized average return 12 months after buys
AVG_RETURN_12MO_AFTER_SELLS	Float	Average return 12 months after sells
AVG_RETURN_12MO_AFTER_SELLS_NORMALIZED	Float	Normalized average return 12 months after sells
AVG_RETURN_24MO_AFTER_BUYS	Float	Average return 24 months after buys
AVG_RETURN_24MO_AFTER_BUYS_NORMALIZED	Float	Normalized average return 24 months after buys
AVG_RETURN_24MO_AFTER_SELLS	Float	Average return 24 months after sells
AVG_RETURN_24MO_AFTER_SELLS_NORMALIZED	Float	Normalized average return 24 months after sells
AVG_RETURN_3MO_AFTER_BUYS	Float	Average return 3 months after buys
AVG_RETURN_3MO_AFTER_BUYS_NORMALIZED	Float	Normalized average return 3 months after buys
AVG_RETURN_3MO_AFTER_SELLS	Float	Average return 3 months after sells
AVG_RETURN_3MO_AFTER_SELLS_NORMALIZED	Float	Normalized average return 3 months after sells
AVG_RETURN_6MO_AFTER_BUYS	Float	Average return 6 months after buys
AVG_RETURN_6MO_AFTER_BUYS_NORMALIZED	Float	Normalized average return 6 months after buys
AVG_RETURN_6MO_AFTER_SELLS	Float	Average return 6 months after sells
AVG_RETURN_6MO_AFTER_SELLS_NORMALIZED	Float	Normalized average return 6 months after sells
AVG_RETURN_DELTA_12MO	Float	Average return delta 12 months
AVG_RETURN_DELTA_24MO	Float	Average return delta 24 months
AVG_RETURN_DELTA_3MO	Float	Average return delta 3 months
AVG_RETURN_DELTA_6MO	Float	Average return delta 6 months
BUY_OR_SELL	Varchar	Indicator of buy or sell
HIT_RATE_12MO_AFTER_BUYS	Number	Hit rate 12 months after buys
HIT_RATE_12MO_AFTER_SELLS	Number	Hit rate 12 months after sells
HIT_RATE_24MO_AFTER_BUYS	Number	Hit rate 24 months after buys
HIT_RATE_24MO_AFTER_SELLS	Number	Hit rate 24 months after sells
HIT_RATE_3MO_AFTER_BUYS	Number	Hit rate 3 months after buys
HIT_RATE_3MO_AFTER_SELLS	Number	Hit rate 3 months after sells
HIT_RATE_6MO_AFTER_BUYS	Number	Hit rate 6 months after buys
HIT_RATE_6MO_AFTER_SELLS	Number	Hit rate 6 months after sells
ISSUER_TICKER	Varchar	Issuer ticker symbol
MAX_PERIOD_OF_REPORT	Date	Maximum period of report
MIN_PERIOD_OF_REPORT	Date	Minimum period of report
NUMBER_OF_BUYS_TRADES	Number	Total number of buy trades
NUMBER_OF_SELL_TRADES	Number	Total number of sell trades
NUMBER_OF_TRADES	Number	Total number of trades
NUM_BUY_FILINGS	Number	Number of buy filings
NUM_DIRECTORS	Number	Number of directors
NUM_FILINGS	Number	Total number of filings
NUM_OFFICERS	Number	Number of officers
NUM_REPORTING_PERSONS	Number	Number of reporting persons
NUM_SELL_FILINGS	Number	Number of sell filings
OFFICER_TITLES	Varchar	Titles of the officers
REPORTING_PERSON_NAMES	Varchar	Names of the reporting persons
SUM_VALUE_TRADED	Float	Total value traded
TRADE_DESCRIPTION	Varchar	Description of the trade