Insiders Handler

Last updated: 4/25/05

This collection captures all insider activity as reported on forms 3, 4, 5 and 144. This includes transactions & holdings information, open market derivative transactions, information on award, exercise or expiration of stock options and expected date of sale, securities to be sold, estimated market value of proposed sales and name of executing broker. The unique cleansing process adds value by making systematic interpretations on the accuracy of as-reported data and insert cleansed fields for comparison.

 Overview

Source Name:                 SDWInsiders

Update Frequency:         Daily (except Sunday) by 9a. Updates start at 8a and run for between 5-30 min, so its safe to check by 9a EST for
                                         updates.

Supported Symbols:        Ticker, CUSIP

Permissioning:                 Dataworks Enterprise login required 

Request Syntax

Provided below are: 1- the parameters and 2- the syntax and search examples for RETURNS, TRANSACTIONS and RATINGS.

Parameters: in addition to ticker and CUSIP, the following are also available to search with:

For Returns

  

Action

Syntax

To view returns, not transactions

RETURNS=Y

Filter by owner last name

LAST=xxx

Filter by owner first name (only applies if LAST is specified)

FIRST=xxx

Limit # of results returned

NUM=xxx (default=100, max=1000)

For Transactions

  

Filter by owner last name

LAST=xxx

Filter by owner first name (only applies if LAST is specified)

FIRST=xxx

Filter by transaction type

TYPE=xxx

Filter by market value >= xxx

MVALUE=xxx

Filter by min. # of shares

SHARES=xxx

Limit # of results returned

NUM=xxx (default=100, max=1000)

Specify date range

STARTDT=mm-dd-yyyy

ENDDT=mm-dd-yyyy

Specify days back to search

DAYSAGO=xxx

For Ratings

  

To view ratings, not transactions

RATINGS=Y

To specify frequency

FREQ=W|D (weekly|daily)

Limit # of results returned

NUM=xxx (default=100, max=1000)

Specify date range

STARTDT=mm-dd-yyyy

ENDDT=mm-dd-yyyy

Specify days back to search

DAYSAGO=xxx

RETURNS:

    By Ticker: TICKER=xx RETURNS=Y STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
RETURNS=Y TICKER=MSFT
RETURNS=Y TICKER=MSF% NUM=10
RETURNS=Y TICKER=%MSFT NUM=10
RETURNS=Y TICKER=%SF% NUM=1000
By Cusip: CUSIP=xx RETURNS=Y STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
RETURNS=Y CUSIP=594918104 NUM=5
RETURNS=Y CUSIP=59491810%
RETURNS=Y CUSIP=%94918104 UM=22
RETURNS=Y CUSIP=%9491810%
By Owner Name: LAST=xx FIRST=xx RETURNS=Y STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
RETURNS=Y LAST=GATES
RETURNS=Y LAST=GATES FIRST=WILLIAM
RETURNS=Y LAST=%ATES FIRST=W%
RETURNS=Y LAST=GAT% FIRST=%ILLIA% NUM=50

TRANSACTIONS

    By Ticker: TICKER=xx TYPE=xx MVALUE=xx SHARES=xx STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
TICKER=MSFT SHARES=100
TICKER=MSF% TYPE=ALL NUM=10
TICKER=%MSFT TYPE=PURCHASES NUM=10
TICKER=%SF% TYPE=SELLS NUM=1000
By Cusip: CUSIP=xx TYPE=xx MVALUE=xx SHARES=xx STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
CUSIP=594918104 MVALUE=2000 TYPE=PS NUM=5
CUSIP=59491810% SHARES=1000 TYPE=PSELLS
CUSIP=%94918104 TYPE=OPTIONS NUM=22 SHARES=5000
CUSIP=%9491810% TYPE=GA MVALUE=100000
By Owner Name: LAST=xx FIRST=xx TYPE=xx MVALUE=xx SHARES=xx STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
LAST=GATES MVALUE=4000 DAYSAGO=200
LAST=GATES FIRST=WILLIAM SHARES=5000 STARTDT=1-1-1900
LAST=%ATES FIRST=W% ENDDT=5-20-2003 NUM=900
LAST=GAT% FIRST=%ILLIA% NUM=50 STARTDT=1-1-2002 ENDDT=12-31-2002

RATINGS

    By Ticker: TICKER=xx RATINGS=Y FREQ=xx STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
RATINGS=Y FREQ=W TICKER=MSFT
RATINGS=Y FREQ=D TICKER=MSF% NUM=10
RATINGS=Y FREQ=W TICKER=%MSFT NUM=10
RATINGS=Y FREQ=D TICKER=%SF% NUM=1000
By Cusip: CUSIP=xx RATINGS=Y FREQ=xx STARTDT=xx ENDDT=xx DAYSAGO=xx NUM=xx

Examples:
RATINGS=Y FREQ=D CUSIP=594918104 NUM=5 DAYSAGO=365
RATINGS=Y FREQ=W CUSIP=59491810% STARTDT=4-1-1995
RATINGS=Y FREQ=D CUSIP=%94918104 NUM=22 ENDDT=4-10-2002
RATINGS=Y FREQ=W CUSIP=%9491810% STARTDT=1-1-2002 ENDDT=12-31-2002