Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Investing (Windows)
Gain/Loss 12-month and Avg. Return (%) 1 - Year are Incorrect
TPerk100
Win 10 Pro, Q17 Premier, but same problem has been with previous versions as well.
Purchased annuity in 2011. Not knowing how to do it any better, I created an investment account named "Annuity." I bought one share of ABC Annuity. The annuity value cannot be downloaded, so I periodically (about once every couple of months) go to Price History and update it with current value.
Problem is that Portfolio View, Gain/Loss 12-Month shows entire gain since 2011 and Avg. Annual Return (%) 1-Year shows total return since 2011.
i suspect I am doing something wrong, but I do not know what it is. Any help will be appreciated.
Find more posts tagged with
Comments
Jim_Harman
Does your Buy show a purchase date in 2011, and is the price history accurate back to 2011 as well?
I suggest you go to Reports > Investing > Investment Performance and select the account in question and the date range "Last 12 months." Do the results look correct there? This report will show the details Quicken is using for the IRR calculation. and should match what it is showing for the Avg Annual Return % 1-yr in the Portfolio views.
Note that in this report and in the Avg Annual Return calculations, Quicken uses the closing price on the day before the start of the period as its starting price. If it doesn't have a price for that day, it uses the last previous price in the price history. Thus for accurate results, you must have the correct share price for the end of the period and for the day before the start of the period.
For Last 12 months as of 9/8/2018, the date range will be 9/9/17 through 9/8/18 and the prices must be correct 9/8/2017 and 9/8/2018.
For a "Last year" report dated 1/1/2017 to 12/31/2017, the prices must be correct for 12/31/2016 and 12/31/2017.
TPerk100
Jim,
I suspected it might have something to do with my entered prices. I do have a purchase date transaction from 2011, but I do NOT have period ending and beginning prices. Since 2011 I have updated price randomly without regard to periods. I am not even sure I can get the data at this point, but I will try to and will try to see if entering period price data makes a difference.
Thanks much!
Jim_Harman
You don't need to have a lot of price data, but the ones for the beginnings and ends of the periods are important. You may be able to download old statements and get the prices from them, or perhaps you can download the price history from the financial institution. Check Quicken's Help for info on how to import price history if you can get it in CSV format.
Also check your price history to make sure there is not extraneous data there - dates where the price goes to zero or back to your original 2011 price for example. You can safely delete any bad prices, but back up your data file first, just in case.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of