question

Upvotes
Accepted
somjade.keswongrot avatar image
3 ●0 ●0 ●4

How to used TRKD API Search v2 get EquityQuotes and FundQuotes in one request?

Hi refinitive support,


Currently we used TRKD api Search v2 "Collection": "EquityQuotes" to search RICs we can't found ETFs include in search result.

Current Req:

{
"Search_Request_1": {
"Collection": "EquityQuotes",
"Filter": "AssetType eq 'EQUITY' and ExchangeCode in ('NXB' 'NYS')",
"ResponseProperties": "RIC,ExchangeCode,CommonName,IssueISIN,AssetType",
"UnentitledAccess": true
}
}

Question 1) Can we used Search v2 "Collection": "EquityQuotes" include ETFs by put in filter?

{
"Search_Request_1": {
"Collection": "EquityQuotes",
"Filter": "AssetType eq 'EQUITY' and ExchangeCode in ('NXB' 'NYS')",
"ResponseProperties": "RIC,ExchangeCode,CommonName,IssueISIN,AssetType",
"UnentitledAccess": true
}
}

Question 2) What's the proper way to search with result 'EquityQuotes' and 'FundQuotes' together?

Question 3) This is only one way used to Search return result 'EquityQuotes' and 'FundQuotes' together?

{
"Search_Request_1": {
"Collection": "SearchAll",
"Filter": "AssetType eq 'EQUITY' and ExchangeCode in ('NXB' 'NYS')",
"ResponseProperties": "RIC,ExchangeCode,CommonName,IssueISIN,AssetType",
"UnentitledAccess": true
}

Thanks,

Somjade.K

rkd-apirkd
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
mohammad.waseem avatar image
381 ●1 ●2 ●3

Hi somjade.keswongrot ,

Apologies for delay in answering. You can correct you need to use 'SearchAll' collection to include both Equity and Funds. SearchAll collection includes all asset categories including equity, funds, commodities, bonds etc. Please find sample request below.

-<Search_Request_1 xmlns="http://www.reuters.com/ns/2017/08/18/webservices/rkd/Search2_1" UnentitledAccess="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">;

<Collection>SearchAll</Collection>

<Filter>AssetCategory in ('ETF' 'ORD' 'PRF') and ExchangeCode in ('NXB' 'NYS')</Filter>

<ResponseProperties>AssetCategoryName,AssetType,ShortName,IssuerCommonName,AssetCategory,ExchangeName,ExchangeCode</ResponseProperties>

</Search_Request_1>

Please note Searchv2 has limitation of number of records to be returned in single API request which is limited to 10000.

thanks,

Waseem




icon clock
10 |1500

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

Click below to post an Idea Post Idea