Spreadsheet: 167718d1342077344-indirect-function-absolute-reference-multiple-rows-new-cells-inserted-by-shiftingdown-keep-cell-reference-same-query
Sheet: Sheet1

DATE | OPEN | HIGH | LOW | CLOSE |  | SMA20
2012-07-10 00:00:00 | 5286.6 | 5348.55 | 5284.55 | 5345.35 |  | 5192.710000000001
2012-07-09 00:00:00 | 5283.7 | 5300.6 | 5257.75 | 5275.15 |  | 5181.237500000001
2012-07-06 00:00:00 | 5324.7 | 5327.2 | 5287.75 | 5316.95 |  | 5170.185
2012-07-05 00:00:00 | 5297.05 | 5333.65 | 5288.85 | 5327.3 |  | 5157.755000000001
2012-07-04 00:00:00 | 5310.4 | 5317.65 | 5273.3 | 5302.55 |  | 5143.8725
2012-07-03 00:00:00 | 5298.85 | 5317 | 5265.95 | 5287.95 |  | 5128.6
2012-07-02 00:00:00 | 5283.85 | 5302.15 | 5263.35 | 5278.6 |  | 5107.3675
2012-06-29 00:00:00 | 5191.25 | 5286.25 | 5189 | 5278.9 |  | 5085.845
2012-06-28 00:00:00 | 5148.95 | 5159.05 | 5125.3 | 5149.15 |  | 5063.98
2012-06-27 00:00:00 | 5149.45 | 5160.1 | 5129.25 | 5141.9 |  | 5052.735000000001
2012-06-26 00:00:00 | 5107.45 | 5134.55 | 5095.5 | 5120.8 |  | 5043.1775
2012-06-25 00:00:00 | 5158.5 | 5194.6 | 5105.65 | 5114.65 |  | 5036.6425
2012-06-22 00:00:00 | 5101.75 | 5159.8 | 5094 | 5146.05 |  | 5030.1925
2012-06-21 00:00:00 | 5097.35 | 5170.4 | 5093.45 | 5165 |  | 5018.91
2012-06-20 00:00:00 | 5114.55 | 5141.7 | 5100.7 | 5120.55 |  | 5006.73
2012-06-19 00:00:00 | 5050.8 | 5113.6 | 5048.1 | 5103.85 |  | 4992.484999999999
2012-06-18 00:00:00 | 5174 | 5190.2 | 5041.7 | 5064.25 |  | 4980.317499999999
2012-06-15 00:00:00 | 5069.55 | 5146.2 | 5069.15 | 5139.05 |  | 4972.407499999999
2012-06-14 00:00:00 | 5105.1 | 5130 | 5047.6 | 5054.75 |  | 4960.027499999999
2012-06-13 00:00:00 | 5117.55 | 5144.9 | 5095.45 | 5121.45 |  | 4950.799999999999
2012-06-12 00:00:00 | 5015.5 | 5128.9 | 5015.15 | 5115.9 |  | 4937.639999999999
2012-06-11 00:00:00 | 5096.7 | 5124.45 | 5040.7 | 5054.1 |  | 4928.985
2012-06-08 00:00:00 | 5044.25 | 5084.45 | 4994.8 | 5068.35 |  | 4921.67
2012-06-07 00:00:00 | 5035.35 | 5059.65 | 5007.75 | 5049.65 |  | 4913.95
2012-06-06 00:00:00 | 4886.65 | 5010.45 | 4886.15 | 4997.1 |  | 4906.411111111111
2012-06-05 00:00:00 | 4869.45 | 4898.95 | 4847.7 | 4863.3 |  | 4901.076470588237
2012-06-04 00:00:00 | 4797.3 | 4858.3 | 4770.35 | 4848.15 |  | 4903.4375
2012-06-01 00:00:00 | 4910.85 | 4925 | 4831.75 | 4841.6 |  | 4907.123333333334
2012-05-31 00:00:00 | 4896.1 | 4949.25 | 4883.55 | 4924.25 |  | 4911.803571428572
2012-05-30 00:00:00 | 4964.25 | 4982.25 | 4944.9 | 4950.75 |  | 4910.846153846154
2012-05-29 00:00:00 | 5005.35 | 5020.15 | 4982.15 | 4990.1 |  | 4907.520833333333
2012-05-28 00:00:00 | 4931.7 | 4994.95 | 4931.3 | 4985.65 |  | 4900.013636363637
2012-05-25 00:00:00 | 4905.95 | 4935.8 | 4889.35 | 4920.4 |  | 4891.45
2012-05-24 00:00:00 | 4863.4 | 4931.9 | 4830.15 | 4921.4 |  | 4888.233333333334
2012-05-23 00:00:00 | 4843 | 4853.75 | 4803.95 | 4835.65 |  | 4884.087500000001
2012-05-22 00:00:00 | 4954.7 | 4956.35 | 4849.9 | 4860.5 |  | 4891.007142857144
2012-05-21 00:00:00 | 4888.5 | 4937.5 | 4888.5 | 4906.05 |  | 4896.091666666666
2012-05-18 00:00:00 | 4796.4 | 4908.5 | 4788.95 | 4891.45 |  | 4894.1
2012-05-17 00:00:00 | 4878.6 | 4922.25 | 4850.2 | 4870.2 |  | 4894.7625
2012-05-16 00:00:00 | 4875.3 | 4882.25 | 4837.05 | 4858.25 |  | 4902.95
2012-05-15 00:00:00 | 4869.85 | 4955.2 | 4868.55 | 4942.8 |  | 4925.3
2012-05-14 00:00:00 | 4934.35 | 4957.2 | 4874.5 | 4907.8 |  | 4907.8
This extends to say, 500 rows, so manually, it becomes cumbersome to make formula change for every row!!