Equity Grants Feed (Point In Time)¶
General Information¶
VertiyData’s Grants database captures equity grants that are disclosed in form 4 filings. Grants are typically disclosed as “A” code transactions in either Table I or II within Form 4s.
The Grants History file contains all Grants on the VerityData platform going back to 2004. Point-in-Time files are available starting April 13, 2022. The Point-in-Time format allows you to build daily snapshots by ingesting daily delta (inserts/edits) files rather than reprocessing the entire history every day.
Some notes on the point-in-time format:
- Updates to company-related fields (ticker, cusip, company_name, etc.) do not trigger updates in the feed, only updates to event specific fields trigger an update.
- Company-related fields are as of the asof field, not the original insert, meaning values such as ticker, cusip, etc. may change when comparing an initial insert to a later update for the same txnid. (e.g. a transaction with ticker "FOO" at insert will show as "BAR" on subsequent updates if the company's ticker changed between the two asof dates. The original insert will always show "FOO", however.)
- Not all fields are available with point-in-time accuracy. Please see the Data Dictionary for more information.
For customers still using the historical grants feed, information on that format follows the Point-in-Time data dictionary.
Data Dictionary¶
| COLUMN | Description |
|---|---|
| ticker | Ticker of the company. Tickers in [square brackets] indicate de-listed or inactive companies. |
| cusip | CUSIP identifier of the company. |
| class_status | Denotes the status of the company at the time of the lastupdate. Useful to exclude posthumous edits to inactive companies from your modeling / testing. |
| company_name | Name of the company. |
| sector | Sector of the company |
| mcap | [Not Point In Time Data] Market Cap of the company as of the filing date. |
| insider_name | Name of the insider. |
| rptcik | SEC assigned unique identifier of the Insider. |
| position_type | Position the insider held at the company, at the time of the transaction. Can be the following values “CEO”, “CFO”, “Officer”, Director”, “10% Owner”, or “Other”. |
| position_title | Position title of the insider in the source filing. If the insider is CEO or CFO, this will show “CEO” or “CFO,” respectively. |
| age | Age of the insider (calculated by using confirmed birthdate and the grants date). |
| gender | Gender of the insider. |
| form_type | SEC form-type for the disclosure's source (almost always Form 4 but occasionally disclosed in Form 5). |
| disclosure_date | The date that the filing was filed at the SEC. |
| filed_time | The exact date and time in YYYY-MM-DD hh:mm:ss the filing was filed at the SEC. |
| received_time | The exact time in YYYY-MM-DD hh:mm:ss.ssssss that we received the filing, usually within seconds after the File_time above. The date and time listed is generated by our internal servers. This field is NULL for all transactions prior to 2008. NOTE: This field may read earlier than the File_Time field as our server time and the SEC's server time are not synced. |
| grant_date | Date which the grant occurred. |
| code | Transaction code. A = Grant |
| category | The type of equity given in the grant. Can be: Restricted Stock, Deferred Comp, Stock Option, or Other. |
| shares | Amount of shares included in the grant. |
| price | Price per share of the equity grant. |
| value | Dollar value of the grant. |
| hire_or_promotion | Indicates whether the Insider was hired or promoted within the 6 months prior to the grant, based on our Management Change database. |
| expiration_date | Expiration date for options (if applicable). |
| low_disclosure | "True" indicates the grant disclosure contained no accompanying footnotes in the source disclosure. |
| performance | Indicates whether the grant was performance-based equity. |
| small | "True" indicates the grant was small in size in absolute terms and/or as a percentage of the Insider's total exposure. |
| txnid | Verity's unique numerical id given to each grant. |
| last_update | The date of the last update for this entry. |
| split_edit | Returns TRUE if the edit was due to a split. |
| edit_action | "U" for update, "D" for delete and "I" for new insert. |
| asof | The date the record appeared in the feed |
Historical Grants Feed¶
General Information¶
The VerityData Equity Grants Feed lists equity grant data disclosed in Form 4s, since 2004. Similar to Insider Transaction Feed which strictly focuses on Buys, Sells, and Exercise and Sells (most commonly P,S,E transaction codes), this feed focuses on grants (most commonly A codes).
Currently, the Equity Grants Feed is only available in full/partial history formats (not available in daily Insert/Edit format).
Data Dictionary¶
| Header | Description |
|---|---|
| ticker | Ticker of the company. Tickers in [square brackets] indicate de-listed or inactive companies. |
| cusip | CUSIP identifier of the company. |
| class_status | Denotes the status of the company at the time of the lastupdate. Useful to exclude posthumous edits to inactive companies from your modeling / testing. |
| company_name | Name of the company. |
| mcap | Market Cap of the company as of the filing date. |
| insider_name | Name of the insider. |
| rptcik | SEC assigned unique identifier of the Insider. |
| position_type | Position of the insider held at the company, at the time of the transaction. Can be the following values “CEO”, “CFO”, “Office”, Director”, “10% Owner”, or “Other”. |
| position_title | Position title of the insider in the source filing. If the insider is CEO or CFO, this will show “CEO” or “CFO,” respectively. |
| file_date | The date that the filing was submitted to the SEC. |
| formtype | SEC form-type for the disclosure's source (almost always Form 4 but occassionaly disclosed in Form 5). |
| grant_date | Date which the grant occurred. |
| category | The type of equity given in the grant. Can be: Restricted Stock, Deferred Comp, Stock Option, or Other. |
| shares | Amount of shares included in the grant. |
| price | Price per share of the equity grant. |
| value | Dollar value of the grant. |
| hire_or_promotion | Indicates whether the Insider was hired or promoted within the 6 months prior to the grant, based on our Management Change database. |
| expiration_date | Expiration date for options (if applicable). |
| low_disclosure | "True" indicates the grant disclosure contained no accompanying footnotes in the source disclosure. |
| performance | Indicates whether the grant was performance-based equity. |
| small | "True" indicates the grant was small in size in absolute terms and/or as a percentage of the Insider's total exposure. |
| txnid | Verity's unique numerical id given to each grant. |