Which tool do you use to measure your asset allocation?

Have a question about your personal investments? No matter how simple or complex, you can ask it here.
User avatar
Topic Author
physics911
Posts: 228
Joined: Thu Feb 09, 2023 3:56 pm

Which tool do you use to measure your asset allocation?

Post by physics911 »

How do you measure your asset allocation? By that I mean, do you use Empower, Quicken, the view in your brokerage account, etc., or the old fashioned spreadsheet method like me?

While I personally use both of the platforms mentioned, I don't use them to check my allocation as they are too granular for me.
Since my wife and I are a simple 3-fund couple (more/less), I just look at FSKAX as US Stock, FXNAX as US Bonds, and FTIHX as International ex. US, and do any rebalancing at that high level. Empower and Quicken further break the holdings down into more granular allocations, which I look at for informational purpuses, but don't really pay too much attention to the granular level.
50% Total US, 20% Total ex US, 30% Total US Bond
User avatar
TomatoTomahto
Posts: 18152
Joined: Mon Apr 11, 2011 1:48 pm

Re: Which tool do you use to measure your asset allocation?

Post by TomatoTomahto »

I use Quicken, but don’t really measure AA. That’s the joy of having enough.
I get the FI part but not the RE part of FIRE.
rkhusky
Posts: 19406
Joined: Thu Aug 18, 2011 8:09 pm

Re: Which tool do you use to measure your asset allocation?

Post by rkhusky »

Spreadsheet.
User avatar
greg24
Posts: 4600
Joined: Tue Feb 20, 2007 9:34 am

Re: Which tool do you use to measure your asset allocation?

Post by greg24 »

Eyeball it.
livesoft
Posts: 87761
Joined: Thu Mar 01, 2007 7:00 pm

Re: Which tool do you use to measure your asset allocation?

Post by livesoft »

I use Vanguard Portfolio Watch and other tools provifded by my financial institutions as described in this thread:

viewtopic.php?t=150267
Wiki This signature message sponsored by sscritic: Learn to fish.
User avatar
windaar
Posts: 1954
Joined: Thu Mar 08, 2012 6:31 am

Re: Which tool do you use to measure your asset allocation?

Post by windaar »

Paper, pencil, and calculator.
Nobody knows nothing.
User avatar
LilyFleur
Posts: 3813
Joined: Fri Mar 02, 2018 9:36 pm

Re: Which tool do you use to measure your asset allocation?

Post by LilyFleur »

Googlesheets.

There are fields that automatically calculate the asset allocations when I update the positions. A recent Treasury/CD ladder has added about 5 or 10 minutes to the copy and paste from Fidelity to my spreadsheet. Unlike Schwab, Fidelity doesn't have a total for the account's fixed income on the positions screen online.

There are several iterations (automatically updated) that I find interesting: % in Roth, % cost basis in the brokerage account, % in cash, % in bonds/fixed income (Treasury/CD ladder), % in equities.

I do watch it fairly carefully, as I may be supporting/partially supporting an ill adult child for their lifetime, as much as I am able.
User avatar
Tyler Aspect
Posts: 1787
Joined: Mon Mar 20, 2017 10:27 pm
Location: California
Contact:

Re: Which tool do you use to measure your asset allocation?

Post by Tyler Aspect »

Started using TestFol.io instead of PortfolioVisualizer for portfolio simulation.
Past result does not predict future performance. Mentioned investments may lose money. Contents are presented "AS IS" and any implied suitability for a particular purpose are disclaimed.
User avatar
Topic Author
physics911
Posts: 228
Joined: Thu Feb 09, 2023 3:56 pm

Re: Which tool do you use to measure your asset allocation?

Post by physics911 »

LilyFleur wrote: Mon Sep 30, 2024 12:44 pm Googlesheets.

There are fields that automatically calculate the asset allocations when I update the positions. A recent Treasury/CD ladder has added about 5 or 10 minutes to the copy and paste from Fidelity to my spreadsheet. Unlike Schwab, Fidelity doesn't have a total for the account's fixed income on the positions screen online.

There are several iterations (automatically updated) that I find interesting: % in Roth, % cost basis in the brokerage account, % in cash, % in bonds/fixed income (Treasury/CD ladder), % in equities.

I do watch it fairly carefully, as I may be supporting/partially supporting an ill adult child for their lifetime, as much as I am able.
This is pretty much exactly what I do. When my wife and I do our 15-minute quarterly review, I update the balances in Google Sheets and I have it pivoted down to be able to see not just allocations, but by account type, tax type, hers vs. mine, etc. It really doesn't take long to do the updates and gives a very thorough, yet easy to read, view of where we stand.
50% Total US, 20% Total ex US, 30% Total US Bond
hirlaw
Posts: 470
Joined: Tue Sep 29, 2009 10:20 am

Re: Which tool do you use to measure your asset allocation?

Post by hirlaw »

I have been using Empower. I don't link the accounts. I enter them and update them manually. Previously used Morningstar XRay. I was happy with that tool, but Morningstar now requires membership to use it.
User avatar
baconavocado
Posts: 859
Joined: Fri Oct 13, 2017 3:03 pm

Re: Which tool do you use to measure your asset allocation?

Post by baconavocado »

Quicken to generate a report which I then copy into an Excel worksheet with embedded formulas. It's a little clunky, takes me 2-3 minutes to put together, but it tells me what I need to know. I only break it down into 4 categories: domestic stocks, domestic bonds, intl stocks, intl bonds.
scarcely
Posts: 46
Joined: Fri Feb 03, 2023 6:37 pm

Re: Which tool do you use to measure your asset allocation?

Post by scarcely »

One of the joys of a three fund portfolio: either a calculator or spreadsheet for a 30 second calculation.
Dead Man Walking
Posts: 1223
Joined: Wed Nov 07, 2007 5:51 pm

Re: Which tool do you use to measure your asset allocation?

Post by Dead Man Walking »

Although most Bogleheads would view a Morningstar subscription as an extravagant expense, I find it a good way to calculate my asset allocation and the value of my investments. I can enter the shares of mutual funds, stocks, treasuries, money market funds, savings account, etc. and the X-ray tool can calculate my asset allocation, show bond and stock style diversification, stock overlap in addition to the total value of my portfolio. I’ve spent more on a family dinner at exclusive restaurants than the cost of a Morningstar subscription. I enjoy some of the content that comes with the subscription.

DMW
tibbitts
Posts: 25757
Joined: Tue Feb 27, 2007 5:50 pm

Re: Which tool do you use to measure your asset allocation?

Post by tibbitts »

I use Vanguard's Portfolio Watch, which is somewhat inaccurate but good enough. I do miss not being able to characterize outside investments as it was possible to do many years ago.
Keebtree
Posts: 38
Joined: Fri Oct 27, 2023 8:55 am

Re: Which tool do you use to measure your asset allocation?

Post by Keebtree »

Google sheets that pulls ticker pricing and other info in automatically. Just need to update amount of shares owned (takes 10 minutes).
Will also tell me where new money needs to get invested to get back to my desired asset allocation. Makes rebalancing (I rebalance annually) very straightforward.
Lastrun
Posts: 1944
Joined: Wed May 03, 2017 6:46 pm

Re: Which tool do you use to measure your asset allocation?

Post by Lastrun »

Quicken for diagnosing and a spreadsheet for surgery (rebalancing).
User avatar
beernutz
Posts: 1010
Joined: Sun May 31, 2015 12:50 pm

Re: Which tool do you use to measure your asset allocation?

Post by beernutz »

I don't agreed with the sentiment sometimes expressed on this site that it is frowned upon to frequently look at your investment balances. There are countless horror stories reported here of people ignoring their investment accounts who come to find they've been compromised and evil has been done. For that reason alone I login to each of my 4 primary accounts multiple times per week and since I'm already logged in why not transfer the balances to my net worth spreadsheet in order to calculate my exact asset allocation? It takes maybe 10 minutes each time I do this. I don't see the downside to doing it this way and I've been doing so for long over a decade.
Last edited by beernutz on Tue Oct 01, 2024 3:43 pm, edited 1 time in total.
AA: 43%/38%/19% - equities/positive return-zero volatility/bonds
User avatar
Artful Dodger
Posts: 2027
Joined: Thu Oct 20, 2016 12:56 pm

Re: Which tool do you use to measure your asset allocation?

Post by Artful Dodger »

Fidelity. It is one of their standard analysis tools.
steadyosmosis
Posts: 1655
Joined: Mon Dec 26, 2022 11:45 am

Re: Which tool do you use to measure your asset allocation?

Post by steadyosmosis »

When I log into my brokerage, 95% of my AA is right there on the screen.
Early-retired ... overall portfolio AA 50/50 ... (46% tIRA, 33% RIRA, 16% taxable, 5% HSA) ... (16% SCHB, 16% VTI, 13% SCHF, 5% VITSX, 42% USTreasuries, 8% SGOV).
MikeG62
Posts: 5223
Joined: Tue Nov 15, 2016 2:20 pm
Location: New Jersey

Re: Which tool do you use to measure your asset allocation?

Post by MikeG62 »

Excel spreadsheet into which I download individual positions by account. I update the spreadsheet quarterly.

I also use Fidelity's FullView to get a quick look at our overall financial assets. It does show asset allocation, although it is not totally accurate for that purpose. It is close enough though.
Real Knowledge Comes Only From Experience
TipsQuestions
Posts: 554
Joined: Mon Aug 28, 2023 10:58 am

Re: Which tool do you use to measure your asset allocation?

Post by TipsQuestions »

Raw vanguard holdings dumped into Excel.
Dufus
Posts: 281
Joined: Mon Sep 25, 2023 8:35 pm

Re: Which tool do you use to measure your asset allocation?

Post by Dufus »

Excel calculates it for me based on my balances.
User avatar
Sandtrap
Posts: 21247
Joined: Sat Nov 26, 2016 5:32 pm
Location: Hawaii No Ka Oi - white sandy beaches, N. Arizona 1 mile high.

Re: Which tool do you use to measure your asset allocation?

Post by Sandtrap »

physics911 wrote: Mon Sep 30, 2024 12:28 pm How do you measure your asset allocation? By that I mean, do you use Empower, Quicken, the view in your brokerage account, etc., or the old fashioned spreadsheet method like me?

While I personally use both of the platforms mentioned, I don't use them to check my allocation as they are too granular for me.
Since my wife and I are a simple 3-fund couple (more/less), I just look at FSKAX as US Stock, FXNAX as US Bonds, and FTIHX as International ex. US, and do any rebalancing at that high level. Empower and Quicken further break the holdings down into more granular allocations, which I look at for informational purpuses, but don't really pay too much attention to the granular level.
Vanguard "Portfolio Watch"

j
Wiki Bogleheads Wiki: Everything You Need to Know
User avatar
grabiner
Advisory Board
Posts: 36084
Joined: Tue Feb 20, 2007 10:58 pm
Location: Columbia, MD

Re: Which tool do you use to measure your asset allocation?

Post by grabiner »

I use a spreadsheet. which is available on my wiki user page. (If you use this spreadsheet, make your own copy; I keep a master copy on Google Drive.)

The spreadsheet allows me to make my own allocation of each fund to multiple asset classes. For example, I divide the market as 80% large/20% small, not treating mid-caps as a separate asset class, and 50% value/50% growth. Thus Total Stock Market is 40% LV, 40% LG, 10% SV, 10% SG, and I combine that with other funds to get my total allocation to small-cap value
Wiki David Grabiner
catlady
Posts: 259
Joined: Sat Mar 26, 2016 8:31 pm

Re: Which tool do you use to measure your asset allocation?

Post by catlady »

Excel
Jack FFR1846
Posts: 19312
Joined: Tue Dec 31, 2013 6:05 am
Location: 26 miles, 385 yards west of Copley Square

Re: Which tool do you use to measure your asset allocation?

Post by Jack FFR1846 »

Excel spreadsheet. I only have a 2 fund portfolio AA. My categories and contents are like this:

US Stock: FZROX, VTI, SCHB, BRK/b, SWPPX.
US Bond and fixed income: US savings bond, FXNOX, cash

I have greatly expanded my spreadsheet over the years and it includes an RMD predictor, an income (MAGI) predictor to compare with expected IRMAA, a net worth calculator, a tracking of costs, Medicare information, retirement spending, tax bracket tables, IRMAA tables, interest documentation, dividend documentation etc.
Bogle: Smart Beta is stupid
jebmke
Posts: 28814
Joined: Thu Apr 05, 2007 2:44 pm
Location: Delmarva Peninsula

Re: Which tool do you use to measure your asset allocation?

Post by jebmke »

I use the little chart that shows up on my main dashboard at Vanguard. More of a curiosity now that I do not re-balance.
When you discover that you are riding a dead horse, the best strategy is to dismount.
Kendall
Moderator
Posts: 1982
Joined: Tue Apr 30, 2019 8:10 pm

Re: Which tool do you use to measure your asset allocation?

Post by Kendall »

This topic is now in the Personal Investments subforum.
Target2019
Posts: 1108
Joined: Sat Mar 03, 2007 4:30 pm

Re: Which tool do you use to measure your asset allocation?

Post by Target2019 »

Actual Target Category
67.13% 65.00% STOCK
32.87% 35.00% FIXED

Each month I collect end-of-month values to my Excel book. The numbers come from several institutions, and I've been doing this since 1990.
Outer Marker
Posts: 4926
Joined: Sun Mar 08, 2009 8:01 am

Re: Which tool do you use to measure your asset allocation?

Post by Outer Marker »

MikeG62 wrote: Tue Oct 01, 2024 6:46 am Excel spreadsheet into which I download individual positions by account. I update the spreadsheet quarterly.

I also use Fidelity's FullView to get a quick look at our overall financial assets. It does show asset allocation, although it is not totally accurate for that purpose. It is close enough though.
Same here. I look at Fidelity FullView daily. (Can't help peeking) and run an occasional detailed spreadsheet.
Nyc1967
Posts: 375
Joined: Thu Feb 20, 2014 7:11 am

Re: Which tool do you use to measure your asset allocation?

Post by Nyc1967 »

Same!
windaar wrote: Mon Sep 30, 2024 12:40 pm Paper, pencil, and calculator.
Onlineid3089
Posts: 959
Joined: Thu Jan 02, 2020 2:47 pm

Re: Which tool do you use to measure your asset allocation?

Post by Onlineid3089 »

Another Excel user here.
User avatar
Steelersfan
Posts: 4170
Joined: Thu Jun 19, 2008 8:47 pm

Re: Which tool do you use to measure your asset allocation?

Post by Steelersfan »

Vanguard Portfolio Watch.

I have few non-Vanguard investments and those don't change much so it works just fine for me.
tonyclifton
Posts: 1152
Joined: Sat Feb 08, 2020 4:25 pm

Re: Which tool do you use to measure your asset allocation?

Post by tonyclifton »

baconavocado wrote: Mon Sep 30, 2024 1:06 pm Quicken to generate a report which I then copy into an Excel worksheet with embedded formulas. It's a little clunky, takes me 2-3 minutes to put together, but it tells me what I need to know. I only break it down into 4 categories: domestic stocks, domestic bonds, intl stocks, intl bonds.
This describes exactly the tools I use and the general workflow. It took time to setup but using it is nothing more than copy-from-Quicken-paste-to-Excel and click refresh in Excel. Zero manipulation or reformatting of what is pasted is required.
User avatar
HomerJ
Posts: 21653
Joined: Fri Jun 06, 2008 12:50 pm

Re: Which tool do you use to measure your asset allocation?

Post by HomerJ »

Excel... Multiple sheets.

My current sheet goes back to 2013.. I haven't changed my investments much since then.

But I also have older sheets, where I still had individual stocks listed. They go back to 2006.

So almost 20 years of history now. Interesting to look back.
"The best tools available to us are shovels, not scalpels. Don't get carried away." - vanBogle59
peppers
Posts: 1658
Joined: Tue Oct 25, 2011 7:05 pm

Re: Which tool do you use to measure your asset allocation?

Post by peppers »

Being long in the tooth and gray in the beard I use paper, pencil and a calculator.
If nothing else it helps with my hand eye coordination.
"..the cavalry ain't comin' kid, you're on your own..."
User avatar
Regal 56
Posts: 551
Joined: Thu May 24, 2007 5:47 pm
Location: South Euclid, OH
Contact:

Re: Which tool do you use to measure your asset allocation?

Post by Regal 56 »

Dead Man Walking wrote:Although most Bogleheads would view a Morningstar subscription as an extravagant expense, I find it a good way to calculate my asset allocation and the value of my investments. I can enter the shares of mutual funds, stocks, treasuries, money market funds, savings account, etc. and the X-ray tool can calculate my asset allocation, show bond and stock style diversification, stock overlap in addition to the total value of my portfolio. I’ve spent more on a family dinner at exclusive restaurants than the cost of a Morningstar subscription. I enjoy some of the content that comes with the subscription.
T. Rowe Price offers a free Morningstar membership to clients who meet a certain investment threshold. Perhaps other investment companies do the same.
delamer
Posts: 18571
Joined: Tue Feb 08, 2011 5:13 pm

Re: Which tool do you use to measure your asset allocation?

Post by delamer »

(Have not read other comments.)

I use Quicken too, and I’m surprised about your comment that it is too granular.

My asset allocation report has just five categories: US stocks (large cap); US stocks (small/medium cap); International stocks: Bonds; Cash

We hold about 10 different index funds across six different accounts.

Are you using a boilerplate Quicken report, or have you created a report that meets your needs? All of my reports are modified versions of Quicken’s standards.
One thing that humbles me deeply is to see that human genius has its limits while human stupidity does not. - Alexandre Dumas, fils
DSBH
Posts: 815
Joined: Tue Jul 21, 2020 3:31 pm
Location: Texas

Re: Which tool do you use to measure your asset allocation?

Post by DSBH »

Primarily number of shares x prices for 3 fund portfolio in Excel - updated at end of each month - and double checked against Vanguard (where we have our tax-advantaged accounts) Portfolio Watch and triple-checked against Fidelity (where we have our taxable account) Portfolio Analysis.
John C. Bogle: "Never confuse genius with luck and a bull market".
sfyetter
Posts: 1
Joined: Sat Feb 11, 2017 8:19 pm

Re: Which tool do you use to measure your asset allocation?

Post by sfyetter »

I use Excel to manually track my shares and the Stock Connector Add-In to dynamically update share prices. That way I have a constantly updating view of my actual vs target allocation and know what to buy or sell for rebalancing.
Last edited by sfyetter on Tue Oct 01, 2024 11:34 am, edited 1 time in total.
User avatar
scotchbriar
Posts: 26
Joined: Thu Dec 08, 2022 9:01 pm
Location: Sawtooth Mountain Bunker

Re: Which tool do you use to measure your asset allocation?

Post by scotchbriar »

I use a Numbers spreadsheet, I'm a MAC guy, for AA. In the past I've tried to use some online tools but I find a spreadsheet works the best for me. As others have said, cut a paste information from your online brokerage/retirement accounts in the spreadsheet. I also like the fact that I can create my own charts/graphs and take into account items that might not play well when using something like Empower or Full View
Scotchbriar | | “Dependence begets subservience and venality, suffocates the germ of virtue, and prepares fit tools for the designs of ambition.” Thomas Jefferson
cnrohio59
Posts: 21
Joined: Sat Jul 11, 2020 3:06 pm
Location: Ohio

Re: Which tool do you use to measure your asset allocation?

Post by cnrohio59 »

Spreadsheet
50/50
Posts: 184
Joined: Wed Mar 13, 2019 9:16 am

Re: Which tool do you use to measure your asset allocation?

Post by 50/50 »

windaar wrote: Mon Sep 30, 2024 12:40 pm Paper, pencil, and calculator.
Me too.
Thou shalt take no risks that thou needest not take. Seek wisdom not knowledge. Knowledge is of the past; wisdom is of the future.
User avatar
wwhan
Posts: 670
Joined: Sat Mar 03, 2007 11:08 pm
Location: CA

Re: Which tool do you use to measure your asset allocation?

Post by wwhan »

I have a custom Excel spreadsheet to track asset allocation and total portfolio value, plus I use the Vanguard Portfolio Watch. They match pretty well.

I manually enter my Fidelity 401K account in the Vanguard Portfolio Watch.

When I update the spreadsheet (twice a year) I save a copy of it, so I have spreadsheets going back to 2005.
Last edited by wwhan on Tue Oct 01, 2024 3:43 pm, edited 2 times in total.
"Everything in Moderation, including Moderation"
friar1610
Posts: 2380
Joined: Sat Nov 29, 2008 8:52 pm
Location: MA South Shore

Re: Which tool do you use to measure your asset allocation?

Post by friar1610 »

Steelersfan wrote: Tue Oct 01, 2024 9:12 am Vanguard Portfolio Watch.

I have few non-Vanguard investments and those don't change much so it works just fine for me.
This ^

I manually update the non-Vanguard holdings on VG Portfolio Watch at the end of each quarter. And today’s the day to do that for Q3!
Friar1610 | 50-ish/50-ish
User avatar
Clever_Username
Posts: 2148
Joined: Sun Jul 15, 2012 12:24 am
Location: California

Re: Which tool do you use to measure your asset allocation?

Post by Clever_Username »

A spreadsheet is great. For non-proprietary funds, I keep the ticker and number of shares listed, and I update them periodically. For proprietary funds, and also Series I Bonds, I have to periodically update the balances. Then I have another sheet within that can tell me what percent, and how many dollars, are in stocks vs bonds, how much is in tax-deferred / Roth / brokerage / treasury, and even what levels of emergency finance I have in various forms (brokerage balance, Series I, governmental 457b balance, Roth contributions and past-the-clock conversions).
"What was true then is true now. Have a plan. Stick to it." -- XXXX, _Layer Cake_ | | I survived my first downturn and all I got was this signature line.
sailaway
Posts: 8998
Joined: Fri May 12, 2017 1:11 pm

Re: Which tool do you use to measure your asset allocation?

Post by sailaway »

I created an excel spreadsheet, but now use it as a Google sheet.

Follow on question: did retirement change your tracking procedures? We did updates twice a year, when RSUs vest because that was generally the largest influx and so a good time to rebalance. So much so, when the vesting schedule changed, we changed our dates. Thinking I might go to quarterly now that we don't have any such lump sums coming in.
schwank
Posts: 110
Joined: Sat Jul 18, 2015 1:14 pm

Re: Which tool do you use to measure your asset allocation?

Post by schwank »

Current AA and drift from a target is calculated in my personal spreadsheet on GDocs. However I don't rebalance as its something like 95 ITOT / 3 BND / 2 cash. I will start building the short term position a couple years ahead of retirement, but even then will remain aggressive by many BH standards.
User avatar
Stinky
Posts: 15424
Joined: Mon Jun 12, 2017 11:38 am
Location: Sweet Home Alabama

Re: Which tool do you use to measure your asset allocation?

Post by Stinky »

Dead Man Walking wrote: Mon Sep 30, 2024 7:38 pm Although most Bogleheads would view a Morningstar subscription as an extravagant expense, I find it a good way to calculate my asset allocation and the value of my investments. I can enter the shares of mutual funds, stocks, treasuries, money market funds, savings account, etc. and the X-ray tool can calculate my asset allocation, show bond and stock style diversification, stock overlap in addition to the total value of my portfolio. I’ve spent more on a family dinner at exclusive restaurants than the cost of a Morningstar subscription. I enjoy some of the content that comes with the subscription.

DMW
This is exactly why I also have a Morningstar subscription. I spend essentially nothing on managing my portfolio , so I feel
I can “splurge” on a Morningstar subscription.

One of the nice byproducts of using Morningstar is that the mobile app gives me access to their portfolio tool. So I’m able to check how much my portfolio “made” or “lost” every day from my phone by just opening the app.

There may be cheaper ways to do the same thing. But Morningstar sure makes it easy.
Last edited by Stinky on Wed Oct 02, 2024 5:44 am, edited 1 time in total.
Retired life insurance company financial executive who sincerely believes that ”It’s a GREAT day to be alive!”
YeahBuddy
Posts: 2907
Joined: Tue Oct 31, 2017 12:55 pm

Re: Which tool do you use to measure your asset allocation?

Post by YeahBuddy »

A calculator.
Light weight baby!
Post Reply