Historical quarterly fundamentals with DEX2 - unexpected result

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:

image

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:

image

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"

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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.

    image

Answers