Hello everyone,
I've noticed that for some TR formulas, some values are consistently being repeated, but I'd like to know the criteria (if possible of course) to choose which dates to repeat.
I'll use as example the following code, that produces the data in the screenshot:
import eikon as ek
ek.set_app_id('xxxxxx')
out2 = ek.get_data(['AA.N'], ['TR.FCFMean', 'TR.FCFMean.date'],{'SDate':'-24M','EDate':'-10M','Frq':'M','Curn':'USD', 'Period':'FY1'})
print(out2)
captura.jpg
Same thing in Excel, notice the repeated dates on the end.
My assumption is that, to fill the vacant slot of data for this company, it just repeats one of the values to complete the request. The same happens for other companies, but other dates are repeated, such is the case for companies like AAN.N.
How can we understand better this behavior? Would using .calcDate instead of date solve this more properly?
Thanks in advance.
