- a cli alternative can be found here: https://github.com/marzzzello/pytr
This tool should help to keep the overview of the transactions within TradeRepublic. In TR there is the possibility to export all orders as PDF. For testing purposes the import and export is currently only possible with G-Drive. Alternatives are on the todo list.
The master sheet lists all previous transactions from the PDFs.
The delta sheet contains all new transactions that have been added since the script was last executed. These are intended to be imported into Portfolio Performance and Investing.com. Delta sheets are dated.
The portfolio sheet contains an overview of all open positions with basic information as average purchase price. The three fields "Stop Preis", "Limit Preis" and "Strategie" are for notes, which are kept at each execution of the script, if the corresponding position is still in the portfolio.
- optimized for Google Colab (https://colab.research.google.com/)
- export optimized for "Portfolio Performance" (https://www.portfolio-performance.info/) and "Investing.com" (https://de.investing.com/)
- for further information about the import at "Investing.com", see: https://www.investing-support.com/hc/en-us/articles/360000265217-Import-Portfolio-Holdings
- TradeRepublic statements will be imported via GoogleDrive. All PDF files shoule be in a single folder. You need to configure the path to your G-Drive before usage (see: "Configurations - to be defined by user")
- for different data sources, see: https://colab.research.google.com/notebooks/io.ipynb
- in order to create different data structures, take a look at "Examples for extracted fields".
- "Kosten des Wertpapierkaufs/verkaufs" are be considered.
- "Kosten während der Haltedauer (pro Jahr)" are not extracted and therefore do not appear the sheets.
- deposits and withdrawals to the depot are not recorded in PDF format. Therefore they are not taken into account and must be entered by hand if necessary.
- each TradeRepublic document has got a "order" number. This is extracted and stored in the field "Notiz". It serves to prevent duplicate entries.
- create sheets for portfolio performance in .csv format
- offer alternatives to G-Drive import/export
- ...
- extract G-Drive folder of TradeRepublic PDFs
- create data structure (for Portfolio Performance or other purposes)
- generate master sheet of all transactions
- generate delta sheet for new transactions (base for TradeRepublic import)
- fixed | sort extracted transactions by date
- fixed | double entries of table lables in delta sheet
- add ticker symbol via finnhub api (requires your own api key)
- fixed | calculate purchase price
- add values to sheet ("Kaufkurs", "Gebühren")
- data structure for Investing.com import
- full refactoring (new class structure)
- add current portfolio as output option
- allow data enrichment of extracted data
- note already extracted PDFs