'get_data' returns different results when 'end date' is not specified
Please take a look at the following two requests. First:
df1, err =eikon.get_data('CRH.L', ["TR.CAEffectiveDate","TR.CAAdjustmentFactor"],{"SDate":"20030101","EDate":"20180520", "Scale": 6,"FRQ": "D"})
The output is:
Second, when leaving the 'end date' out:
df2, err=eikon.get_data('CRH.L', ["TR.CAEffectiveDate","TR.CAAdjustmentFactor"],{"SDate":"20030101","Scale": 6,"FRQ": "D"})
The output is:
The second one is completely different and not correct. Can this be fixed please? Thanks!
@Joris.Hoendervangers
I'm not convinced the result you got is unexpected. As far as I can see for capital change history when you specify only one of the SDate or EDate parameters the service interprets the SDate as the near date and EDate as the far date relative to today. So, when you only provide SDate the service returns the events that occurred prior to the SDate. And when you only provide EDate it returns the events that occurred since the EDate. In your example when you only provide SDate the service returned the only capital change event this stock had prior to 01-Jan-2003, which happened in 2001.
Thanks Alex. Changing SDate to EDate in the second request gives indeed the same output as the first request. I would think of 'start date' in calendar days rather than relative to today. Perhaps a bit confusing for some...