Excel Analysis of Monthly MACD for Financial Markets
- or -
Post a project like this3982
£50(approx. $62)
- Posted:
- Proposals: 15
- Remote
- #247794
- Completed
Design and Build Turnkey Data based business solutions and process streamlining for SME's
Birmingham
Accounts, Book-keeping, Data entry, MS Excel & MS Word, MIS, SEO, Research, Translation, Payroll, Admin Support, Business Support
Coimbatore
4442502258112677353765365275371533382738392661422934442585442902442907
Description
Experience Level: Intermediate
Hi,
We are looking for someone who has a good knowledge of Financial Market Analysis including technical indicators such as MACD.
We would like you to first look at the data we provide being daily Open, High Low and Close prices and then provide in the next column the Monthly Macd figure which will either be negative or positive.
We would then want the programme to mark all days that have a negative monthly MACD number in red and all days that are positive to be marked in blue.
We would then want a column showing result for each trading day. This result would simply be the current days close minus the previous days close price showing the movement of the chosen market on any given day.
These results would either be negative ie the market closed lower or positive ie the market closed higher.
We would then finally like the programme to cross reference the Macd Figures with the closing prices and produce a Jan to Dec summary for each year.
So for example if the MACD was negative and the market fell this would be counted as a winning day as both MACD and the market fell.
If the MACD was positive and the market rose on that day then again this would be counted as a win. Any other result would be counted as a loss.
A summary of this would then be shown for each month and then year.
So we may have in any one year say 200 trading days with 132 being counted as wins and 90 counted as losing being a rate of 66% winning and 34% losing, percentages to be shown as well in the summary.
We expect this to be the first of quite a few jobs with these types of calculations.
We have attached a file showing the daily price data for the UK ftse100 as an example of the data to work with.
We are looking for someone who has a good knowledge of Financial Market Analysis including technical indicators such as MACD.
We would like you to first look at the data we provide being daily Open, High Low and Close prices and then provide in the next column the Monthly Macd figure which will either be negative or positive.
We would then want the programme to mark all days that have a negative monthly MACD number in red and all days that are positive to be marked in blue.
We would then want a column showing result for each trading day. This result would simply be the current days close minus the previous days close price showing the movement of the chosen market on any given day.
These results would either be negative ie the market closed lower or positive ie the market closed higher.
We would then finally like the programme to cross reference the Macd Figures with the closing prices and produce a Jan to Dec summary for each year.
So for example if the MACD was negative and the market fell this would be counted as a winning day as both MACD and the market fell.
If the MACD was positive and the market rose on that day then again this would be counted as a win. Any other result would be counted as a loss.
A summary of this would then be shown for each month and then year.
So we may have in any one year say 200 trading days with 132 being counted as wins and 90 counted as losing being a rate of 66% winning and 34% losing, percentages to be shown as well in the summary.
We expect this to be the first of quite a few jobs with these types of calculations.
We have attached a file showing the daily price data for the UK ftse100 as an example of the data to work with.
Neil M.
100% (50)Projects Completed
64
Freelancers worked with
44
Projects awarded
45%
Last project
10 Apr 2024
United Kingdom
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