question

Upvotes
Accepted
401 18 20 34

GetRICSymbology: no data returned

Can you please take a look at the below. I’m trying to simply get SEDOLs for a RIC, and getting no Instrument data back from TRTH-API:

Request body:

   <soapenv:Body>
      <typ:GetRICSymbology>
         <typ:instrument>
            <typ:code>VOD.L</typ:code>
         </typ:instrument>
         <typ:dateRange>
            <typ:start>2007-04-01</typ:start>
            <typ:end>2007-04-05</typ:end>
         </typ:dateRange>
      </typ:GetRICSymbology>
   </soapenv:Body>

Response body:

   <soapenv:Body>
      <GetRICSymbologyResponse xmlns="http://types.webservice.tickhistory.thomsonreuters.com">
         <instrumentList/>
      </GetRICSymbologyResponse>
   </soapenv:Body>
tick-history-rest-apisoap-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
13.7k 26 8 12

I reproduced what you see with the TRTH SOAP API, using SoapUI. Your syntax is correct.

There are 2 reasons why you did not get any results:

  1. There is no data available for the particular instrument you chose (VOD.L).
  2. The restricted date range.

Below is a successful call for a different instrument (CARR.PA) and a wider date range (if you restrict the date range to what you originally used then you will not get any data either).

Hope this helps !

Request body:

   <soapenv:Body>
      <typ:GetRICSymbology>
         <typ:instrument>
            <typ:code>CARR.PA</typ:code>
         </typ:instrument>
         <typ:dateRange>
            <typ:start>2000-01-01</typ:start>
            <typ:end>2016-07-31</typ:end>
         </typ:dateRange>
      </typ:GetRICSymbology>
   </soapenv:Body>

Response body:

  <soapenv:Body>
      <GetRICSymbologyResponse xmlns="http://types.webservice.tickhistory.thomsonreuters.com">
         <instrumentList>
            <instrument>
               <code>CARRn.PA</code>
               <dateRange>
                  <start>2001-01-09</start>
                  <end>2003-05-08</end>
               </dateRange>
               <name>
                  <string>CARREFOUR NV</string>
                  <string>**SEE <CARR.PA>*</string>
               </name>
               <status>Verified</status>
               <statusInfo/>
               <exchange>
                  <string>NXT</string>
                  <string>PAR</string>
               </exchange>
               <type>
                  <string>113</string>
                  <string>225</string>
               </type>
               <currency>
                  <string>EUR</string>
               </currency>
               <peCode>
                  <string>6520</string>
               </peCode>
               <releaseCycle>0</releaseCycle>
            </instrument>
            <instrument>
               <code>CARR.PA</code>
               <isin>
                  <string>FR0000120172</string>
               </isin>
               <sedol>
                  <string>5641567</string>
               </sedol>
               <gics>
                  <int>30101040</int>
               </gics>
               <dateRange>
                  <start>1996-01-01</start>
                  <end>2016-08-15</end>
               </dateRange>
               <name>
                  <string>CARREFOUR</string>
               </name>
               <status>Verified</status>
               <statusInfo/>
               <exchange>
                  <string>PAR</string>
                  <string>NXT</string>
                  <string>PAR</string>
               </exchange>
               <type>
                  <string>113</string>
               </type>
               <expiryDate>
                  <dt>2007-03-09</dt>
                  <dt>2007-03-16</dt>
                  <dt>2007-03-19</dt>
                  <dt>2007-03-23</dt>
                  <dt>2007-03-30</dt>
               </expiryDate>
               <maturityDate>
                  <dt>2007-03-09</dt>
                  <dt>2007-03-16</dt>
                  <dt>2007-03-19</dt>
                  <dt>2007-03-23</dt>
                  <dt>2007-03-30</dt>
               </maturityDate>
               <currency>
                  <string>EUR</string>
               </currency>
               <peCode>
                  <string>3032</string>
                  <string>6520</string>
               </peCode>
               <underlyingRIC>
                  <string>CARR.PA</string>
               </underlyingRIC>
               <releaseCycle>2</releaseCycle>
            </instrument>
         </instrumentList>
      </GetRICSymbologyResponse>
   </soapenv:Body>
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.