Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by mzeman · Apr 22, 2020 at 02:49 PM · ricisincf_curr

Why CF_CURR does not return currency when asking same instrument via different types of identifier?

When I ask for CF_CURR via TICKER and ISIN, I get USD for ticker but NaN for ISIN.

identifiers = ['US03076C1062', 'AMP']

data, error = ek.get_data(identifiers, fields=['CF_CURR'])

Output:

Instrument CF_CURR

0 US03076C1062 None

1 AMP USD

Is this desired behaviour that I have to first convert all identifiers to RIC (even other data can be obtained via ISIN)?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Apr 23, 2020 at 03:20 AM

@mzeman

From my testing, it works with other fundamental fields, such as TR.CurrEnterpriseValueEV.

I assume that it doesn't work with CF_CURR because CF_CURR is in the Real-Time category.

Typically, we use RICs to subscribe to real-time data. If you check the raw output, you will see that it returns 'The record could not be found' for the instrument 'US03076C1062'.

{'columnHeadersCount': 1,
 'data': [['US03076C1062', 28429632678.7, None],
  ['AMP', 28429632678.7, 'USD']],
 'error': [{'code': 251658243,
   'col': 2,
   'message': "'The record could not be found' for the instrument 'US03076C1062'",
   'row': 0}],
 'headerOrientation': 'horizontal',
 'headers': [[{'displayName': 'Instrument'},
   {'displayName': 'Current EV', 'field': 'TR.CURRENTERPRISEVALUEEV'},
   {'displayName': 'CF_CURR', 'field': 'CF_CURR'}]],
 'rowHeadersCount': 1,
 'totalColumnsCount': 3,
 'totalRowsCount': 3}

1587611580706.png (19.7 KiB)
1587611672687.png (61.6 KiB)
Comment
mzeman

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Gurpreet · Apr 22, 2020 at 04:42 PM

Hi @mzeman,

RIC is the only acceptable identifier for use with Eikon API. If you inspect error object, it contains this message:

[{'code': 251658243, 'col': 1, 'message': "'The record could not be found' for the instrument 'US03076C1062'", 'row': 0}]
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
mzeman · Apr 23, 2020 at 06:50 AM 0
Share

That's not true. The answer from jirapongse.phuriphanvichai explains this problem and also provides an example that RIC is not only an acceptable identifier.

avatar image
REFINITIV
Answer by Pimchaya.Wongrukun · Apr 23, 2020 at 02:27 AM

Hello @mzeman

You can use get_symbology(..) function which returns a list of instrument names converted into another instrument code e.g. ISIN is converted to RIC as an example below:

aRIC = ek.get_symbology(["US03076C1062"], from_symbol_type="ISIN", to_symbol_type="RIC")
aRIC


isin2ric.png (1.4 KiB)
Comment
mzeman

People who like this

1 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
mzeman · Apr 23, 2020 at 06:53 AM 0
Share

Thanks. I know this solution. I have already used it. However, it doesn't explain this problem. But jirapongse.phuriphanvichai explains it well.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Get Historical Prices from Bond ISIN

Search for bonds on Eikon Data API (using Python)

Unable to download Fund price

Get_Symbology from ISIN to RIC with currency

list of bankrupt companies & balance sheet/ income statements of a specific year

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges