tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/60873-cost-basis-isnt-calculating-correction-for-history-reports-in-the-portfolio-reportInfinite Kind: Discussion 2020-08-26T23:00:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-09T22:33:37Z2020-05-09T22:33:37ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>Do you mean that it doesn't adjust for different # of shares when asking for the portfolio report. I see that recent purchases are not included as number of shares in an older report as I expect. Maybe if you could give a simple example? Or even better create a new account with a single security showing this effect?<br>
(Not IK Support)</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-10T08:38:47Z2020-05-10T08:38:47ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>Hi sth,</p>
<blockquote>
<p>Do you mean that it doesn't adjust for different # of shares when asking for the portfolio report.</p>
</blockquote>
<p>The report shows the correct number of shares for the report date, but<br>
not the correct cost of those shares: cost basis appears to always<br>
calculate on today's date, not the date the report's being run for.</p>
<p>I'm replying by email and not sure if the screenshots are going to take,<br>
but here goes.</p>
<p>I started a brand new file and added a single investment account called<br>
'Invest Account', associated a single security called 'Security A', and recorded a small number of transactions, shown here:</p>
<p>Should the screenshot not come through, here're the transactions:</p>
<ul>
<li>1 May: xfr'd £100</li>
<li>1 May: bought 20 shares at £1/share</li>
<li>2 May: bought 20 shares at £1.5/share</li>
<li>3 May: bought 20 shares at £2/share</li>
</ul>
<p>Here's the portfolio report when run with default setup, for today (10 May):</p>
<p>Again, if the screenshot doesn't come through:</p>
<p>Shares: 60<br>
Price: 2<br>
Cost Basis: 90<br>
Gains: 30<br>
Balance: 120<br>
1/3/5 year 5: None<br>
All %: high number, guessing because I'm giving myself a high return</p>
<p>When I backdate the report date to 2 May, which is before my 3rd buy:</p>
<p>Shares: 40 (correct)<br>
Price: 1.5 (correct)<br>
Cost Basis: 90 (not correct - should be 50)<br>
Gains: -30 (not correct - should be 10)<br>
Balance: 60 (correct)<br>
1/3/5 year 5: None<br>
All %: high number, guessing because I'm giving myself a high return</p></div>rjgiskardtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-16T13:46:17Z2020-05-16T13:46:17ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>I ran into this issue today and a quick search of the discussions shows that this has been reported at least as far back as Moneydance 2015. So I guess we just have to ignore the cost basis on the Portfolio report if we use a date other than the current date.</p></div>markritchietag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-17T18:26:13Z2020-05-17T18:26:13ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>I think investing is becoming more common than ever before, so hopefully<br>
the devs take notice of this bug as more of us post here to say we're<br>
affected by it.</p></div>rjgiskardtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-17T23:22:22Z2020-05-17T23:22:22ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>I have been away for a bit, so I apologize for not getting back to you. I have seen no issue with my securities and wonder if it is something odd in your stock history prices.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-17T23:44:18Z2020-05-17T23:44:18ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>I thought it might have to do with the price history, the transaction and the portfolio being on the same day. Did the pricing happen before or after the purchase that happened before or after the portfolio report. I spaced out transactions and see the same error. In fact the price should be the average price of 1.25/share after the second purchase.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-18T06:26:29Z2020-05-18T06:43:15ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>Edit: initially replied by email after reading the email from your first reply; after reading your second, I see my reply is moot... So editing...</p>
<p>From your last post, I gather you’re seeing the issue now, too?</p>
<p>In my test, the buys were consecutive days. In real life, these are transactions going back years. If I backdate the Portfolio report to any date prior to my last buys/sells, the cost basis is still calculated for the current date. So the further back I try to see a snapshot of my portfolio at the time, the worse the report.</p></div>rjgiskardtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-18T12:44:13Z2020-05-18T12:44:13ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>I am pretty sure I understand the issue. The only weirdness I was trying to eliminate is if you ask for a portfolio report as of May 3. And you purchased securities on May 3, does the report include that purchase. What about the price change that is entered on May 3 as well. It was a question of the off by one scenario on the date. The version I posted avoids that by spacing the purchases out with an extra day in-between.</p>
<p>Either way the average price per share, the number of shares and the total basis costs should be consistent. Instead of showing screen shots, I posted the whole test case for the developer to work on.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-18T14:20:17Z2020-05-18T14:20:17ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>Hi sth, Please see above post 7. I had replied by email after reading post 5, but before reading post 6. I edited my response a few minutes later after reading post 6. So I think we're on the same page here.</p></div>rjgiskardtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-27T20:23:42Z2020-05-27T20:23:43ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>I have reported this issue twice over the last 3 years. But has it been fixed - no it hasn't. The other day I was wanting to find the value of an investment in 2001, where I make a regular monthly investment and while the value was correct, the cost included all additional investments made between 2001 and 2020! So cost was so much greater than the value, when value should exceed cost.</p></div>Garthtag:infinitekind.tenderapp.com,2009-01-14:Comment/483144242020-05-27T22:51:30Z2020-05-27T22:51:30ZCost Basis isn't calculating correctly for history reports in the 'Portfolio' report<div><p>Sadly Investments and Investment reports seem to have been overlooked in Moneydance for quite some time. There are problems with quite a number of the reports and the capability in handling invesment transactions could do with expansion.</p>
<p>The issues have been raised on many occasions, but more noise about the inadequacies in this area never hurts.</p></div>dwg