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.
interactive brokers portfolioanalyst, check for “parsed” data (with known to them funds expanded into constituents)
but frankly as the big companies dominating the indexes today are giant transnationals, attributing them to a single county by primary stock listing strikes me as a pointless ordeal. for example nestle only makes 1-2% revenue in CH. do you really want to attribute it to CH? dont make me laugh
Thx for the tool recommendation, but I dont have my portfolio at IB and dont plan anytime soon
I see your point with giant transnational companies and global revenues, but consider for a second that not everyones Portfolio is heavely loaded on large caps
You could still parse it so it’s a nice graph. Maybe if you do it on Google Sheets it could become a nice thing that you could easily share with everyone.
I think i will do it with vba, atleast step 2 and 3. I am not particularly a fan of Google Sheets. I prefer to hold my Portfolio Tracker offline, as long as I have my Office 365 Subscription, but I could share the script for the macro here, once I am done.
By reading and partipating to this forum, you confirm you have read and agree with the disclaimer presented on http://www.mustachianpost.com/
Durch das Lesen und die Teilnahme an diesem Forum bestätigst du, dass du den auf http://www.mustachianpost.com/de/ dargestellten Haftungsausschluss gelesen hast und damit einverstanden bist.