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 Nate.Kim · Sep 12, 2019 at 02:03 PM · python apipython api eikonoasfioptionadjustedspreadoption adjusted spread

Python API - Fi Option Adjusted Spread (get data)

Hi,

I'm trying to pull the Option Adjusted Spread (FiOptionAdjustedSpread) for a specific bond on a specific date. Can anyone help me with the python code for that? Thank you!


3.png (127.3 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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by James.Perkins · Sep 18, 2019 at 01:11 PM

If you want to reference OAS via the get_timeseries() function you would reference "OAS" as the field (which is pulling from TR.OPTIONADJUSTEDSPREADBID) ; there are some slight differences required at times when using get_data() vs. get_timeseries() to pull hisotrical values since there are multiple databases for some data types.

oas_hist = ek.get_timeseries('075887BX6=',['Bid','Bid_yield','OAS'], start_date = "2019-08-06", end_date = "'2019-09-06", interval="taq")


oas.png (24.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 James.Perkins · Sep 12, 2019 at 09:45 PM

The field TR.OPTIONADJUSTEDSPREAD does not appear to have a value available for 075887BX6=FINR . I recommend using TR.OPTIONADJUSTEDSPREADBID or TR.OASAnalytics;

ek.get_data('075887BX6=FINR','TR.OASAnalytics(ValuationDate=20190719)')


oas.png (167.7 KiB)
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
blucap · Sep 18, 2019 at 12:41 AM 0
Share

Just wondering if these spreads can also be retrieved over time using ek.get_timeseries()

avatar image
Answer by Nate.Kim · Sep 13, 2019 at 02:47 PM

Thanks for your answer. I am trying to pull FiOptionAdjustedSpread specifically since I need the spread based on the Treasury rates. I don't know how normal OptionAdjustedSpread function or OASAnalytics function are calculated but those values are different from what I'm looking for... is there a way to pull FiOptionAdjustedSpread? if not for this bond, other bonds?

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 James.Perkins · Sep 13, 2019 at 09:34 PM

Tkanks Nate; to be honest TR.OPTIONADJUSTEDSPREAD is a legacy analytics field. TR.OASAnalytics is a more modern analytic field and there are more details provided on methodology (see below). If you need/want more details on calc methodology feel free to email me at james.perkins@refinitiv.com .


oas.png (82.6 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 >
8 People are following this question.

Related Questions

Request CF_LAST in a particular currency.

How to correctly query python API for Eikon news

How can I get dividend data in certain condition using python API?

How to dynamically get a list of bonds from Eikon Python API or Pydatastream

How to retrieve different Peer Sets and fields?

  • 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