Excel Analysis of Monthly MACD for Financial Markets

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.