Spreadsheet: 862591d1710266986-how-to-pull-data-from-the-next-available-date-if-the-date-isnt-an-exact-match-problem-sample-workbook
Sheet: historical data

date | close | open | high | low
2020-05-18 00:00:00 | 9234.83 | 9177.15 | 9267.22 | 9154.35
2020-05-15 00:00:00 | 9014.56 | 8839.99 | 9018.4 | 8821.38
2020-05-14 00:00:00 | 8943.72 | 8788.04 | 8945.71 | 8705.25
2020-05-13 00:00:00 | 8863.17 | 9006.05 | 9074.16 | 8752.68
2020-05-12 00:00:00 | 9002.55 | 9225.14 | 9250.96 | 9000.06
2020-05-11 00:00:00 | 9192.34 | 9054.91 | 9241.92 | 9053.17
2020-05-08 00:00:00 | 9121.32 | 9056.89 | 9125.98 | 9018.21
2020-05-07 00:00:00 | 8979.66 | 8973.78 | 9015.99 | 8932.85
2020-05-06 00:00:00 | 8854.39 | 8874.7 | 8933.25 | 8819.37
2020-05-05 00:00:00 | 8809.12 | 8809.66 | 8909.96 | 8781.31
2020-05-04 00:00:00 | 8710.71 | 8555.32 | 8715.82 | 8537.83
2020-05-01 00:00:00 | 8604.95 | 8681.29 | 8754.46 | 8566.84
2020-04-30 00:00:00 | 8889.55 | 8911.01 | 8926.11 | 8825.83
2020-04-29 00:00:00 | 8914.71 | 8802.7 | 8957.26 | 8765.01
2020-04-28 00:00:00 | 8607.73 | 8825.68 | 8830.57 | 8600.7
2020-04-27 00:00:00 | 8730.16 | 8717.98 | 8754.57 | 8697.37
2020-04-24 00:00:00 | 8634.52 | 8530.08 | 8642.93 | 8464.42
2020-04-23 00:00:00 | 8494.75 | 8528.84 | 8635.22 | 8475.2
2020-04-22 00:00:00 | 8495.38 | 8434.55 | 8537.31 | 8404.54
2020-04-21 00:00:00 | 8263.23 | 8460.69 | 8480.29 | 8215.69
2020-04-20 00:00:00 | 8560.73 | 8553.37 | 8684.91 | 8553.37
2020-04-17 00:00:00 | 8650.14 | 8667.48 | 8670.3 | 8531.69
2020-04-16 00:00:00 | 8532.36 | 8479.11 | 8560.16 | 8393.27
2020-04-15 00:00:00 | 8393.18 | 8355.96 | 8464.66 | 8308.79
2020-04-14 00:00:00 | 8515.74 | 8353.21 | 8531.11 | 8338.09
2020-04-13 00:00:00 | 8192.42 | 8127.69 | 8200.44 | 8035.95
2020-04-09 00:00:00 | 8153.58 | 8169.01 | 8227.91 | 8072.32
2020-04-08 00:00:00 | 8090.9 | 7975.72 | 8114.43 | 7901.94
2020-04-07 00:00:00 | 7887.26 | 8129.99 | 8146.43 | 7881.22
2020-04-06 00:00:00 | 7913.24 | 7660.17 | 7938.33 | 7617.79
2020-04-03 00:00:00 | 7373.08 | 7477.27 | 7518.72 | 7288.11
2020-04-02 00:00:00 | 7487.31 | 7317.45 | 7501.7 | 7307.95
2020-04-01 00:00:00 | 7360.58 | 7459.5 | 7566.37 | 7301.98
2020-03-31 00:00:00 | 7700.1 | 7740.06 | 7880.31 | 7642.86
2020-03-30 00:00:00 | 7774.15 | 7583.46 | 7784.35 | 7539.97
2020-03-27 00:00:00 | 7502.38 | 7554.25 | 7716.24 | 7491.13
2020-03-26 00:00:00 | 7797.54 | 7462.21 | 7809.82 | 7462.21
2020-03-25 00:00:00 | 7384.3 | 7421.36 | 7671.21 | 7276.4
2020-03-24 00:00:00 | 7417.86 | 7196.15 | 7418.37 | 7169.86
2020-03-23 00:00:00 | 6860.67 | 6847.28 | 6984.94 | 6631.42
2020-03-20 00:00:00 | 6879.52 | 7248.07 | 7354.44 | 6854.67
2020-03-19 00:00:00 | 7150.58 | 6996.45 | 7341.38 | 6858.38
2020-03-18 00:00:00 | 6989.84 | 6902.32 | 7182.83 | 6686.36
2020-03-17 00:00:00 | 7334.78 | 7072 | 7406.23 | 6828.91
2020-03-16 00:00:00 | 6904.59 | 7392.73 | 7422.2 | 6882.86
2020-03-13 00:00:00 | 7874.88 | 7610.39 | 7875.93 | 7219.09
2020-03-12 00:00:00 | 7201.8 | 7398.58 | 7712.33 | 7194.67
2020-03-11 00:00:00 | 7952.05 | 8136.25 | 8181.36 | 7850.95
2020-03-10 00:00:00 | 8344.25 | 8219.76 | 8347.4 | 7930.43
2020-03-09 00:00:00 | 7950.68 | 7957.93 | 8243.31 | 7943.16
2020-03-06 00:00:00 | 8575.62 | 8469.02 | 8612.36 | 8375.13
2020-03-05 00:00:00 | 8738.6 | 8790.09 | 8921.08 | 8677.39
2020-03-04 00:00:00 | 9018.09 | 8834.1 | 9019.96 | 8757.66