question

Upvotes
Accepted
1 0 0 1

PermID - How to get the currency of an instruments quote

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?

#productpermid-apiopen-permid-api
icon clock
10 |1500

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

Upvotes
Accepted
76.9k 240 52 72

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



1699352698218.png (29.5 KiB)
1699352753865.png (28.0 KiB)
icon clock
10 |1500

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

Upvotes
1 0 0 1

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!

icon clock
10 |1500

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

@Tony Edwards

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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