Possible bid/ask mismatch?
Hi,
Currently, we are seeing a fairly high percentage of bonds where 'bid price > ask price', and subsequently bid yield < ask yield in our data.
As this is unexpected and likely due to the way data is feeding in to our system, we are unable to determine how to resolve it (ex: in 2014 10% of the bonds had this issue, which is far more than expected.)
I've provided a sample of data we have where bid price > ask price for the company Goldman Sachs below.
We are using the get_data function with the 'Frq' parameter set to 'D' for daily to get this data, and we are wondering why we might be noticing this issue with our data?
We suspect that it might be possible since we are getting daily data, it be that there is a mismatch and we are getting data from different hours (i.e. our ask price value may be from a different hour than bid price when we're getting this data)
Best Answer
-
Hi @kevin.guo
I can see the same behavior using this code:
df,err = ek.get_data('CA44810ZBF6=',['TR.ASKYIELD.Date','TR.ASKYIELD','TR.BIDYIELD','TR.ASKPRICE','TR.BIDPRICE'],
{'SDate':'20160101','EDate':'20200626','Frq':'D'})
df.dropna(inplace=True)
result_df = df.loc[df['Ask Price'] < df['Bid Price']]
result_dfHowever, the result is the same as Eikon Excel.
This is Eikon Excel formula:
=@TR("CA44810ZBF6=","TR.ASKPRICE.Date;TR.ASKPRICE;TR.BIDPRICE","SDate=20160101 EDate=20200630 CH=Fd RH=IN",E2)
This is the content question as why ASK PRICE is less then BID PRICE.
I raised ticket number 08896233 on your behalf to Refinitiv Content Helpdesk.
Helpdesk will contact you directly.
0
Answers
-
Hi @kevin.guo,
In the realtime tick-by-tick feed, bid is always less than ask. When these quotes are quantized into buckets, i.e. bars are generated from it, be it minute, hourly, daily bars, usually high/low/average of the bars is a representation of what happened in that interval. This can lead to data behavior that you see here.
If it is important for your application, maybe you should use tick-by-tick data - which is available from Refinitiv Tick History product.
1 -
hi @Gurpreet.,
so I checked with another one of our developers and I don't think this is the reason why our issue is occuring.
for this hydro one bond, isin: CA44810ZBF68, on 2020-06-16, our bid price matches 23:00 and ask price matches 21:00.
However they are neither the high nor low value for that day, and mathematically it would not make sense for an average of the bid prices for the day to be greater than an average of ask prices for the day, since at any given time instance it should be the case that ask price >= bid price.0 -
Hi @kevin.guo
I saw that you have a ticket number 08888894 opened.
The ticket number 08896233 will be closed as it is duplicated to the previous one.
I have asked the helpdesk to find an appropriate group to take care of the ticket 08888894.
Thanks.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 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
- 370 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛