Downloading fundamental stocks data using API in VBA

Question

Question by antonio.turi · Oct 28, 2016 at 08:51 AM · eikon eikon-com-api api excel vba equities fundamentals

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)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2016-11-01T18:03:15Z

REFINITIV

Best Answer

Answer by Alex Putkov.1 · 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

2 · Share

10 |1500 characters needed characters left characters exceeded

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

Downloading fundamental stocks data using API in VBA

1 Reply

Watch this question

Related Questions