Historical quarterly fundamentals with DEX2 - unexpected result

sdittmar

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"

Jirapongse

@sdittmar

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.