Lazy to explain. But roarus asked something interesting here:



Stashaway said the costs of expense ratio/bid spread may outweigh the benefit of lower Withholding Tax.

True or false?

Data:

https://finance.yahoo.com/quote/VOO/history?p=VOO
https://finance.yahoo.com/quote/CSPX.L/history?p=CSPX.L

https://finance.yahoo.com/quote/QQQ/history?p=QQQ
https://finance.yahoo.com/quote/CNDX.L/history?p=CNDX.L

Methodology:

Same as previous thread using harmonic mean and geometric return.

But, I noticed something interesting. There were additional and missing data from both the US domiciled ETF and the ones listed at London Stock Exchange.
I suspect it's due to public holidays but let's find out using Google.





NOTE: 25 April 2011 is public holiday in London not in US.






NOTE: 25 Nov 2010 is public holiday in US not in London.

Total list of data removed:



IMPORTANT: Yahoo Finance does not give daily bid/ask spread data. I can only calculate which ETF gives better return. Since both track the same thing, their returns should be the same. Furthermore, bid/ask spread does not matter as everything will be 'equalled' out eventually as your transactions get higher and higher (i.e. n is very huge).

This is why I use harmonic mean. It's the same reason why there is little to low exchange rate risk when buying foreign ETFs because let's say MYR is weak and you buy less of USD ETF (1USD:MYR4.5). Some years, MYR grew stronger than USD (1USD:MYR3.5). Eventually your transactions will converge towards the harmonic mean. Possibly near 1 USD:MYR 4 depending on scenarios.

You may argue that you lose 'return' when you sell the ETF because you sell at a lower price compared to US domiciled ETF due to the wider bid/ask spread gap. This is bullshit because another person may argue that he/she has to buy at a higher price compared to US domiciled ETF due to bid/ask spread. Furthermore, some days you may queue at buy instead of buy from the seller. Some days you may buy immediately. Eventually everything will be evened out. Also, assuming efficient markets, there is unlikely to be mispricings in ETFs because the NAV can be calculated almost instantly every second and a lower priced ETF than its NAV (undervalued) will be bought up immediately until it equals the fair value.

Thus, the argument that bid/ask spread causes lower returns is untrue and any difference between the returns from US domiciled vs non-US domiciled ETFs is solely due to other factors including expense ratio/tracking error. High possibility it is the effect of higher expense ratios that is compounded for years especially since the non-US domiciled ETF is measured based on NAV. Higher expenses -> Lower NAV -> Less money that gets reinvested.

Results:





Note: I suppose the dividends have already been accounted for in the price of the ETFs on the LSE. Hence, the NAV increases as dividends are taxed, reinvested immediately and should reflect the price.

Conclusion:

What Stashaway said is true. You have an advantage buying US domiciled ETFs which have lower expense ratios. However, the gap is very small at 0.13%~0.15% in the long run.

This post has been edited by Yggdrasil: Oct 26 2019, 09:11 PM

Reserved. I will test out FAANG/FAAMG returns if I have time. Let me know if I made a mistake/you disagree or you have anything interesting to investigate.

This post has been edited by Yggdrasil: Oct 26 2019, 09:35 PM

When VOO and QQQ pay dividend, the dividend yield given on Yahoo Finance's website is net of WHT or not yet net but we pay our own dividends later?

CSPX.L and CNDX.L still lose.
I think Stashaway is right. I mean they are probably smarter than both of us.

roarus I recently found out about Invesco EQQQ NASDAQ-100 UCITS ETF (EQQQ.MI)

I realised my mistake when I compared QQQ with the Ireland equivalent was that my sample was using NASDAQ 100 from Invesco while comparing it to iShares.
That probably explains the difference.

I did a quick test using EQQQ.MI (Invesco - Milan) as there was a problem with the data from Invesco EQQQ NASDAQ-100 UCITS ETF (EQQU.L) and sure enough it was better.



Note: I assumed that the withholding tax was 15% but it doesn't matter because it's an accumulating ETF.

Edit: I removed the problematic data resulting in a 3 year sample and QQQ wins again.



Edit: Wrong image earlier. This is the correct one. Small difference only.

This post has been edited by Yggdrasil: Nov 17 2019, 09:34 PM

Need but in my calculation for the ETF in Milan, it doesn't matter what WHT rates.
I'm not sure whether the Withholding Tax in Milan is 15% or something else but it doesn't matter because withholding tax are already paid by them.

That makes sense. However, there were some dates whereby the data were around 170 suddenly it jumped to 15783.00. I trimmed these off.

No accurate dividend data was given so I used the difference between the closing price and the adjusted closing price to calculate dividend yield. The closing price should be the reinvested portion.

I.e. I presume adjusted price is sort of like ex-dividend. A RM1 share paying RM0.20 dividend should be RM0.80 ex-dividend date. If it still remains RM1 on ex-dividend, technically the dividend has been 'reinvested' into the shares pushing the price up.

Quite hard to explain without the Excel file. What I'm trying to say is actually Modigliani and Miller's Dividend Irrelevance Theory.

Hmm. I didn't use this method because it does not track multiple periods. Using this means the sample size is only 2 observation.

I will try to upload the Excel file for QQQ and EQQU.L when I have time.

You cannot simply do this because this is theoretical whereby what I am doing is testing it against actual data.
It's like saying Inveso's Nasdaq 100 and iShares' Nasdaq 100 should give same return if both expense ratios and Withholding Tax are the same. But is it true? We don't know until we test it.

From what I noticed, US domiciled are distributing while non-US are accumulating.

Attached Excel file for QQQ v EQQU.L for samples from 26/3/2015 to 15/5/2018 (excluding public holidays) if you are interested to read.
QQQ still wins but by a slim margin <1%. Note my sample is only 3.136 years.

Link: here

It does say distributing but Yahoo Finance gave EQQU.L's closing price and adjusted closing price as the same.
This is why I cannot calculate the dividend yield.