I am creating a presentation for financial sales.
I want to take a stock index ( DJIA, SP500, NASDAQ) and make excel go back 30 years to the day to retrieve the value, then 29 years, then 28 yrs, all the way to last year. I want all values entered in a row.
Then I want to calculate the difference and express it a percentage. I then want to create a graph that will show positive percentage gains as a green line, but negative percentage gains as a red line.

In the next excel sheet and graph I want to do the same, but show only positive gains. If there are negative returns, then the percentage is Zero and the green line is flat.

Basically, I am showing a "backtest" for investment returns in a fully invested index versus an account that uses futures contracts to lock in investment gains.

I would like to be able to to this for each of the 3 indices (perhaps from a dropdown box) but make it work daily.

Once the sheet is perfected I will insert it into a powerpoint.

Is this too bi an ask?