tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/1310-rounding-on-portfolio-valuationsInfinite Kind: Discussion 2018-03-16T06:11:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132016-12-02T14:27:10Z2016-12-02T14:27:10Zrounding on portfolio valuations<div><p>Which version of MD 2017 are you using? Help > about MD</p>
<p>Can you be more specif about the discrepancies.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132016-12-02T21:24:59Z2016-12-02T21:24:59Zrounding on portfolio valuations<div><p>I am using Version 2017 (1584)<br>
The valuation error was for a single security. In late November I
had a reinvested dividend of 4.861 shares for $47.05. That computes
as<br>
$9.679078378 per share, and it brought my holdings of that security
to 4,243.293 shares.<br>
Per Moneydance, 4.243.293 shares times $9.679078/share = $41,071.16
Per both Excel and Quicken, the extension was $41,071.17. This was
the first time in 8 months, with multiple securities (most of which
reinvest<br>
dividends) that I had a rounding difference. Hence, my belief that
MD used<br>
"precision as displayed." Also, and I regret that I do not remember
the exact sequence of how I found this, another security got a
reinvested dividend on 12/1/16, and<br>
after I entered the transaction in the register, I found that the
security<br>
detail had not been updated. The difference between the per/share
value and<br>
the closing value was very small (.0003203,) but I would have
thought the<br>
security detail would have been updated.<br>
These small differences never occurred with MD2015. I hope you are
not following Quicken's lead in emasculating your product.</p></div>Geza Soostag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132016-12-07T18:35:22Z2016-12-07T18:35:22Zrounding on portfolio valuations<div><p>Please update to the latest build of MD 2017 (1293). There were
some issues with security pricing that were fixed. I did the math
in MD 2017 (1293) and received the correct 41071.17 figure.</p>
<p>You can download that from here: <a href="http://infinitekind.com/preview">http://infinitekind.com/preview</a></p>
<p>If this does not resolve the issue, please send me a screen shot
of your cost basis for this security. I would want to rebuild a
copy of your holdings to see if the rounding error is somewhere
else than the simple math.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132016-12-14T14:49:04Z2016-12-14T14:49:05Zrounding on portfolio valuations<div><p>Thank you. I think that helped, although I am not sure because
the issue<br>
was resolved when end-of-November pricing reverted to 2
decimals.<br>
Unfortunately, in my haste to update, I downloaded a preview
[Version 2017.1 (1593)] instead of the recommended (1293.) It seems
to work,<br>
although I have gotten a few messages that (1593) did not have a
digital<br>
signature. Did I screw up? Should I (and is it possible to) go back
to<br>
(1293?) I did not put this into the public discussion because I was
unable to find my original question.</p>
<p>Thanks!</p></div>Geza Soostag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132016-12-14T19:49:10Z2016-12-14T19:49:10Zrounding on portfolio valuations<div><p>Support are in error there is no such thing as Moneydance 2017
build 1293, I believe Tom meant to type in build 1593</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132016-12-16T20:08:13Z2016-12-16T20:08:13Zrounding on portfolio valuations<div><p>Yes I meant 1593 but typed too fast and failed to notice.</p>
<p>Thanks DWG</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132017-01-03T21:46:00Z2017-01-03T21:46:00Zrounding on portfolio valuations<div><p>In 2017.1 (1593) I am still having the problem that a 6-digit
history does not give a correct valuation. Formely, it was
8-digits.<br>
I use 2 files: a file for FMV and a file that I reconcile to
provider online balances. The FMV is no problem, since they never
have more than 4 decimal places. However, if a dividend yields an
7-or-more decimal price, I cannot reconcile without creating some
stupid reconciliation value, which I have to reverse no later than
month-end. All of this makes me think that I cannot use MD except
for transitory (and unrecorded) values.</p></div>Geza Soostag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132017-01-12T05:21:48Z2017-01-12T05:21:48Zrounding on portfolio valuations<div><p>I will put in a bug ticket. The rounding to only six does
through off the current value figure.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/413220132017-01-12T13:00:40Z2017-01-12T13:00:40Zrounding on portfolio valuations<div><p>Thank you.</p></div>Geza Soos