Simple Moving Average Bottom Up Instead of Top Down; Newest Date at top

I have been running in circles the past few days trying to write VBA code for a 14 day simple moving average that starts at the bottom of the worksheet instead of the top. I am extracting data from Yahoo and the most recent date is at the top of the page then descends downwards to the oldest date. Whatever I try to do, when I write the code using the average function, it always starts at the top of the worksheet and moves down

I would like have the most recent date at the top because it is easier to read. Below is the code so far but I am even unsure if it is correct.

i.e.

5/20/16
5/19/16
5/18/16
5/17/16

etc..

Please Login or Register  to view this content.

Thankyou everyone in advance for looking at this. I have learned a lot on this forum along with trial and error.

Hi Jeff,

Thankyou much for your time. I intend to use the Average in a workbook consisting of 20 stocks in which I will
update the prices everyday with the most recent DATE, OPEN, HIGH, LOW, CLOSE will be at the top of the spreadsheet.
The Average should be calculated from the bottom up. Please see the attached file.

Thankyou very much

Joe

See if this gets you there. Note that you attached a csv file, which is data only. I had to save it as an Excel file to save formulas and add a macro.

I don't understand what you mean by this:

This is incorrect. The Moving Average should start at the bottom of the range instead of the top

A two-week moving average for any given date is defined as the average of that date and the 13 days before that date. It doesn't make sense to talk about where it starts (bottom or top).

You didn't specify what you wanted the average of so I used the closing price. I also added a macro with a button to insert a new row and fill in the formula for the average.

I think this is the correct code for a 3 period SMA; I have been fiddling around with it and it seems to be correct but I am a little

concerned with

Please Login or Register  to view this content.

I think I have this correct.

Would the above mean 2 rows up from the very last row in a range and 2 columns from the left of the last column in a range ?

Please Login or Register  to view this content.

I saw your post in between my last reply . I like your solution, how do you change the moving average ?

Thankyou very much for your time.

Originally Posted by rmccain

I saw your post in between my last reply . I like your solution, how do you change the moving average ?

Change it how? Change how many days it includes?

Thankyou very much for this and your time !