How to get above data for RIC MDLZ.OQ in Codebook (see attachment). Can this be solved?
Hi @KaranSubramani05, Thank you for reaching out!
The fields are right, but the parameters used doesn't hit the right timeframe, so it brings in no data. While this is a content related question and I would recommend contacting LSEG Support, I would run the below code to check for what timeframe data is available to get an idea and then apply the parameters (those in the brackets in each field).
import lseg.data as ld ld.open_session() ld.get_history( universe=['MDLZ.OQ'], fields=['TR.F.TotRevenue.date','TR.F.TotRevenue.value','TR.F.TotRevBizActiv'], start='2020-01-01', #I have chosen any random date end='2026-06-01', #I have chosen any random date interval='1D' #This is important. 1D would bring data at the most granular period & I can see the pattern. ) ld.close_session()
The output of the above shows that data is available for the last of December only. Thus, FQ0 parameter didn't pull anything.
Please let me know if this helps. Thanks : )
Hi @ujjawal_khandelwal Client has a follow up and below is the query please assist Query This does not make sense. MDLZ.OQ returns the correct results (2026-03-31) for field TR.F.OPPROFBEFNONRECURINCEXPN (see first attachment).
What’s more, MDLZ.OQ has filed its latest 10-Q data for 2026-03-31 on 2026-04-28 (see second attachment).
Is there therefore a content problem for the mentioned RIC from your side?
@KaranSubramani05
This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.
The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.
You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code. You can also refer to the How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.
Hi @KaranSubramani05, My intent was not to determine whether the field is ultimately the correct one for your analytical requirement, but rather to demonstrate how to validate data availability and granularity for the fields used in your query. In your original call, the fields themselves are syntactically valid, and this is why they return NaT rather than an error. By adjusting the parameters and checking the full historical range, we can see that data does exist for these fields, but only for specific finalized reporting periods. Whether TR.F.TotRevenue or TR.F.TotRevBizActiv is the appropriate field for your use case, or whether an alternative field should be used for the latest quarter, is a content definition question and would be best confirmed by LSEG Support.
TR.F.TotRevenue
TR.F.TotRevBizActiv
If you need help further, please let me know. Thanks : )
