question

Upvotes
Accepted
38 2 1 4

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:

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"
eikoneikon-com-apidatavba
1586328888429.png (2.7 KiB)
1586328901544.png (5.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
38.1k 71 35 53

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


1586396702642.png (7.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

This does not answer my question above and the whole purpose of an open forum is to share the solution.

Upvotes
38 2 1 4

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea