This guide will create a new portfolio file in Portfolio Performance (PP) and import a converted CSV file. For this guide, we will import the converted example in the README. Screen captures are from PP 0.71.2 (October 2024).
-
Download a transactions CSV file from your Charles Schwab account, say,
example.csv
. -
Convert the CSV. See the README for syntax.
-
Open Portfolio Performance and click on "Create a new file".
- Select "USD (United States Dollar)" for currency.
- Type "Securities" for Securities Account and "Deposit" for Reference Account. Then click on "Add" button.
- Click on "Finish" button.
- Import the converted CSV. Go to File menu, Import, CSV files (comma-separated values) and select
example_out.csv
.
- Click on "Next" button.
- Note that "Deposit" is chosen as the Cash Account and "Securities" as the Securities Account. These two names were entered in a previous step. Click on "Finish" button.
- Click on "OK" button.
-
Now we are going to retrieve historical quotes for securities that exist in the account.
- Select "All Securities" from the tree menu on the left panel.
- Right click on "VANGUARD TOTAL INTERNATIONAL BND ETF" and choose "Edit".
- Select "Historical Quotes" tab.
- Choose "Yahoo Finance" from the Provider dropdown list. See official documentation about other providers.
- Historical quotes will be retrieved. Then click on "OK" button.
- Repeat this for other securities in the account. Note that this only needs to be done once for each new securities in the account. For example, repeat this when a new security is purchased. PP will retrieve historical quotes automatically, or you can manually do so via Online menu, Update Quotes.
-
Verify. Select "All transactions" from the tree menu on the left panel. Import complete.