Another question. I have a set of data, dates and P&L. I created a pivot table and have the following:
Date, Sum of P&L,
5/1 $100
5/2 -$200
5/4 $100
I would like to add a 3rd column to create a cumulative P&L or equity curve. I would like to create another column IN THE PIVOT TABLE to create an equity curve:
Equity Curve
= $100
= $100 + -$200
= 100 + -$200 + 100
Etc and ultimately chart this...
Hopefully this makes sense?
Thanks
Bookmarks