Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Old 04-18-2017, 03:59 PM   #41
Thinks s/he gets paid by the post
 
Join Date: Jul 2011
Posts: 1,281
Quote:
Originally Posted by Ian S View Post
Personal Capital appears to lack a function to download your data. I prefer SigFig which does have that ability. However, the latter is really only geared for investment monitoring but that's of most interest to me.
Hmm, it downloads (updates) my accounts several times per day. I am not a client of their investment service. I use the free online service. I do get online requests to become a client and some unsolicited advice. But no calls.

I like that it provides a quick net worth statement. And, yesterday, I played around to see how accurate the gain/loss percentage for the 1st quarter was vs. the broker accounts and the data was very close.
savory 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 04-18-2017, 04:26 PM   #42
Recycles dryer sheets
 
Join Date: Nov 2011
Posts: 182
Quote:
Originally Posted by pb4uski View Post
Quicken... and I then import my positions into an Excel spreadsheet that I use to analyze my AA in relation to my target AA and what, if any, adjustment that I need to make.
+1 This is what I do as well.
__________________
FIREd 2012 at Age 49
523HRR is offline   Reply With Quote
Old 04-18-2017, 07:11 PM   #43
Thinks s/he gets paid by the post
 
Join Date: Aug 2014
Location: Red Rock Country
Posts: 1,915
Quote:
Originally Posted by davef View Post
Hmm, it downloads (updates) my accounts several times per day. I am not a client of their investment service. I use the free online service. I do get online requests to become a client and some unsolicited advice. But no calls.
Sorry, I meant that I can't download their data in spreadsheet format to my computer. SigFig allows you to download a csv file which can be easily opened in Excel. I also get calls from P.C. every month or two.
Ian S is online now   Reply With Quote
Old 04-18-2017, 07:20 PM   #44
Thinks s/he gets paid by the post
 
Join Date: Sep 2006
Posts: 2,840
Excel
Running_Man is offline   Reply With Quote
Old 04-18-2017, 09:45 PM   #45
Moderator
sengsational's Avatar
 
Join Date: Oct 2010
Posts: 10,656
Excel for me too. I wrote some code that pulls each institutions holdings, then some offline code that gets each position in a uniform layout, easy to pull into various Excel sheets.

Nobody commented, but I shared an asset allocation sheet a while back https://www.early-retirement.org/for...ml#post1632582
sengsational is online now   Reply With Quote
Old 04-18-2017, 09:51 PM   #46
Thinks s/he gets paid by the post
Fedup's Avatar
 
Join Date: Mar 2014
Location: Southern Cal
Posts: 4,032
I only do this once a year. Not too complicated. I like the KISS method.
Fedup is offline   Reply With Quote
Old 04-18-2017, 10:21 PM   #47
Thinks s/he gets paid by the post
gcgang's Avatar
 
Join Date: Sep 2012
Posts: 1,568
When I worked I used Excel. Now I just use pen and paper. Very infrequently.
__________________
You know that suit they burying you in? Thar ain’t no pockets in that suit, boy.
gcgang is offline   Reply With Quote
Old 04-19-2017, 01:37 AM   #48
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Aug 2016
Location: Northern Virginia
Posts: 7,544
I use excel for much of my historical account balance recordkeeping and for portfolio re-allocation, which I do only annually. My spreadsheet is similar to yours, sengsational, I did enjoy reiewing yours.

On an interim basis I use sigfig to monitor holdings. I have a mixture of funds and individual stocks, so some automation is required or you are going to spend a lot of time doing data entry.

Seems excel is the most popular tool.
Montecfo is offline   Reply With Quote
Old 04-19-2017, 01:40 AM   #49
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Aug 2016
Location: Northern Virginia
Posts: 7,544
Quote:
Originally Posted by W2R View Post

I have taxable and Roth IRA at Vanguard, and the TSP and my bricks'n'mortar bank accounts. That's 5 numbers needed from Vanguard for my 5 funds, 1 from the TSP, and 1 from the bank.

So, each day I log into Vanguard, the TSP, and my bank, and copy the 7 total numbers that I obtain into my master retirement/investment spreadsheets in Excel. For me it takes almost no time at all. Piece o' cake.
W2R-do you do this daily so you can monitor activity or balances each day?

M
Montecfo is offline   Reply With Quote
Old 04-19-2017, 05:42 AM   #50
gone traveling
 
Join Date: Sep 2003
Location: DFW
Posts: 7,586
Spreadsheet + Fidelity
eytonxav is offline   Reply With Quote
Old 04-19-2017, 06:27 AM   #51
Thinks s/he gets paid by the post
exnavynuke's Avatar
 
Join Date: Sep 2016
Location: Acworth
Posts: 1,214
Quote:
Originally Posted by Ian S View Post
Personal Capital appears to lack a function to download your data. I prefer SigFig which does have that ability. However, the latter is really only geared for investment monitoring but that's of most interest to me.
Currently the only thing they let you grab is a CSV of all transactions. You'd have to sort those yourself if you wanted, but you can download that data. Though I agree, it'd be nice to be able to download specific data from the reports they have (such as downloading just investments data).
exnavynuke is offline   Reply With Quote
Old 04-19-2017, 06:50 AM   #52
Thinks s/he gets paid by the post
kaudrey's Avatar
 
Join Date: Feb 2006
Location: Alexandria, Va
Posts: 1,053
Quote:
Originally Posted by DrRoy View Post
+1
+2 (Excel Spreadsheet)
__________________
Two roads diverged in a wood, and I - I took the one less travelled by...
kaudrey is offline   Reply With Quote
Old 04-19-2017, 07:10 AM   #53
Recycles dryer sheets
 
Join Date: Nov 2007
Location: a suburb somewhere
Posts: 54
Excel with a twist.

We have too many accounts and holdings, old 401(k)s and whatnot. As I have whittled away at our portfolio, consolidating accounts, my goal has been to get it all to fit on one printed page from excel. This may be an irrational compulsion but it has guided my efforts to simplify the portfolio. I copy the data onto a new sheet each quarter. I bought space on the sheet by moving all extraneous information such as account numbers and beneficiary designations off to another sheet.

Several years ago, I achieved my goal of fitting everything onto one landscape page. A thing of beauty! As I keep at it, white space has appeared at the right and bottom margins. I fill these newly won square inches with analytics: asset allocation, international vs domestic, taxable vs retirement, basis information, etc. I was even able to increase the font size recently! I have finally reached a comfort level where everything fits neatly on one page.

I realize that fitting our portfolio into 8-1/2 by 11 inches is, in and of itself, kinda bogus as a financial goal. It does drive real consolidation and simplification though. Every quarter I update the spreadsheet, print it out (one concise page) and review it with my wife. We mark it up together and I prioritize the next moves. Works for us.

-F&J
flotsamandjetsam is offline   Reply With Quote
Old 04-19-2017, 07:35 AM   #54
Thinks s/he gets paid by the post
jimbee's Avatar
 
Join Date: Oct 2010
Posts: 1,214
I use LibreCalc for asset tracking. Management is performed using the website of the investment company. Management consists mainly of an annual Roth IRA conversion, combined with an asset allocation rebalance. Simple stuff.
jimbee is online now   Reply With Quote
Old 04-19-2017, 08:12 AM   #55
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: May 2008
Posts: 5,176
I am surprised that a lot of people answered "Excel" as their spreadsheet. I use Open Office spreadsheet since it's free... I also use personalcapital.com for Fidelity only because it lets me see the YTD rate of return (which Fidelity website is not capable of doing for some reason...). Other than that, I used online tools available at my investment firms.
tmm99 is offline   Reply With Quote
Old 04-19-2017, 08:34 AM   #56
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Aug 2016
Location: Northern Virginia
Posts: 7,544
Quote:
Originally Posted by tmm99 View Post
I am surprised that a lot of people answered "Excel" as their spreadsheet. I use Open Office spreadsheet since it's free... I also use personalcapital.com for Fidelity only because it lets me see the YTD rate of return (which Fidelity website is not capable of doing for some reason...). Other than that, I used online tools available at my investment firms.
For me, I have a lot of excel spreadsheets already and use it in my job. it is not efficient to change. And I think i paid $99 a few years ago for Word, Excel, Powerpoint etc as a bundle for I believe 3 computers. So for me it is a good value.

Open Office is essentially a charity. So those tools are funded by donations
and you never know when it may stop being supported. I think it has a place, but I do not need the headache.

Other minds may differ.
Montecfo is offline   Reply With Quote
Old 04-19-2017, 08:42 AM   #57
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
easysurfer's Avatar
 
Join Date: Jun 2008
Posts: 13,130
Spreadsheet (Open Office, to be exact). Most of info I get from Vanguard, but I have few things (for example, savings bonds) outside of Vanguard so end up manually inputing Vanguard and other totals into a spreadsheet. I only update once a quarter and rebalance once a year .
__________________
Have you ever seen a headstone with these words
"If only I had spent more time at work" ... from "Busy Man" sung by Billy Ray Cyrus
easysurfer is offline   Reply With Quote
Old 04-19-2017, 08:43 AM   #58
Full time employment: Posting here.
 
Join Date: May 2011
Location: Twin Cities
Posts: 523
I use Quicken Rental Property Manager.

Easily pulls in data from my 10 rental properties, my business (realtor) and personal investments/expenses.

Been using some form of Quicken since 1991 when I met Scott Cook (Intuit founder) at Comdex in Vegas and he gave me a demo in their booth.
Fishingmn is offline   Reply With Quote
Old 04-19-2017, 08:48 AM   #59
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,003
Quote:
What portfolio management tool do you use?
Self-discipline, and lots of it.
__________________
Numbers is hard
REWahoo is offline   Reply With Quote
Old 04-19-2017, 08:51 AM   #60
Thinks s/he gets paid by the post
mpeirce's Avatar
 
Join Date: Feb 2012
Location: Northern Ohio
Posts: 3,182
Quote:
Originally Posted by braumeister View Post
Numbers spreadsheet.
Apple finally added the capability to have live updates on stock prices which is very nice. I'm in the camp of those who won't give my account passwords to a consolidator.
I use a Numbers spreadsheet too. I gotta get around to using the new stock price feature. I currently have a link to Yahoo which downloads all the stocks/funds I own as a csv file and I cut and paste into the spreadsheet.

Like this (edited down):
http://download.finance.yahoo.com/d/...sax+swtsx&f=l1

Since I store it in iCloud I can access it from my big screen iMac a home, but also on the iPad or, in a pinch, the iPhone.

And I get all the customizing benefits of rolling my own spread sheet. My summary page shows me a few different ways to look at everything: with and without taxes (estimated capital gains and IRAs); pretty asset allocation pie charts; historical graphs; and graphs of specific fund/stock histories.

I also have sheets in the document that track spending at the level I care about: mostly broadly, but also detailed for travel. I can look back at what that trip to Germany in 2013 cost us...

The downside is that I've found a couple of bugs over the years. Nothing that was big, but if you roll your own spreadsheet you do need to check (and keep checking over the years as it evolves) for errors.
mpeirce 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
Best tool that charts a portfolio’s combined performance krldrummerboy FIRE and Money 18 05-30-2016 12:51 PM
AssetAllocation & Portfolio Tracking Tool Manji FIRE and Money 3 04-21-2009 04:19 PM
Portfolio Management Website Culture FIRE and Money 5 11-08-2008 09:02 PM
Portfolio Management Bikerdude FIRE and Money 5 02-28-2008 08:06 AM
Poll: Retirement Portfolio Management chinaco FIRE and Money 11 03-31-2007 04:51 PM

» Quick Links

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