convert-csv-schwab2pp.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"authorship_tag":"ABX9TyN8p6vhJ6jpaD74JXkRN4eB"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","source":["# A Charles Schwab CSV Converter for Portfolio Performance\n","\n","Converts a [Charles Schwab](https://www.schwab.com/) transaction CSV file to a ready-to-import CSV file for [Portfolio Performance](https://www.portfolio-performance.info/en/) (PP).\n","\n","[ ![workflow badge](https://github.com/rlan/convert-csv-schwab2pp/actions/workflows/python-app.yml/badge.svg) ](https://github.com/rlan/convert-csv-schwab2pp/actions)\n","\n","Source code: [https://github.com/rlan/convert-csv-schwab2pp](https://github.com/rlan/convert-csv-schwab2pp)\n","\n","## Usage\n","\n","This notebook will download code from Github, verify the example and convert ```schwab.csv```.\n","\n","1. Run this entire notebook once (Runtime -> Run All). Because ```schwab.csv``` (your Schwab CSV file) doesn't exist yet, there will be an error.\n","2. Upload your ```schwab.csv```. See instructions below.\n","4. Download ```pp.csv```.\n","\n","## License\n","\n","Eclipse Public License - v 2.0\n"],"metadata":{"id":"vEzvpPb1u9zm"}},{"cell_type":"markdown","source":["Show versions"],"metadata":{"id":"ppnSnL_QjOO1"}},{"cell_type":"code","source":["!python --version\n","!python -c 'import pandas; print(f\"Pandas {pandas.__version__}\")'"],"metadata":{"id":"bZxnlMK5jDL9"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Download code"],"metadata":{"id":"GQzwBEUpgPgC"}},{"cell_type":"code","source":["!git clone https://github.com/rlan/convert-csv-schwab2pp.git"],"metadata":{"id":"VGDXmilONSKU"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Change current folder"],"metadata":{"id":"uB8f1lZkgTPI"}},{"cell_type":"code","source":["%cd /content/convert-csv-schwab2pp"],"metadata":{"id":"R79yYr4bfNvd"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Install ```requirements.txt```"],"metadata":{"id":"RUqfwIwrji6p"}},{"cell_type":"code","source":["!pip install -r requirements.txt"],"metadata":{"id":"3fxO-GrPjhg3"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Run test"],"metadata":{"id":"m4IFUL2EgtDr"}},{"cell_type":"code","source":["!python convert.py example.csv -p test.csv"],"metadata":{"id":"C_iP0gPLfZxX"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Check result with reference. Pass, if result is empty."],"metadata":{"id":"MR2BKYPQgwZM"}},{"cell_type":"code","source":["!diff example_out.csv test.csv"],"metadata":{"id":"7W8iieGsfeJm"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["Running this notebook the first time will error: ```schwab.csv not found```.\n","\n","You must run this notebook once before uploading your own ```schwab.csv```. \n","\n","To upload your CSV:\n","\n","1. If not open already, click on folder icon to see the folder-and-files panel.\n","2. Click on folder refresh button. ```convert-csv-schwab2pp``` will show.\n","3. Right-click on folder ```convert-csv-schwab2pp``` and choose Upload.\n","4. Upload your ```schwab.csv```. Must be named that.\n","5. Run the next cell below. Hover mouse cursor over the code then click on the play button.\n","6. Refresh the folder-and-files panel. Download the converted ```pp.csv```. Right click and choose Download."],"metadata":{"id":"SC5F1x7Rij-Q"}},{"cell_type":"code","source":["!python convert.py example.csv -p pp.csv"],"metadata":{"id":"5FDhIMXchtPW"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["After download is completed, delete this runtime and your data: Runtime -> Disconnect and delete runtime."],"metadata":{"id":"5rK2TmBA2YPH"}}]}