Im writing a thesis where im going to backtest a strategy on the swedish stockmarket and have som problems to create my data set that i need with Eikon. I have tried for 4 days without success and would be very thankful if someone could help me with the codes i need.
The data i need i following:
1. Priceindex, for OMXSPI, Annual & Mounthly, (could be in different spreadsheets) for 20 years back in time until today
2.The same for all stocks on the swedish stockmarket.
3. Fundamentals for all stocks on the swedish stockmarket, mounthly basis, 20 years back in time until today. The fundamentals i need i following;
Return on invested capital,
Pay out ratio.
I would be very thankful if some one could help me with the codes i need to export this data from Eikon into excell.