Skip to content

Latest commit

 

History

History
71 lines (38 loc) · 2.66 KB

README.md

File metadata and controls

71 lines (38 loc) · 2.66 KB

A step-by-step guide

This guide will create a new portfolio file in Portfolio Performance (PP) and import a converted CSV file. Screen capturse are from PP 0.71.2 (October 2024).

  1. Download a transcations CSV file from your Charles Schwab account, say, example.csv.
  2. Convert the CSV. README for convert.py.
python3 convert.py example.csv -p example_out.csv
  1. Open Portfolio Performance and click on "Create a new file".

Create a new file

  1. Select "USD (United States Dollar)" for currency.

USD (United States Dollar)

  1. Type "Securities" for Securities Account and "Deposit" for Reference Account. Then click on "Add" button.

Securities and Deposit accounts

  1. Click on "Finish" button.

Clikd on Finish

  1. Import the converted CSV. Go to File menu, Import, CSV files (comma-seperated values) and select example_out.csv.

File menu, Import, CSV files

  1. Click on "Next" button.

Click on "Next" button

  1. Note that "Deposit" is chosen as the Cash Account and "Securities" as the Securities Account. These two names where entered in a previous step. Click on "Finish" button.

Click on "Finish" button

  1. Click on "OK" button.

Click on "OK" button

  1. Now we are going to retrieve historial quotes for securities that exist in the account.

    1. Select "All Securities" from the tree menu on the left panel.

    Select "All Securities"

    1. Right click on "VANGUARD TOTAL INTERNATIONAL BND ETF" and choose "Edit".

    Right click and choose Edit

    1. Select "Historical Quotes" tab.

    Select Historical Quotes tab

    1. Choose "Yahoo Finance" from the Provider dropdown list. See official documentation about other providers.

    Choose Yahoo Finance from the Provider dropdown list

    1. Historical quotes will be retrieved. Then click on "OK" button.

    Historical quotes retrieved Chart of historical quotes

    1. 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.

  2. Verify. Select "All transcations" from the tree menu on the left panel. Import complete.

Select All transactions