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 aquilesjlp300 · Feb 18, 2019 at 01:35 PM · pythonpython apipython api eikonpython eikon

Request CF_LAST in a particular currency.

I'm using CF_LAST to get last traded price on a stock. I'd like to get the given price in given currency, let's say USD. Is there a direct way to do that? It doesn't seem to be a setting available for that CF_ factor that allows me to do so.

I could try using the FX pair options provided indeed, but is that the only way to achieve this? I'd like to know.

Thanks for your time,

Aquiles

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Feb 19, 2019 at 10:10 AM

At the backend we can only convert to another currency historical prices available through TR. fields. CF_ fields come from the real-time streaming datafeed, which does not have the capability to convert prices to another currency. The only way to convert to another currency most recent market data coming from real-time streaming datafeed is to do it in a client application. Mind that if you're looking to provide comprehensive currency conversion for global stocks, it's not a trivial task. You have to take into account that in the FX market by convention most currencies are quoted to USD directly (i.e. in units of the currency per 1 USD), but some currencies (e.g. EUR, GBP, AUD) are quoted indirectly (i.e. in USD per unit of the currency). You also have to take into account that in some markets, e.g. UK, South Africa, Israel stocks are quoted in minor (pennies, agorot) rather than major (pounds, shekels) currency units.

Comment
aquilesjlp300

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
aquilesjlp300 · Feb 19, 2019 at 11:18 AM 0
Share

Yes, I totally agree and aware of the points you're mentioning @Alex Putkov., that's one of the reasons why I wanted to know if Eikon had a more straightforward method to do this (like it does with TR.PriceClose, that lets you select the currency in which you desire it to be).

But that's ok, looks like that's going to be the way I'll proceed at the moment because like you guessed, I'm working with real-time streaming and that's the only way at the moment.

Still, thanks a lot for the feedback on this!

avatar image
REFINITIV
Answer by jason.ramchandani · Feb 18, 2019 at 05:47 PM

@aquilesjlp300 Yes you can get the last price using the PriceClose field:'TR.PriceClose(Curn=USD)'

The parameter 'Curn=' can be any currency RIC eg CAD, JPY etc

I hope this can help.

Comment
aquilesjlp300

People who like this

1 Show 2 · 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
aquilesjlp300 · Feb 18, 2019 at 05:57 PM 0
Share

Thanks for this reply @jason.ramchandani, the thing is, TR.PriceClose only gives me the closing price, CF_LAST indeed at some point of the day becomes the closing price for a given market, but what if I request it at a particular moment of the day, where market close has not yet arrived (?)

That's why I'm not considering using TR.PriceClose as an option.

avatar image
REFINITIV
jason.ramchandani ♦♦ aquilesjlp300 · Feb 18, 2019 at 06:08 PM 0
Share

@aquilesjlp300 Apols misread your question - can you try 'TR.CLOSEPRICE(Curn=USD)' to get last traded price.

You can use the Data Item Browser App in Eikon (DIB) to discover data items with both values, descriptions and parameter settings.

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 >
8 People are following this question.

Related Questions

Python Data retrieving

Get All Mergers and Acquisitions on the Python API

EIKON API PYTHON AUTOMATION

Find or calculate intraday volatility.

How to get Eikon data on python for a set of RICs given in excel sheet?

  • 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