Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Automatic tracking of investment balances
Old 07-02-2008, 01:45 PM   #1
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
samclem's Avatar
 
Join Date: May 2004
Location: SW Ohio
Posts: 14,404
Automatic tracking of investment balances

Based on the posts here, it seems many folks know daily exactly what their investment balances and allocations are. I suppose I'm the last person alive who still does this manually. Present procedure: log into each web site (Vanguard, Fidelity, my bank) and write the numbers into a notebook. Go to the Traesury site and try to estimate what my I-Bonds might be worth. If I'm feeling industrious, take all this and enter it manually into my (always out-of-date) Morningstar portfolio tracker and run an X-ray on it and apply other tools to see how my allocation is going, then re-balance as necessary.

I guess it's clear why I only do this annually. Sometimes not even that often.

I've searched the archives here, went to the fatwallet site recommended CFB in a previous post, and poked around a little, and still haven't found any easy-to-use software or web site that will do everything for me. The biggest glitch seems to be the auto-download of info from the financial services companies.

Am I missing some simple, no-fuss approach to all of this? I'm subscribed to the Morningstar Premium service, so I might explore that route a little more. I don't need/want to know my account balances every day, but I think I'm too far at the other end of the spectrum now.
samclem is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 07-02-2008, 02:01 PM   #2
Full time employment: Posting here.
 
Join Date: Jan 2007
Posts: 582
Well, you're not the last one, I'm holding out too! We're still in the accumulation phase, so checking everything once or twice a year is fine for me.

I did try out Quicken for a couple months, and once it was set up it would auto-download everything from Vanguard, etc., although I don't know that it could do Treasury stuff. I hated using it, though, so I'm happily back to pencil and paper.
__________________

WM is offline   Reply With Quote
Old 07-02-2008, 02:06 PM   #3
Thinks s/he gets paid by the post
 
Join Date: Apr 2006
Posts: 1,490
with either Morningstar or Yahoo you can construct a portfolio listing all your mutual funds, which is updated every day. i simply take the $/share and copy it onto a spreadsheet which has the share information. for your i-bonds, you could easily estimate the value on your spreadsheet using the date functions as the interest rates are known.
d is offline   Reply With Quote
Old 07-02-2008, 02:07 PM   #4
Recycles dryer sheets
Abreutime's Avatar
 
Join Date: Jan 2008
Posts: 325
I signed up for yodlee.com recently, and it works pretty well. It's a free site, and it can track your balances for you. Pretty neat seeing your net worth easily updated.
Abreutime is offline   Reply With Quote
Old 07-02-2008, 02:09 PM   #5
Thinks s/he gets paid by the post
maddythebeagle's Avatar
 
Join Date: Jun 2005
Posts: 2,450
I dont want to check daily....I long used the yahoo portfolio for my taxable investments and can download the prices into my spreadsheet, but who would want to do that right now, anyway...
__________________
- Hurry! to the cliffs of insanity!
maddythebeagle is offline   Reply With Quote
Old 07-02-2008, 02:24 PM   #6
Recycles dryer sheets
bamsphd's Avatar
 
Join Date: Nov 2005
Posts: 337
Quote:
Originally Posted by samclem View Post
.. and still haven't found any easy-to-use software or web site that will do everything for me. The biggest glitch seems to be the auto-download of info from the financial services companies.
It won't do "everything." However, if you also want FREE, login to your Vanguard account, then click "Go to Accounts & Activity" under balances on your home page. Next scroll to near the bottom where you will see "Outside Investments — Linked Online Accounts" and use "Add Accounts" to add most, possibly all, of your non-Vanguard accounts.

It is certainly not perfect. For example it thinks the stock I have at ETrade is worth exactly $1/share every day, and that my balance fluctuates, while the truth is the price/share fluctuates. It also does not give any history, or any intelligence about my asset allocation.

However, it will let you go to a single page and see your "current" balance for all the accounts you register. That is not everything you wanted, but it is simple and might be good enough. It has been good enough that I have not bothered to re-purchase Quicken since my last copy's download support expired. It is also a lot less work than reconciling Quicken accounts. I do sometimes miss Quicken's bells and whistles, especially history. However, Vanguard's summary gives me a pretty good idea of how depressed I need to be each day, and that is generally sufficient for me.
bamsphd is offline   Reply With Quote
Old 07-02-2008, 02:29 PM   #7
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Nov 2007
Posts: 7,746
Not using pen and paper, but I do use a spreadsheet. Manually logging in to 5 investment accounts or so isn't that hard. I only do a full "financial statement" quarterly, and it might take an hour or two. Maybe 4 if I had a particularly exciting quarter with lots of activity. I've found the automated services to be lacking in some regard and they require more time to set up, configure, troubleshoot, and maintain than if I just do it manually. With automated programs, there is always the chance that I'm not getting the real numbers. With manual entry, I see exactly what the account custodian shows me w/o any intermediary potentially screwing something up.

I'm still accumulating, so it is helpful to see how I am doing from time to time, but I don't really need to know it day to day or even month to month. I have better things to do!
FUEGO is offline   Reply With Quote
Old 07-02-2008, 03:01 PM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
clifp's Avatar
 
Join Date: Oct 2006
Posts: 7,733
In this market I wish Schwab, Morningstar, and Vanguard didn't automatically show me current liquid net worth.

It isn't fun to see red numbers most days.
clifp is offline   Reply With Quote
Old 07-02-2008, 04:06 PM   #9
Moderator Emeritus
W2R's Avatar
 
Join Date: Jan 2007
Location: New Orleans
Posts: 47,468
My favorite part of the day (even this past week) is the first 10-15 minutes over coffee when I manually check Vanguard, the TSP, and my bank manually and enter the numbers into Excel to get my portfolio size and my net worth.

OK, I know.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.

Happily retired since 2009, at age 61. Best years of my life by far!
W2R is online now   Reply With Quote
Old 07-02-2008, 04:14 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
ziggy29's Avatar
 
Join Date: Oct 2005
Location: North Oregon Coast
Posts: 16,483
Quote:
Originally Posted by Want2retire View Post
My favorite part of the day (even this past week) is the first 10-15 minutes over coffee when I manually check Vanguard, the TSP, and my bank manually and enter the numbers into Excel to get my portfolio size and my net worth.
And then your monitor runs out of red pixels...
__________________
"Hey, for every ten dollars, that's another hour that I have to be in the work place. That's an hour of my life. And my life is a very finite thing. I have only 'x' number of hours left before I'm dead. So how do I want to use these hours of my life? Do I want to use them just spending it on more crap and more stuff, or do I want to start getting a handle on it and using my life more intelligently?" -- Joe Dominguez (1938 - 1997)
ziggy29 is offline   Reply With Quote
Old 07-02-2008, 04:16 PM   #11
Thinks s/he gets paid by the post
jIMOh's Avatar
 
Join Date: Apr 2007
Location: west bloomfield MI
Posts: 2,223
I write down my balances on Dec 31 into a spreadsheet, and then the spreadsheet calculates my annual return for each account and total portfolio.

Other than that, I only look at account balanced and allocations two other times during year (June and December) when I rebalance.
__________________
Light travels faster than sound. That is why some people appear bright until you hear them speak. One person's stupidity is another person's job security.
jIMOh is offline   Reply With Quote
Old 07-02-2008, 04:21 PM   #12
Thinks s/he gets paid by the post
2B's Avatar
 
Join Date: Mar 2006
Location: Houston
Posts: 4,337
"Bless me father for I have....."

I update every day and I know it's wrong, wrong, wrong. It elevates my blood pressure and gives me useless angst.

I wish I would only check every month, quarter, year or longer. Quicken needs to go.
__________________
The object of life is not to be on the side of the majority, but to escape finding oneself in the ranks of the insane -- Marcus Aurelius
2B is offline   Reply With Quote
Old 07-02-2008, 04:44 PM   #13
Moderator Emeritus
Nords's Avatar
 
Join Date: Dec 2002
Location: Oahu
Posts: 26,855
Quote:
Originally Posted by 2B View Post
I update every day and I know it's wrong, wrong, wrong. It elevates my blood pressure and gives me useless angst.
I enter every transaction manually in Quicken. At the end of the month I also enter every dividend/interest/cap gain number in a tax-tracking spreadsheet. After nearly 16 years it's hard to stop.

Yeah, it's fun to cackle like Montgomery Burns when it's going up. But it's a PITA whether the market's going up or down.

If there's a benefit to the process, it's that occasionally I'll look at a number, wonder about it, and come up with a new financial idea. It's the same way that changing the oil on your car gives you a chance to look the vehicle over and think about what other maintenance needs doing.
__________________
*

Co-author (with my daughter) of “Raising Your Money-Savvy Family For Next Generation Financial Independence.”
Author of the book written on E-R.org: "The Military Guide to Financial Independence and Retirement."

I don't spend much time here— please send a PM.
Nords is offline   Reply With Quote
Old 07-02-2008, 05:00 PM   #14
Moderator Emeritus
W2R's Avatar
 
Join Date: Jan 2007
Location: New Orleans
Posts: 47,468
Quote:
Originally Posted by ziggy29 View Post
And then your monitor runs out of red pixels...
Hey, there was a green one in there this morning! VTSAX sitting there all by its little lonesome and up 11 cents... Tomorrow morning I will try to just be philosophical.

I think it's probably harder to do this every day after ER, but I am still working and spending less than half. That helps.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.

Happily retired since 2009, at age 61. Best years of my life by far!
W2R is online now   Reply With Quote
Old 07-02-2008, 05:44 PM   #15
Moderator Emeritus
 
Join Date: May 2007
Posts: 12,890
I use Quicken and auto-download all transactions from the web daily. But I don't like the asset allocation tool on Quicken (too few asset classes for my taste), so I plug in my portfolio manually into Morningstar and run X-ray on it to determine my AA, and I use my own XL spreadsheet to rebalance my portfolio.
FIREd is offline   Reply With Quote
Old 07-02-2008, 07:10 PM   #16
Thinks s/he gets paid by the post
Rustward's Avatar
 
Join Date: Apr 2006
Posts: 1,684
Quote:
Originally Posted by Nords View Post
I enter every transaction manually in Quicken.
... and I thought I was the only one that did this ...
Do it for all expenses, also.

It will bring you closer to your data -- whether you like it or not.
Rustward is offline   Reply With Quote
Old 07-02-2008, 10:31 PM   #17
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 4,366
I update in Quicken weekly. I downlad that data into a spreadsheet to track week-to-date gains/losses. Hopefully I'll get bored with this soon. I'm almost all in funds now, so at least I'm not watching stock prices all day! I may get to the point where weekly or monthly works for me. I don't think I could do yearly.
Animorph is offline   Reply With Quote
Old 07-03-2008, 05:31 AM   #18
Moderator Emeritus
W2R's Avatar
 
Join Date: Jan 2007
Location: New Orleans
Posts: 47,468
Quote:
Originally Posted by ziggy29 View Post
And then your monitor runs out of red pixels...
Quote:
Originally Posted by Want2retire View Post
Hey, there was a green one in there this morning! VTSMX sitting there all by its little lonesome and up 11 cents... Tomorrow morning I will try to just be philosophical.

I think it's probably harder to do this every day after ER, but I am still working and spending less than half. That helps.
Even this morning there was a green pixel in there - - VFSTX (short term investment grade bond fund) went up a penny. The rest look a little dismal so I try to remember that the equity funds are only there to combat long term inflation. Besides, I got through childbirth thirty years ago with no bad aftereffects, so I can certainly withstand the pain of a down market now that I am older and (supposedly) wiser.

Weeks like this do tend to shake one's faith in the market. When that has happened in the past, later I usually wish I had bought. If the market is down another 100+ points by noon today I just might give in to my market-timer impulses and buy some more VTSAX and VFWIX.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.

Happily retired since 2009, at age 61. Best years of my life by far!
W2R is online now   Reply With Quote
Old 07-03-2008, 06:19 AM   #19
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Dawg52's Avatar
 
Join Date: Feb 2005
Location: Central MS/Orange Beach, AL
Posts: 9,067
Quote:
Originally Posted by bamsphd View Post
It won't do "everything." However, if you also want FREE, login to your Vanguard account, then click "Go to Accounts & Activity" under balances on your home page. Next scroll to near the bottom where you will see "Outside Investments — Linked Online Accounts" and use "Add Accounts" to add most, possibly all, of your non-Vanguard accounts.
That's what I do with my Fidelity account. Simply download all your other outside accounts and walla! All summarized for you on one page. Easy way to get a quick summary of your entire portfolio along with pie charts and the rest. Only problem is my laptop is not holding up very well to all the tears seeping through the keyboard.
__________________
Retired 3/31/2007@52
Investing style: Full time wuss.
Dawg52 is offline   Reply With Quote
Old 07-03-2008, 06:44 AM   #20
Full time employment: Posting here.
CitricAcid's Avatar
 
Join Date: May 2008
Posts: 546
Just wondering, do most of you guys calculate your house equity as part of your net worth, and if you do, where do you get the information on how much the house is/should be worth? Zillow? I think it would be cool to braek down your entire net worth including net worth into the various "investments" you have, but was just wondering if anyone else ever does that.
CitricAcid is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Credit Card Balances: Min Payment = How long to pay off? samclem FIRE and Money 10 06-20-2008 07:36 AM
Interest Rate Reduction Automatic Call TromboneAl Other topics 7 04-05-2008 05:54 PM
Automatic reinvestment Tiger FIRE and Money 17 12-22-2007 04:30 PM
Can Vanguard update Emigrant Direct balances? free4now FIRE and Money 7 10-09-2007 12:16 PM
Automatic payments from a money market (savings) account a FIRE and Money 4 04-07-2007 12:14 PM

» Quick Links

 
All times are GMT -6. The time now is 10:31 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.