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
  • image.png

  • Posts

    • Crypto trading is a bit complicated when it comes to understanding the dynamics in profit making. Some people are more inclined to technical analysis which of course has been the widely used trading tool but some are more inclined to fundamentals but sticking to fundamentals alone could be highly risky in my own opinion even though crypto is also financial instrument that often respond to news updates.  A blend of the two could provide a safety net for traders in minimizing losses compared to potential profit. The above case scenario is largely attributed to perp futures trading and other derivatives. TA and FA could also be very useful for spot trading but I feel timely listing of projects could largely determine one's profit from investing in a project. These may not be for all projects cos some are **** coins. This could be a personal perspective but I have noticed listing speed is also another important factor to consider along with project fundamentals when trading and if we are to include listing speed as a factor for choosing trade then it will affect our choice of trading platform cos some are more inclined to top cap projects while others are more inclined low cap gems.   My experience with ORDI has proven this trading skill rewarding. ORDI was first listed on Bitget before other exchange joined the listing party after it saw rapid adoption reflecting in it significant MCap growth. This chart should give us a glimpse of my experience with this strategy.
    • In a stunning display of market momentum, the PANDORA token, the first of its kind, has skyrocketed an astonishing 4872% from its introduction on February 2nd to February 7th. This remarkable performance has not only caught the attention of cryptocurrency enthusiasts but has also solidified PANDORA’s position as a groundbreaking asset in the digital currency landscape. Pandora's ERC-404 protocol revolutionizes the token landscape by seamlessly blending the qualities of ERC20 and ERC721 standards. This experimental mixed implementation enables persistent liquidity and non-fungibility for NFTs, unlocking a realm of possibilities previously unexplored. Adding to the excitement, Bitget Wallet is gearing up to introduce a specialized section dedicated to ERC-404 token market listings. This feature creates a hub for tokens that blend the best of both worlds—the liquidity of ERC-20s and the uniqueness of ERC-721 NFTs. I have come to believe that, the electrifying surge of PANDORA token and the innovative ERC-404 standard is not just a fleeting trend but a window into the future of cryptocurrency.
    • A significant turning point in the #PORTALxBitget collaboration is the listing of $PORTAL on Bitget through the Candybomb event, which opens up benefits and synergistic prospects like 1. Diversified Trading choices: Users now have access to a wide range of trading choices thanks to $PORTAL's listing on the exchange, including cutting-edge leveraged trading capabilities and spot trading. This gives customers the freedom to interact with $PORTAL in a way that suits their preferred level of risk and trading techniques. 2. Community Synergy: By uniting the exchange users and the pre-existing $PORTAL community, the Candybomb event stimulates community engagement. Through this synergy, a positive environment surrounding #PORTALxBitget may be developed, encouraging cooperation, information exchange, and sustained interest in the project. Could this recent collab stimulate the  stage for a fruitful and mutually beneficial relationship between #PORTAL and exchange.
×
×
  • Create New...
us