8 digit precision in exported reports

schmidtl4
schmidtl4 Quicken Windows Subscription Member ✭✭
in Errors and Troubleshooting (Windows)

I use the Extended precision option in Investment Preferences. I have two issues:

  1. I never see more than six digits of precision in the register. I don't know what checking the option for Extended precision does if there's no visual effect.
  2. I export transactions daily to another app for analysis, etc. I've experimented with the tab-delimited.txt file and the .xlsx export. Excel is useless…never has more than 2 decimal places. The tab-delimited only shows six places, again, despite selecting the option for 8.

In a show that it is working, the one place that I see 8 decimal places is in the Holdings report, but alas that can't be exported…

Aren't these bugs? Is anyone working on them? Are there "tricks" to enforcing 8 decimal places everywhere (for consistency!)?

Tagged:

Answers

  • crwalejr
    crwalejr Quicken Windows Subscription Member ✭✭✭✭

    1) Why you never see more than 6 decimals in the register

    The Investment Preferences → Use extended precision (8 digits) option affects only Quicken’s internal math, not the display layer.

    What it actually does

    • Quicken stores share quantities internally to 8 decimal places
    • Cost basis and gain/loss calculations use the full precision
    • IRR, ROI, and performance reports use the extended precision internally

    What it does NOT do

    • It does not change the register display
    • It does not change the “Edit Transaction” dialog
    • It does not change the “Enter Transactions” wizard
    • It does not change the number of decimals in exports

    Quicken’s UI is hard‑coded to show 6 decimal places max for share quantities. There is no way to make the register show 7 or 8.

    This is a known limitation and has been acknowledged by Quicken moderators for years.

    2) Why exports never show more than 6 decimals

    You’ve already discovered the two export paths:

    A) Excel (.xlsx) export

    • Quicken exports rounded values, not raw values
    • Excel receives only 2 decimal places for prices and amounts
    • Excel receives only 6 decimal places for share quantities
    • Formatting the Excel cells to show more decimals does nothing — the extra precision simply isn’t there

    This is a Quicken limitation, not an Excel one.

    B) Tab-delimited (.txt) export

    • This is the best export Quicken offers
    • But it still caps share quantities at 6 decimals
    • Prices and amounts are capped at 2 decimals
    • Again, formatting the file won’t reveal more precision — Quicken never writes it

    Even with Extended Precision enabled, Quicken never exports more than 6 decimals for shares and never exports more than 2 decimals for prices.

Categories