Mercury Handler - Investment Research

Last updated 4/25//05

This collection provides timely analysis and forecasts on companies, industries, products and markets across the globe with the most comprehensive collection of information and aftermarket brokerage reports written by expert analysts at more than 450 of the world�s top investment banks, brokerage houses and research firms. The original-format PDF reports offer active coverage on some 57k companies across all industries and countries.

 Overview

Source name:                   Mercury

Update Frequency:          Daily by 6 AM

 (There are loads that occur throughout the day, but the majority of the loads occur at night,     between 12 AM � 6AM)

Supported Symbols:         Ticker or Investext symbol

Permissioning:                  Dataworks Enterprise login and Mercury Application ID are both required 

Request Syntax

There are 3 kinds of requests available: Search, Table of Contents and GetDocument. Examples are provided below for each.

1- Search for Documents: DoSearch

To Returns the entire collection:

<?xml version="1.0" encoding="utf-8" ?>
<DoSearch xmlns="http://xml.thomson.com/financial/v1/tools/search/mercury/2003-04/API">
<Header>
<ApplicationID>YOUR MERURY ID</ApplicationID>
</Header>
<Criteria>
<Group>
<Collection>INV</Collection>
<Text grammar="IB">spotfire</Text>
</Group>
</Criteria>
<SortOrder>
<Item order="D">PublishDate</Item>
</SortOrder>
<MaxResults>3</MaxResults>
</DoSearch>

To returns the maximum of 10 search results for IBM:

<?xml version="1.0" encoding="utf-8" ?>
<DoSearch xmlns="http://xml.thomson.com/financial/v1/tools/search/mercury/2003-04/API">
<Header>
<ApplicationID>YOUR MERURY ID</ApplicationID>
</Header>
<Criteria>
<Group>
<Collection>INV</Collection>
<Text grammar="IB">spotfire</Text>
<Company>IBM</Company>
</Group>
</Criteria>
<SortOrder>
<Item order="D">PublishDate</Item>
</SortOrder>
<MaxResults>10</MaxResults>
</DoSearch>

To returns all the search results for IBM:

<?xml version="1.0" encoding="utf-8" ?>
<DoSearch xmlns="http://xml.thomson.com/financial/v1/tools/search/mercury/2003-04/API">
<Header>
<ApplicationID>YOUR MERURY ID</ApplicationID>
</Header>
<Criteria>
<Group>
<Collection>INV</Collection>
<Text grammar="IB">spotfire</Text>
<Company>IBM</Company>
</Group>
</Criteria>
<SortOrder>
<Item order="D">PublishDate</Item>
</SortOrder>
</DoSearch>

2- Table of Content: GetTOC

<?xml version="1.0" encoding="utf-8" ?>
<GetTOC xmlns="http://xml.thomson.com/financial/v1/tools/search/mercury/2003-04/API">
<Header>
<ApplicationID>YOUR MERURY ID</ApplicationID>
</Header>
<Headlines>
<HeadlineID> if9e1ca22d35a4ceb9bc7fa2f5664aac4</HeadlineID>
</Headlines>
</GetTOC>

3- Retrieve Documents: GetDocument

http://qamercdoc.tfn.com/MercuryAPI/GetDocument.aspx?ApplicationID=yourmerucryID&%20&DocumentID=10120161&DocumentIDType=INV&

Sample Response

Sample response for a DoSearch request:

<?xml version="1.0" encoding="utf-8" ?>
- <Record xmlns="http://xml.thomson.com/financial/v1/tools/distribution/dataworks/enterprise/2003-07/">
<Source>Mercury</Source>
<Instrument><?xml version="1.0" encoding="utf-8" ?>
<DoSearch xmlns="http://xml.thomson.com/financial/v1/tools/search/mercury/2003-04/API"><Header><ApplicationID>HARBOR</ApplicationID></Header><Criteria><Group><Collection>INV</Collection><Company>IBM</Company></Group></Criteria><SortOrder><Item order="D">PublishDate</Item></SortOrder><MaxResults>3</MaxResults></DoSearch>
</Instrument>
<Tag />
<StatusType>Connected</StatusType>
<StatusCode>0</StatusCode>
<StatusMessage />
- <Fields>
- <Results>
<Status>2</Status>
<Start>1</Start>
<End>3</End>
<Count>3</Count>
<Total>17</Total>
<Handle>ia744b3e100000101d4c77976af01b87d</Handle>
- <Headline>
<HeadlineID>i3bb7d99dc8d24f338e16b66d05bea780</HeadlineID>
<VATitle>INTERNATIONAL BUSINESS MACHINES CORP.</VATitle>
<NumPages>12</NumPages>
<NumBillablePages>11</NumBillablePages>
<NonBillablePages>1</NonBillablePages>
<PublishDate>20050118</PublishDate>
<Collection>INV</Collection>
<SubCollection />
<Language>eng</Language>
<Source srcType="VA">FDF</Source>
<VASourceName>THOMSON STREETEVENTS</VASourceName>
<SortAuthorName>ANON</SortAuthorName>
<VACompanyString>INTERNATIONAL BUSINESS MACHINES CORP.</VACompanyString>
+ <Resource>
<DocGuid>i1728588f39c54dee8a5f496fa10d7b00</DocGuid>
<ExternalId extTaxon="INV">10060104</ExternalId>
<Format>NATIVE</Format>
<DocSize>160498</DocSize>
<MimeType>application/pdf</MimeType>
<ContentType>VA</ContentType>
<Parent>i3bb7d99dc8d24f338e16b66d05bea780</Parent>
<DocNumPages>12</DocNumPages>
<DocNumBillablePages>11</DocNumBillablePages>
<DocNonBillablePages>1</DocNonBillablePages>
</Resource>
<TOCFlag>TRUE</TOCFlag>
</Headline>
+ <Headline>
<HeadlineID>ic4abd3606eb44205bf0c42c4fa8a138e</HeadlineID>
<VATitle>INTERNATIONAL BUSINESS MACHINES CORP.</VATitle>
<NumPages>14</NumPages>
<NumBillablePages>13</NumBillablePages>
<NonBillablePages>14</NonBillablePages>
<PublishDate>20050113</PublishDate>
<Collection>INV</Collection>
<SubCollection />
<Language>eng</Language>
<Source srcType="VA">SCB</Source>
<VASourceName>SANFORD C. BERNSTEIN & CO., INC.</VASourceName>
<SortAuthorName>SACCONAGHI, A.M., ET AL</SortAuthorName>
<VACompanyString>INTERNATIONAL BUSINESS MACHINES CORP.</VACompanyString>
- <Resource>
<DocGuid>if930a82891b4421ba96b1ed5dca774ac</DocGuid>
<ExternalId extTaxon="INV">10051458</ExternalId>
<Format>NATIVE</Format>
<DocSize>272512</DocSize>
<MimeType>application/pdf</MimeType>
<ContentType>VA</ContentType>
<Parent>ic4abd3606eb44205bf0c42c4fa8a138e</Parent>
<DocNumPages>14</DocNumPages>
<DocNumBillablePages>13</DocNumBillablePages>
<DocNonBillablePages>14</DocNonBillablePages>
</Resource>
<TOCFlag>TRUE</TOCFlag>
</Headline>
+ <Headline>
<HeadlineID>i0a9b0407f5fb421eb6d742bd2d98d178</HeadlineID>
<VATitle>INTERNATIONAL BUSINESS MACHINES CORP.</VATitle>
<NumPages>7</NumPages>
<NumBillablePages>7</NumBillablePages>
<NonBillablePages />
<PublishDate>20050103</PublishDate>
<Collection>INV</Collection>
<SubCollection />
<Language>eng</Language>
<Source srcType="VA">AGE</Source>
<VASourceName>A.G. EDWARDS & SONS, INC.</VASourceName>
<SortAuthorName>WONG, D., ET AL</SortAuthorName>
<VACompanyString>INTERNATIONAL BUSINESS MACHINES CORPORATION</VACompanyString>
- <Resource>
<DocGuid>i0d9cd43a1ef74ecda88a80bf93096d81</DocGuid>
<ExternalId extTaxon="INV">10028627</ExternalId>
<Format>NATIVE</Format>
<DocSize>99369</DocSize>
<MimeType>application/pdf</MimeType>
<ContentType>VA</ContentType>
<Parent>i0a9b0407f5fb421eb6d742bd2d98d178</Parent>
<DocNumPages>7</DocNumPages>
<DocNumBillablePages>7</DocNumBillablePages>
<DocNonBillablePages />
</Resource>
<TOCFlag>TRUE</TOCFlag>
</Headline>
- <Information>
<Code>1</Code>
<Detail status="1">(=Collection(INV) & DI=EmbargoDate([1980:20050202]) % =Source(MER MIH BNA BNE DRI KBS DNB LBA LBU LBM SLH)) & =Collection(#INV) & =Company:coType="investextid VA"(#IBM)</Detail>
<Detail status="1"> TF_END3B,TF_END3A,TF_END0,TF_END1,TF_END2,TF_ENDCRTA,TFJP_JPD0,TFJP_JPDRA </Detail>
</Information>
</Results>
</Fields>
</Record>