differences between refinitv data and quarterly report

Hello, I'm using the following function to download oil production data and other variables. I’ve noticed that sometimes Q4 information is missing, or it differs significantly from the quarterly reports. Could you please explain how I can fix or reconcile these differences?

import refinitiv.data as dl

fundamental_and_reference.Definition( universe = tickers_list, fields = ["TR.F.CrudeOilProdPerDayAvgTot.Date", "TR.F.TotRevenue", "TR.F.NatGasProdPerDayAvgTot", "TR.F.CrudeOilProdPerDayAvgTot", "TR.F.OpExpnTot", "TR.F.SGATot", "TR.F.InvstLT", "TR.F.DeprInCOGS","TR.F.CashCashEquivTot","TR.F.DebtTot","TR.F.ComShrOutsTot"], parameters = {"SDate": "2005-01-01", "EDate": "0", "FRQ": "FQ", "Period": "FQ0"}, extended_params = {"output":"Col,T|Va,Row,In,DATE|"}).get_data()

Find more posts tagged with

python

commodities

#content

lseg-data-library

Accepted answers

All comments

Jirapongse

@lladamartin

Thank you for reaching out to us.

Please provide sample instruments and the corresponding output that triggered this issue.

Are you using the desktop.workspace session or the platform.ldp (Data Platform) session?

lladamartin

Thanks
The figure shows the daily crude oil production time series for Exxon Mobil Corp (XOM.N). The drops and missing data correspond to the fourth quarter. The data come from fundamental_and_reference() function.

Jirapongse

@lladamartin

I checked the data by running the following formula in the Workspace Space.

=@RDP.Data("XOM.N","TR.F.CrudeOilProdPerDayAvgTot.date;TR.F.CrudeOilProdPerDayAvgTot","SDate=2005-01-01 EDate=0 Frq=FQ Period=FQ0 CH=Fd RH=IN",B2)

I found the NULL data on 12/31/2014 and 12/31/2015.

This could be a content issue. Please contact the helpdesk support team directly via LSEG Support to verify the content.

Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.

EXPLORE OUR SITES