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

somjade.keswongrot

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

mohammad.waseem

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&quot; UnentitledAccess="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;

<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