Decimal places for shares, change the default
D Bunker
Member ✭✭
I am working on a historical spin off and would like the number of decimal places for the new shares to match the historical record (3 places), whereas the program is using 4 places. Is there a way to set the default for a stock (and time period) to 3? If not, what is the best method for removing the "extra" fractional shares? Thanks.
0
Best Answer
-
As Sherlock points out, the user has no direct control of the number of share decimals resulting from a calculation within QWin. QWin will display up to 6 decimals and, IIRC from an old post, actually carries 8 decimals in the database.
My preference, like yours, is to have QWinreport the same precision as the FI reports. If a QWin calculation procedure results in reporting added decimals, I go back and edit the transaction and truncate the reported value as necessary.
Example; QWin reports a Shares Added value of 123.456789 sh - I edit this to 123.457 sh.QWin & QMac (Deluxe) Subscription
Quicken user since 19916
Answers
-
We cannot set the precision used by Quicken but we can set the precision displayed on reports. If necessary, I suggest you remove shares using a Removed action transaction and reset the cost basis using Added shares transactions.0
-
As Sherlock points out, the user has no direct control of the number of share decimals resulting from a calculation within QWin. QWin will display up to 6 decimals and, IIRC from an old post, actually carries 8 decimals in the database.
My preference, like yours, is to have QWinreport the same precision as the FI reports. If a QWin calculation procedure results in reporting added decimals, I go back and edit the transaction and truncate the reported value as necessary.
Example; QWin reports a Shares Added value of 123.456789 sh - I edit this to 123.457 sh.QWin & QMac (Deluxe) Subscription
Quicken user since 19916 -
I prefer the J_Mike approach as the cost basis was correct, only the "precision" of the number of shares needed adjusting. His method requires less effort.0
-
Dear J_Mike: When I am editing, I use the Accounts window. Can I filter or mask to show only that security? I see that I can sort by the security name which will work. But I don't think that I can edit transaction share numbers from a custom report with only that security, right? Thanks.0
-
@Bunker
Unfortunately, QWin does not have that register filtering capability.
Suggest running Reports > Investing > Investment Transactions report.
Customize to display the desired security.
Double-click on a transaction in the report to open an editing dialog.
Be sure to do frequent backups along the way - that is you escape route in case of an error.QWin & QMac (Deluxe) Subscription
Quicken user since 19910