For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
Gerald S avatar image
1 ●1 ●1 ●2

Datascope Select API Configuration

Dear Team,

I have a Client looking to resolve an issue within DSS, please details below;

Request: Client require the rate feed for 3M – CNY SHIBOR.

Issue: Cannot get the Instrument nto return correct Field, see below an extract from the Clients response;

"The response now contains a CNY record. However, the record does not contain a “Closing Price“ value. Please see below:

Request:

<ValidatedInstrument>

<IdentifierValue>SHICNY3MD=</IdentifierValue>

<IdentifierType>RIC</IdentifierType>

<Source>N/E</Source>

<AssetId>0x00100b0006064ef3</AssetId>

<QuoteId>0x0003f8016432a509</QuoteId>

<Segment>Y</Segment>

<ObjectType>MNQU</ObjectType>

<Ric>SHICNY3MD=</Ric>

<FileCode>1892</FileCode>

</ValidatedInstrument>

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>

Could you please investigate what the issue might be and let us know?

dss-rest-apidatascope-selectdss
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.

Christiaan Meihsl avatar image   Christiaan Meihsl

Duplicate of this query, but with more detail.

zoya faberov avatar image   zoya faberov

Hello @Christiaan Meihsl,

Do you mean this is a duplicate that should be removed?

Thanks

Christiaan Meihsl avatar image   Christiaan Meihsl zoya faberov

Hi @zoya.farberov,

I would have removed the other one (because it has less details), but as it was posted by a customer I did not remove it, we do not want to discourage customers from posting queries. This one was posted by a TR person, it would be less of an issue to remove it, but it has more useful details that make it easier to understand, so I decided to leave it as well.

So in this case I just mentioned the duplication to avoid people wasting time answering the same query twice :-)

PS: sorry for the late answer, I was away for 2 weeks.

zoya faberov avatar image   zoya faberov

Hi @Christiaan Meihsl,

I totally understand!

Will you be able to provide the link to the other question as the answer?

Thanks much,

-Zoya

Christiaan Meihsl avatar image   Christiaan Meihsl zoya faberov

Hi Zoya, done :)

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @Gerald S

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,
AHS

chavalit-jintamalit avatar image   chavalit-jintamalit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

Please see the answer to the same query here.

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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