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 antonio.turi · Oct 28, 2016 at 08:51 AM · apiexcelvbaequityfundamental

Downloading fundamental stocks data using API in VBA

example.jpg Hi, we would like to use the function TR in an API Excel application in order to download some fundamental data (e.g. net income, EPS estimates, prices and valuation multiples) for a sample of stocks (e.g. the constituents of the Stoxx Europe 600 index). We are able to do this via a Request tables as in the attached jpeg. How can we replicate something similar using TR (or anything else)? Specifically, we are not able to find the data fields matching the datatypes specified in the request table. Do you have a list of data fields usable in TR?
example.jpg (104.3 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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Nov 01, 2016 at 06:03 PM

Hi @antonio.turi

If you'd like to retrieve fundamental data into Excel VBA, then please visit the link below. This is where you can find documentation, examples and tutorials for Eikon COM APIs for use in Microsoft Office.

https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office

The best way to explore the field names and parameters you can use to retrieve data through =TR function is by following Formula Builder wizard in Eikon Excel. In Thomson Reuters ribbon click on the leftmost button named Build Formula and follow the prompts. Once you've completed the wizard and are happy with the data retrieved into Excel worksheet by =TR function, the syntax used in =TR function is fairly straightforward to translate into syntax required for DEX2 COM library. If you need help with using Formula Builder wizard or =TR function, I would suggest you call your local Thomson Reuters Helpdesk. The Helpdesk representative can guide you through the wizard and =TR function.

Finally, I'm not sure what was the significance of the screenshot you included, but I'm afraid I have no idea what it illustrates. I cannot even tell what application this is. If you need assistance with whatever that screenshot represents, please elaborate on how you created this image.

Best regards,

Alex

Comment
zoya.farberov
Zhenya Kovalyov

People who like this

2 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 >
8 People are following this question.

Related Questions

How do I trigger a VBA macro from within the TR function in Eikon Excel

Excel chain

Cant call Adfin bond function 'BdCashFlows' from VBA

Corporate Action Excel getting wrong data

RFA Exception Handler - Access Violation / Excel Vba Eikon

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges