Number of digits when exporting CSV prices/quotes

Good morning.

When exporting transactions to .csv… prices/quotes display only two digits to the right of decimal. Some of my mutual fund prices use 6 digits.

All six digits are recorded within PP… is there a way to export 6 digits to .csv?

Thank you!


Did you check your third party software, that the cell number format is not formatted w/ two decimals? What you get displayed on screen and what value is stored per single cell is might be different.


In addition to what @Rafa said, I’d like to point out a misunderstanding:

In transactions, no security prices are stored at all. Only the total amount and the number of shares are recorded. You can therefore recreate the price within Excel to any desired accuracy by simply dividing the amount by the number of shares.

1 Like

Thanks! I did not realize that prices were not stored.