moving averages

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...

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...

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...

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...

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...

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...

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...

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...

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...