I am a lot of data involving stocks. Say 50 shares in the portfolio. I want a formula that will be able to sum up the return for each stock based on a given date period. For example each stock between 1/1/19 and 1/2/19.
My data is currently with dates going vertical, and the returns for each stock across in rows. Excel is attached and data will be run off the "Data Input" tab.