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.
Hi Mane0014. If you plan to export it to Excel have you tried creating it in Eikon for Excel? Use the 'Build Formula' wizard to add your instruments and fields. Eikon Search is available in the wizard so should help in finding what you need. As the output is a formula it is easily adjusted.
I find this a useful way of discovering the fields I plan to use with the COM APIs