VBA Excel based on the Hong Kong Stock Market Screener
- or -
Post a project like this3192
$400
- Posted:
- Proposals: 9
- Remote
- #837040
- Awarded
Business Consultant, Website Design, Website Development, PHP, WordPress, Web App, Mobile App, Branding, Designer, Business Plans, Business Support, Presentation, Adviser, Analyst, Strategist, Advisor
City of London
Data Mining/Web Scraping/Software Testing/Selenium Webdriver/SOAPUI/Excel Macro/VB/Rest API
Bangalore
A professional expert - Excel VBA, MS Word, MS Powerpoint, MS Access, Data scraping, Data Analysis, Virtual Assistance, Web Scraping
Kolkata
882641136596190175473174579409743560800218875556986284
Description
Experience Level: Expert
Estimated project duration: 1 day or less
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:
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:
Jacky C.
80% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
20%
Last project
11 Aug 2015
Hong Kong
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies