This program converts a JSON response generated from Alpaca trade executions to a CSV format suitable for importing into Portfolio Performance.
- Install the Python 3.10 interpreter.
- Navigate to the program folder in the terminal.
- Create a virtual environment in the program folder using the command
python3 -m venv env
. - Activate the virtual environment using the command
source env/bin/activate
if on Linux/MacOS orenv\Scripts\activate.bat
if on Windows. - Install the required packages using the command
pip install -r requirements.txt
. - Place the json file(s) to be converted in the program folder.
- Run the program using the command
python converter.py
. The program will convert all the json files in the program folder and output a single .csv file.
- Make sure your Portfolio Perfomance locale is set to English and US number format
- Import the generated csv file into Portfolio Performance via
File > Import > CSV Files...
- During the import process, make sure to select
Type of data: Portfolio Transactions