why so slow bro?

should open it earlier

We're still waiting...

Will do it soon ... got sidetracked making another spdreadsheet for keeping track of my own portfolio, never realised there were so mantly google finance features built into Sheets

next week!

https://docs.google.com/spreadsheets/d/142S...dit?usp=sharing

Hopefully that's correct, need to double check through the formulas.

There seems to be some issues with the GOOGLEFINANCE features, sometimes a few of them don't load up but work after refresh.

Formula looks okay except:
1. Withholding tax for VUSD is 15% not 0% I believe.
2. IB's cost for US denominated stocks on LSE is 0.05% trade value / min. order $5 ($10,000 value). So it should be Qty (-5) & Cost (+5) in the formulas.
3. For those who have not build up to $100k, the trading cost on this platform is exactly $10 every month.
4. For DRIPS, can it reinvest less than 1 stock? My take is that if you're consistently adding to the fund, dividends collected will simply be rolled into the next BUY event anyway.

I re-did the calculations using criteria (1) & (3) above, my results are:
ROI VUSD 9.68% vs VOO 8.83% (0.85% difference)
VUSD $342.71 extra

This post has been edited by ferox: Apr 27 2015, 02:27 PM

1. VUSD Witholding taxes are already settled in the ETF, not deducted after payout. So there's no extra 15% to be deducted
2. You're right, I was going with £6 / trade which I put at $9, so it's actually $4 / less per trade.
3. I didn't include the platform fee

A quick recalculation:
ROI VUSD 9.74% vs VOO 8.83% (0.91% difference)
VUSD $363.64 extra

So.. IB buying LSE stocks it is?

For buy and hold they're a better option - of course if amounts are smaller the trading costs become more of a factor.

For active trading not so much - less liquid and higher spreads!

I mostly buy and hold, hardly actively trade at all.

What about withholding tax on dividends?


This post has been edited by wodenus: Apr 27 2015, 03:06 PM

Taxed at 15% rather than 30%, the reported dividends already account for the 15% deduction as far as I'm aware.

Double checked last VUSD payout



No additional WT, the 15% is already withheld in the ETF - same as if you were holding feeder fund through FSM as example

This post has been edited by rjb123: Apr 27 2015, 03:18 PM

Ok so you buy the VUSD on the LSE.. so you only get charged 15%.. cool yea let us know

Yup, edited previous post already and confirmed with last dividend payout in March

Hi everyone,

What are your thoughts on CIMB FTSE ASEAN 40?

They dont have vast experience on this..

bloomberg now showing usd/rm 3.6132.
last week 3.55-3.56 wud be nice!
i m late too!

almost there.

As of Friday Maybank are only giving 3.5100 but I've got bills to pay unfortunately

maybank sell 3.61....

3.615... But I'm talking about USD to MYR, other way around.

what u got, 3.51 usd->myr, is about right on fri.

maybe mbb spread a little worse but when i checked cimb on thu, i was told 3.53.

3.6132 myr->usd is probably a derived rate at this time since rm is not traded during the holidays.
http://www.bloomberg.com/markets/currencies/asia-pacific/

This post has been edited by AVFAN: May 2 2015, 10:24 PM