Joined
·
701 Posts
I'm working at converting over to a passive ETF index portfolio, and if I choose to go with US-traded funds for US and international equities (Vanguard's VTI/VEA/VWO for instance) instead of the currency-neutral Canadian offerings, I'll have a need to purchase a large chunk of $US-denominated stuff in my RRSP. The wonder that is the internet alerted me to Norbert's Gambit, which might be useful in saving the normal currency conversion costs. I whipped up an online calculator to try and get some sense of the savings:
http://www.northernraven.ca/financial/NGcalculator.php
You can enter an amount, your trading commission, and choose from a range of currency conversion spreads that you might otherwise experience. For a number of inter-listed stocks, it will choose the whole number of shares closest to your chosen amount at the Toronto exchange Ask price, and calculate the $USD realized by selling at the US exchange Bid price. The "Savings" column will show the difference from what purchasing the same amount of $USD at the current rate plus the spread you chose, minus twice the commission amount.
The output is quite ugly as I whipped this up fairly quickly yesterday, and needed to see a bunch of intermediate calculations, but I'd love to get feedback on the basic calculation method, or if there are other stocks that people like to use for this. The quotes are coming from Yahoo Finance, although I have to look into the details of what they are providing. The results go goofy outside of normal trading hours, as the bid-ask numbers are very wide.
http://www.northernraven.ca/financial/NGcalculator.php
You can enter an amount, your trading commission, and choose from a range of currency conversion spreads that you might otherwise experience. For a number of inter-listed stocks, it will choose the whole number of shares closest to your chosen amount at the Toronto exchange Ask price, and calculate the $USD realized by selling at the US exchange Bid price. The "Savings" column will show the difference from what purchasing the same amount of $USD at the current rate plus the spread you chose, minus twice the commission amount.
The output is quite ugly as I whipped this up fairly quickly yesterday, and needed to see a bunch of intermediate calculations, but I'd love to get feedback on the basic calculation method, or if there are other stocks that people like to use for this. The quotes are coming from Yahoo Finance, although I have to look into the details of what they are providing. The results go goofy outside of normal trading hours, as the bid-ask numbers are very wide.