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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aman.kesarwani avatar image
1 ●0 ●1 ●2

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)

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonhistoricalpricingsymbology
capture1.png (6.7 KiB)
capture.png (10.0 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
nick.zincone avatar image
9.7k ●49 ●38 ●60

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)
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
nick.zincone avatar image
9.7k ●49 ●38 ●60

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)
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
aman.kesarwani avatar image
1 ●0 ●1 ●2

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)
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