How does everyone keep track of your portfolio?

Discuss all general (i.e. non-personal) investing questions and issues, investing news, and theory.
Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:13 pm

I created an excel spreadsheet with all of my fund/portfolio information. This includes the account (taxable, Roth, 401K, 403b etc), ticker, fund name, unit price, basis, amount, and expense ratio. Because I have several accounts, this has been really helpful for me to look at everything on one page.

The main problem is I manually entered in all the info. I logged into Fidelity, typed out all the info into excel and then moved onto the next account (Vanguard, then Schwab etc). So now I have to manually update the amounts and prices.

Or is there a way to make this easier, or even automated? I looked at google finance portfolio option, but it looks like this will be unavailable after November this year. I could also add accounts from other sites into my Fidelity account, but often this won't include ER, or other important info, or it won't link at all.

I don't know excel very well, but am trying to learn as much as I can.

User avatar
Toons
Posts: 12025
Joined: Fri Nov 21, 2008 10:20 am
Location: Hills of Tennessee

Re: How does everyone keep track of your portfolio?

Post by Toons » Sun Oct 15, 2017 2:14 pm

Quicken Software. :happy
"One does not accumulate but eliminate. It is not daily increase but daily decrease. The height of cultivation always runs to simplicity" –Bruce Lee

Cheyenne
Posts: 269
Joined: Sun Jun 14, 2015 6:46 am

Re: How does everyone keep track of your portfolio?

Post by Cheyenne » Sun Oct 15, 2017 2:16 pm

I tried the auto-update feature with Quicken 2017 for Mac but didn't like the way it worked so I also use an Excel spreadsheet that I made and an allocation spreadsheet that I found on here somewhere.

rrppve
Posts: 818
Joined: Sun Aug 12, 2012 12:35 am

Re: How does everyone keep track of your portfolio?

Post by rrppve » Sun Oct 15, 2017 2:16 pm

Fidelity full view will provide you with much of the information. I use Personal Capital to get frequent updates, as it's very easy to use as an app on phone or tablet.

retiredjg
Posts: 30592
Joined: Thu Jan 10, 2008 12:56 pm

Re: How does everyone keep track of your portfolio?

Post by retiredjg » Sun Oct 15, 2017 2:18 pm

I use a pencil and paper. Works for me. :wink:

livesoft
Posts: 56571
Joined: Thu Mar 01, 2007 8:00 pm

Re: How does everyone keep track of your portfolio?

Post by livesoft » Sun Oct 15, 2017 2:19 pm

I don't make very many transactions and don't own many different investments, thus I do not find manual entry a bother at all. So I use the free Microsoft Money Sunset Deluxe edition and manually enter information. I like all the different kinds of reports that I can generate with MS Money once everything is entered. I've been using this for more than 12 years now.

Some other things are discussed in this thread that shows screen captures, too:
viewtopic.php?t=150267
Last edited by livesoft on Sun Oct 15, 2017 2:19 pm, edited 1 time in total.
This signature message sponsored by sscritic: Learn to fish.

truenorth418
Posts: 309
Joined: Wed Dec 19, 2012 7:38 am

Re: How does everyone keep track of your portfolio?

Post by truenorth418 » Sun Oct 15, 2017 2:19 pm

Google spreadsheet. Links to all my funds and ETFs so I can see the portfolio value in real time.

sschullo
Posts: 2307
Joined: Sun Apr 01, 2007 8:25 am
Location: Rancho Mirage, CA
Contact:

Re: How does everyone keep track of your portfolio?

Post by sschullo » Sun Oct 15, 2017 2:19 pm

I have been using M* portfolio feature since 1994. All you have to do is create a free account, insert ticker and number of shares, and what you paid (not necessary but interesting). Has gazillion statistics, updates after the close of markets every day and is totally free.
You can download the portfolio at any time on your Excel program all intact for your records and with the different views you can also download the related statistics.
Public School K-12 Educators: "Ask NOT what your annuity sales person can do for you, ask what you can do to be a Do-It-Yourselfer (DIY)."


Mispoken
Posts: 41
Joined: Sat Apr 23, 2016 1:18 pm

Re: How does everyone keep track of your portfolio?

Post by Mispoken » Sun Oct 15, 2017 2:21 pm

Like you, I've created a pretty intricate spreadsheet. I've always been looking for a good software solution to this problem, but all I've tried have missed the mark. They're missing one feature or another that is too important to not make it worth keeping. Would love to hear some experiences of solution people have found. I always heard MS money was great, but a dead program. I've also heard quick books is good but the Mac version is not good. One particular calculation that's important to me is XIRR or modified internal rate of return. I haven't found anything yet that does this properly.

One thing I have been using to track cost basis is Gainskeeper.com but it doesn't track XIRR like I want. It will calculate taxes on sales.

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:28 pm

rrppve wrote:
Sun Oct 15, 2017 2:16 pm
Fidelity full view will provide you with much of the information. I use Personal Capital to get frequent updates, as it's very easy to use as an app on phone or tablet.
I have access to both these. I should look at these further as I'm probably just not aware of the full options and capabilities. Thanks!

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:30 pm

truenorth418 wrote:
Sun Oct 15, 2017 2:19 pm
Google spreadsheet. Links to all my funds and ETFs so I can see the portfolio value in real time.
When I tried this, the site posts

"Google Finance is under renovation. As a part of this process, the Portfolios feature won't be available after mid-November 2017. To keep a copy, download your portfolio."

Archimedes
Posts: 51
Joined: Wed Feb 15, 2017 11:27 am

Re: How does everyone keep track of your portfolio?

Post by Archimedes » Sun Oct 15, 2017 2:32 pm

Personal Capital tracks and updates your net worth on an ongoing basis for free. The software is quite good. And did I mention it is free?

The downside: They may have one of their financial advisors contact you to ask if you want to have them manage your investments for a fee, but there is no obligation to take their call or to accept their service.

In the past I used a spreadsheet, or Quicken. Now I only use Personal Capital. It’s a big leap forward for me.

Miriam2
Posts: 1747
Joined: Fri Nov 14, 2014 11:51 am

Re: How does everyone keep track of your portfolio?

Post by Miriam2 » Sun Oct 15, 2017 2:33 pm

retiredjg wrote: I use a pencil and paper. Works for me. :wink:
I use pencil & paper also - and a ruler to make my columns :happy It always seemed faster than trying to figure out a computer program, then type figures into columns.

However, now I know more and wish to keep better track of our asset allocation. How do you add, subtract & multiply the hand-written columns, especially with several accounts, then apply the correct math for percentages?

jebmke
Posts: 6866
Joined: Thu Apr 05, 2007 2:44 pm

Re: How does everyone keep track of your portfolio?

Post by jebmke » Sun Oct 15, 2017 2:35 pm

We moved everything to Vanguard. It is all there when I log in. I still track my cost basis for taxable holdings in Quicken (2012) but transaction volume is very low; I enter these manually.
When you discover that you are riding a dead horse, the best strategy is to dismount.

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:36 pm

Archimedes wrote:
Sun Oct 15, 2017 2:32 pm
Personal Capital tracks and updates your net worth on an ongoing basis for free. The software is quite good. And did I mention it is free?

The downside: They may have one of their financial advisors contact you to ask if you want to have them manage your investments for a fee, but there is no obligation to take their call or to accept their service.

In the past I used a spreadsheet, or Quicken. Now I only use Personal Capital. It’s a big leap forward for me.
Yeah I just logged into my Personal Capital account and didn't even realize they have my holdings already in there. It's not perfect, for instance I can't link Fidelity 401k, and all the funds are listed in alphabetical order instead of by account, but it's still better than what I thought I had access to. :sharebeer

JohnFiscal
Posts: 462
Joined: Mon Jan 06, 2014 4:28 pm
Location: USA

Re: How does everyone keep track of your portfolio?

Post by JohnFiscal » Sun Oct 15, 2017 2:37 pm

I also use Excel to keep track of all transactions and current value.

I have found the easiest thing for me to update daily prices (actually, I do this once a week, maybe more often) is to use a Google Sheet that uses Google functions to grab the prices (but Google seems to be almost a day behind updating these...disappointing). Then I just copy/paste into Excel. Takes a moment.

I have many "accounts" at Vanguard: Roths for my spouse and I, ditto IRAs, ditto taxable, and my inherited IRA. Each account might have several funds in it (up to 4-6), and these might be the same funds as in other accounts. It got to be a bookkeeping headache (I was in the mode of doing it myself, not depending on Vanguard). I wrote a 'script' in Excel (VBA) to make this (ever-so-much) easier: I download the Vanguard transactions monthly to a csv file (very easy on their site), then my script imports the transactions into my workbook, into the appropriate sheet and line. The script does a lot of other work as well automatically. What once was a tedious, painful, painstaking chore (and I would get confused and make errors) now takes less than a minute once the csv is open.

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:38 pm

Miriam2 wrote:
Sun Oct 15, 2017 2:33 pm
retiredjg wrote: I use a pencil and paper. Works for me. :wink:
I use pencil & paper also - and a ruler to make my columns :happy It always seemed faster than trying to figure out a computer program, then type figures into columns.

However, now I know more and wish to keep better track of our asset allocation. How do you add, subtract & multiply the hand-written columns, especially with several accounts, then apply the correct math for percentages?
This is where excel is very useful. Even with my limited excel knowledge, it is easy to add columns of numbers using the SUM function. The same can be done with percentages. Might be worth the time to try/learn it.

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:40 pm

JohnFiscal wrote:
Sun Oct 15, 2017 2:37 pm
I also use Excel to keep track of all transactions and current value.

I have found the easiest thing for me to update daily prices (actually, I do this once a week, maybe more often) is to use a Google Sheet that uses Google functions to grab the prices (but Google seems to be almost a day behind updating these...disappointing). Then I just copy/paste into Excel. Takes a moment.

I have many "accounts" at Vanguard: Roths for my spouse and I, ditto IRAs, ditto taxable, and my inherited IRA. Each account might have several funds in it (up to 4-6), and these might be the same funds as in other accounts. It got to be a bookkeeping headache (I was in the mode of doing it myself, not depending on Vanguard). I wrote a 'script' in Excel (VBA) to make this (ever-so-much) easier: I download the Vanguard transactions monthly to a csv file (very easy on their site), then my script imports the transactions into my workbook, into the appropriate sheet and line. The script does a lot of other work as well automatically. What once was a tedious, painful, painstaking chore (and I would get confused and make errors) now takes less than a minute once the csv is open.
This sounds great! Thanks! Exactly what I was hoping was possible. I'll look into it

Miriam2
Posts: 1747
Joined: Fri Nov 14, 2014 11:51 am

Re: How does everyone keep track of your portfolio?

Post by Miriam2 » Sun Oct 15, 2017 2:43 pm

Newone88 wrote:
Miriam2 wrote: I use pencil & paper also - and a ruler to make my columns :happy It always seemed faster than trying to figure out a computer program, then type figures into columns.

However, now I know more and wish to keep better track of our asset allocation. How do you add, subtract & multiply the hand-written columns, especially with several accounts, then apply the correct math for percentages?
This is where excel is very useful. Even with my limited excel knowledge, it is easy to add columns of numbers using the SUM function. The same can be done with percentages. Might be worth the time to try/learn it.
Thank you Newone88. I assume you are talking about plain old Excel that comes with our computer?

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 2:51 pm

yup, plain old excel. lets say you place a few numbers in columns a1, a2, and a3. Then if you go to a4 and type in =SUM, you can highlight a1-3 and press return. The sum will then be in a4. Sorry if that doesn't make sense. It should, once you play around with it a little bit.

dbr
Posts: 23711
Joined: Sun Mar 04, 2007 9:50 am

Re: How does everyone keep track of your portfolio?

Post by dbr » Sun Oct 15, 2017 2:58 pm

It would probably be useful to Google on functions in Excel. Functions are invoked when you type the '=' sign into a cell such as
=a1+a2 or =average(a1:15) and things of that nature.

furwut
Posts: 1253
Joined: Tue Jun 05, 2012 8:54 pm

Re: How does everyone keep track of your portfolio?

Post by furwut » Sun Oct 15, 2017 3:01 pm

jebmke wrote:
Sun Oct 15, 2017 2:35 pm
We moved everything to Vanguard. It is all there when I log in.
Same. I have a few outside accounts that I entered into Vanguard. All I really need is the 50,000 ft view.

chevca
Posts: 434
Joined: Wed Jul 26, 2017 11:22 am

Re: How does everyone keep track of your portfolio?

Post by chevca » Sun Oct 15, 2017 3:03 pm

The Vanguard site does fine for me.

I only have a couple accounts and can enter all that plus the savings stash in there to see the total. Just update it every two weeks when deferred comp. contributions get made and done.

User avatar
mickeyd
Posts: 4436
Joined: Fri Feb 23, 2007 3:19 pm
Location: Deep in the Heart of South Texas

Re: How does everyone keep track of your portfolio?

Post by mickeyd » Sun Oct 15, 2017 3:05 pm

I view my quarterly statements when they arrive in the mail and check my accounts @ VG at least annually after RMD. If they need tweaking I take care of it at that time. If not, I return to what I was doing.
Part-Owner of Texas | | “The CMH-the Cost Matters Hypothesis -is all that is needed to explain why indexing must and will work… Yes, it is that simple.” John C. Bogle

dbr
Posts: 23711
Joined: Sun Mar 04, 2007 9:50 am

Re: How does everyone keep track of your portfolio?

Post by dbr » Sun Oct 15, 2017 3:07 pm

You can Google for some Excel entries that download quotes such as at Yahoo and other web sites. Not all information can be automated but it should not be that big a burden unless your accounts are really complicated. The advantage of a spread sheet is just precisely that you can easily enter data manually in any way you choose whenever whatever application you are using can't do it or does it erroneously.

retiredjg
Posts: 30592
Joined: Thu Jan 10, 2008 12:56 pm

Re: How does everyone keep track of your portfolio?

Post by retiredjg » Sun Oct 15, 2017 3:19 pm

Miriam2 wrote:
Sun Oct 15, 2017 2:33 pm
retiredjg wrote: I use a pencil and paper. Works for me. :wink:
I use pencil & paper also - and a ruler to make my columns :happy It always seemed faster than trying to figure out a computer program, then type figures into columns.

However, now I know more and wish to keep better track of our asset allocation. How do you add, subtract & multiply the hand-written columns, especially with several accounts, then apply the correct math for percentages?
I don't use columns. In fact, I hardly even use a piece of paper - usually the corner of a stray scrap of paper. Perhaps my portfolio is simpler than yours?

Or, could you be using dollar amounts rather than percentages? That is way more trouble and more likely to cause a mistake.

Never, never, never transpose dollar amounts to a column on a piece of paper and then add up columns of dollar amounts. Always convert to percentages and then add. Just make sure the percentages add up to 100% before going further.

When I check my balances, I add up the total dollar amount (just 2 numbers - total as reported by Vanguard and total as reported by the TSP), then I figure out what percentage is in each fund and I write those down on my scrap of paper. In fact, that is the only thing I write down other than the total portfolio amount.

It will look something like 43% bonds, 3% bonds, 29% US, 4% US, 4% US, 10% foreign, 4% foreign, 3% bonds. That's about 8 positions in 3 accounts spread over 2 custodians. So all I've written down is 9 numbers.

Then I add together the 3 US fund percentages, the 2 international funds, and the 3 bond funds. Maybe I get something like 37% US, 14% Foreign, 49% bonds (to me all the bonds are just bonds - I don't care how much I have in each kind).

Then I check that against my goal which is 35% US, 15% Foreign, 50% bonds. Then I'm usually done. This takes about 10 minutes.

If I'm out of my rebalancing band....let's say by 2%.....then I figure out what 2% of the total is and move it from US stocks to any kind of bond fund or vice versa. I rarely have to adjust my Foreign stock amount. This might take another 5 minutes.

If you don't have a lot of custodians and a lot of funds, it should be just that easy. Feel free to PM me if you need more detailed information.

Broken Man 1999
Posts: 803
Joined: Wed Apr 08, 2015 11:31 am

Re: How does everyone keep track of your portfolio?

Post by Broken Man 1999 » Sun Oct 15, 2017 3:21 pm

furwut wrote:
Sun Oct 15, 2017 3:01 pm
jebmke wrote:
Sun Oct 15, 2017 2:35 pm
We moved everything to Vanguard. It is all there when I log in.
Same. I have a few outside accounts that I entered into Vanguard. All I really need is the 50,000 ft view.
Same here, also.

Our entire portfolio, including the savings bonds I manually value each month via Savings Bond Wizard and update total at Vanguard is presented in one screen. All accounts (taxable, TIRAs, Roth IRAs, Vanguard Annuity, savings bonds) are available to examine.

I really don't need anything else.

Broken Man 1999
“If I cannot drink Bourbon and smoke cigars in Heaven than I shall not go. " -Mark Twain

blueman457
Posts: 267
Joined: Sun Jul 26, 2015 12:19 pm

Re: How does everyone keep track of your portfolio?

Post by blueman457 » Sun Oct 15, 2017 3:41 pm

My wife and I have a number of investment accounts at different institutions (403b, 457s, 401a, Roth IRAs) and I STILL use a Excel spreadsheet to track prices and rebalance our asset allocation. I haven't figured out how to use the XIRR feature, so I technically don't know what my return is, but it's all in index funds so I figure I'm batting average.

Blue Man

Miriam2
Posts: 1747
Joined: Fri Nov 14, 2014 11:51 am

Re: How does everyone keep track of your portfolio?

Post by Miriam2 » Sun Oct 15, 2017 3:52 pm

retiredjg wrote:
Miriam2 wrote:
retiredjg wrote: I use a pencil and paper. Works for me. :wink:
I use pencil & paper also - and a ruler to make my columns :happy It always seemed faster than trying to figure out a computer program, then type figures into columns.
However, now I know more and wish to keep better track of our asset allocation. How do you add, subtract & multiply the hand-written columns, especially with several accounts, then apply the correct math for percentages?
I don't use columns. In fact, I hardly even use a piece of paper - usually the corner of a stray scrap of paper. Perhaps my portfolio is simpler than yours?

Or, could you be using dollar amounts rather than percentages? That is way more trouble and more likely to cause a mistake.

Never, never, never transpose dollar amounts to a column on a piece of paper and then add up columns of dollar amounts. Always convert to percentages and then add. Just make sure the percentages add up to 100% before going further.

When I check my balances, I add up the total dollar amount (just 2 numbers - total as reported by Vanguard and total as reported by the TSP), then I figure out what percentage is in each fund and I write those down on my scrap of paper. In fact, that is the only thing I write down other than the total portfolio amount.

It will look something like 43% bonds, 3% bonds, 29% US, 4% US, 4% US, 10% foreign, 4% foreign, 3% bonds. That's about 8 positions in 3 accounts spread over 2 custodians. So all I've written down is 9 numbers.

Then I add together the 3 US fund percentages, the 2 international funds, and the 3 bond funds. Maybe I get something like 37% US, 14% Foreign, 49% bonds (to me all the bonds are just bonds - I don't care how much I have in each kind).

Then I check that against my goal which is 35% US, 15% Foreign, 50% bonds. Then I'm usually done. This takes about 10 minutes.

If I'm out of my rebalancing band....let's say by 2%.....then I figure out what 2% of the total is and move it from US stocks to any kind of bond fund or vice versa. I rarely have to adjust my Foreign stock amount. This might take another 5 minutes.

If you don't have a lot of custodians and a lot of funds, it should be just that easy. Feel free to PM me if you need more detailed information.
Thank you retiredjg for your step-by-step! :happy Our accounts are not much more complicated than yours. We do however have Wellington and Wellesley in addition to Total Stock, so the percentages become a little more complicated.

I have to review this information more carefully, but need to do outside work now :annoyed

livesoft
Posts: 56571
Joined: Thu Mar 01, 2007 8:00 pm

Re: How does everyone keep track of your portfolio?

Post by livesoft » Sun Oct 15, 2017 3:56 pm

Mispoken wrote:
Sun Oct 15, 2017 2:21 pm
. I always heard MS money was great, but a dead program. I've also heard quick books is good but the Mac version is not good. One particular calculation that's important to me is XIRR or modified internal rate of return. I haven't found anything yet that does this properly.
MS Money is not dead, but it is not supported. Big difference. MSMoney does XIRR() perfectly well.
This signature message sponsored by sscritic: Learn to fish.

User avatar
Thrifty Femme
Posts: 277
Joined: Sun Apr 12, 2015 1:54 pm

Re: How does everyone keep track of your portfolio?

Post by Thrifty Femme » Sun Oct 15, 2017 3:59 pm

Newone88 wrote:
Sun Oct 15, 2017 2:36 pm

Yeah I just logged into my Personal Capital account and didn't even realize they have my holdings already in there. It's not perfect, for instance I can't link Fidelity 401k, and all the funds are listed in alphabetical order instead of by account, but it's still better than what I thought I had access to. :sharebeer
You can connect your Fidelity 401k by searching for netbenefits and logging in. Also you edit the names to get the names to show up in the order you want.

Jack FFR1846
Posts: 5750
Joined: Tue Dec 31, 2013 7:05 am

Re: How does everyone keep track of your portfolio?

Post by Jack FFR1846 » Sun Oct 15, 2017 4:01 pm

I'm another Excel user. I manually update values for each fund and it automatically updates my cost, asset allocations, and such.
Bogle: Smart Beta is stupid

Johnsson
Posts: 42
Joined: Mon Jul 17, 2017 2:28 pm

Re: How does everyone keep track of your portfolio?

Post by Johnsson » Sun Oct 15, 2017 4:13 pm

Ditto on the Excel. Data entry on the 1st of the month (or so) with auto calculations for rebalancing.

Several tabs... plus list of accounts w/login info, projections, IPS ... all for DW to ponder and/or throw away when I'm gone.

radiowave
Posts: 1260
Joined: Thu Apr 30, 2015 5:01 pm

Re: How does everyone keep track of your portfolio?

Post by radiowave » Sun Oct 15, 2017 4:17 pm

+1 on Excel as well. I usually update it around the 15th of each month to let expenses and tax deferred account settle. I have a YTD and comparison with prior years tab, a retirement simulator which links to current year, and save each past year worksheet. I have a "what if" simulator to look at different early retirement possibilities.
Bogleheads Wiki: https://www.bogleheads.org/wiki/Main_Page

flight
Posts: 17
Joined: Fri Sep 22, 2017 9:52 pm

Re: How does everyone keep track of your portfolio?

Post by flight » Sun Oct 15, 2017 4:27 pm

If you are looking for a software option, try fundmanagersoftware.com. For $99 one-time fee, there is a subscription to a personal version (professional version available too). It downloads transactions (buy, sell, dividends, etc) from brokerages and internet retrieves prices, and you can run reports/graphs around time-weighted returns, portfolio value, asset allocation and many things like that. Can be done at the portfolio level or individual security level, and you can dimension between IRAs, taxable accounts, or however you want.

Helo80
Posts: 436
Joined: Sat Apr 29, 2017 8:47 pm

Re: How does everyone keep track of your portfolio?

Post by Helo80 » Sun Oct 15, 2017 4:43 pm

I log on to Vanguard and Fidelity... and make sure "It's all good!" and then log off.

I've thought about writing a few macros and vb scripts to mine the *.csv data pulls you can sometimes download from these mutual fund brokers, but it's too much work. I guess it would be cool to track how the money grows from day to day and week to week, but that's too much work for too little gain IMHO. Grand scheme of things, I'm throwing money at different investment buckets and basically never sell the shares for a profit or loss as I hold investments for long periods of times.

rst113
Posts: 10
Joined: Fri Apr 30, 2010 10:50 am

Re: How does everyone keep track of your portfolio?

Post by rst113 » Sun Oct 15, 2017 6:59 pm

I also use a pretty elaborate google spreadsheet that pulls in all the fund prices from all of my accounts and also calculates my asset allocation and tells me how far off I am at any given moment. When my threshold is met to rebalance it is easy to see. Once a month I update the share quantities by downloading the .csv files and pasting that information into a separate google sheet for each account (the main spreadsheet is set to update the share quantities based on the values in each accounts separate sheet). I also then use longinvest's awesome return spreadsheet to let me see my overall returns as I have not quite figured out how to do it otherwise myself. I usually update that every month or so. All in all it probably requires about 30 minutes worth of effort a month to gather all the necessary information. The return spreadsheet is in this thread: viewtopic.php?t=150025

munemaker
Posts: 2107
Joined: Sat Jan 18, 2014 6:14 pm

Re: How does everyone keep track of your portfolio?

Post by munemaker » Sun Oct 15, 2017 7:05 pm

As far as I know,"everyone" is not keeping track of my portfolio; I hope I am the only one.

I personally use aggregators...Vanguard, Fidelity and Personal Capital.

User avatar
Sandtrap
Posts: 2377
Joined: Sat Nov 26, 2016 6:32 pm
Location: Hawaii😀 Northern AZ.😳

Re: How does everyone keep track of your portfolio?

Post by Sandtrap » Sun Oct 15, 2017 7:15 pm

furwut wrote:
Sun Oct 15, 2017 3:01 pm
jebmke wrote:
Sun Oct 15, 2017 2:35 pm
We moved everything to Vanguard. It is all there when I log in.
Same. I have a few outside accounts that I entered into Vanguard. All I really need is the 50,000 ft view.
+1
I consolidated everything in Vanguard and a little still in Schwab. Both are easy to monitor when logging in.
I sleep well with the 50,000 feet view.
Like watching paint dry :D

AlohaJoe
Posts: 2558
Joined: Mon Nov 26, 2007 2:00 pm
Location: Saigon, Vietnam

Re: How does everyone keep track of your portfolio?

Post by AlohaJoe » Sun Oct 15, 2017 7:17 pm

Newone88 wrote:
Sun Oct 15, 2017 2:30 pm
truenorth418 wrote:
Sun Oct 15, 2017 2:19 pm
Google spreadsheet. Links to all my funds and ETFs so I can see the portfolio value in real time.
When I tried this, the site posts

"Google Finance is under renovation. As a part of this process, the Portfolios feature won't be available after mid-November 2017. To keep a copy, download your portfolio."
Google spreadsheet and Google Finance are different things. Google Sheets is unchanged and has functions to get real-time prices.

CarlZ993
Posts: 198
Joined: Tue Feb 20, 2007 3:00 pm
Location: Austin, Texas

Re: How does everyone keep track of your portfolio?

Post by CarlZ993 » Sun Oct 15, 2017 8:05 pm

I play around with both Excel & Google Sheets to keep up with my portfolio. I occasionally have problems printing my GoogleSheets results. Don't know why. I really like the lookup function for a mutual fund in Googlesheets: =googlefinance(Cell reference with stock symbol, "price"). The only thing I have to update is the number of fund shares. Another cell has the formula to multiply the price X the number of shares for the total.
Carl Z

User avatar
Taylor Larimore
Advisory Board
Posts: 26125
Joined: Tue Feb 27, 2007 8:09 pm
Location: Miami FL

Re: How does everyone keep track of your portfolio?

Post by Taylor Larimore » Sun Oct 15, 2017 8:30 pm

Bogleheads:

My three funds are with Vanguard.

I check my asset-allocation and balances once or twice a year (for fraud, error and activity) on the Vanguard website and also when I receive my annual statement.

Vanguard website and statements provide much more information than I can possibly use.

That's it :happy

Best wishes.
Taylor
"Simplicity is the master key to financial success." -- Jack Bogle

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 8:38 pm

Taylor Larimore wrote:
Sun Oct 15, 2017 8:30 pm
Bogleheads:

My three funds are with Vanguard.

I check my asset-allocation and balances once or twice a year (for fraud, error and activity) on the Vanguard website and also when I receive my annual statement.

Vanguard website and statements provide much more information than I can possibly use.

That's it :happy

Best wishes.
Taylor
I love the simplicity. It may take me awhile to get there, but that's what I strive for.

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 8:44 pm

AlohaJoe wrote:
Sun Oct 15, 2017 7:17 pm

Google spreadsheet and Google Finance are different things. Google Sheets is unchanged and has functions to get real-time prices.
Thanks for clarifying this.

Newone88
Posts: 38
Joined: Sat Oct 07, 2017 3:26 pm

Re: How does everyone keep track of your portfolio?

Post by Newone88 » Sun Oct 15, 2017 8:45 pm

rst113 wrote:
Sun Oct 15, 2017 6:59 pm
I also use a pretty elaborate google spreadsheet that pulls in all the fund prices from all of my accounts and also calculates my asset allocation and tells me how far off I am at any given moment. When my threshold is met to rebalance it is easy to see. Once a month I update the share quantities by downloading the .csv files and pasting that information into a separate google sheet for each account (the main spreadsheet is set to update the share quantities based on the values in each accounts separate sheet). I also then use longinvest's awesome return spreadsheet to let me see my overall returns as I have not quite figured out how to do it otherwise myself. I usually update that every month or so. All in all it probably requires about 30 minutes worth of effort a month to gather all the necessary information. The return spreadsheet is in this thread: viewtopic.php?t=150025
Thanks for the link to that return spreadsheet!

NYCguy
Posts: 192
Joined: Sun Nov 13, 2016 12:42 pm

Re: How does everyone keep track of your portfolio?

Post by NYCguy » Sun Oct 15, 2017 8:52 pm

I am a long-time happy Quicken user.
If your out-go is greater than your income, your upkeep will be your DOWNFALL.

User avatar
digarei
Posts: 664
Joined: Sat Jul 05, 2014 1:41 am
Location: Sacramento
Contact:

Re: How does everyone keep track of your portfolio?

Post by digarei » Sun Oct 15, 2017 9:41 pm

I have an Excel spreadsheet that has grown in complexity and girth since its creation in 2003 but still requires less than one hour per year to update. 30 funds over three accounts, the balances of which are manually transcribed to paper, then into cells, before shredding. Updated whenever but invariably at least once a quarter. I copy figures to a year over year summary worksheet once per calendar year.

Everything I need is automated in real time from entry of those figures... aggregating funds across appropriate asset classes, into a worksheet that evaluates asset weighting (stocks vs. bonds, large vs. small, value vs. growth, % real estate, domestic vs. international, etc.) against the bands specificied on my IPS worksheet.

Decisions about rebalancing are made from these analyses and documented on a separate tab. All one spreadsheet. No automation, which has proven problematic in the past (web sites change, order of funds change, passwords change.) Maintaining a wall of separation between my online accounts info and my spreadsheet has had another benefit: the act of writing fund balances has sharpened my overall financial awareness.
Connect with Bogleheads in Northern California! Click the link under my user info/avatar.

User avatar
serbeer
Posts: 1062
Joined: Fri Dec 28, 2007 2:09 pm

Re: How does everyone keep track of your portfolio?

Post by serbeer » Sun Oct 15, 2017 9:43 pm

Fidelity has FullView tool that allows you to keep track of all accounts, including the ones external to Fidelity

dcop
Posts: 23
Joined: Fri Sep 08, 2017 6:06 pm

Re: How does everyone keep track of your portfolio?

Post by dcop » Sun Oct 15, 2017 9:51 pm

Excel spread sheet. I can write code with Autoit and VBA so I make a listing in Yahoo portfolios and with my code I get the listing from Yahoo and write it to excel. This includes my mutual funds and equities. So...I can update my worth by the minute, day or week. If I didn't know how to write code I would use the export feature to download a .csv from yahoo then just copy and paste into my spreadsheet.

Post Reply