When I load some quarterly fundamental data (Siemens has a Sept year end) using the following code:
With MyDex2RData .InstrumentIDList = "SIEGn.DE" .FieldList = "TR.Revenue" .RequestParam = "Sdate:20180930 Edate:20190930 Period:FQ1 Frq:FQ scale:6" .DisplayParam = "RH:date CH:Fd Transpose:Y" .Subscribe False End With
I receive the following expected response:
Now, if I add two data fields (replacing one line in the above code):
.FieldList = "TR.Revenue;TR.TotalCashDividendsPaid;TR.CashDividendsPaid"
the response is unexpected:
Why do I receive an additional (empty) column that is also outside the chronological order?
In fact it gets even messier, when you move the time slot by three quarters backwards:
.RequestParam = "Sdate:20171231 Edate:20181231 Period:FQ1 Frq:FQ scale:6"
You can contact the Eikon support team via MyRefitiv and ask for the request parameters for the TR function in Eikon Excel used to get the required information. Then, you can apply the request parameters to DEX2.
The problem was caused by a data issue that was resolved for the years 2018 + 2019 through a different customer service inquiry. Not sure why the person did not fix the other years as well...
If you replace 2018 + 2019 with 2016 + 2017 you could still get the funky behavior...