ooo thanks for that call-out, I will definitely look into that. Looks like the ETF has 9% in EPD, alongside 5 others which represent close to half their holdings, so may well serve my purpose. After the EPD sale, I have literally zero exposure to commodities (outside Russian miners... and GDIG which is doing well), so getting both that exposure and a pipeline exposure definitely appeals and aligns with my ETF purchases atm! I've put it onto a watchlist and may well buy with my next deposit :)
Down just over a % is terrific. I'm down around 8% or so. It took me a.while to find a decent money-weighted calculator to work this out with though -- don't suppose you have a spreadsheet or similar you could direct us to?
Yep, happy with that. I was running quite far ahead pre Ukraine invasion, but I had about 10% of my portfolio in POLY and EVR, and I'm down 85% on those positions... But I've also had some real winners, so swings and roundabouts, and I've kept calm and continued plodding along, which I'm super happy about. Since that fall, I have caught up and overtaken the S&P, but the FTSE350 has just hugely outperformed thanks to the FTSE100, and it remains comfortably ahead over a 2 year period in which I've been investing. I imagine down 8% still potentially means you are outperforming, depending on when you started. The FTSE250 and the S&P500 have really had a dreadful year, but most of the markets are down double digits. My method of calculating time weighted is to take the month performance of my portfolio. I take a hypothetical 100 from when I started (Dec 2020), and then multiple it each month. So in Dec 2020, I was up 2.81% in my actual portfolio, so I would would start with 100, and it would go to 102.81 at Dec close. In Jan 2021, I was up 0.23% across the month, so at Jan close it'd be 103.04, and so on. I do the same with the S&P500 and the FTSE350 as my comparison benchmarks of choice. Below is a sample of my 1st 6 months for guidance, it's basically just a simple calculation that reads (for line Jan-21, my financial column) "=E51+(E51*B52)", or in words, take the financial figure in the previous month, and add to it that figure multiplied by the performance of the current month. Month Me - % S&P - % FTSE % Me - £ S&P - £ FTSE - £ Dec-20 2.81% 3.71% 3.61% £102.81 £103.71 £103.61 Jan-21 0.23% -1.11% -0.90% £103.04 £102.56 £102.68 Feb-21 1.99% 2.61% 1.58% £105.10 £105.24 £104.30 Mar-21 4.21% 4.24% 3.43% £109.52 £109.70 £107.88 Apr-21 4.36% 5.24% 3.95% £114.30 £115.45 £112.14 May-21 3.40% 0.55% 0.77% £118.19 £116.08 £113.00 Hopefully that makes sense! I actually tidied up my portfolio tracker a little over Xmas and I'm considering doing a video where I walk through my tracker, where I can explain it. Assume would be of interest? :)
@@swphilosophy3040 So the deposit is irrelevant. In the above, I just take a hypothetical 100 quid start. Essentially my portfolio has a result each month as a financial figure for PROFIT, and I take that and divide by the VALUE of portfolio, which gives me a profit % each month. I use that figure to multiply by the running 100 quid. As an example, for Dec 2020, I had a 117 profit on a 4158 portfolio, so a 2.81% profit. I then have my hypothetical 100, that if I'd have put that in, I'd have 102.81. If I'd have put the same 100 in the S&P500 or FTSE350, I'd have 103.71 and 103.61 respectively. Then I do the same next month. My deposit amount and value of portfolio isn't used. Profit is used, and then that is used to give me a monthly profit or loss %, which is what I base for the time weighting.
![Twenty One Pilots - “The Line” (from Arcane Season 2) [Official Music Video]](http://i.ytimg.com/vi/E2Rj2gQAyPA/mqdefault.jpg)
Happy New Year 😊
Ayyye Happy New Year! :)
If you still want pipelines, Alerian Midstream ETF on 212 has access to a lot of these pipeline projects. Comes in USD & GBP flavours
ooo thanks for that call-out, I will definitely look into that.
Looks like the ETF has 9% in EPD, alongside 5 others which represent close to half their holdings, so may well serve my purpose. After the EPD sale, I have literally zero exposure to commodities (outside Russian miners... and GDIG which is doing well), so getting both that exposure and a pipeline exposure definitely appeals and aligns with my ETF purchases atm!
I've put it onto a watchlist and may well buy with my next deposit :)
Down just over a % is terrific. I'm down around 8% or so.
It took me a.while to find a decent money-weighted calculator to work this out with though -- don't suppose you have a spreadsheet or similar you could direct us to?
Yep, happy with that. I was running quite far ahead pre Ukraine invasion, but I had about 10% of my portfolio in POLY and EVR, and I'm down 85% on those positions... But I've also had some real winners, so swings and roundabouts, and I've kept calm and continued plodding along, which I'm super happy about. Since that fall, I have caught up and overtaken the S&P, but the FTSE350 has just hugely outperformed thanks to the FTSE100, and it remains comfortably ahead over a 2 year period in which I've been investing.
I imagine down 8% still potentially means you are outperforming, depending on when you started. The FTSE250 and the S&P500 have really had a dreadful year, but most of the markets are down double digits.
My method of calculating time weighted is to take the month performance of my portfolio. I take a hypothetical 100 from when I started (Dec 2020), and then multiple it each month. So in Dec 2020, I was up 2.81% in my actual portfolio, so I would would start with 100, and it would go to 102.81 at Dec close. In Jan 2021, I was up 0.23% across the month, so at Jan close it'd be 103.04, and so on.
I do the same with the S&P500 and the FTSE350 as my comparison benchmarks of choice.
Below is a sample of my 1st 6 months for guidance, it's basically just a simple calculation that reads (for line Jan-21, my financial column) "=E51+(E51*B52)", or in words, take the financial figure in the previous month, and add to it that figure multiplied by the performance of the current month.
Month Me - % S&P - % FTSE % Me - £ S&P - £ FTSE - £
Dec-20 2.81% 3.71% 3.61% £102.81 £103.71 £103.61
Jan-21 0.23% -1.11% -0.90% £103.04 £102.56 £102.68
Feb-21 1.99% 2.61% 1.58% £105.10 £105.24 £104.30
Mar-21 4.21% 4.24% 3.43% £109.52 £109.70 £107.88
Apr-21 4.36% 5.24% 3.95% £114.30 £115.45 £112.14
May-21 3.40% 0.55% 0.77% £118.19 £116.08 £113.00
Hopefully that makes sense!
I actually tidied up my portfolio tracker a little over Xmas and I'm considering doing a video where I walk through my tracker, where I can explain it. Assume would be of interest? :)
@@Bosshog-WealthHealthBetterment thanks for this. So how does time weighted control for the unevenness in your deposits? Not sure I've got that bit...
@@swphilosophy3040 So the deposit is irrelevant. In the above, I just take a hypothetical 100 quid start.
Essentially my portfolio has a result each month as a financial figure for PROFIT, and I take that and divide by the VALUE of portfolio, which gives me a profit % each month. I use that figure to multiply by the running 100 quid.
As an example, for Dec 2020, I had a 117 profit on a 4158 portfolio, so a 2.81% profit. I then have my hypothetical 100, that if I'd have put that in, I'd have 102.81. If I'd have put the same 100 in the S&P500 or FTSE350, I'd have 103.71 and 103.61 respectively. Then I do the same next month. My deposit amount and value of portfolio isn't used. Profit is used, and then that is used to give me a monthly profit or loss %, which is what I base for the time weighting.