On this sample sheet...... https://docs.google.com/spreadsheets...it?usp=sharing

...... my goal is to add a historic stock price, probably between 'columns D & E' that the 'Return %' in 'column I' can calculate. Currently, as you can see, it is working off the small table in 'columns N & O', which (as an example on Row 15) uses the GoogleFinance formula in N14 to calculate by the date entered in D15.

I suppose I could just hide this table somewhere off to the side, but I would like to know if there is a cleaner option?