Hi I am trying to read in historical company guidance data from Eikon, but am getting data and related date/timestamps that are either repeated or missing in some cases. I am not sure if this is because I am using the wrong formula and would ask for your help.
This is the code I am using to read in the historical guidance data:
Ticker = 'INTC.O'
start_date = '2010-01-01'
end_date = '2021-08-27'
#Get company Revenue guidance
fields = ["TR.GuidanceMeasure", "TR.GuidanceLowValue", \
"TR.GuidanceHighValue", "TR.GuidanceDate",
"TR.RevenueActSurprise"]
rev_guide_df, err = ek.get_data([Ticker], fields, \
{'GuidMeasure':'REV', "SDate":start_date, "EDate":end_date, "Period":"FQ1", "Frq":"FQ"})
The missing company guidance for certain days is somewhat understandable. it could be that the company did not provide one. I just wanted to check if that is how you format your data. But, what is less clear is why the dates are the same for a different set of guidance. Is it because the co. raised the guide? If that is the case, how can there be a "surprise" related to that number, if there was no reporting for the guide that was upgraded during the quarter. Can you please explain how to interpret the raw data output?
