Amend VBA in Excel Spreadsheet

The attached spreadsheet records odds data from third party software using COM. The live data for a race is displayed in sheet W1 and then recorded in sheet Data W1. Various parameters are configurable using sheet Status W1. The spreadsheet updates dynamically with the result that sheet Data W1 contains a list of recorded odds split between Back Odds, Lay Odds and Last Price Matched. When the race is finished the software moves to the next race. The attached spreadsheet includes data to enable bidders to understand how it works. This project is to amend the VBA to insert two moving averages in sheet MAs for each horse using the Last Price Matched. The first moving average is a “slow moving average” which is the average of the last 20 values and the second moving average is a “fast moving average” which is the average of the last 10 values. The code should insert the next moving average in the cell below dynamically when each new Last Price Matched entry is populated and the end result should be a lists of two moving averages for each horse. For example, for the first horse the moving averages should be set out in columns A and B of sheet MAs, for the second horse they should be set out in columns C and D, etc. When the software moves to the next race the code should clear all moving averages from the previous race and start again. If there are any questions please ask.