Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Quicken performance calculation
Old 10-17-2018, 07:39 AM   #1
Recycles dryer sheets
 
Join Date: Nov 2017
Posts: 75
Quicken performance calculation

For those who use Quicken, can you tell me if what I am doing is right to arrive at investment performance by category. I go into reports->Investing->Investment performance. I then change the date to custom date of ending to 12/31/2018. I ask it to sort by security type. I then compare those performance with equivalent indexes or funds. For example my bond performance vs VCIT (Vanguard inter corp. )

I pick my own Reits, Bonds and preferred positions. I use mostly ETF index funds for equity. So it is important for me to see how I am doing compared to market. Thanks for input.
__________________

Cpadave 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 10-17-2018, 09:00 AM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 19,498
Yes, if you change the end date from current date to 12/31/2018 it will convert from annualized yield to YTD return. I tested it for a Roth that we have that has VTSAX and has had no investment activity and it works perfectly... YTD return is exactly the same as Vanguard's website.
__________________

__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56...60/35/5 AA
pb4uski is online now   Reply With Quote
Old 10-17-2018, 09:08 AM   #3
Recycles dryer sheets
 
Join Date: Nov 2017
Posts: 75
Thanks. It makes it easy and fast to do what I need
Cpadave is offline   Reply With Quote
Old 10-17-2018, 09:09 AM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 19,809
The Quicken ROI function YTD is a reasonable estimate of YTD return using the current days date.

Why need end of year date?
__________________
Retired since summer 1999.
audreyh1 is online now   Reply With Quote
Old 10-17-2018, 09:13 AM   #5
Recycles dryer sheets
 
Join Date: Nov 2017
Posts: 75
Because quicken takes the YTD number and annualized it. I checked this by comparing what it was showing me for VTI and what the total return was for that ETF. If you don't change the date to 12/31, it will give you the wrong number.
Cpadave is offline   Reply With Quote
Old 10-17-2018, 09:51 AM   #6
Thinks s/he gets paid by the post
OldShooter's Avatar
 
Join Date: Mar 2017
Location: City
Posts: 2,186
My experience has always been that the Quicken calculations are unreliable. Once in a while it would produce a credible number but in many cases they were obviously wrong.

Last spring we moved DW's IRA from her former megabank employer "wealth management" department to Schwab, transferring all the assets in kind. This has hopelessly confused Quicken, so I don't even look at its numbers any more. They are completely la-la land.

Caveat Emptor.
OldShooter is offline   Reply With Quote
Old 10-17-2018, 09:52 AM   #7
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
audreyh1's Avatar
 
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 19,809
Quote:
Originally Posted by Cpadave View Post
Because quicken takes the YTD number and annualized it. I checked this by comparing what it was showing me for VTI and what the total return was for that ETF. If you don't change the date to 12/31, it will give you the wrong number.
The ROI calculation is not annualized. It’s just a straight % return over any given time period.
__________________
Retired since summer 1999.
audreyh1 is online now   Reply With Quote
Old 10-17-2018, 10:08 AM   #8
Recycles dryer sheets
 
Join Date: Nov 2017
Posts: 75
So here is how I have checked quicken performance vs actual. I took one ETF where I had no sales or buys during the year. For example, IXUS. Using fidelity, it shows the total YTD return for that ETF as -7.47%. If I use the quicken performance number as YTD without adjusting it to 12/31/18, it shows total return of -9.3%. However if I change the date to 12/31/2018, it shows -7.45%, which is very close to Fidelity number.

One thing I was not sure if there was new purchases during the year. If quicken can calculate the number correctly, I compared quicken numbers to the 1, 3 year performance number on my portfolio and it was pretty close to it. So I think quicken number can be reliable.
Cpadave is offline   Reply With Quote
Old 10-17-2018, 10:23 AM   #9
Thinks s/he gets paid by the post
OldShooter's Avatar
 
Join Date: Mar 2017
Location: City
Posts: 2,186
Quote:
Originally Posted by Cpadave View Post
... I think quicken number can be reliable.
Agreed. I have seen Quicken numbers that seem to be correct, but not all of them and not all of the time. In fact, it may be that Quicken gets it right in simple situations like your test, but when things get more complicated it falls on its nose. It's really the worst kind of bug because for me it means that I can't trust anything it says. YMMV of course.
OldShooter is offline   Reply With Quote
Old 10-17-2018, 02:06 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 19,498
Same here... for some reason it has a lot of trouble calculating money leaving the ring fence or even being transferred between accounts within the ring fence.

My withdrawals are only from my online savings account, which is part of my retirement assets... but when I include that account in a Quicken performance report I get garbage results compared to XIRR calculation. I can see that online savings account is the problem because when I sort the performance report by account, that account has a nonsensical return (I know it only returns 1.5-2%). Also, even though I converted ny Roth from a fund to a brokerage account on the first business day of January, it totally throws Quicken for a loop.
__________________

__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.

Retired Jan 2012 at age 56...60/35/5 AA
pb4uski is online now   Reply With Quote
Reply

Tags
performance, quicken


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
Change in CPI Calculation Michael Other topics 37 07-12-2005 01:40 AM
Cars - A Basic Calculation Whisper9999 FIRE and Money 72 02-05-2005 04:23 AM
Is it this simple? My calculation dex FIRE and Money 10 09-23-2004 06:29 AM
SS Calculation jodz FIRE and Money 14 08-31-2004 09:07 PM

» Quick Links

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