VBA Excel based on the Hong Kong Stock Market Screener

Industry: Business
Description of excel work: Hong Kong Stock Market Screener Filter

Select from all the stock code in Hong Kong (update automatically)
Make an filter by the following trading signal: MACD, RSI.
MACD (12,26,9) - Divergence must be in the range of 0.001 to 0.02.
RSI 14 - It must be above 30.

CCASSID- 3 out of 5 is Broker.
https://webb-site.com/ccass/choldings.asp?issue=3616 - can refer from this website.


In the Final Display table, it can select the following on the top right area

Daily average turnover (record by weekly result)>10m (Can be adjustable by key in different amount)
Price Range $1-$10 (Can be adjustable by key in different amount)
Date.

In the First Row - Stock No, Company Name, Today Price, 52 weekly low, 52 weekly high, Top 5 CCASS Name [five columns+ stake %]

Stock Data can be taken from YahooHK Finance or GoogleHK Finance.
Design and target audience: Personal Use only
Extra notes: