hi @Eikon10 ,

Here's the information from my colleague.

the IBES daily data in DFO excel will be replaced by the monthly data each month. If the user really wants to have the daily data, I would suggest he either download the figures on a daily basis and save it in their local drive. Or they can use the Eikon excel addin. It keeps the daily figures. Below is an example of the Excel formula file for reference. Hope it helps.

Datastream formula used

=@Thomson.Reuters.AFOSpreadSheetFormulas.DSGRID("D:DBK","EBT1MN;EBT1D","-2Y","","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")

Eikon formula used

=@TR("DBKGn.DE","TR.EBITMean","SDate=-2Y EDate=-0D CH=IN;Fd RH=calcdate")

Which can be converted to Python code with Eikon Data API as

import eikon as ek

ek.set_app_key('### YOUR VALID APP KEY ###')

df, err = ek.get_data(instruments = 'DBKGn.DE'
                      , fields = ['TR.EBITMean.calcdate', 'TR.EBITMean']
                      , parameters = { 'SDate': '-2Y', 'EDate': '-0D'})
df

@Eikon10

You can contact the Refinitiv Datastream Web Service support team directly via MyRefinitv to verify the retrieved data.

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.

Hi,

I tried this in first place. Unfortunately, they were not able to help me.

For reference, here's an answer provided by the support team in the case raised

We made a follow-up with our specialists and we were advised that 
The client can pull daily data and store this. However, this is overwritten by the weekly & monthly values. So we are unable to provide the history on a daily basis because of the reasons mentioned.

Plus, more information from the IBES user guide on my Refiniv are below
Update frequency I/B/E/S monthly values are updated at the latest by close of business (EST) on the Thursday following the third Friday of the month. The monthly update overwrites all previous monthly values and adds the latest month’s values. The monthly update is a snapshot taken on the Thursday preceding the third Friday of every month at close of business in New York

Weekly and daily updates are available but note that only a small proportion of stocks will have a change on any given day. All stocks will have a value applied on a weekly basis, based on Thursday data. Daily updates are available only if there was a change made to one of its values (other than price) on the previous day. If no change has been made, the latest data available will be for the previous Thursday. No history of weekly or daily updates is available. The I/B/E/S database is updated the next business day by approximately 0900 hrs GMT. Weekly data is updated over the weekend, available to view on Datastream on the Monday.