el_mysterito
New Member
- Joined
- Jun 9, 2015
- Messages
- 2
Hello, dear community members.
My goal is to export Net Asset Value (NAV) data of the funds listed on this particular website (Price development (NAV) EN) to Excel so that I could make the data to update automatically.
Unfortunately, I cannot retrieve the required data successfully. If I choose to display the data in the form of a table, Excel > Data > From Web function does not recognize that table. If I create .iqy file containing the link to .xlsx file with NAVs (http://www.danskeinvest.fi/web/show...2015&p_vFormat=XLSX&p_vType=DAG&p_vFelter=IV;) and use Excel > Data > Existing Connections, I import nothing more than "PK" and some symbols.
Therefore, some questions arise. Why don't those methods presented above work? Is there any other way to achieve the desired goal?
I really do hope that someone can shed some light on the problem. Any help will be greatly appreciated.
Thank you all in advance.
Kind Regards,
el_mysterito
My goal is to export Net Asset Value (NAV) data of the funds listed on this particular website (Price development (NAV) EN) to Excel so that I could make the data to update automatically.
Unfortunately, I cannot retrieve the required data successfully. If I choose to display the data in the form of a table, Excel > Data > From Web function does not recognize that table. If I create .iqy file containing the link to .xlsx file with NAVs (http://www.danskeinvest.fi/web/show...2015&p_vFormat=XLSX&p_vType=DAG&p_vFelter=IV;) and use Excel > Data > Existing Connections, I import nothing more than "PK" and some symbols.
Therefore, some questions arise. Why don't those methods presented above work? Is there any other way to achieve the desired goal?
I really do hope that someone can shed some light on the problem. Any help will be greatly appreciated.
Thank you all in advance.
Kind Regards,
el_mysterito
Last edited: