Web Scrapping, Data Pipeline and Data Cleansing will be used within this project.
Callable Bull / Bear Contract (CBBC) , Warrant and stock data will be scrapped from the Hong Kong Exchange and yahoo stock finance API by python libraries respectively.
The aim is to generate a dynamic dataset for investment banks. These per day generated data can be used by business intelligence applications such as Tableau or PowerBI to build dashboards for bankers and other stalkholders.
For the data pipeline part, it can be done by setting up the task scheduler in window or Mac OS.
1.HKEX CBBC Dataset (All)
2.HKEX Warrant Dataset (All)
3.HKEX Warrant (Stock) Dataset (All)
4. Stock Price Performance (2Y) of listed CBBC (Yahoo)
5. Stock Price Performance(2Y) of listed stock warrant (Yahoo)
Tableau Relationship joining is recommended to deal with the datasets.