question

Upvotes
Accepted
1 0 0 0

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?


ricssymbology
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.

@zoya faberov if you could add some insight?

thank you

1 Answer

Upvotes
Accepted
23k 22 9 14

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.


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