Jump to content

How to calculate total TER of ETF portfolio


Guest theshidoshi

Recommended Posts

Guest theshidoshi

How to calculate total TER for an ETF portfolio

renderTimingPixel.png

Hi guys

I am a new investor and as I have been learning about ETF portfolio structuring and key things such as keeping a low TER.

I am shifting my portfolio to ETF portfolio and I am not sure how to calculate an aggregate TER for the portfolio. I am not sure I am doing the total TER calculation for all 7 ETFs correctly.

Example of my ETF structure:

Percentage of holding - ETF - TER

  1. 40% in CSP1 TER 0.07%
  2. 20% in CUKX TER 0.07%
  3. 10% in IUKP TER 0.40%
  4. 10% in GBDV TER 0.45%
  5. 10% in SWDA TER 0.20%
  6. 5% in EMIM TER 0.18%
  7. 5% in SGLN TER 0.25%

 

Do I calculate it in the following way:

A) Sum of all 7 ETF TERs = 1.62%

B) Average of all 7 ETF TERs = 0.23%

C) Or more complex calculation considering the TER of each ETF in relation to its position size (e.g 40% in CSP1 with TER of 0.07% vs. 5% in EMIM with TER of 0.18% means its a lot cheaper than the simple addition of both TERs)

 

Any explanation with an example would be most helpful.

Thank you

Link to comment

Hi @theshidoshi

The answer is C. You need to weight the TER of each ETF by its weight in your portfolio.

In Excel, if you had the weights in column A and TER’s in column B, you could use the SUMPRODUCT function to find the TER for your portfolio.

I’ve calculated this for you and I got a TER of 0.1685%. Let me know if you've got any other questions!

Kind regards,

Sam

Link to comment
Guest theshidoshi
2 hours ago, samd_IG said:

Hi @theshidoshi

The answer is C. You need to weight the TER of each ETF by its weight in your portfolio.

In Excel, if you had the weights in column A and TER’s in column B, you could use the SUMPRODUCT function to find the TER for your portfolio.

I’ve calculated this for you and I got a TER of 0.1685%. Let me know if you've got any other questions!

Kind regards,

Sam

Thank you so much. I learnt a lot. I do have one question. My example above is the future weighting.

 

I tried it with my current portfolio I am trying to restructure and got a TER that is much much lower than I expected. I tested with our example above and ot worked but when applied to my current holdings it comes up with 0.05% which I find strange

 

Below is the ETF table (currently only 25% of my ISA portfolio)

Symbol - TER - Weighting

CSP1 0.07% 8.62%
CUKX 0.07% 3.99%
IUKP 0.40% 2.47%
EMIM 0.18% 1.02%
GBDV 0.45% 3.59%
SWDA 0.20% 3.18%
SGLN 0.25% 1.65%

 

I used the formula:

=SUMPRODUCT(A1:A7,B1:B7)

Answer 0.05%

 

How is that possible with such low TER?

Link to comment
1 hour ago, theshidoshi said:

Below is the ETF table (currently only 25% of my ISA portfolio)

If you are just finding the TER for the portion of your portfolio that is invested in assets that have an annual expense then I would recommend either using weights for this part that sum to 100%, or to gross up the weights as shown in the screenshot below.

Both methods should get to the same answer, which I've calculated as 0.19% (2 d.p)

TER.PNG.0e438cb85d2164dfb59a2bd534fbafda.PNG

TER2.PNG.ff87db95403900d90e7cf13f70c0aaad.PNG

 

That should do the trick. Let me know if you've any other questions!

Link to comment
  • 1 month later...
Guest theshidoshi

I just wanted to say thank you. This has worked for me beautifully now in Excel. I completely understand it.

 

Now I am learning how to do this in Python as it is a language I am trying to learn for Finance & Investing.

 

Many thanks

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
      23,074
    • Total Posts
      95,527
    • Total Members
      43,695
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    jimipop
    Joined 04/10/23 17:01
  • Posts

    • Yes, there are may time-sized cycle. I will bear in mind your data. It is very good. This is going to be an interesting year forward! All the best.  
    • Here's some more clues as to what the markets are doing - Remember, this just would not work if markets were random This is Gann's Square of Nine (9) - He used it to work on both price and time It's basically a spiral of ORDERED numbers around a circle of 360 degrees, divided into sections  If you look closely enough you will see if you pulled number "1" up and towards you, the form would create a PYRAMID  As you can see in this simpler Gann Sq of 9 below, we can split the sq into GEOMETRICAL harmonics, in this case this is a cardinal cross Get the reference number point "61" and work through 65,69,73,77,81,86,91 etc - you can follow the sequence easily enough and see that those prices are following the natural order sequence of those cardinal point cross points...................... Here's those points in TIME (MONTHS) from the Oct 2022 LOW on the SP500 market - As you can see MANY MANY hits to the month and then the market reversed to some degree - KNOWLEDGE of this method would of allowed you to place those dates on your charts in 2002! YEARS in advance and this is just one method of many that pinpointed the 2009 low from a TIME perspective  THT
    • Short comment today: I've been expecting some "sort" of event that causes "issues" in the generic economy going into Oct 2025 This should be a stock market swing LOW turning point - there's other issues for 2026, where the 666 week "beast" cycle turns up and also the 18 year property cycle crash low too The 66 week "beast" cycle last hit from memory May ish 2013, as its a 12 yr and a bit month cycle it rolls into early -mid 2026 - usually causes wild price fluctuations (check out 2013) Don't write off the bigger cyclic picture we are in, this cycle has a huge win/hit rate above 90% that covers over 200 years of stock market price data and history and we should see the USA market(s) MASSIVELY UP into 2034 THT
×
×
  • Create New...
us