Option Adjusted Spread Calculation
I've been doing some quant bond work and have found numerous inconsistencies with OAS data provided by Eikon. This is true both within the platform and in comparison to Bloomberg data as well. Would it be possible to get an explanation regarding the methodology used as well as some direction regarding which of the numerous methods are most inline with industry standard :
Please note: Bloomberg had 21.09 for the OAS Bid
Additionally, the quote has something entirely different...
some clarity and direction would be greatly appreciated
My code for both:
fields = ['TR.OASAnalytics', 'TR.FiOptionAdjustedSpread']
oas = ek.get_data('002824BE9', fields=fields)[0]
fields_2 = ['TR.OPTIONADJUSTEDSPREADBID', 'OAS_BID']
oas_bid = ek.get_data('002824BE9=1M', fields=fields_2)[0]
oas_bid
Best Answer
-
Hello @jgarden ,
Sorry for the belated response- I did not see your comment.
From the examples that you have provided, when I run them on my side, the three instruments do differ:
fields = ['TR.OASAnalytics', 'TR.FiOptionAdjustedSpread']
ek.get_data(['002824BE9','002824BE9=1M','002824BE9='], fields=fields)Results in:
( Instrument Option Adjusted Spread Option Adjusted Spread
0 002824BE9 -27.195224 24.663915
1 002824BE9=1M -73.969221 24.663915
2 002824BE9= -27.195224 24.663915,
None)And request:
fields_2 = ['TR.OPTIONADJUSTEDSPREADBID', 'OAS_BID']
Results in:
( Instrument Option Adjusted Spread Bid OAS_BID
0 002824BE9 -28.6 <NA>
1 002824BE9=1M -42.3 -42.3
2 002824BE9= -28.6 -29.0,
[{'code': 251658243,
'col': 2,
'message': "'The record could not be found' for the instrument '002824BE9'",
'row': 0}])The results for instrument 002824BE9= (currently they are OAS_BID = -29.0) requested via API and via desktop, please observe on the screenshot from my testing are the same, we can verify the field used by the template by hovering over the field value:
From what I see, the three mentioned instruments are different, and in my understanding you would like to find out the methodology for the calculation of the fields and the difference between the instruments.
This forum can be of most help with API usage, and our content experts can best help with insight into the content provided via API.
An Eikon support content ticket #11838641 has been opened on your behalf, please expect our content experts to reach out to you shortly via email.
Hope that this helps
0
Answers
-
Hello @jgarden
I checked case 11838641. The case is closed with the following answer from the Content support team.
The difference between the similar instruments:'002824BE9','002824BE9=1M','002824BE9=' '002824BE9','002824BE9=1M','002824BE9='. Different code may use different source/contributor
for ex. RIC <002824BE9=1M'> is sourced from MARKETAXESS while 002824BE9= is the composite RIC which is mainly source from Eval Pricing
002824BE9 is the CUSIP.... since client is retrieving pricing data (not T&C data), it will retrieve it from the default/preferred RIC for this instrument which is typically the composite RIC
The methodology used in calculation of fields: 'TR.OASAnalytics', 'TR.FiOptionAdjustedSpread', 'TR.OPTIONADJUSTEDSPREADBID', 'OAS_BID' for these instruments. OAS_BID is the real time field on Quote. this is FID 3712. refer to STR/OAS as this is on Quote, the calculation depends on the RIC used
TR.OPTIONADJUSTEDSPREADBID - this is a time series data item which practically stores the eod snap of OAS_BID
TR.FiOptionAdjustedSpread - this is the OAS calculated on the REPS Valuation tab - essentially uses RRPS price
TR.OASAnalytics - based from Adfin Function - typically gets the same value as bond calculator. depended on the contributed MID price.0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛