How to create a list of German Companies with historical data?

andrea.sattelmayer

Hello,

I am wiriting my Master's thesis and I have not worked with Thomson Reuters before. I need a list of German Companies with historical data about the last four years. I need German Companies without Financial sector wich have a number of employees greather than 1,000. I also need the dept/equity index, revenue and net profit/loss of these companies.

I tried it with Eikon but I do not get historical data in a list with all companies. I only get the data of the last year. I also tried it with Excel tool but without the know-how I do not know how to put the right codes in it.

Hope you can help me.

Thanks for your support! BR, Andrea

Alex Putkov.1

I advise you to call Thomson Reuters Helpdesk in your country and ask how you can retrieve the data you're after into Excel. Product support specialist will guide you through retrieving the data you're after using Eikon Excel add-in. And then if you're interested in retrieving the same data programmatically, you'll have a much better idea about the metadata you need to use. You can also refer to API tutorials available on this portal for examples of how to retrieve similar datasets. And of course if you have any specific questions about Eikon APIs, feel free to use this Q&A forum to have them answered.

woodbury

Hello,
I need a list of Estonian companies with the historical data for the period of 8 years. How can I possibly create such a list with Eikon Excel add-ins?

Checked the topics: Full list of companies with active stocks in

questions/39355/listing-active-and-inactive-stocks-over-a-period.html
questions/71238/how-can-i-call-a-full-list-of-companies-listed-in.html

Alex Putkov.1

@woodbury

When asking a new question, always start a new thread. Old threads are not monitored by forum moderators. If you need to reference an old thread, include a link to it in your post.
To answer your question, please see the article titled "Find Your Right Companies with SCREENER".