Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by sdittmar · Apr 07, 2020 at 07:54 PM · eikoneikon-com-apidatavba

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"
1586328888429.png (2.7 KiB)
1586328901544.png (5.9 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Jirapongse · Apr 09, 2020 at 01:45 AM

@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)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
sdittmar · Apr 24, 2020 at 09:34 AM 0
Share

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

avatar image
Answer by sdittmar · Apr 28, 2020 at 03:02 PM

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

VBA API - Fetch CF_CLOSE with DEX2 doesn't work

Using COM API in VBA code, suddenly cannot connect to Eikon Desktop

How to get Gross Dividend Amount over a period in a Single value

VBA - Run and update TR Eikon data

Excel chain

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges