Last 5 Trades in Trade Reporting Data Model (MP)
I need to read as consumer application some information about last 5 trades. In detail I need to have Last Price, Last Qty, and Trade Time.
For the Last Price and Trade Time, I am using respectively fields: TRDPRC_1 to TRDPRC_5 and SALTIM_NS to SALTIM5_NS.
For Last Qty I mean the "Quantity (e.g. shares) bought/sold on this (last) fill.". Which field I could use for this information?
Best Answer
-
I think there is a misunderstanding for what you are after. Is it simply the number of shares that have been traded at the price in TRDPRC_1? In which case the field is TRDVOL_1 (178) and it is available in Market Price. If you are looking to see where this came from or how the execution happen - was it hit by the BID or ASK side for example) , very few exchanges provide this info with the trade message so you would have to have a side-by-side analysis of the top of the orderbook. You could potentially do this by looking at the BID and BIDSIZE and ASK and ASKSIZE fields retrospectively to see the quantities prior to the trade execution. There would be a bit of noise around that too (ie cancelled orders, new prices etc coming in as well as trade executions occuring to remove quantity).
In the level 2 information (ie Market-by-price or Market-by-order - or in some rare case Market-by-market maker!) you will only get the orderbook information so no post trade data. But this would give you a better idea of what was occuring as you would not only see the top of book.
0
Answers
-
Hello @cdefusco,
To my best knowledge, from most exchanges, this information is not available as part of Market Price, MP, model. There is a chance that there are some exceptions.
From Market By Order, level 2, this content is available.
Alternatively, from a history product, such as Tick History, it can be extracted.
However, for content questions such as this, by far the best resource is Refinitiv Content Helpdesk , by creating a query and specifying Content -> Elektron, you will be able to get a definitive answer on Elektron content, that can be accessed by APIs, including EMA.
0 -
I dont think last trade's volume information is available from Market By Order messages, unless you subscribe to updates and consolidate the information yourself. Please contact Refinitiv content support as mentioned by Zoya.
0 -
Yes, ORDER_SIZE for already executed orders, which have disappeared from the book.
0
Categories
- All Categories
- 6 AHS
- 37 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 中文论坛