A new version of the ExtractionEngine will be released soon.  I hope to be able to deliver it with your Second Quarter update.  The new version will include an enhancement to the SmartBrowser and a specialized tool to allow you to identify filing events around specific windows.

The SmartBrowser is the html viewer that appears when you select the Review Tables item from the Pre-Process menu.  When you start the SmartBrowser in a particular directory it builds a queue of all of the htm and txt files that are in the directory.  The first one is displayed and then you cycle through the queue using the next button.  Right now there is no easy way to jump to a particular filer’s tables if you need to check a specific data value or table heading.

I have added a feature that will allow you to type in a CIK number and the SmartBrowser will load the files beginning with the CIK number that you have entered.  This should save you some time when you have a large collection of snipped tables but only need to review a small number.

The EventExtraction tool will allow you to easily identify any SEC filings that were made in a window around a specific filing date.  You get to specify a unique event date for each CIK number and specify the length of the window.  The program will create a CSV file that will list all dates in the window that you specified.  Next to each date will be a list of all SEC filings made on that date.  If no filings were made on a particular date the output will indicate that no filings were made.

Below is an example of the output from checking for SEC filings in an eight  day window  around 12/31/2001 for CIK 1128709.  Notice that the days the SEC is not accepting filings (12/22;  12/23; 12/25; 01/01; 01/05; 01/06) are not included in the output.  The program builds the window based on available filing dates, dates the EDGAR system is not accepting filings are not included in the window span.

‘1128709’, ’12/18/2001′,No Filing Events on this Date
‘1128709’, ’12/19/2001′,No Filing Events on this Date
‘1128709’, ’12/20/2001′,No Filing Events on this Date
‘1128709’, ’12/21/2001′,No Filing Events on this Date
‘1128709’, ’12/24/2001′,No Filing Events on this Date
‘1128709’, ’12/26/2001′,No Filing Events on this Date
‘1128709’, ’12/27/2001′,No Filing Events on this Date
‘1128709’, ’12/28/2001′,No Filing Events on this Date
‘1128709’, ’12/31/2001′,’424B3′, ‘8-K’
‘1128709’, ’01/02/2002′,No Filing Events on this Date
‘1128709’, ’01/03/2002′,No Filing Events on this Date
‘1128709’, ’01/04/2002′,No Filing Events on this Date
‘1128709’, ’01/07/2002′,No Filing Events on this Date
‘1128709’, ’01/08/2002′,No Filing Events on this Date
‘1128709’, ’01/09/2002′,No Filing Events on this Date
‘1128709’, ’01/10/2002′,No Filing Events on this Date
‘1128709’, ’01/11/2002′,No Filing Events on this Date

The second program does something similar but is limited to 8-K filings and their reasons.  It will build an output listing all 8-K filing that took place in your event window and the reasons for the filing.    The output from this program using CIK 104327, specifying an Event Date of 06/18/2002 and requiring a three day window was:

‘1043277’, ’06/13/2002′, ‘No Filing Events on this Date’
‘1043277’, ’06/14/2002′, ‘No Filing Events on this Date’
‘1043277’, ’06/17/2002′, ‘No Filing Events on this Date’
‘1043277’, ’06/18/2002′, ‘No Filing Events on this Date’
‘1043277’, ’06/19/2002′, ‘No Filing Events on this Date’
‘1043277’, ’06/20/2002′, ’06/18/2002′, ‘AUCHANGE’, ‘FINANCIALSTMTS’
‘1043277’, ’06/21/2002′, ‘No Filing Events on this Date’