Hey guys I am collecting ideas for an implementation of a tool, that:
automatically downloads monthly factsheets publications from index providers (MSCI/FTSE)
gets from the monthly factsheet the actual country weights
copy the weights into my excel sheet
Step 1. is optional, since I dont know if its even possible as private person without a subscription to the services of the index provider. Any suggestions in which language to write the tool if the end destination is excel. Direct import through excel results in a formatting nightmare so far.