DSS API Query

preshan.govinder

We are now
getting a record back for the CNY rate, but the record does not contain the
“Closing Price” value. Please see below:

Response:

<ExtractResult>

<RowCount>23</RowCount>

<Columns>

<ExtractionColumn>

<Name>RIC</Name>

<DataType>String</DataType>

<Values>

<string>AUD3MFSR=</string>

<string>AUPRIME=</string>

<string>CAD3MFSR=</string>

<string>CAPRIME=</string>

<string>CHF3MFSR=</string>

<string>CHPRIME=</string>

<string>DKK3MFSR=</string>

<string>ECBMRO=</string>

<string>EUR3MFSR=</string>

<string>GBP3MFSR=</string>

<string>GBPRIME=</string>

<string>HKPR=</string>

<string>JPPRIME=</string>

<string>JPY3MFSR=</string>

<string>NOUTL=</string>

<string>NZD3MFSR=</string>

<string>NZPRIME=</string>

<string>SEK3MFSR=</string>

<string>SERP=</string>

<string>SHICNY3MD=</string>

<string>USD3MFSR=</string>

<string>USPRIME=</string>

<string>ZAPRIME=</string>

</Values>

</ExtractionColumn>

<ExtractionColumn>

<Name>Trade Date</Name>

<DataType>DateOnly</DataType>

<Values>

<empty />

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-10-02</date>

<empty />

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-10-02</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

</Values>

</ExtractionColumn>

<ExtractionColumn>

<Name>Close Price</Name>

<DataType>Double</DataType>

<Values>

<empty />

<double>1.5</double>

<empty />

<double>3.2</double>

<double>-0.726</double>

<double>0.5</double>

<empty />

<double>0</double>

<double>-0.37943</double>

<double>0.335</double>

<empty />

<double>5</double>

<double>1</double>

<double>-0.05121</double>

<double>1.5</double>

<empty />

<double>1.75</double>

<empty />

<double>-0.5</double>

<empty />

<double>1.33389</double>

<double>4.25</double>

<double>10.25</double>

</Values>

</ExtractionColumn>

</Columns>

You will notice that for all
other instruments, the request returns a value for the 29th however SHICNY3MD=
is looking for a value for today?

Do they need to adjust their API
request?

Christiaan Meihsl

@preshan.govinder

For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via My Account or to call the Thomson Reuters Help Desk directly.

preshan.govinder

Hi Christiaan, are you able to assist with this query?