Calculating cumulative Profit and Loss

[MikeFranz123]

Hi guys,

So, been stuck on something a bit silly for a while now. I am trying to calculate the cumulative Profit and Loss of a portfolio on a daily basis.

Here are some sample data (lets just assume I buy 100 share):

Please Login or Register  to view this content.

So the first 5 columns (Date, Action, Quantity, RealisedProfitForDay and UnrealisedProfitForDay) are given. I am trying to calculate the cumulative profit column.

Any help would be great,

Thanks

[JBeaucaire]

Maybe in F2:

=N(F1)+E2

...copied down.


Your last row answer doesn't make sense to me.

[nigelbloomy]

If I am understanding this correctly then you want the Realized profit plus the unrealized profit and then to keep a running total.

This could be done by adding the two for the very first day in the *** profit. Then for the second day and down you would add the previous day profit plus the current day realized and unrealized profit.