Business & Investing
Sponsored by

Portfolio analysis tool

1,247 Views | 8 Replies | Last: 3 mo ago by TW1993
El Chupacabra
How long do you want to ignore this user?
Not sure if I'm asking this right or if this tool exists.

Pretend I own the following
$10k AAPL
$10k XOM
$10K ABC
$10k XYZ
$20k SPY
$20k QQQ
$20k IWM

Is there a tool out there where I can put all of my holdings into and it spit out my individual stock holdings by percentage and do an analysis by sector?
permabull
How long do you want to ignore this user?
AG
I think this site will do it if you customize the inputs

https://www.portfoliovisualizer.com/backtest-portfolio
RockOn
How long do you want to ignore this user?
portfolio visualizer recently went under some changes to generate some money but you can still access the old site at legacy.portfoliovisualizer.com but the data for funds is limited to 10 years.

For a full set of data go to testfol.io
YouBet
How long do you want to ignore this user?
AG
Personal Capital does this I think. And is probably the most user friendly visualization you will find. It's also free if you don't mind a sales call once in a while from them which you can ignore.
El Chupacabra
How long do you want to ignore this user?
I changed my google-foo and found this one.

Portfolio Analyzer - Investment Checkup | Empower

anyone ever used it?
gggmann
How long do you want to ignore this user?
AG
I like empower. You can link your accounts, and it'll pull all of your holdings and show your asset allocation breakdown as well as performance. You can dig down multiple levels (e.g. US Stocks>Large Cap Growth>inidividual tickers).
LMCane
How long do you want to ignore this user?
El Chupacabra said:

Not sure if I'm asking this right or if this tool exists.

Pretend I own the following
$10k AAPL
$10k XOM
$10K ABC
$10k XYZ
$20k SPY
$20k QQQ
$20k IWM

Is there a tool out there where I can put all of my holdings into and it spit out my individual stock holdings by percentage and do an analysis by sector?

if you use Fidelity Brokerage you can see EXACTLY to the .00 percentage how much of everything you own
I bleed maroon
How long do you want to ignore this user?
AG
Unless I'm mistaken, what the original poster is asking for is a stock-by-stock analysis, which I'm not sure any of these tools provide.

For instance, If he owns $50,000 worth of QQQ, he wants to know how many shares of NVDA he "owns" within that ETF. Or in a VTI mutual fund, how much MSFT exposure does he have.

Unfortunately, I don't believe there's anything remotely like this, for several reasons. First, Index ETFs are sometimes proxies for stock ownership - they don't actually hold the individual equities, and instead use derivatives or phantom tracking stock to derive returns. Second, mutual funds only are required to disclose their holdings periodically, and their latest holdings list is almost certainly dated by the time you see it.

Cathie Wood (like her or not) actually set a pretty high bar by disclosing trades in her ARK funds on a daily basis, but I'm not sure her information is completely accurate between regulatorily required disclosure periods.

OP - your interest is laudable, but either you have to buy stocks individually (you listed AAPL and XOM) to truly know how much exposure you have, or the alternative is to categorize the holdings in somewhat arbitrary buckets (like IWM, QQQ, SPY or midcap, small cap, energy, technology, etc.).
TW1993
How long do you want to ignore this user?
AG
You have to pay for the subscription, but Morningstar Investor will do what you are asking. You create a portfolio and then you use the stock intersection tool.
Refresh
Page 1 of 1
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.