Finance quantitative model - handle outdated stocks/tickets

We are developing a cutting edge quantitative model for financial markets. Stocks information are retrieved from Bloomberg and processed in order to build reports and analysis. Within this context, we need an extension allowing an automatic recognition of outdated titles. The recognition of outdated titles shall be performed using the API of Bloomberg Terminal. The outdated titles shall be memorized in a DB table, so that the quantitative model can skip the processing of those titles. Everything should be provided with documentation, unit test, integration in the actual source code, integration test. Needed Skills: python, statistical and Bloomberg api. // Added information on 03 Mar 2019 The list of the titles is all stored in a database. The list is not fixed and can change according to the necessity. We don't need data, but a software developer to modify existing software. Unit testing will be written with the python 2.7 unittest library ([login to view URL]). The main tasks of the project are the following: 1 Solution design - Provide the public interface of the classes and the new tables needed. Describe also how these class shall integrate with the actual solution. 2 Unit test implementation - Provide a set of unit test for the public interface of task 1. At this stage, all the tests will fail. 3 Solution implementation - Implement all the class of task 1. Extend the structure of the database. At this stage, all the testes of task 2 shall success. 4 Integration - Integrate all the classes of task 1 into the actual working software. 5 Integration test - Design, implement and perform the integration tests. Provide a detailed report on it. 6 Documentation - Write separate documentation of source code, database, tests. // Added on 04/03/2019 The stock data are retrieved with the Bloomberg terminal Python desktop API. The file named "[login to view URL]" provide an example of how to perfom the task 3. The sheet named "analisi" at column I gives the precise description. // Added on 05/03/2019 There is an existing and working software written in python 2.7. You have to modify the related source code on a virtual machine, with Ubuntu, python, pycharm, svn, and other stuff. The design is related to your piece of work: the classes that you intend to write, the public interface, the DB table and any other thing you think useful.