I am using this formula to calculate daily,weekly, and monthly returns. Since I have to insert a new column each day to reflect the most current day's price, I use the following formula so that the absolute cell/column is referenced in my calculation does not change:

=((INDIRECT("M4")-INDIRECT("N4"))/INDIRECT("N4"))

The problem is when I copy this cell down to the remaining rolls (each roll reflects an individual stock), the formula does not increment the roll number. Is there a way to copy down this formula and have the roll referenced to increment to reflect the current roll number?

Thanks