Explore my holdings and show look through exposure.
For example if I own 100 share of Nvidia as well as SPY and QQQ - what’s my Nvidia exposure?
1 Like
I’ve updated the title a bit for clarity
To handle also broader allocations (like % of equity vs bonds in ETFs like V80A), the assets should be prefixed with “Equity/…”, “Bond/…”, etc.
Although less readable, I’d consider using ISIN codes instead of symbols to make the matches accurate. Maybe the UI could resolve ISINs to proper names and/or help with finding a proper one when editing the field.
1 Like
This would be a fantastic addition. Currently, I still rely on managing my entire portfolio in Excel to understand my stock/bond allocation due to holdings like V80A or similar.
It would also be incredibly helpful to analyze my portfolio-level allocations for:
• Developed vs. Emerging markets
• Large-cap, Mid-cap, and Small-cap stocks
• Value, Blend, and Growth styles
At the moment, I manually update this data in Excel periodically, using Morningstar’s stock style-weighted charts available in the “Portfolio” tab for each ETF.
These are actually already in - checkout Categories tab. You can modify them freely to suit your style
This makes sense, but I’m uncertain if it applies to assets with variable underlying allocations, such as an ETF composed of 70% developed markets and 30% emerging markets, or one split into 37% value, 24% blend, and 39% growth. These allocations need to be updated periodically as the ETF tracks an index whose composition evolves. Can the app already handle such scenarios?
Categories are dynamic and may shift with time, they won’t be 100% accurate to the percent though. But a an ETF may shift from one to another.
For regions, the Region taxonomy is pretty accurate as you can define percentages there. Similar with Industries. You can update them yourself or trigger an update to refetch the data from the market data provider.
Thanks, I’ll give it a go!
Hi There
I am not sure if the question was clear but I think I would like the same thing e.g. if I hold Nvidia via a fund vs via an ETF, my exposure may be 2-3x what I think it is. From memory, this is an x-ray and some providers e.g. morningstar offer a look through.
2 Likes
You’re essentially talking about doing a proper “look-through” analysis, which most retail tools still don’t handle well. The cleanest way is to treat every ETF or fund as a container and break it down into its underlying holdings with weights, then aggregate everything at the portfolio level. So in your example, you’d calculate Nvidia exposure as: direct shares + (SPY weight of Nvidia × your SPY position) + (QQQ weight of Nvidia × your QQQ position). The tricky part is keeping those underlying weights updated, since ETFs rebalance and shift over time.
One approach that works well is combining a holdings database (from ETF issuers or data providers) with a simple aggregation model. That’s basically how institutional portfolios are analyzed firms such as Mercer Wealth Management structure portfolios using full transparency across asset classes, sectors, and factors. There’s a useful overview of how portfolio solutions are structured on their Mercer Wealth Management website that can help frame how to think about multi-layer exposure rather than just top-level tickers.
Expanding on what others mentioned, once you have that framework, you can go beyond single-stock exposure and calculate things like equity vs. fixed income splits, regional exposure (developed vs. emerging), and style factors (growth vs. value). A practical setup is to maintain a table of ETF constituents with weights and link it to your positions, Excel works, but a small script or portfolio tool can automate updates. That way, instead of manually checking Morningstar charts, you’re generating a live “look-through” view of your entire portfolio, including overlaps like Nvidia across multiple funds.
1 Like