Diversiview logo

View individual stock exposure for portfolios that contain ETFs

If you have an investment portfolio containing a mix of ETFs and individual stocks, there is always a possibility that some of your ETFs also contain some of your individual stocks, some ETFs may overlap, or some ETFs may contain stocks you don’t want to invest in.

In other words, your actual exposure to different individual stocks will be higher than you thought, or you may be overexposed to certain industries and underexposed to others.

Do you want more certainty about your investments?

It is always a good idea to know what you actually invest in, especially when you’re looking to invest in several ETFs along with several individually listed securities.

That is true no matter if you invest in one share market only or if you diversify internationally.

So, how to go about that?

Let’s look at an example and then we’ll show you where you find this information calculated for you in Diversiview.

Individual Stock Exposure example

Assume you have a portfolio with 3 stocks and 2 ETFs as follows: CBA (20%), BHP (30%), RIO (20%), ETF1 (15%), ETF2 (15%).

The high level asset type / industry allocation is as below:

ETF115ETF (Exchange Traded Fund)
ETF215ETF (Exchange Traded Fund)

Many investment platforms and trading application will only show you the above piechart with the high level allocation.

But is that enough for you to understand your real investment exposure to all the risk and growth opportunities that are linked to the underlying holdings?

Assume that ETF1 is a global fund, containing: MSFT (10%), APPL (10%), BHP (10%), RIO (5%), COL (20%), WES (45%).

Also assume that ETF2 is an Australian fund containing: MQG (30%), BHP (20%), CSL (10%), COL (20%), CBA (20%).

As you can see, in this small example BHP appears in both ETFs, while CBA and RIO appear in one ETF each.

If we calculate the individual exposure for each stock considering the ETF compositions as described above, we obtain:

ETF1MSFT101.5US Information Technology
15%AAPL101.5US Information Technology
COL203Consumer Staples Distribution & Retail
WES456.75Consumer Discretionary Distribution & Retail
ETF2MQG304.5Financial Services
CSL101.5Pharmaceuticals Biotechnology & Life Sciences
COL203Consumer Staples Distribution & Retail

Based on the above calculations, the exposure to industry groups becomes:

Consumer Discretionary Distribution & Retail6.75%
Consumer Staples Distribution & Retail6%
Financial Services4.50%
Pharmaceuticals Biotechnology & Life Sciences1.50%
US Information Technology3%

As one can notice, the exposure to Banks and Materials industry is actually higher than initially thought, and there is exposure to many other industry groups, in Australia and US.

What about the actual holdings?

By holding the two example ETFs in your portfolio, you actually hold the following individual securities:


Individual Stock Exposure in Diversiview

The example above is very easy to figure out and calculate in a spreadsheet, once you have all the data you need including ETF holdings.

What if you have many ETFs, many overlapping stocks or no time to calculate?

Diversiview can help.

Simply enter you portfolio or upload from a CSV, click on “Get results” and Diversiview will show you the Individual stock exposure as a separate section at the top of the page, immediately after the Portfolio Composition section.

All individual holdings that are in your portfolio as part to your ETFs will be listed. The top 20 holdings are automatically shown, and you can click on “See more” to view all that have a weight higher than 0.01%.

Note that the individual stock exposure section will not appear if there are no ETFs in the portfolio or when Diversiview does not have the holdings data (check out the list of ETF with holdings available at current date).

If you have an ETF that is not in our list above, please contact us (email below) and we will be happy to add it.


Please contact the team at hello@diversiview.online and we will be happy to help.

Try Diversiview today. Do better, get more from your investment portfolio.