Issues with TRTH intraday summaries for multiple symbols
TLT.O
- TLT.O does not have any data from 11/1/2011 – 2/1/2016, might
this be due to exchange listing change?
- We were told that TLT.O is the consolidated ticker, is that not
the case? If not, what’s the correct consolidated ticker. But this should be
transparent to us
.VIX
- Based upon the fields available, there is no field ‘Close’. Is
the field ‘Price’ equivalent to Close? The other ones that concern us are the
Open, High, Low
- In the GUI, there is no field called ‘Price’ as listed in the
csv you sent. However, there is a ‘Last’ field. Is that equivalent to
Price/Close?
- I created a new report for .VIX with the Timebar Persistence
unchecked. However the report still contains data outside the range specified
e.g. 08:31:00 (screen shot included) and ends before the time specified (15:14)vixissue1.jpgvixissue2jpg.png
Best Answer
-
If you want to extract data for only between 09:30 and 16:00 daily, you can select the 'TimeRangeMode': 'Window'.
Anyway, from my testing, you also need to change the 'Query Time Zone' to 'Local Exchange Time'.
0
Answers
-
Closing price
The "Last" field is the closing price.
Query date and time range
The start and end times do not apply daily, they apply as the initial (and final) points in time for the entire range of dates.
In other words, your query starts on the 1st November 2011 at 09:30, and ends on the 14th August at 16:00. All times in between are part of the range (i.e. from 2 Nov 2011 till 13 Aug 2019 the query covers the entire day. That is why you see data on 2 Nov 2011 at 08:31.
Timebar persistence
If it is not activated, you only get returned records for bars where there was some data. That is why there might be no bars in the specified datetime range.
Your other queries
Your queries are mainly data queries, in the GUI, not API queries. I attempted to answer what I could. This forum is aimed at software developers using Refinitiv APIs. The moderators on this forum do not have the required deep expertise in all the content sets available through our products to answer your question. For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via MyRefinitiv or to call the Refinitiv Help Desk directly. They will either have the answer for you right away, or will reach out to the content experts who can provide the answer you're looking for.
0 -
Thanks for the answers. Any update on why TLT.PO does not have any data from 11/1/2011 – 2/1/2016, might this be due to exchange listing change? How do I get data for TLT from 2011 onwards for 1-min bar?
0 -
I reran .VIX and I do get data within the range specified by updating the query using the above. However, why is the last print for .VIX is at 15:14?
0 -
As you did not activate Timebar persistence, you only got returned records for bar intervals where there was some source data; probably there was none after 15:14.
0 -
Since the market is open till 16:00, there should be data till 16:00. I am looking at Yahoo finance and can see data beyond 15:14. Can you confirm why there is no data for this period?
0 -
I have extracted raw data for .VIX RIC on Nov 1 2011. There was no data provided after 15:14 (GMT -5). This is related to content of this RIC. For more information, please open a content-related enquiry via MyRefinitiv or to call the Refinitiv Help Desk directly.
The timezone of timestamp in the following screenshot is GMT+0.
0 -
You can deduce from this that Yahoo Finance might be using a mechanism to persist timebars. This is usual, especially for charting.
If you want data for the entire period, then persist timebars and you will no longer have gaps.
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
- 688 Datastream
- 1.4K DSS
- 620 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 663 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
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛