SIGNALS_BY_PERSON

insider_txn_share.signals_by_person

This model looks at generating signals based on the historical track record of reporting persons/entities.

It calculates the average returns over various time periods (3, 6, 12, and 24 months) following each insider's buy and sell transactions. The model then flags insiders as significant buyers, sellers, or traders based on the consistency and magnitude of these returns.

Key features:

• Determines if an insider is a significant buyer or seller based on the number of positive or negative return periods

• Identifies "super buyers" and "super sellers" using stricter return thresholds and filing count

• Calculates the percentage rank of each insider's returns within the dataset

• Assigns an overall percentage rank to each insider based on the sum of their buy and sell return ranks

• Includes additional information about the insider, such as their title, director status, and filing counts

Column Name	Data Type	Column Description
AVG_RETURN_12MO_AFTER_BUYS_NORMALIZED	Float	Average normalized return 12 months after buys
AVG_RETURN_12MO_AFTER_SELLS_NORMALIZED	Float	Average normalized return 12 months after sells
AVG_RETURN_24MO_AFTER_BUYS_NORMALIZED	Float	Average normalized return 24 months after buys
AVG_RETURN_24MO_AFTER_SELLS_NORMALIZED	Float	Average normalized return 24 months after sells
AVG_RETURN_3MO_AFTER_BUYS_NORMALIZED	Float	Average normalized return 3 months after buys
AVG_RETURN_3MO_AFTER_SELLS_NORMALIZED	Float	Average normalized return 3 months after sells
AVG_RETURN_6MO_AFTER_BUYS_NORMALIZED	Float	Average normalized return 6 months after buys
AVG_RETURN_6MO_AFTER_SELLS_NORMALIZED	Float	Average normalized return 6 months after sells
DIRECTIONAL_CORRECT_COUNT	Number	Count of directionally correct predictions
IND_SIGNIFICANT_BUYER	Number	Indicator for significant buyer
IND_SIGNIFICANT_SELLER	Number	Indicator for significant seller
IND_SIGNIFICANT_SUPER_BUYER	Number	Indicator for significant super buyer
IND_SIGNIFICANT_SUPER_SELLER	Number	Indicator for significant super seller
IND_SIGNIFICANT_SUPER_TRADER	Number	Indicator for significant super trader
IND_SIGNIFICANT_TRADER	Number	Indicator for significant trader
ISSUER_TICKER	Varchar	Ticker of the issuer
IS_DIRECTOR	Boolean	Is director
IS_OFFICER	Boolean	Is officer
MAX_PERIOD_OF_REPORT	Date	Maximum period of the report
MIN_PERIOD_OF_REPORT	Date	Minimum period of the report
NUM_BUY_FILINGS	Number	Number of buy filings
NUM_FILINGS	Number	Total number of filings
NUM_SELL_FILINGS	Number	Number of sell filings
OFFICER_TITLES	Varchar	Titles of the officers
PCT_RANK_BUYS_NORMALIZED_12MO	Float	Percentage rank of normalized buys 12 months
PCT_RANK_BUYS_NORMALIZED_24MO	Float	Percentage rank of normalized buys 24 months
PCT_RANK_BUYS_NORMALIZED_3MO	Float	Percentage rank of normalized buys 3 months
PCT_RANK_BUYS_NORMALIZED_6MO	Float	Percentage rank of normalized buys 6 months
PCT_RANK_OF_PCT_RANK_SUM	Float	Percentage rank of the sum of percentage ranks
PCT_RANK_SELLS_NORMALIZED_12MO	Float	Percentage rank of normalized sells 12 months
PCT_RANK_SELLS_NORMALIZED_24MO	Float	Percentage rank of normalized sells 24 months
PCT_RANK_SELLS_NORMALIZED_3MO	Float	Percentage rank of normalized sells 3 months
PCT_RANK_SELLS_NORMALIZED_6MO	Float	Percentage rank of normalized sells 6 months
PCT_RANK_SUM	Float	Sum of percentage ranks
REPORTING_PERSON_CIK	Number	CIK of the reporting person
REPORTING_PERSON_NAME	Varchar	Name of the reporting person