A Charles Schwab CSV Converter for Portfolio Performance

A command-line tool that converts a Charles Schwab transaction CSV file to a ready-to-import CSV file for Portfolio Performance (PP).

After conversion, this step-by-step guide creates a new portfolio file in PP and imports the converted example CSV.

After importing the converted example CSV.

Installation

First, install pipx (not pip).

Then:

pipx install git+https://github.com/rlan/convert-csv-schwab2pp

Try it out!

Let's see if installation was successful:

schwab2pp --help

usage: schwab2pp [-h] [-p PP_CSV] schwab_csv

Converts a Charles Schwab transaction CSV file to a ready-to-import CSV file for Portfolio
Performance.

positional arguments:
  schwab_csv            Input Charles Schwab CSV file

optional arguments:
  -h, --help            show this help message and exit
  -p PP_CSV, --pp_csv PP_CSV
                        Resulting CSV file for Portfolio Performance (default: pp.csv)

Example:

An example Schwab CSV: example.csv. The converted ready-to-import CSV file: example_out.csv.

To replicate this conversion:

schwab2pp example.csv -p example_out.csv

Update to a new version

pipx upgrade schwab2pp

Uninstallation

pipx uninstall schwab2pp

Details

Supported transactions:

• "NRA Tax Adj"
• "Credit Interest"
• "NRA Withholding"
• "Short Term Cap Gain"
• "Long Term Cap Gain"
• "Cash Dividend"
• "Buy"
• "Wire Received"
• "Wire Sent"¹ (Thank you, @ipaulo)
• "Sell" (Not verified)

Not-yet-supported transactions:

• ACH deposit and withdrawal

I have actual transactions for the supported transactions. "Sell" is an educated guess; I don't have an actual sale. If you could share actual transactions for not-yet-supported ones, please let me know. Thank you.

Duplicate transactions:

As far as I can test, PP will detect and skip duplicate transactions. So it is safe to import overlapping transactions in the future.

Dates:

If date is in "date1 as of date2" format, "date1" will be used and "as of date2" will be appended to the resulting "Note" column.

Citation

If this project helps your research, don't hesitate to spread the word! Click on the badge below and find citation formats (e.g., BibTeX and etc) at the bottom of that page.

License

MIT

Footnotes

1. https://github.com/rlan/convert-csv-schwab2pp/issues/2 ↩