moving average

  1. D

    I need help writing a Daily Average Formula

    Howdy, I have a problem that I can't figure out, and I'm hoping someone here can give me a hand. For the past several years I have been keeping a record of how far I walk/run/cycle each day via Excel. It has worked great for letting me see my average year by year. However, I have one Excel...
  2. D

    Moving Average Based On Time Period

    I have data from a datalogger which varies in the time interval it was collected, sometimes the data is collected every hour, sometimes every 15 minutes. Column A has date/time info (ex: 6/3/16 9:52:00) and Column B have the raw readings (ex: 0.00025). I would like to be able to create graph...
  3. J

    12 month moving average

    I need help calculating a 12 month rolling average for employee turnover for the month of January. After I get the turnover, then I need to display this in a graph or sort. I'm lost. I know how to do the rolling average for each the turnover and the headcount, then calculate Jan turnover, BUT...
  4. P

    Auto Adjusting moving average, please assist

    Hello everyone, I'm a day trader and would like to make a formula that adjusts a moving average with just one input change. I'm trying to get the average of the last X amount of days and change this based on the input of Days in test. I also want it to test only the number of days in test all...
  5. R

    Days Moving Average with Non-Consecutive Days Data

    Hello, This is part of my data set on my fuel spending which I am trying to analyse: <tbody> 23/02/2013 $53.88 3/03/2013 $47.80 16/03/2013 $53.16 20/03/2013 $87.81 3/04/2013 $31.88 4/04/2013 $79.28 17/04/2013 $43.41 23/04/2013 $70.37 2/05/2013 $68.39 23/05/2013 $84.36...
  6. I

    Returning a moving average across colums

    Hi all, There are any number of posts on this topic but all are based on data in adjacent columns. I have to get a cell to return the average of the last 5 values entered in a row but cannot get it to work. Probably because I can't fully understand what the row and column settings mean in the...
  7. T

    Moving Average in VBA

    Hi. I've been looking all over MrExcel.com and the rest of the web, but every post about VBA code for moving averages isn't exactly a solution for what I want to do. I'm working with very large amounts of data. About 10 years of daily stock returns, and doing 10 stocks at a time (that's about...
  8. G

    Excel 2003 - Average of data entered in last 28 days

    I'm having a few issues calculating an average that includes a changing dataset. Column A: Date data in entered Column H: The data i want to find the average of Cell L1 - Where I need the result. The number of data rows changes every day but the dates the data relate to aren't always entered...
  9. 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...
  10. L

    Calculating Moving Average for different uniques

    I have a table with hundreds of uniques all with performance data for 30 days. I want to calculate the moving average for a variable number of days (i.e. 4 day moving average). I saw a couple of posts in this forum but I didnt quite get it to work. Thanks!
  11. S

    Rolling/Moving Average

    Hello Is there anyway to automatically calculate a 12 month rolling average from a pivot table, without having to create an additional seperate table? I've tried many searches about this on the internet and came up with nothing that seems to be conclusive :confused: Any help you could...
  12. N

    Question Re: Monthly Running Sum query

    Hello everything, This seems like a great forum and its my first time posting so Ill do my best to be as clear as possible... I have a table, lets call it "MyTable", it contains 3 fields: ID (Autonumber), LogDate (Date), Volume (currency) I need to create a query based on this table with two...
  13. A

    More elegant moving average

    I'm not an advanced excel user, but have figured out an layman's solution to my first problem. The issue is the second problem. I'm looking for a 30 day moving average that automatically updates based on newly entered data. I've successfully used the following formula to return a 7-day moving...
  14. A

    Speed Challenge

    Hello I have a friendly challenge for the board. I have some code I built that I want to see if anyone can improve the performance of. I never had any formal VBA education other than the trial and error method and learning from looking at different code on this board. Here is the challenge...
  15. S

    Creating Moving Average in Pivot Tables

    Hi Is there any way to create an average on each row of data in a pivot table when you have one column giving you a monthly total and are using a calculated field giving the ongoing running total for the year to date. Don't seem to be able to use the running total as a field in another...
  16. S

    Calculating Moving Average

    We are developing a tiered commission structure for our sales reps whereby the percent commission they earn will be based on the recent moving average of their sales. For example, if salesperson X has a 60 day moving average of $25,000 in sales, they would earn a higher percentage of...
  17. S

    Moving Average in Pivot Table Calculating off Percentages

    Moving Average in Pivot Table Calculating off Percentages- <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Need it to Calculate off Actuals (Need to Use a Range)<o:p></o:p> <o:p> </o:p> I have a pivot table that filters by three data fields: Card...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top