create professional factsheet

Job ID: 32357513

Budget: $2 – $8 USD

Develop a bot code for automatic generation of a factsheet, see attachment. Function requirements are: - Webscraping daily historical price (NAV) data of 16 investment funds / ETFs from Financial Times Markets, e.g., https://markets.ft.com/data/funds/tearsheet/historical?s=LU2001393136:EUR - Cleaning the data from redundant and missing data points - Calculating the daily development of the value of our complete model portfolio starting at inception on Dec. 31, 2020, as describes in the attached factsheet - Calculate all values and time series strings for the charts shown in the attached factsheet - Generate the attached factsheet as similar as possible as the attached factsheet with professional quality. I use Excel and LibreOffice for that as attached in the current versions for the current Q3 factsheet, done completely manually by myself. This whole process shall be completely automatized such that the attached factsheet can be generated by a mouse click. The coding has to be done in a modular way with good documentation, and sustainable architecture such that it can be extended with more functions for financial portfolio simulation as support of our portfolio management. The code has to be well documented such that following coder can get easily into the code and continue to extend it . I expect good collaboration in an agile scrum style way with frequent reports and exchanges on the progress, problems, solutions