SECFilings Handler

Last updated: 4/25/05

Public filings are those documents that companies file with stock exchanges and regulatory agencies to disclose detailed and material financial information to meet legal or listing requirements. This collection includes filings for over 58,000 global companies in 204 countries, so over 7 million EDGAR and image filings. Documents can be retrieved as HTML, XML, RTF and PDF.

 Overview

Source Name:                         SECFilings

Update Frequency:                 Real-Time

Supported Symbols:               Ticker, CUSIP, SEDOL, COMPNR

Permissioning:                        Dataworks Enterprise login required

Request Syntax

Provided below are: 1-additional parameters, 2-additional search parameters and 3-various search examples:

Additional Parameters:

  1. Company Name
  2. SEDOL
  3. Primary SIC
  4. CUSIP
  5. Country
  6. Exchange
  7. State

Additional Search Options:

Action

Syntax

  • Retrieve ONLY filing data

SEARCH=Y

  • Search by filing type

TYPE=xxxx (i.e.: TYPE=10-K|10-Q|8-K|REGST|PROXY)

  • Limit number of filings returned

NUM=xxx

  • Search by date

DATE1=mm/dd/yy DATE2=mm/dd/yy

  • To get back XML from SECAPI

INCLUDE_RESULT_XML=Y|ONLY

  • To sort the results

*Use SORT1 to specify PRIMARY_SORT and SORT2 to specify Secondary_Sort
*Use ORDER1 to specify PRIMARY_SORT_ORDER (A or D) and ORDER2 to specify SECONDARY_SORT_ORDER (A or D)

Search Examples:

Company Resume (no filing info):

TICKER=DELL
COMPNR=K816700000 INCLUDE_RESULT_XML=ONLY
SEDOL=2008154 INCLUDE_RESULT_XML=ONLY
CUSIP=00724F101
EXCHANGE=NYS
STATE=MI COMPNAME=THOMSON
COMPNAME=THOMSON ORDER1=A SEARCH=Y
COUNTRY=UK
SIC=7371 DATE1=2004/01/01 TICKER=MSFT
TICKER=MSFT SEARCH=Y DATE1=2004/01/01 DATE2=2004/01/31 SORT1=DOC_DCN

Latest SEC Filings: (default to latest 5 filings)

TICKER=MSFT SEARCH=Y NUM=5
CUSIP=00184A105 SEARCH=Y NUM=5
SEDOL=2712165 SEARCH=Y NUM=5
COMPNR=M529390000 SEARCH=Y NUM=5

Latest SEC Filings by Type:

TICKER=MSFT SEARCH=Y TYPE=10-K|10-Q|8-K|REGST|PROXY

Latest SEC Filings after a specific date:

TICKER=MSFT SEARCH=Y DATE1=12/02/04

Retrieve Filings

CODE=10-Q KEY=00637244 F=HTML Q=C T=E V=N
CODE=10-K KEY=00637244 F=HTML Q=C T=E V=N INCLUDE_RESULT_XML=Y
CODE=10-K EY=00637244 F=XML Q=C T=E V=N INCLUDE_RESULT_XML=Y
CODE=10-Q KEY=00637244 F=RTF Q=C T=E V=N INCLUDE_RESULT_XML=Y
CODE=10-Q/A KEY=00637244 F=PDF Q=C T=I V=N INCLUDE_RESULT_XML=Y

Sample Response

Sample output for last 3 10-Ks for MSFT:

<?xml version="1.0" encoding="utf-8" ?>
-
<Record xmlns="http://xml.thomson.com/financial/v1/tools/distribution/dataworks/enterprise/2003-07/">
<Source>SECFilings</Source>
<Instrument>TICKER=MSFT SEARCH=Y TYPE=10-K NUM=3</Instrument>
<Tag />
<StatusType>Connected</StatusType>
<StatusCode>0</StatusCode>
<StatusMessage />
- <Fields>
<_1_DOC_COMPANY_NAME>MICROSOFT CORP</_1_DOC_COMPANY_NAME>
<_1_DOC_COMPANY_NR>M529390000</_1_DOC_COMPANY_NR>
<_1_DOC_DATE>2004/06/30</_1_DOC_DATE>
<_1_DOC_DATETIME_ARRIV>2004/09/01 17:06:11:293</_1_DOC_DATETIME_ARRIV>
<_1_DOC_DCN>041011640</_1_DOC_DCN>
<_1_DOC_EXCHANGE>N</_1_DOC_EXCHANGE>
<_1_DOC_FORM_TYPE_DESC>E</_1_DOC_FORM_TYPE_DESC>
<_1_DOC_FSA>XLS|BCP|CCP|ICP</_1_DOC_FSA>
<_1_DOC_LANGUAGE>102</_1_DOC_LANGUAGE>
<_1_DOC_PAGE>224</_1_DOC_PAGE>
<_1_DOC_PRODUCT>E</_1_DOC_PRODUCT>
<_1_DOC_REGIST_NUMBER>00014278</_1_DOC_REGIST_NUMBER>
<_1_DOC_SEC_FORMTYPE>10-K</_1_DOC_SEC_FORMTYPE>
<_1_DOC_TYPE>10-K</_1_DOC_TYPE>
<_1_URL>http://secapi.disclosure.com/servlets/RetrieveFiling?VERSION=4.0&CONT_CODE=10-K&CONT_KEY=041011640&CONT_FORMAT=HTML&CONT_QUALIFIER=C&VIEWER=Y</_1_URL>
<_2_DOC_CDID>A2124</_2_DOC_CDID>
<_2_DOC_COMPANY_NAME>MICROSOFT CORP</_2_DOC_COMPANY_NAME>
<_2_DOC_COMPANY_NR>M529390000</_2_DOC_COMPANY_NR>
<_2_DOC_DATE>2003/06/30</_2_DOC_DATE>
<_2_DOC_DATETIME_ARRIV>2003/09/05 06:06:04:510</_2_DOC_DATETIME_ARRIV>
<_2_DOC_DCN>03882442</_2_DOC_DCN>
<_2_DOC_EXCHANGE>N</_2_DOC_EXCHANGE>
<_2_DOC_FORM_TYPE_DESC>E</_2_DOC_FORM_TYPE_DESC>
<_2_DOC_FSA>XLS|BCP|CCP|ICP</_2_DOC_FSA>
<_2_DOC_LANGUAGE>102</_2_DOC_LANGUAGE>
<_2_DOC_PAGE>142</_2_DOC_PAGE>
<_2_DOC_PRODUCT>E</_2_DOC_PRODUCT>
<_2_DOC_REGIST_NUMBER>00014278</_2_DOC_REGIST_NUMBER>
<_2_DOC_SEC_FORMTYPE>10-K</_2_DOC_SEC_FORMTYPE>
<_2_DOC_TYPE>10-K</_2_DOC_TYPE>
<_2_URL>http://secapi.disclosure.com/servlets/RetrieveFiling?VERSION=4.0&CONT_CODE=10-K&CONT_KEY=03882442&CONT_FORMAT=HTML&CONT_QUALIFIER=C&VIEWER=Y</_2_URL>
<_3_DOC_CDID>A2053</_3_DOC_CDID>
<_3_DOC_COMPANY_NAME>MICROSOFT CORP</_3_DOC_COMPANY_NAME>
<_3_DOC_COMPANY_NR>M529390000</_3_DOC_COMPANY_NR>
<_3_DOC_DATE>2002/06/30</_3_DOC_DATE>
<_3_DOC_DATETIME_ARRIV>2002/09/06 08:05:35:913</_3_DOC_DATETIME_ARRIV>
<_3_DOC_DCN>02757909</_3_DOC_DCN>
<_3_DOC_EXCHANGE>N</_3_DOC_EXCHANGE>
<_3_DOC_FORM_TYPE_DESC>E</_3_DOC_FORM_TYPE_DESC>
<_3_DOC_FSA>XLS|BCP|CCP|ICP</_3_DOC_FSA>
<_3_DOC_LANGUAGE>102</_3_DOC_LANGUAGE>
<_3_DOC_PAGE>111</_3_DOC_PAGE>
<_3_DOC_PRODUCT>E</_3_DOC_PRODUCT>
<_3_DOC_REGIST_NUMBER>00014278</_3_DOC_REGIST_NUMBER>
<_3_DOC_SEC_FORMTYPE>10-K</_3_DOC_SEC_FORMTYPE>
<_3_DOC_TYPE>10-K</_3_DOC_TYPE>
<_3_URL>http://secapi.disclosure.com/servlets/RetrieveFiling?VERSION=4.0&CONT_CODE=10-K&CONT_KEY=02757909&CONT_FORMAT=HTML&CONT_QUALIFIER=C&VIEWER=Y</_3_URL>
<DOC_LOC>sec.api.thomsonib.com trdocserveruk.thomsonib.com</DOC_LOC>
<DOC_TYPE>10-K</DOC_TYPE>
<DOCUMENT_COUNT>24</DOCUMENT_COUNT>
<HOSTNAME>secapi.disclosure.com</HOSTNAME>
<MAX_RESULTS>3</MAX_RESULTS>
<PORT>80</PORT>
<REF_COUNT>3</REF_COUNT>
<START_ROW>1</START_ROW>
<TICKER>MSFT</TICKER>
<TIMESTAMP>2005/04/26 12:59:04:004</TIMESTAMP>
<VERSION>4.0</VERSION>
</Fields>
</Record>