Wrong data in Trade Date field
I queried for the fields Trade-Date and Quote-Date for time and sales data from TRTH. However the dates in these fields are just the timestamp fields and not the actual trade dates.
Best Answer
-
Refer Tick History Data Content Guide,Trade - Date and Quote - Date are local dates transmitted with the first on-market trade or quote message of the day, respectively.
The following is a result from time and sales extraction.
The Date-Time field at column D is timestamp. The Date field at column S is Quote - Date or Trade - Date.
If your result is different from this, please share your request and result.
0
Answers
-
Re: Trade - Date and Quote - Date are local dates transmitted with the first on-market trade or quote message of the day, respectively.
Can you please clarify "local dates"? Did you mean the local date where the exchange is located? If that's the case, can you please explain the following for me?
FBU is traded on the NZX, timezone GMT+12. Why is date-time stamp is 2021-07-02T11:03:53.897807187+12 (NZ time) but the trade date is 2021-07-01 (1 day before)? If trade date is supposed to be local, why is trade date not same as the date-time stamp?
0 -
The exchange time is still 23:03:54. However, please contact the Refinitiv Tick History support team directly via MyRefinitiv to clarify the definitions of those fields.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛
