I have a large table of daily stock price returns that looks something like this:
I'd like to calculate the daily return but instead of directly referencing the cell row/columns, I'd like to type elsewhere in my spreadsheet the cells I'd like to use for my calculation, then reference those in my formula. For example, the return calculation on 1/4/2020 would normally be =(.04/.02)-1. What I want to do is type in "B3" and "B4" in - for example - cells C1 and C2. I'd like my daily return calculation to read =(C2/C1)-1. By doing this, I can easily choose two dates using cells C1 and C2 instead of scrolling up and down the table.
Thx in advance for your help.
Date | Return |
1/2/2020 | .05 |
1/3/2020 | .02 |
1/4/2020 | .04 |
... | ... |
3/13/2020 | -.09 |
I'd like to calculate the daily return but instead of directly referencing the cell row/columns, I'd like to type elsewhere in my spreadsheet the cells I'd like to use for my calculation, then reference those in my formula. For example, the return calculation on 1/4/2020 would normally be =(.04/.02)-1. What I want to do is type in "B3" and "B4" in - for example - cells C1 and C2. I'd like my daily return calculation to read =(C2/C1)-1. By doing this, I can easily choose two dates using cells C1 and C2 instead of scrolling up and down the table.
Thx in advance for your help.