moving averages

  1. M

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

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

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

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

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

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

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

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top