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"