# moving averages

1. ### Maximum 7 Day Average from data range

Hi, I have a problem that I can't find a solution for. I have a table that retrieves total production from a site on a given day. This ranges back 3 years. What I want to be able to find is the maximum 7 day average throughout that period. Any suggestions on the best way to achieve this would...
2. ### Use excel formula to provide grand total of moving averages

Hello, I need help in finding a formula I can plug into a cell, and would give me the grand total for the moving averages. ColumnB contains the values and the Averages column has the formula "=Average(B2:B3)", which is then copied down the column, for example =Average(B3:B4), etc. Finally I sum...
3. ### exponential moving average formula help, please...

Greetings all - I am trying to build a formula to calculate an exponential moving average. Have searched both Mr Excel and elsewhere and have gotten several (conflicting) answers. I thought I had gotten this right yesterday, but now that I am validating things, I've found that what I have is...
4. ### I urgently need help with VBA about moving average

Hello guys, I just joined this forum so i don't know about your posting rules and i don't have so much time so i don't have time for reading forum rules and i searched the internet that this was the most helpful site about excel and VBA so i registered. So let me ask you my problem and i...
5. ### 3 Month Moving Average w/ Criteria

Hi all, I have a spreadsheet with multiple employees on it, their number of completed tasks, and the month that it was recorded. It looks something like this: Employee Month Completed Tasks Moving average A 1/1/2016 23 B 1/1/2016 19 C 1/1/2016...
6. ### VBA Moving Average question

Hi guys, I'm the first time using Excel VBA. The question is Given the formulas for moving average and corresponding moving standard deviation, develop the code that uses n, number of past observations, as an input in to the calculations in such a way that n can be changed dynamically updating...
7. ### How to Calculate Moving Average for Different Period

Hi all, I would like to use Excel to calculate the Moving Average for Dow Jones or SP500 in Excel. For example I have a set of data, said 500 data in Column A, when I entered a different period, say 5 or 10, in B1, can Excel give Moving Average in Column C for 5 day Moving Average or 10 day...
8. ### Stock Moving Averages

I am trying to build an excel formula for doing some basic stock analysis. I found a way for excel to automatically link with MSN money and import LIVE basic stock quotes. What I am now looking for is a way to calculate the current 200 and 50 day moving averages of the stock price without...
9. ### numeric moving averages

OK I may be asking Excel to do something it's really not designed for, but here goes anyway... I have a workbook consisting of 5 worksheets: A) Advertising Expenses B) Revenue tied to specific ad campaigns C) Pivot tables summarizing a & b D) Line item detail (table calculating information...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back