Compustat Handler 

Last updated: 4/26/05

This source provides company profile, financial and accounting results, market and per-share data. Covers more than 10,500 active and 11,069 inactive US companies.

 Overview

Source Name:                      COMPUSTAT

Update Frequency:              M-F by 9 AM, daily

Supported Symbols:            Ticker, CUSIP, SEDOL, ISIN and WSID

Permissioning:                     Dataworks Enterprise login required and contract with Compustat required

Request Syntax

TICKER=XXX SEDOL=XXX ISIN=XXX CUSIP=XXXX (in any combination)
Note: ticker is not advised to be used alone as duplicate tickers are possible. To make sure you are getting the right company, please use a unique identifier such as CUSIP, SEDOL or ISIN.

Examples:�

TICKER=MSFT
TICKER=AOL SEDOL= 2588173
CUSIP=594918104 ISN=US00184A1051 SEDOL= 2588173
TICKER=AOL ISN= US5949181045
CUSIP=00184A105 SEDOL=2712165

Sample Response       

The following is a portion of the output for CUSIP=00184A105:�
� <?xml version="1.0" encoding="utf-8" ?>
- <Record xmlns="http://xml.thomson.com/financial/v1/tools/distribution/dataworks/enterprise/2003-07/">
<Source>COMPUSTAT</Source>
<Instrument>CUSIP=594918104</Instrument>
<Tag />
<StatusType>Connected</StatusType>
<StatusCode>0</StatusCode>
<StatusMessage />
- <Fields>
<AcctPayAndAccruLiabIncDecCFStmt0Q />
<AcctPayAndAccruLiabIncDecCFStmt0Y />
<AcctPayAndAccruLiabIncDecCFStmt-1Q />
<AcctPayAndAccruLiabIncDecCFStmt-1Y />
<AcctPayAndAccruLiabIncDecCFStmt-2Q />
<AcctPayAndAccruLiabIncDecCFStmt-2Y />
<AcctPayAndAccruLiabIncDecCFStmt-3Q />
<AcctPayAndAccruLiabIncDecCFStmt-4Q />
<AcctPayAndAccruLiabIncDecCFStmt-5Q />
<AcctPayAndAccruLiabIncDecCFStmt-6Q />
<AcctPayAndAccruLiabIncDecCFStmt-7Q />
<AcquisitionsCFStmt0Q>4</AcquisitionsCFStmt0Q>
<AcquisitionsCFStmt0Y>4</AcquisitionsCFStmt0Y>
<AcquisitionsCFStmt-1Q>4</AcquisitionsCFStmt-1Q>
<AcquisitionsCFStmt-1Y>1063</AcquisitionsCFStmt-1Y>
<AcquisitionsCFStmt-2Q>4</AcquisitionsCFStmt-2Q>
<AcquisitionsCFStmt-2Y>0</AcquisitionsCFStmt-2Y>
<AcquisitionsCFStmt-3Q>4</AcquisitionsCFStmt-3Q>
<AcquisitionsCFStmt-4Q>1063</AcquisitionsCFStmt-4Q>
<AcquisitionsCFStmt-5Q>891</AcquisitionsCFStmt-5Q>
<AcquisitionsCFStmt-6Q>879</AcquisitionsCFStmt-6Q>
<AcquisitionsCFStmt-7Q>870</AcquisitionsCFStmt-7Q>
<AddressCity>Redmond</AddressCity>
<AddressStateProvince>WA</AddressStateProvince>
<AddressZipPostalCode>98052-8300</AddressZipPostalCode>
<AdjustmentFactor0Q>1</AdjustmentFactor0Q>
<AdjustmentFactor0Y>1</AdjustmentFactor0Y>
<AdjustmentFactor-1Q>1</AdjustmentFactor-1Q>
<AdjustmentFactor-1Y>1</AdjustmentFactor-1Y>
<AdjustmentFactor-2Q>1</AdjustmentFactor-2Q>
<AdjustmentFactor-2Y>2</AdjustmentFactor-2Y>
<AdjustmentFactor-3Q>1</AdjustmentFactor-3Q>
<AdjustmentFactor-4Q>1</AdjustmentFactor-4Q>
<AdjustmentFactor-5Q>1</AdjustmentFactor-5Q>
<AdjustmentFactor-6Q>2</AdjustmentFactor-6Q>
<AdjustmentFactor-7Q>2</AdjustmentFactor-7Q>
<ADRRatio>0</ADRRatio>
<AnnualizedDividendRate0Q>0</AnnualizedDividendRate0Q>
<AnnualizedDividendRate0Y>0</AnnualizedDividendRate0Y>
<AnnualizedDividendRate-1Q>0</AnnualizedDividendRate-1Q>
<AnnualizedDividendRate-1Y>0</AnnualizedDividendRate-1Y>
<AnnualizedDividendRate-2Q>0</AnnualizedDividendRate-2Q>
<AnnualizedDividendRate-2Y>0</AnnualizedDividendRate-2Y>
<AnnualizedDividendRate-3Q>0</AnnualizedDividendRate-3Q>
<AnnualizedDividendRate-4Q>0</AnnualizedDividendRate-4Q>
<AnnualizedDividendRate-5Q>0</AnnualizedDividendRate-5Q>
<AnnualizedDividendRate-6Q>0</AnnualizedDividendRate-6Q>
<AnnualizedDividendRate-7Q>0</AnnualizedDividendRate-7Q>
<AssetsPerEmployee0Q />
<AssetsPerEmployee0Y>1.62085964912281</AssetsPerEmployee0Y>
<AssetsPerEmployee-1Q />
<AssetsPerEmployee-1Y>1.44674545454545</AssetsPerEmployee-1Y>
<AssetsPerEmployee-2Q />
<AssetsPerEmployee-2Y>1.33952475247525</AssetsPerEmployee-2Y>
<AssetsPerEmployee-3Q />
<AssetsPerEmployee-4Q />
<AssetsPerEmployee-5Q />
<AssetsPerEmployee-6Q />
<AssetsPerEmployee-7Q />
<BookValuePerShare0Q>0</BookValuePerShare0Q>
<BookValuePerShare0Y>6.8887</BookValuePerShare0Y>
<BookValuePerShare-1Q>0</BookValuePerShare-1Q>
<BookValuePerShare-1Y>5.6652</BookValuePerShare-1Y>
<BookValuePerShare-2Q>0</BookValuePerShare-2Q>
<BookValuePerShare-2Y>4.8684</BookValuePerShare-2Y>
<BookValuePerShare-3Q>0</BookValuePerShare-3Q>
<BookValuePerShare-4Q>0</BookValuePerShare-4Q>
<BookValuePerShare-5Q>0</BookValuePerShare-5Q>
<BookValuePerShare-6Q>0</BookValuePerShare-6Q>
<BookValuePerShare-7Q>0</BookValuePerShare-7Q>
<BusinessDescriptionExtended>Microsoft Corp. (Microsoft) develops, manufactures, licenses and supports a range of software products for a multitude of computing devices. Its software products include scalable operating systems for servers, personal computers and intelligent devices; server applications for client/server environments; information worker productivity applications; business solutions applications; and software development tools. The company provides consulting services and product support services and trains and certifies system integrators and developers. It sells the Xbox video game console, along with games and peripherals. The company's online businesses include the MSN subscription and the MSN network of Internet products and services. Microsoft's business is organized into seven product segments: Client; Server and Tools; Information Worker; Microsoft Business Solutions; MSN; Mobile and Embedded Devices; and Home and Entertainment. The Client segment includes Windows XP and other standard Windows operating systems. Server and Tools has overall responsibility for integrated product development and marketing of Windows Server System products, including building and marketing Windows Server operating systems. Information Worker is responsible for developing and delivering technologies that focus on improving productivity for information workers. The segment consists of the Microsoft Office System of programs, servers, services and solutions. Microsoft Business Solutions is responsible for developing and marketing integrated, end-to-end business applications and services designed to help small and mid-market businesses. MSN includes MSN Subscriptions and MSN Network services. Mobile and Embedded Devices includes Windows Mobile software, Windows Embedded device operating systems, MapPoint, and Windows Automotive. Home and Entertainment includes the Microsoft Xbox video game system, PC games, the Home Products Division and TV platform products.</BusinessDescriptionExtended>
<CapitalExpendituresCFStmt0Q>1109</CapitalExpendituresCFStmt0Q>
<CapitalExpendituresCFStmt0Y>1109</CapitalExpendituresCFStmt0Y>
<CapitalExpendituresCFStmt-1Q>552</CapitalExpendituresCFStmt-1Q>
<CapitalExpendituresCFStmt-1Y>891</CapitalExpendituresCFStmt-1Y>
<CapitalExpendituresCFStmt-2Q>339</CapitalExpendituresCFStmt-2Q>
<CapitalExpendituresCFStmt-2Y>770</CapitalExpendituresCFStmt-2Y>
<CapitalExpendituresCFStmt-3Q>167</CapitalExpendituresCFStmt-3Q>
<CapitalExpendituresCFStmt-4Q>891</CapitalExpendituresCFStmt-4Q>
<CapitalExpendituresCFStmt-5Q>618</CapitalExpendituresCFStmt-5Q>
<CapitalExpendituresCFStmt-6Q>436</CapitalExpendituresCFStmt-6Q>
<CapitalExpendituresCFStmt-7Q>160</CapitalExpendituresCFStmt-7Q>
<CapitalExpendPctSales0Q>11.9349978476108</CapitalExpendPctSales0Q>
<CapitalExpendPctSales0Y>3.01072349667436</CapitalExpendPctSales0Y>
<CapitalExpendPctSales-1Q>6.01634877384196</CapitalExpendPctSales-1Q>
<CapitalExpendPctSales-1Y>2.7681983409451</CapitalExpendPctSales-1Y>
<CapitalExpendPctSales-2Q>3.33891460652024</CapitalExpendPctSales-2Q>
<CapitalExpendPctSales-2Y>2.71461307949938</CapitalExpendPctSales-2Y>
<CapitalExpendPctSales-3Q>2.03286670724285</CapitalExpendPctSales-3Q>
<CapitalExpendPctSales-4Q>11.0477371357719</CapitalExpendPctSales-4Q>
<CapitalExpendPctSales-5Q>7.88768347160179</CapitalExpendPctSales-5Q> 
<CapitalExpendPctSales-6Q>5.1047886664325</CapitalExpendPctSales-6Q
<CapitalExpendPctSales-7Q>2.06558223599277</CapitalExpendPctSales-7Q> 
<CapitalExpendPctTotalAssets0Q>1.20035935013909</CapitalExpendPctTotalAssets0Q> 
<CapitalExpendPctTotalAssets0Y>1.20035935013909</CapitalExpendPctTotalAssets0Y> 
<CapitalExpendPctTotalAssets-1Q>0.614925306627157</CapitalExpendPctTotalAssets-1Q> 
<CapitalExpendPctTotalAssets-1Y>1.11975468449561</CapitalExpendPctTotalAssets-1Y> 
<CapitalExpendPctTotalAssets-2Q>0.39447502240013</CapitalExpendPctTotalAssets-2Q>
<CapitalExpendPctTotalAssets-2Y>1.13827868610117</CapitalExpendPctTotalAssets-2Y>
<CapitalExpendPctTotalAssets-3Q>0.198146676000522</CapitalExpendPctTotalAssets-3Q>
<CapitalExpendPctTotalAssets-4Q>1.11975468449561</CapitalExpendPctTotalAssets-4Q>
<CapitalExpendPctTotalAssets-5Q>0.829730673182782</CapitalExpendPctTotalAssets-5Q>
<CapitalExpendPctTotalAssets-6Q>0.602551168479388</CapitalExpendPctTotalAssets-6Q>
<CapitalExpendPctTotalAssets-7Q>0.227806649106571</CapitalExpendPctTotalAssets-7Q>
<CashAndCashEquivIncDecCFStmt0Q>9544</CashAndCashEquivIncDecCFStmt0Q>
<CashAndCashEquivIncDecCFStmt0Y>9544</CashAndCashEquivIncDecCFStmt0Y>
<CashAndCashEquivIncDecCFStmt-1Q>2910</CashAndCashEquivIncDecCFStmt-1Q>
<CashAndCashEquivIncDecCFStmt-1Y>3422</CashAndCashEquivIncDecCFStmt-1Y>
<CashAndCashEquivIncDecCFStmt-2Q>-289</CashAndCashEquivIncDecCFStmt-2Q>
<CashAndCashEquivIncDecCFStmt-2Y>-906</CashAndCashEquivIncDecCFStmt-2Y>
<CashAndCashEquivIncDecCFStmt-3Q>-670</CashAndCashEquivIncDecCFStmt-3Q>
<CashAndCashEquivIncDecCFStmt-4Q>3422</CashAndCashEquivIncDecCFStmt-4Q>
<CashAndCashEquivIncDecCFStmt-5Q>1284</CashAndCashEquivIncDecCFStmt-5Q>
<CashAndCashEquivIncDecCFStmt-6Q>2536</CashAndCashEquivIncDecCFStmt-6Q>
<CashAndCashEquivIncDecCFStmt-7Q>2322</CashAndCashEquivIncDecCFStmt-7Q>
<CashDividendCoverageRAtio0Q />