Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Old 04-19-2017, 08:09 PM   #81
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
easysurfer's Avatar
 
Join Date: Jun 2008
Posts: 7,456
Quote:
Originally Posted by CountryGal View Post
Well.. I have played around with a few of the suggestions. I did everything manually as I do not trust giving my passwords out to any of these tools.
- Looked at Google.. too basic and didn't see a way to see the allocation visually.
- Tried Full View by Fidelity. It imported my whole 401 as one account and I didn't see an easy way to get to the details. Maybe it had to be done manually. The tool seemed clunky.
- I tried Morning star on a few funds and then realized I had to pay to see any kind of analysis
- I downloaded excel spreadsheet templates that are on the internet. They seem complicated
- Quicken doesn't have the X-ray feature in the mac version yet.
- Personal Capital wasn't bad at all. All the tools are a pain to get the data into given 401 k funds that aren't in most of the tools. I was even able to split up the one Target Retirement fund into the appropriate allocations. It was able to give me what I was looking for.

That all said, I can see that our portfolio on the whole is too heavily weighted in cash/bonds and low on stocks. Given the current market, how would you recommend rebalancing? Dollar cost average over time?

Based on some other things I have seen, my 'small' taxable account that only has bonds in it should probably be mostly/all stocks. Hubby's 401k/IRA will probably be tapped first, given he is 65 and I am late 50s.

Thoughts?
Since the excel spreadsheet templates you downloaded on the internet seem complicated, have you thought about creating your own spreadsheet? That way you can control what data gets on there and make as simple as you like.

As for the rebalancing question, for me, I rebalance one a year in a large chunks to my desired allocation. But I do so in IRA accounts so there is not a tax event.
__________________

__________________
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
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-19-2017, 08:36 PM   #82
Recycles dryer sheets
 
Join Date: Jan 2016
Posts: 142
I have the skills to make my own spreadsheet, but not the desire. Was hoping for something easy. I had a glitch with Personal Capital that kept deleting a fund in one of the 401ks. It also contributed to showing a lower % for stocks than reality. While I still want to tweak the allocation, the total isn't as off as I thought it was.

Personal Capital is doing what I need it to do. I believe the glitch had to do with an & sign that I used in the name of the fund. When I removed it, the fund was not deleted.
__________________

__________________
CountryGal is offline   Reply With Quote
Old 04-19-2017, 08:47 PM   #83
Thinks s/he gets paid by the post
timo2's Avatar
 
Join Date: Jul 2011
Location: Fort Collins
Posts: 1,382
Quote:
Originally Posted by Fedup View Post
Excel spreadsheet.
+1
__________________
"The natural inclination of every boat everywhere is to sink".......Nicole Pasulka
timo2 is offline   Reply With Quote
Old 04-20-2017, 04:55 AM   #84
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,528
I would buy this---
https://www.amazon.com/Microsoft-Off.../dp/B0153V61XU

Over a period of 3-5 years of use, I would have Excel and Word, and the cost per year would be $75, maybe $50, per year.
__________________
target2019 is online now   Reply With Quote
Old 04-20-2017, 04:59 AM   #85
Thinks s/he gets paid by the post
target2019's Avatar
 
Join Date: Dec 2008
Posts: 3,528
Quote:
Originally Posted by CountryGal View Post
I have the skills to make my own spreadsheet, but not the desire. Was hoping for something easy. I had a glitch with Personal Capital that kept deleting a fund in one of the 401ks. It also contributed to showing a lower % for stocks than reality. While I still want to tweak the allocation, the total isn't as off as I thought it was.

Personal Capital is doing what I need it to do. I believe the glitch had to do with an & sign that I used in the name of the fund. When I removed it, the fund was not deleted.
What you will find is that glitches will come up from time to time and you'll need to investigate, and fix.
If this solution works for you, and requires little time, then go with it.
__________________
target2019 is online now   Reply With Quote
Old 04-20-2017, 09:59 AM   #86
Recycles dryer sheets
lem1955's Avatar
 
Join Date: Mar 2007
Posts: 124
Send a message via Yahoo to lem1955
I use Quicken for Mac to download all my investment transactions and balances. And I use Vanguard's Portfolio Tester Tool to plan AA rebalances. Before these tools were available I used Excel to manage investments but it was much more labor intensive. I would rather spend my time reading about investing than doing data entry into a spreadsheet.
__________________
Retired 12/16/2015 at 60.
lem1955 is offline   Reply With Quote
Old 04-20-2017, 10:36 AM   #87
Thinks s/he gets paid by the post
Gotadimple's Avatar
 
Join Date: Feb 2007
Posts: 1,664
Quote:
Originally Posted by jimbee View Post
When the alternative is free, then $229 is too much for me. LibreCalc also runs on Linux, my OS of choice.
Libre or Open Office is free, you are correct, and you do get updates. There are slight differences between these and the MS products, as long as they meet your needs.

If one has to have the Office Suite on their computer (with no updates), then $229 is a reasonable cost, until you want to upgrade to newer software. If regularly updated software that isn't free is a choice, an annual Office subscription at $79/year plus local tax is a reasonable choice and close to the $229 and no update option.

I did use OO for years, until I had a volunteer project needing a database. OO's database program was great for handling data and querying. But, there was no reports module - still being developed. I am not trained in writing software and MS Access is great for creating reports easily - so back to paid software.

- Rita
__________________
Only got A dimple, would have preferred 2!
Gotadimple is offline   Reply With Quote
Old 04-20-2017, 03:53 PM   #88
Dryer sheet aficionado
 
Join Date: Aug 2014
Posts: 37
I've used Personal Capital for 3+ years, both for investment tracking and for budget tracking. It's adequate in both areas but does have some quirks as others have pointed out. I also transcribe my investment results - by account - into an Excel spreadsheet at the end of each month to document month-to-month performance.
__________________
"Doubt is not a pleasant condition, but certainty is absurd." Voltaire
Tallman4123 is offline   Reply With Quote
Old 04-20-2017, 04:24 PM   #89
Dryer sheet aficionado
 
Join Date: May 2015
Posts: 36
Quote:
Originally Posted by Tallman4123 View Post
I've used Personal Capital for 3+ years, both for investment tracking and for budget tracking. It's adequate in both areas but does have some quirks as others have pointed out. I also transcribe my investment results - by account - into an Excel spreadsheet at the end of each month to document month-to-month performance.
This is also my method. Track everything in Personal Capital with monthly rollups in a spreadsheet.
__________________
orangehairfella is offline   Reply With Quote
Old 04-20-2017, 04:58 PM   #90
Thinks s/he gets paid by the post
 
Join Date: Aug 2004
Location: Laurel, MD
Posts: 2,664
Quote:
Originally Posted by splitwdw View Post
I'm slowly learning my way around the Fidelity website. I have a IRA and a 401k there. I can see the YTD rate of return for the IRA under the "Performance" tab and the 401k under the "Investments" tab. I can see YTD, 1 yr., 3yr., 5yr. and since inception. Is this not what you are looking for?


That's curious. I can't find YTD return for my Fido IRA anywhere and I only get the 401k YTD on the Mobil version or netbenefits. I mainly use the Fido GPS tool on the analysis tab. I manually add outside accounts quarterly and it meets my needs which is primarily asset allocation.
__________________
...with no reasonable expectation for ER, I'm just here auditing the AP class.Retired 8/1/15.
jazz4cash is offline   Reply With Quote
Old 04-20-2017, 05:42 PM   #91
Recycles dryer sheets
 
Join Date: Aug 2014
Location: Phoenix
Posts: 417
Quote:
Originally Posted by Tallman4123 View Post
I've used Personal Capital for 3+ years, both for investment tracking and for budget tracking. It's adequate in both areas but does have some quirks as others have pointed out. I also transcribe my investment results - by account - into an Excel spreadsheet at the end of each month to document month-to-month performance.
That's my biggest complaint with P.C.: it should offer the ability to download the data to your own spreadsheet software. That's why I use SigFig. It's so easy I do it every week.
__________________
Ian S is offline   Reply With Quote
Old 04-26-2017, 01:17 AM   #92
Recycles dryer sheets
Cat-tirement's Avatar
 
Join Date: Mar 2013
Posts: 183
Quote:
Originally Posted by braumeister View Post
Very easy to use. For a simple price, just use this in a spreadsheet cell:
=STOCK(A2,price)
where A2 is the cell with the symbol.

Besides price, you can get a couple dozen other attributes for a given stock. Very well done (although long overdue).
Thanks for the tip, I didn't know that was available. I guess I'll have to try the newer version of Numbers now. (I have been holding at an earlier version, before they stripped out features to make it more like iOS.)
__________________
How can you tell when a cat is retired?
Cat-tirement is offline   Reply With Quote
Old 04-26-2017, 01:28 AM   #93
Recycles dryer sheets
Cat-tirement's Avatar
 
Join Date: Mar 2013
Posts: 183
Quote:
Originally Posted by lem1955 View Post
And I use Vanguard's Portfolio Tester Tool to plan AA rebalances.
I've recently started using their portfolio analyzer/tester tool too. It allows you to enter outside accounts, good since only half our stuff is at Vanguard. There's no automatic updating, but I'm another who won't trust other account passwords with a single service. Since I only look at it quarterly or monthly at most, manually updating the outside accounts isn't a big deal to me.
__________________
How can you tell when a cat is retired?
Cat-tirement is offline   Reply With Quote
Old 04-26-2017, 02:42 PM   #94
Recycles dryer sheets
 
Join Date: Dec 2015
Posts: 50
FundManager is an AWESOME tool. It allowed me to "finally" get control over a very complex portfolio with way more funds and investments than I 'should' have..shows returns over various time periods, nice charting/graphing capabilities and a lot more.

It's a really well written piece of software. (Coming from a tech background I appreciate well designed software, especially after using the piece of .... known as Quicken).

I also wrote some custom macros in Excel that allow me to slice and dice my PF in ways that FM doesn't do natively. Not sure if any of the freeware spreadsheets can do VBA macros..
__________________
RetireSoon is offline   Reply With Quote
Old 04-27-2017, 01:18 PM   #95
Recycles dryer sheets
 
Join Date: Feb 2015
Posts: 88
This is a related workaround for Personal Capital that I figured out and have posted elsewhere:

Personal Capital tip: Do you have any monies or funds in PC that somehow show up as "unallocated"? (no automated and applicable asset allocation) Here's how to change that, manually: Add a new manual investment account. Name it accordingly. Add one new holding, only 1 share of the ticker QCERQ (happens to be a JP Morgan sweep code, but PC doesn't know that), with the share value equal to your entire fund holding. (For example, suppose we have a variable annuity with an insurance company which holds the Franklin Income VIP Fund. There is no ticker for that fund, as it is only held in insurance annuity accounts. And let's say we have $125,000 in that fund in the annuity. You would then add 1 share of QCERQ @ $125,000 per share in the new manual PC investment portfolio you just created.)
Now, go to Portfolio>Asset Allocation in PC. Click on the "Manual Allocation" button in the general upper right area. You will see your "unallocated" QCERQ with a value of $125,000. Click on that and then, from the actual fund prospectus, enter the percentages of the fund's allocations and Save. Boom! Allocation now accounted for! The only downside is that you'll have to occasionally update the total balance of your fund holding to get the most recent allocation. Cheers!
__________________
dadu007 is offline   Reply With Quote
Old 04-27-2017, 01:51 PM   #96
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
youbet's Avatar
 
Join Date: Mar 2005
Location: Chicago
Posts: 9,824
I use the portfolio management tool on the Schwab web site. Works great for what I need. It handles both internal and external accounts, provides an AA calculation (including drilling down into multi-asset class funds such as Wellesley) and allows any combination of various accounts to be grouped.

The only negative is that it will not go out and look up changes in the external accounts such as my 401k. I have to enter changes manually. (It will automatically apply the closing value of the security or fund at the end of the day but it won't look for changes in the number of shares you own) Since I'm long FIRE'd and not contributing to my 401k, not a big deal. Changes only happen when I rebalance.
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
youbet is offline   Reply With Quote
Old 04-27-2017, 02:20 PM   #97
Recycles dryer sheets
 
Join Date: Feb 2015
Posts: 88
Quote:
Originally Posted by trixs View Post
You can use the formula I posted above. Press ctrl+alt+F9 and excel will automatically download the current price.
@trixs: the formula in your quote is incomplete (missing closing parenthesis and more...).
Do you have the complete string for Excel? (not Google Sheets)?

Edit: Found it elsewhere!: =NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&B7&"&f=l1"))

where B7 is cell with whatever ticker you're using...

Edit #2: weird; I see that the forum truncates the formula once posted! For those interested, after the 1 you need to add a quotation mark " and then two closed parenthesis ))
__________________

__________________
dadu007 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

 

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