You can do it in Excel, you can do it in Python - as long as the data stays on your desktop :)

Are you looking for current active Danish stocks or also for stocks that are already 'dead'? I am guessing for the latter one - if you include the data of the dead ones, you will account for the survivorship bias. Also, do you have a specific list of Danish stocks (based on certain criteria) in mind or the OMX Copenhagen? Datastream would definitely work best to include the data of 'dead' series.

https://developers.refinitiv.com/en/api-catalog/eikon/datastream-web-service/qa

Thanks for the answer!
I want to make sure what you mean by the first part - is it a license thing that the data must only be used on the machine that has access?
You are right, I am interested in avoiding survivorship bias as much as possible. Ideally, I would like to select some data and then have all returned all stocks that are or have been in existence since that given date. But maybe that's not possible? In that case, should I somehow acquire a list of stocks in existence at the beginning date? If that is the case I guess I might miss companies that had a later IPO and then delisted.

I especially want to look at small and medium cap danish stocks. But again, ideally I would like to have data on all stocks and then later filter - to enable me to analyze for instance momentum as a function of market cap.

Yep - licensing. Though I assume you need it solely for research purpose, so you seem covered. Up to you how you retrieve data.

Why I was asking - because in Datastream you can look up indices and its historical constituents. Best to use OMXC - LCOSEASH (about 134 constituents). Of that index, you can retrieve the constituents of any month by using LCOSEASH0118 (logic is LCOSEASHMMYY) for example. So, not only you can retrieve the constituents as of a particular date, but also the changes in between. Hope this helps!

Thanks again for the answer. I am moving towards an idea of how to approach this - I have an okay experience level with Excel, but none with Eikon.

It seems like a primitive way to go at it then could be checking when the list of constituents changes, something like this:

LCOSEASHMMYY-LCOSEASHMMYY

I assume it returns a list and I can then step forward the date in the first term and see when something gets delisted. Then I can call the data I need for the initial list of constituents from beginning of test period until first change. Then repeat this until next change.
I would then only need to put it together, so that each equity forms a timeseries through all the time it is listed.
But maybe there is something way simpler.

I have looked around a lot, and there are some tutorials for simple things like downloading data for one stock. But I haven't found much about setting up a proper dataset and avoiding survivorship bias etc - thus all my questions here.

You can get the list of joiners and leavers for the OMX Copenhagen Stock Exchange's All-Share Index for the last 10 years using

=TR(".OMXCPI","TR.IndexJLConstituentChangeDate;TR.IndexJLConstituentName;TR.IndexJLConstituentRIC;TR.IndexJLConstituentComName","EDate=-10Y CH=Fd")

Hello,
I'm a student at Clarke University - Business Adminidtration major and I need to backtest a strategy on the Norwegian stockmarket for my project. How can I create a dataset of numerous agencies arranged by financials, ratios, etc.? I'm also confused about an automatic data transfer. So that I could transfer the information easily between my SQL-database and the Reuters Eikon Monitor App.

___________
Issues with an automatic data trasfer creating a dataset in Excel for a project writemyessay

Hi Deifell

Did you figure out a solution and get on with your project?