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?
1
●0 ●0 ●1
PermID - How to get the currency of an instruments quote
Hi @Tony Edwards ,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thank you,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thank you,
AHS
79.2k
●251 ●52 ●74
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
Then, we need to lookup for https://permid.org/1-500110.
output,err = opid.lookup("1-500110", orient="column", format='dataframe')
output
You can refer to the Terms and Conditions page for the list of avaialble fields for each entity type.
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!
