getting TR.LastObservationDate in results for rd.discovery.search
i am searching for economic indicator via above search and want to get the same fields i would get in the workspace. for example the field TR.LastObservationDate, which seems impossible to get in the result data.
this is my attempt:
search = rd.discovery.search(
view = rd.discovery.Views.INDICATOR_QUOTES,
filter = "( SearchAllCategoryv2 eq 'Economic Indicators')",
select = "DTSubjectName,SourceName ,RIC,RCSCountryOfIndicator ,StartDate,SearchAllCategoryv2 ,Unit ,SearchAllCategory,RCSCountryOfIndicatorLeaf,SourceName,StartDate,RCSIndicatorType,Unit,AdjustmentFactor,RealtimeRIC, TR.LastObservationDate")
some fields work, some dont:
i asked via the helpdesk but the sent me in here (which i dont understand, why cant they provide support via ticket?), so i'd appreciate your help.
thank you.
Best Answer
-
Hi @andreas01 ,
The 'TR.LastObservationDate' is not available as a metadata for the search function, to see all available metadata, the code below can be used
import refinitiv.data as rd
from refinitiv.data.content import search
rd.open_session()
response = search.metadata.Definition(
view = search.Views.INDICATOR_QUOTES
).get_data()
response.data.dfFrom this, I found the metadata named 'ObservationDate' and the data is returned as below, is this what you're looking for?
search = rd.discovery.search(
view = rd.discovery.Views.INDICATOR_QUOTES,
filter = "( SearchAllCategoryv2 eq 'Economic Indicators')",
select = "DTSubjectName,SourceName ,RIC,RCSCountryOfIndicator ,StartDate,SearchAllCategoryv2 ,Unit ,SearchAllCategory,RCSCountryOfIndicatorLeaf,SourceName,StartDate,RCSIndicatorType,Unit,AdjustmentFactor,RealtimeRIC, ObservationDate")For the detail regarding using search function, you could check these articles: Building Search into your Application Workflow and Build queries easily using Refinitiv's Search API with Python and Jupyter
Hope this helps and please let me know in case you have any further questions.
1
Answers
-
i think i found it with a suggested post (funnily enough, i searched the hell out of it before posting and didnt come up with anything)
with that said, there seems to be a bug with the NextReleaseDate:
it shows the wrong date
why?
0 -
doublechecked it with the workstation, it looks correct in there, just not via api
0 -
Hi @raksina.samasiri , thank you for this. i found the Observation date but your code looks very valuable for any further enquiries.
have you seen the issue with the next release date? maybe you have an idea about this?
0 -
Hi @andreas01 ,
You're welcome. Regarding the next release date issue, as this forum is dedicated to an API usage
question, the moderators on this forum do not have deep expertise in
every type of content available through Refinitiv products. Such expertise is
available through Refinitiv Helpdesk, which can be reached via MyRefinitiv. To be of help, ticket number 13181403 was raised on your
behalf and the support team is going to contact you directly to clarify this.1 -
thank you @raksina.samasiri , this is very much appreciated!
0 -
You're welcome @andreas01 , I'm happy to help.
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 中文论坛