ETF: Irish domiciled ETF vs US, WHT benefit vs expense ratio bid spread
|
|
 Nov 22 2019, 11:08 PM
|
 
Senior Member
1,042 posts Joined: Jan 2003 
|
QUOTE(Yggdrasil @ Nov 20 2019, 07:24 PM) 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. Just noticed, you used EQQU.L - which points to a distributing class. In that case the dividend yield in your spreadsheet shouldn't be 0 right?QQQ still wins but by a slim margin <1%. Note my sample is only 3.136 years. Link: here  |
|
|
Nov 23 2019, 10:37 AM
|
Senior Member
2,210 posts Joined: Jan 2018
|
QUOTE(roarus @ Nov 22 2019, 11:08 PM) Just noticed, you used EQQU.L - which points to a distributing class. In that case the dividend yield in your spreadsheet shouldn't be 0 right? 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. |
|
|
Nov 23 2019, 06:13 PM
|
|
Senior Member
1,042 posts Joined: Jan 2003
|
I got more with CSPX
 CSPX vs VOO - 16 Sep 2010 till 22 Nov 2019 - Starting with $10,000 capital - Fractional units allowed (for the good preservation of my sanity and hair) - VOO dividends applied with 30% WHT - VOO dividends reinvested on payment date (because that's what happens in real life, you can only reinvest after dividend is paid out rather than ex date) - Initial buy and dividend reinvest using closing price Excel file download here: https://ufile.io/jv3vdxcy End result: CSPX: 32,232.81 +698.33 (322.33%) VOO: 31,534.48 (315.34%) This post has been edited by roarus: Nov 23 2019, 06:16 PM |
| Change to: |  0.0136sec
 0.48
 5 queries
 GZIP Disabled
Time is now: 4th December 2025 - 07:58 PM |
Quote