For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
juha.pomell avatar image
3 ●1 ●1 ●1

ISIN code and Currency

Hi,


I need find instruments trading currency. I'm using ISIN codes and universe is equities, ETFs and bonds. I have tested CF_CURR, Ccy etc and still <NA>.

What should I try next?


Thx.


Juha

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonforexisin
1616178702798.png (7.3 KiB)
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.

3 Answers

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @juha.pomell

I think you can convert ISIN to RIC first, then try to get CF_CURR.


ahs.jpg (50.7 KiB)
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.

Upvotes
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @juha.pomell

You can use TR.FundCurrency field.



ahs.jpg (186.9 KiB)
ahs2.jpg (12.8 KiB)
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.

Upvotes
juha.pomell avatar image
3 ●1 ●1 ●1

Hi @chavalit.jintamalit


Thanks for your suggestion. I'm afraid TR.FundCurrency only partially solves the problem. As I mentioned, I'm using list of ISINs for equity, ETFs, bonds and funds.


Perhaps example below explains the situation better than my previous example. I have tested CF_CURR, Ccy and TR.FundCurrency and only in case of ETF I get the instrument's currency.


Cheers,

Juha


isins.png (22.8 KiB)
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