Creating Very Basic Search

Hi Everyone, this might be a very simple solution or not.

We are implementing a simple Search function for the following Exchanges

PAR,ASX, BRU, OSL, MUN, LSE, LIS, NSE, MIL, TLV, TO, NYS, NAS

If for example Id like for a user to search for a specific Ticker, but that same ticker is on multiple exchanges, for example


Royal Bank, has two exchanges it trades on,

RY.TO & RY.N (primary RIC)

in our current search tool bar, it is showing as

ROYAL BANK OF CANADA ORD, USD, RY.N, RY.TO, NYS

ROYAL BANK OF CANADA ORD, CAD, RY.NEO, RY.TO, NEO *we are no longer using NEO we will be RY.NBC and RY.NB

Is there a best practice one can recommend for us to implement the search tools to be able to fully deliver our end users the proper search selection for Ticker/Exchange/Country


Example

RY.TO, RY.NBC, Canada

RY.N, RY.NB, USA

Correct?


Tagged:

Best Answer

  • Hello @Wick ,

    I am finding exchanges for RY with this RDP search (one has to be permissioned for either search or searchlight to run RDP search queries):

    https://{{RDP_HOST}}/discovery/search/v1/ 

    or

    https://{{RDP_HOST}}/discovery/searchlight/v1/ 

    Request:

    {
    "View": "EquityQuotes",
    "Filter": "RIC eq 'RY.*' ",
    "Select": "RIC,CompositeRIC,IssuerCommonName,ExchangeName",
    "Top": 500,
    "Skip": 0
    }

    Resulting in:

    {
    "Total": 72,
    "Hits": [
    {
    "RIC": "RY.TO",
    "CompositeRIC": "RY.CCP",
    "IssuerCommonName": "Royal Bank of Canada",
    "ExchangeName": "The Toronto Stock Exchange"
    },
    {
    "RIC": "RY.N",
    "CompositeRIC": "RY",
    "IssuerCommonName": "Royal Bank of Canada",
    "ExchangeName": "New York Stock Exchange"
    },
    {
    "RIC": "RY.CCP",
    "IssuerCommonName": "Royal Bank of Canada",
    "ExchangeName": "Canadian Composite Quote/Trade"
    },
    {
    "RIC": "RY.TH",
    "CompositeRIC": "RY",
    "IssuerCommonName": "Royal Bank of Canada",
    "ExchangeName": "NASDAQ INTERMARKET"
    },
    {
    "RIC": "RY.P",
    "CompositeRIC": "RY",
    "IssuerCommonName": "Royal Bank of Canada",
    "ExchangeName": "NYSE Arca"
    },
    {
    "RIC": "RY.GO",
    "CompositeRIC": "RY.CCP",
    "IssuerCommonName": "Royal Bank of Canada",
    "ExchangeName": "Canadian Securities Exchange/PURE - CSE Listed & Other Canadian Listed Securities"
    },
    ...

    However, is this is what you are looking to do?

    Otherwise, please explain more of the requirement.


Answers