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 aman.kesarwani · Oct 30, 2019 at 06:38 PM · python api eikonhistorical datacusipclosebidcmo

Trying to fetch Close Bid Price for CMO tranche from Python

I am trying to fetch the close bid price of CMO tranche with CUSIP 151314GD7 using below python formula

This python formula returns NaN values, however when I check the value from TR Desktop I can see 85.13 value

I would be really kind if anyone can provide me with correct Pythpon formula to obtain the close bid values. I understand that CMO tranche are fixed income product so they may have different labels to fetch the value, but I am not sure how to find those (I have experimented with some of the fields that I found on FLDS but no result)

capture1.png (6.7 KiB)
capture.png (10.0 KiB)

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 nick.zincone.1 · Oct 30, 2019 at 11:30 PM

Not all data is directly available using the current Python Eikon API @aman.kesarwani.

The other option available within the API is to use the get_timeseries() call but that has a limited set of fields it provides and doesn't provide BID values. The get_timeseries() presently only supports a limited set of fields, i.e. OPEN, CLOSE, HIGH, LOW, VOLUME. For example:

As mentioned in my first answer, the best resource to confirm if the data is available is to reach out to the Refinitiv Helpdesk. We have content specialists there that can confirm.


ahs.png (11.9 KiB)
Comment

People who like this

0 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 nick.zincone.1 · Oct 30, 2019 at 09:13 PM

Hi @aman.kesarwani,

Looking at the Data Item Browser (DIB) within the Eikon Desktop, I don't see the specific fields you are after. This is what appears to be available:

And when you query using the API, this is what comes back:

The best resource to ask questions about data availability is the Refinitv Helpdesk.



ahs.png (62.4 KiB)
ahs2.png (17.4 KiB)
Comment

People who like this

0 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
Answer by aman.kesarwani · Oct 30, 2019 at 10:13 PM

Let me simplify this for you @. I have below excel formula which gives output for a list of CUSIPs


=RHistory($A$2:$A$3,"BID.Timestamp;BID.Close","START:01-Sep-2000 END:01-Oct-2019 CODE:CUSIP INTERVAL:1D",,"TSREPEAT:NO CH:Fd",B2)


I want to replicate the same in Python. Kindly help me with the same.

I have also attached the excel file screenshot where we have generate the output using the above formula (cell C2). Since we are planning to fetch the data for many more CUSIPs so we are trying to get the results through Python.


capture.png (76.3 KiB)
Comment

People who like this

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

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

Related Questions

Hello , How to get S&P500 all stock daily weight by eikon with python API ? thank you.

Close price older than Oct 2017

How to get the TR.PE at a historical date?

I have using python. I need to get the real time streaming data.

Missing RICs in screener result for Taiwan exchange

  • 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