Hi,
I have a ek.get_data() script, and it's returning different values for the same data item for the same trading day if I specify a date range, but it's fine if I only specify one day in the same script:
df_ric_ts, err_ric_ts = ek.get_data(['AIBGY.PK'], ['TR.PriceClose.date; TR.PriceClose; TR.TotalReturnYTD; TR.TotalReturnMTD; ' 'TR.TotalReturnQTD; TR.TotalReturn6Mo, TR.CompanyMarketCap; TR.PE; TR.PriceToBVPerShare; ' 'TR.PriceToTangBVPerShare; ' 'TR.FwdPEG; TR.BasicNormalizedEps.date; TR.BasicNormalizedEPS; ' 'TR.LTDebtToTtlCapitalPct; TR.TtlDebtToTtlEquityPct'], {'SDate': '2023-03-01', 'EDate': '2023-02-15', 'CURN': 'USD', 'FRQ': 'D'})
The result of above script gives me below value:
It's a partial screenshot, but you can see, the return column and market cap column are all having different values for same day, 2/23, 2/21 and 2/13.
If I only specify one day like below for 2/23:
df_ric_ts, err_ric_ts = ek.get_data(['AIBGY.PK'], ['TR.PriceClose.date; TR.PriceClose; TR.TotalReturnYTD; TR.TotalReturnMTD; ' 'TR.TotalReturnQTD; TR.TotalReturn6Mo, TR.CompanyMarketCap; TR.PE; TR.PriceToBVPerShare; ' 'TR.PriceToTangBVPerShare; ' 'TR.FwdPEG; TR.BasicNormalizedEps.date; TR.BasicNormalizedEPS; ' 'TR.LTDebtToTtlCapitalPct; TR.TtlDebtToTtlEquityPct'], {'SDate': '2023-02-23', 'EDate': '2023-02-23', 'CURN': 'USD', 'FRQ': 'D'}) print(df_ric_ts)
Below is the result:
Why is that?
Plus I have asked this to the helpdesk/support team, and they recommend me here to ask this question. Thank you.