Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Old 07-03-2008, 07:15 AM   #21
Full time employment: Posting here.
 
Join Date: Feb 2006
Posts: 987
Quote:
Originally Posted by CitricAcid View Post
where do you get the information on how much the house is/should be worth? Zillow?
I use the services of Yodlee (along with downloads from Fidelity & Vanguard, however for different views/applications).

Yodlee does a direct download from Zillow, and if you wish, you can include your estimated home value in your net worth.

The reason I do different auto-downloads is that for Fidelity/Vanguard, I use their retirement tools for forecasting (e.g. Retirement Income Planner & Financial Engines).

I use Yodlee to give me an overall "estate net worth" which includes all my/DW's bank, credit card, investment accounts, and house value. While it's a "feel good number" (I don't include my home in my retirement forecast, but I understand if you do, based upon your personal situation) it's a good daily check on CC activity. For instance, I have three CC's, only one that I use. Since my DW/me travel several times a year, I have two in "reserve". Yodlee just lets me know that I have a zero balance, and makes sure that they are not used (nor my active account) on a daily basis as just a "sanity check".

BTW, Yodlee lets you select accounts for cosideration in your "net worth" computation. For instance, I'm legally responsible for my (disabled) son, so I do a download daily on his accounts (in the same sweep); however, this is not included in my estate net worth.

Yodlee is the engine that is used to download account info for Fidelity's "full view" service, so it is not necessarily only a stand alone product.

- Ron
rs0460a 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-04-2008, 11:30 AM   #22
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
It looks like I haven't overlooked any easy, complete way to do what I want to accomplish. I'll probably upgrade my automation slightly by using the approach bamsphd is using, then type all the stuff into Morningstar if I want to do some more analysis on the asset allocation part.

Thanks for the suggestions.
.
samclem is offline   Reply With Quote
Old 07-05-2008, 07:45 AM   #23
Recycles dryer sheets
gryffindor's Avatar
 
Join Date: Mar 2008
Posts: 51
I use Quicken with a few manual updates.

However, I believe that checking too frequently can be dangerous to your psyche.
Mathematically, the more often you check you more often your portfolio is likely to be negative (e.g., day to day volatility outweighs longer-term returns). If you don't have a strategy that requires you to adjust daily, why check? Over time I've worked from daily to weekly. Still working on going monthly instead.
__________________
Gryffindor
gryffindor is offline   Reply With Quote
Old 07-05-2008, 09:08 AM   #24
Thinks s/he gets paid by the post
grumpy's Avatar
 
Join Date: Jul 2004
Posts: 1,321
Quote:
Originally Posted by Dawg52 View Post
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.
I also use the Vanguard Linked Online Accounts function. It works pretty well most of the time but whenever one of my linked account web sites changes its login process (e.g. requires longer PW, adds additional security features, etc.) the auto update fails. Then I call Vanguard or submit an online request that they update their process. What I have found is that it can take weeks to months for them to fix their end of the process. This even applies to major sites like T.R. Price. I waited months for them to fix access to Lord Abbett They have to work through a third party software vendor that they use to download your data.

Because of these issues I also maintain my own spreadsheet. I have two portfolios set up in the WSJ web site (one for stocks, the other for funds). With two clicks I can export the closing prices in Excel format. I have a "prices" sheet in my spreadsheet with the holdings listed in the same order as the exported sheet. I copy and paste in the prices from the WSJ export into that sheet. All other price references in my spreadsheet point to the respective cell on the "prices" sheet. I also have an "allocation" sheet that displays the percentage of Large Cap, Mid Cap, Small Cap, International, Fixed Income and Cash. I spend twenty minutes every Saturday morning doing this update. I print any changed sheet and put it into a three ring binder which is my reference whenever I am deciding where to invest new $'s. I have been maintaining and expanding the spreadsheet for about 15 years and it has gotten quite large. At the end of the year I archive that year's sheet and begin updating a new copy. That allows me to do year to year comparisons and calculate annual returns, etc. This works well for me and I enjoy fiddling with it.
grumpy is offline   Reply With Quote
Old 07-05-2008, 09:22 AM   #25
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
Quote:
Originally Posted by grumpy View Post
. . . I also have an "allocation" sheet that displays the percentage of Large Cap, Mid Cap, Small Cap, International, Fixed Income and Cash.
How does the data from the first sheet (fund totals) get translated into the cells on the allocation sheet? Pasting entire fund totals into each allocation category would work if your funds were relatively "pure," but otherwise you'd need to break out each fund total into the various appropriate allocation buckets (e.g. Target Retirement 2025: X % to large cap, X% to small cap, X% to corp bonds, X% to REITS, etc). Do you do this?
samclem is offline   Reply With Quote
Old 07-05-2008, 09:40 AM   #26
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Google spreadsheet has a function called GoogleFinance(). I buit a straightforward spreadsheet on Google so I can get to it from any computer. Aside from the usual spreadsheet capabilities, Here are some attributes you can retrieve:

View a list of attributes for mutual funds.
  • closeYest: the NAV of a mutual fund.
  • date: date at which NAV (net asset value) was reported.
  • returnytd: year-to-date return total.
  • netassets: The day-end net assets of the mutual fund. Net-asset figures are useful in gauging a fund's size, agility, and popularity. They help determine whether a small company fund, for example, can remain in its investment-objective category if its asset base reaches an ungainly size.
  • change: change in NAV value between the most recent reported NAV, and the NAV prior to that.
  • changepct: the % change in the NAV.
  • yieldpct: Also known as the distribution yield, Morningstar computes this End Yield figure by summing the trailing 12-month's income distributions and dividing the sum by the last month's ending NAV, plus capital gains distributed over the same time period. Income refers only to interest payments from fixed-income securities and dividend payments from common stocks.
  • returnday: one-day total return.
  • return1: one-week total return.
  • return4: four-week total return.
  • return13: thirteen-week total return.
  • return52: 52 week total return.
  • return156: 156 week total return.
  • return 260: 260 week total return.
  • incomedividend: the amount of the most recent cash distribution for the fund.
  • incomedividenddate: the date the above occurred.
  • capitalgain: the amount of the most recent capital gain distribution from the fund.
  • capitalgaindate: the date of the above.
  • morningstarrating: the Morningstar "star" rating.
  • expenseratio: The percentage of fund assets used to pay for operating expenses and management fees, including 12b-1 fees, administrative fees, and all other asset-based costs incurred by the fund, except brokerage costs. Fund expenses are reflected in the fund's NAV. Sales charges are not included in the expense ratio.
If this is more than you need, I second the vote for Vanguard or Yodlee with outside account retrieval. Personally, I track the big indexes generically on my google home page, but as for my personal investments I just check my Vanguard with outside accounts once a month or so (mostly to make sure my automatic deposits went through). Used to check more frequently but that got boring fast.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Old 07-05-2008, 09:55 AM   #27
Thinks s/he gets paid by the post
 
Join Date: Apr 2006
Posts: 1,490
Quote:
Originally Posted by Rich_in_Tampa View Post
... Used to check more frequently but that got boring fast.
sometimes boring, sometimes exciting, sometimes frightening ...
d is offline   Reply With Quote
Old 07-05-2008, 10:42 AM   #28
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 35,712
Quote:
Originally Posted by CitricAcid View Post
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.
I use Microsoft Money to keep track of my portfolio, which I admit is a bit messy: 2 IRAs + 2 Roths + 2 Coverdell + 2 401k + 2 I-bond accts (self, wife, and 2 children), 1 bank account, 2 brokerage accounts, 3 MM accounts.

MS Money takes care of stock and mutual fund prices, while I update interest from I-bonds and MMs at the end of the month. As for house equities, I do not pay as much attention as I do not plan to sell them anytime soon, and they are such illiquid assets that one cannot use price info for much. On the other hand, knowing whether to shift around between other assets can get me a bit more money.

I look at my total everyday, but do not trade daily (I would if I knew how to make it work). I've been through the Great Crash of 2000-2002, watching my portfolio getting decimated, so am used to up-and-down. Perhaps part of my taking it well is that I am still working part-time and not living off that portfolio. It would be scary to draw on a dwindling account. I guess I better not piss off the pointy heads (Dilbert-boss) at the big corp I am with.
NW-Bound is offline   Reply With Quote
Old 07-05-2008, 11:11 AM   #29
Thinks s/he gets paid by the post
Free To Canoe's Avatar
 
Join Date: May 2008
Location: Cooksburg,PA
Posts: 1,873
Like many, I have several accounts at various places. Like "D" and others, I made a portfolio at Yahoo (for free) that updates daily. I copy it into my spreadsheet and that is it. I have added asset allocation and other things to the spreadsheet.
Free To Canoe is offline   Reply With Quote
Old 07-05-2008, 11:18 AM   #30
Thinks s/he gets paid by the post
grumpy's Avatar
 
Join Date: Jul 2004
Posts: 1,321
Quote:
Originally Posted by samclem View Post
How does the data from the first sheet (fund totals) get translated into the cells on the allocation sheet? Pasting entire fund totals into each allocation category would work if your funds were relatively "pure," but otherwise you'd need to break out each fund total into the various appropriate allocation buckets (e.g. Target Retirement 2025: X % to large cap, X% to small cap, X% to corp bonds, X% to REITS, etc). Do you do this?
Samclem,

I do have a balanced index fund (VBINX) that I split 60/40 (lg cap/fixed inc.) on the allocation sheet. Otherwise, I put each fund into a single allocation "bucket". While that is not totally accurate, it is close enough for my purposes. I keep my overall allocation to equities around 75% and am not too concerned about the split between small, mid, large or growth/value. We have been fully retired for four years now. Even with the current fall of the markets, our portfolio is still at approximately the same value as when we retired. During this period we bought a new house and a new car and have taken several nice vacations. Our withdrawal rate for regular expenses is well below 4% so I don't fiddle very much with our overall allocations.
grumpy is offline   Reply With Quote
Old 07-05-2008, 11:35 AM   #31
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 35,712
Quote:
Originally Posted by grumpy View Post
Samclem,

We have been fully retired for four years now. Even with the current fall of the markets, our portfolio is still at approximately the same value as when we retired. During this period we bought a new house and a new car and have taken several nice vacations. Our withdrawal rate for regular expenses is well below 4% so I don't fiddle very much with our overall allocations.
Well, I do not want to scare anybody, but can't help it...

Except for the difference that I am still working part-time (wife already ER), I also bought a 2nd home, a new car, and took several European and domestic vacations in the last 4 years (2-3 each year). And my children entered college too. Yet, my total net worth grows ... The reason was simple: We have been in a bull market since 2003.

But can it last? I sure hope it will, so that I can join my wife in ER and travel more. But until the smoke clears on the crude oil price, I am hunkering down a bit, but besides cancelling my annual Europe trip, don't know what else I could do, being frugal in all other areas.

I don't want to be a fear monger. Somebody, please tell me it's all hunky dory...
NW-Bound is offline   Reply With Quote
Old 07-05-2008, 11:56 AM   #32
Thinks s/he gets paid by the post
 
Join Date: Oct 2006
Posts: 4,629
Sam, you're not the last to do this manually. I enter the balances once a quarter into an Excel spreadsheet. I then print a hard copy for my wife (it's not real to her if the numbers are on a computer screen). She does the same kind of "reasonableness" check on the numbers that I do. I like to be sure that I know why the total moved the way it did, and I also like to know that we aren't running out of money.
Independent is offline   Reply With Quote
You asked for it -- you got it!
Old 07-05-2008, 12:11 PM   #33
Thinks s/he gets paid by the post
Gotadimple's Avatar
 
Join Date: Feb 2007
Posts: 2,605
You asked for it -- you got it!

Quote:
Originally Posted by NW-Bound View Post
Somebody, please tell me it's all hunky dory...
OK. It's hunky dory.

Happy days are here again
The skies above are clear again
Let us sing a song of cheer again
Happy days are here again
Altogether shout it now!
There's no one who can doubt it now
So let's tell the world about it now
Happy days are here again
Your cares and troubles are gone;
There'll be no more from now on
Happy days are here again
The skies above are clear again
Let us sing a song of cheer again
Happy days are here again


copyright 1929 Ager & Yellen

----------------------------
Sorry, I just couldn't help it!!!

-- Rita
__________________
Only got A dimple, would have preferred 2!
Gotadimple is offline   Reply With Quote
Old 07-05-2008, 12:13 PM   #34
Full time employment: Posting here.
 
Join Date: Feb 2006
Posts: 987
Quote:
Originally Posted by gryffindor View Post
If you don't have a strategy that requires you to adjust daily, why check? Over time I've worked from daily to weekly. Still working on going monthly instead.
Yodlee shows a overall net worth graph in monthly format for the last "x" months, so you can show your trend for a period that you select. In addition, it lists the actual net change data from the current/last month's data in detail.

- Ron
rs0460a is offline   Reply With Quote
Old 07-05-2008, 12:30 PM   #35
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
NW-Bound's Avatar
 
Join Date: Jul 2008
Posts: 35,712
Quote:
Originally Posted by gotadimple View Post
ok. It's Hunky Dory.

Happy Days Are Here Again
The Skies Above Are Clear Again
Let Us Sing A Song Of Cheer Again
Happy Days Are Here Again
Altogether Shout It Now!
There's No One Who Can Doubt It Now
So Let's Tell The World About It Now
Happy Days Are Here Again
Your Cares And Troubles Are Gone;
There'll Be No More From Now On
Happy Days Are Here Again
The Skies Above Are Clear Again
Let Us Sing A Song Of Cheer Again
Happy Days Are Here Again


Copyright 1929 Ager & Yellen

----------------------------
Sorry, I Just Couldn't Help It!!!

-- Rita

Thanks, I Needed That!
I knew someone would come through for me!
NW-Bound is offline   Reply With Quote
Old 07-05-2008, 07:51 PM   #36
Recycles dryer sheets
 
Join Date: Apr 2006
Posts: 143
Quote:
Originally Posted by CitricAcid View Post
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.
I've been keeping track of my house value and including it in my net worth. I update the house value number once a year. I updated the mortgage balance number once a month when I got my statement.

I've been guestimating its value by starting with the appraisal from refinancing a mortgage many years ago and then adjusting this number based on statistics about how much the median house price has changed year-to-year for the city or county where I live. I get the statistics from press releases published by the California Association of Realtors, although I notice different real estate organizations publish slightly different numbers for the same periods of time.

I should consider Zillow as a source of information and might convert over to it. I don't take the value of my house too seriously on grounds that it doesn't generate cash income for me. It will generate capital gains income for me someday if I decide to relocate, but I will likely reinvest the after-tax money in another home somewhere else.
rogersteciak is offline   Reply With Quote
Old 07-05-2008, 08:12 PM   #37
Recycles dryer sheets
 
Join Date: Apr 2006
Posts: 143
I used to use Yodlee many years ago, but stopped using it when it changed its format and completely messed up my account.

Most of my portfolio is with a major Wall Street brokerage firm, while some of it is with a 401K plan and some with an HSA. Once a week, I visit each online account and copy and paste the account balances into my spreadsheet, overwriting the numbers that my spreadsheet calculates to project my balances into the future. I also fetch the end-of-month numbers for the final monthly numbers.

The main advantage of this weekly and monthly update cycle is that I keep current on my financial net worth. I can look at a graph that goes out many years into the future and figure out if I'm going to run out of money before I die. My spreadsheet assumes I will live to be 120, which is the maximum theoretical lifespan for humans.
rogersteciak is offline   Reply With Quote
Old 07-05-2008, 08:27 PM   #38
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
Quote:
Originally Posted by rogersteciak View Post
IMy spreadsheet assumes I will live to be 120, which is the maximum theoretical lifespan for humans.
Not to pick a nit, but the maximum "theoretical" lifespan for humans is quite a bit older than 120.

There's at least one well-documented case of a French woman (Oldest people - Wikipedia, the free encyclopedia ) who lived to 122 years, 164 days. She would have run out of food 894 days early if she'd planed on only 120 years!

But, you point is still valid. Most of us are unlikely to see 120.
samclem is offline   Reply With Quote
Old 07-05-2008, 09:28 PM   #39
Recycles dryer sheets
 
Join Date: Apr 2006
Posts: 143
Quote:
Originally Posted by samclem View Post
Most of us are unlikely to see 120.
What leads me to use a high age as my postulated lifespan (for planning purposes) are the statistics that someone who reaches the age of 65 has a very good chance to living well into their 90s (which is referred to as "longevity risk" by the retirement professionals).

Even the IRS agrees and has published the required minimum distribution numbers for a traditional IRA (see Table 3 at the bottom of the page for tax publication 590 [Publication 590 (2007), Individual Retirement Arrangements (IRAs)]).

I saw a PBS program on the biotech revolution 10 years ago that said someone born a generation from now would have a life expectancy of 200 years (and be vibrant and healthy at that age also). I can only imagine the retirement planning challenges future generations will face if they have to live more than a century on their retirement income.

Unfortunately, most people alive today will not benefit much from biotech in terms of an increasing life span. But using a high number as one's postulated lifespan encourages one to set up a "perpetuity" that will maintain its inflation-adjusted purchasing power forever. Even though you can't benefit from having such a large amount of retirement assets, your heirs and favorite charities will certainly benefit.
rogersteciak is offline   Reply With Quote
Old 07-06-2008, 11:01 AM   #40
Thinks s/he gets paid by the post
 
Join Date: Feb 2007
Location: Upstate
Posts: 2,948
Quote:
Originally Posted by Rustward View Post
It will bring you closer to your data -- whether you like it or not.
Interesting that you say that. I have a spreadsheet (excel) where I automatically update the quotes at end of day. (I used to have it set up to do realtime updates using dde but found that to be a bit of a hassle.) In any case, I have quite a few holdings, and one of the things I miss about the old days of updating manually is that I now feel less "connected" to how a security is acting.
copyright1997reloaded 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 08:24 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.