Why are the prices I have exported to Excel truncated?

To view or save your positions into CSV format, first open your Account Window by clicking the Account menu option in TWS followed by Account Window. From there, click the File menu option followed by Export Portfolio. Enter a name for your file and, once finished, click Save. This will work in both a live and paper trading account…

Yes, you can export your clients' information to Excel. From the Contacts tab, click the Download icon and select “Contact Summary to CSV”.

Additional Information…

You can set the number of decimal places to any integer value from 1 to 6. For example, setting the value to 2 will display Last Size values formatted to two decimal places…

Yes. In addition to the TurboTax .TXF format, IBKR supports the download of this worksheet in a Comma-Separated Values, or .CSV file format.  Files in this format can be opened in applications such as Microsoft Excel, Open Office Calc or Google Docs. The .CSV file format is not supported for purposes of import to TurboTax. IB also supports the download of this worksheet in PDF format…