|
|
04-19-2017, 08:09 PM
|
#81
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2008
Posts: 13,150
|
Quote:
Originally Posted by CountryGal
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
|
|
|
|
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!
|
04-19-2017, 08:36 PM
|
#82
|
Recycles dryer sheets
Join Date: Jan 2016
Posts: 235
|
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.
|
|
|
04-19-2017, 08:47 PM
|
#83
|
Thinks s/he gets paid by the post
Join Date: Jul 2011
Location: Bernalillo, NM
Posts: 2,717
|
Quote:
Originally Posted by Fedup
Excel spreadsheet.
|
+1
__________________
"We live the lives we lead because of the thoughts we think" ...Michael O’Neill
"We can cannot compel others to do our will" ....Norman Goldman
"There never is shortage of the gullible to accept the illogical"...Anonymous
|
|
|
04-20-2017, 04:55 AM
|
#84
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2008
Location: On a hill in the Pine Barrens
Posts: 9,722
|
Quote:
Originally Posted by W2R
|
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.
|
|
|
04-20-2017, 04:59 AM
|
#85
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2008
Location: On a hill in the Pine Barrens
Posts: 9,722
|
Quote:
Originally Posted by CountryGal
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.
|
|
|
04-20-2017, 09:59 AM
|
#86
|
Recycles dryer sheets
Join Date: Mar 2007
Posts: 315
|
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.
__________________
"Retirement isn’t really a switch you flip at a certain age anymore," the Schwab report states. "It’s a financial state that allows for the flexibility to make work optional."
|
|
|
04-20-2017, 10:36 AM
|
#87
|
Thinks s/he gets paid by the post
Join Date: Feb 2007
Posts: 2,613
|
Quote:
Originally Posted by jimbee
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!
|
|
|
04-20-2017, 03:53 PM
|
#88
|
Recycles dryer sheets
Join Date: Aug 2014
Posts: 141
|
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
|
|
|
04-20-2017, 04:24 PM
|
#89
|
Recycles dryer sheets
Join Date: May 2015
Posts: 67
|
Quote:
Originally Posted by Tallman4123
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.
|
|
|
04-20-2017, 04:58 PM
|
#90
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Aug 2004
Location: Laurel, MD
Posts: 8,327
|
Quote:
Originally Posted by splitwdw
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.
|
|
|
04-20-2017, 05:42 PM
|
#91
|
Thinks s/he gets paid by the post
Join Date: Aug 2014
Location: Red Rock Country
Posts: 1,932
|
Quote:
Originally Posted by Tallman4123
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.
|
|
|
04-26-2017, 01:17 AM
|
#92
|
Recycles dryer sheets
Join Date: Mar 2013
Posts: 285
|
Quote:
Originally Posted by braumeister
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?
|
|
|
04-26-2017, 01:28 AM
|
#93
|
Recycles dryer sheets
Join Date: Mar 2013
Posts: 285
|
Quote:
Originally Posted by lem1955
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?
|
|
|
04-26-2017, 02:42 PM
|
#94
|
Thinks s/he gets paid by the post
Join Date: Dec 2015
Posts: 1,166
|
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..
|
|
|
04-27-2017, 01:18 PM
|
#95
|
Recycles dryer sheets
Join Date: Feb 2015
Posts: 217
|
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!
|
|
|
04-27-2017, 01:51 PM
|
#96
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2005
Location: Chicago
Posts: 13,186
|
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
|
|
|
04-27-2017, 02:20 PM
|
#97
|
Recycles dryer sheets
Join Date: Feb 2015
Posts: 217
|
Quote:
Originally Posted by trixs
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 ))
|
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|