Build a list of cherry picked stocks from the DEGIRO broker, based on the API https://github.com/Chavithra/degiro-connector Download portfolios from DEGIRO and also from BourseDirect (thanks to an adapted version of https://github.com/carldeg/BourseDirect) Merge the porfolios with stock data, and compute a synthesis per sector.
Please export the environment variables GT_DG_USERNAME and GT_DG_PASSWORD as your DEGIRO login and password, before launching Jupyter Lab.
- The first block downloads and put in cache the data from DEGIRO and eventually Yahoo! finance, then build the raw dataframe of all stocks. You should get as little as 15000 stocks there!
- The second block performs the ranking in order to establish the hall of fame based on complex formula. All your CPU cores will be used during the computation, it may be long depending on your gear.
- The third block filters out and displays the final result. Please read the "readme.rtf" to get the meaning of the columns and how the ranking is done.
- The other blocks:
- save the result to a CSV file
- overwrite a favourite list on your DEGIRO account from top 100 stocks of computed result
- display your current portfolio merged with data from the computed result.
- if GT_BD_USERNAME and GT_BD_PASSWORD (BourseDirect credentials) are defined, then download the porfolio from BourseDirect and merge the 2 portfolios.
Downloaded data stay forever to avoid to much load on DEGIRO. You have to remove the cache manually ( rm .cachedb* ) and launch the different blocks to get some fresh data.