Cost in Portfolio report
A problem which arose in the first version of MD 2017 has not been corrected in MD 2017.4
In the Portfolio report the Cost Basis remains the same regardless of what date is used. See below - the cost of an investment at 31 Dec 2016 is 30,711.86 when per the Cost Basis report it should be 30,190.66. The Portfolio report always uses the latest cost. The Balance in the Portfolio report correctly changes when the date changes. This problem means the Gains in the Portfolio report is not correct unless the current date is used in the Portfolio report. [Reports use ddmmyyyy format]
Cost Basis
Account/Action Date Shares Amount Cost Basis Running Total
Buy 01/12/2016 65.15 65.15 30,190.66
Buy 03/01/2017 65.15 65.15 30,255.81
Buy 01/02/2017 65.15 65.15 30,320.96
Buy 01/03/2017 65.15 65.15 30,386.11
Buy 01/04/2017 65.15 65.15 30,451.26
Buy 02/05/2017 65.15 65.15 30,516.41
Buy 01/06/2017 65.15 65.15 30,581.56
Buy 03/07/2017 65.15 65.15 30,646.71
Buy 01/08/2017 65.15 65.15 30,711.86
Total 30,711.86
Portfolio
As of: 31/12/2016
Security Ticker Shares Price Cost Basis Gains Balance
Investment AAA 513,324.82 1 30,711.86 482,612.96 513,324.82
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
System closed this discussion on 04 Nov, 2017 01:10 PM.