You have chosen to sponsor your bid up to a maximum amount of .
1. Get the stock information from website, such as hk.finance.yahoo.com to mysql/MSSQL in daily basis by using yahoo API
2. Use the VBA to extract the data to excel
Create sample report in excel spreedsheet including below feature
- Select particular stock from a selected period
- Select a stock list from a selected period
- Select all stock from a selected date or period