Hi, I try downloading historical market cap values for some companies. I noticed when the start_date is before the first trading date, all data seems to be incorrect. For examples:
import_symbols ="AAC.N" start_date = "20141001" end_date="20141006" field_name = "TR.COMPANYMARKETCAP" df_a, error = eikon.get_data(import_symbols, [field_name, field_name + ".DATE"], {"SDate": start_date, "EDate": end_date}, field_name=True) df_a
The output is:
While if I use the following code:
import_symbols ="AAC.N" start_date = "20141002" end_date="20141006" field_name = "TR.COMPANYMARKETCAP" df_a, error = eikon.get_data(import_symbols, [field_name, field_name + ".DATE"], {"SDate": start_date, "EDate": end_date}, field_name=True) df_a
The output is as follows:
I think this applies to more columns than just market cap.
I assume the latter is correct? What would be the best way to get the correct data?