PermID - How to get the currency of an instruments quote

Tony Edwards
Tony Edwards
in Open PermID

It seems there is no currency field in either the instruments or quotes part of the search endpoint. Any ideas how to get the currency of an instrument or quote?

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @Tony Edwards

    Thank you for reaching out to us.

    The currency is available in the Quote entity when lookup. It is in the "isQuotedIn" field.

    output,err = opid.lookup("1-55838323096", orient="column", format='dataframe')
    output

    1699352698218.png

    Then, we need to lookup for https://permid.org/1-500110.

    output,err = opid.lookup("1-500110", orient="column", format='dataframe')
    output

    1699352753865.png

    You can refer to the Terms and Conditions page for the list of avaialble fields for each entity type.


Answers

  • Tony Edwards
    Tony Edwards

    Thanks but when I use the search api the isQuotedIn field is not there ....


    https://api-eit.refinitiv.com/permid/search?num=50&entitytype=quote&q=ticker:XXX


    @{"instruments":{"total":5,"entities":[{"isIssuedBy":"https:\/\/permid.org\/1-4295862367","hasPrimaryQuote":"https:\/\/permid.org\/1-55838865334","hasName":"Western Forest Products Ord Shs","isIssuedByName":"Western Forest Products Inc","primaryTicker":"WEF","@id":"https:\/\/permid.org\/1-8590929575","assetClass":"Ordinary Shares"},{"isIssuedBy":"https:\/\/permid.org\/1-4295895247","hasPrimaryQuote":"https:\/\/permid.org\/1-55836048473","hasName":"NWF Group Ord Shs","isIssuedByName":"NWF Group PLC","primaryTicker":"NWF","@id":"https:\/\/permid.org\/1-8590942063","assetClass":"Ordinary Shares"},{"isIssuedBy":"https:\/\/permid.org\/1-5037439944","hasPrimaryQuote":"https:\/\/permid.org\/1-21505370084","hasName":"Newfield Resources Ord Shs","isIssuedByName":"Newfield Resources Ltd","primaryTicker":"NWF","@id":"https:\/\/permid.org\/1-21502532003","assetClass":"Fully Paid Ordinary Shares"},{"isIssuedBy":"https:\/\/permid.org\/1-4295885268","hasPrimaryQuote":"https:\/\/permid.org\/1-55838842578","hasName":"New Zealand Windfarms Ord Shs","isIssuedByName":"NZ Windfarms Ltd","primaryTicker":"NWF","@id":"https:\/\/permid.org\/1-8589943531","a....... etc

    Am I missing something here ??

    Thanks!

  • Jirapongse
    Jirapongse

    @Tony Edwards

    You need to use lookup in order to get the isQuotedIn field.

Categories