Excel

This week you will develop a model to assess the profitability of a strategy.

Let's start with:

1) acquire the daily data on Excel (from Yahoo Finance) for the past year on UVXY.

2) arrange the data so it runs from oldest to newest (dates).

3) create a formula to determine a buy at the close (today) and sell at the open (tomorrow) strategy. (this will be a difference from one time to the next)

4) generate a separate row with the information from #3.

5) next, sum the data from your calculation to determine if this strategy is profitable.

6) How can this strategy be improved or "optimized"?