Running Profit / Loss Tracker

Good morning,

I am trying to keep a running tally of a profit / loss tracker for daily stock stuff. Everything is fine up till I enter a Withdrawl or Add a contribution.

-Everyday I go in and enter today's date along with the value of the account (Daily Start Net Liq), which is column B. If column B is greater than yesterdays column D, then the difference is profit. However, if I enter a withdrawal or a contribution the Profit and loss column is not accurate. The profit and loss in cell E3 is accurate, but from there on out it is not accurate. Below are the formula's currently used. Hope this helps explain.

Column D formula -=if(ISBLANK(B9),"",(C9+D9))
Column E Formula -=if(isblank(B10),"",abs(C10-E9-(sum($D$7:D10))))

If I add something in the withdrawal or contributions column I want to still be able to see my overall Profit and Loss, if that makes sense. Here is a screenshot of the table. Thank you.

Screenshot 2024-09-21 at 9.56.28 AM.png

Ok, sorry. First time here. I appreciate your help.

HI Janmorris,

Thank you. Hope I did this right.

HI Janmorris,

Thank you. Hope I did this right. It's not letting me post the link, however, I named it "ProfitLoss" that shows up in the link you sent me.

For clarification: I'm looking to only capture my daily P/L without the withdrawals or contributions being added to the P/L, if that makes sense. Because if I add $5000 on a day that doesn't equal profit but just an account balance addition. Hope that makes sense.For clarification: I'm looking to only capture my daily P/L without the withdrawals or contributions being added to the P/L, if that makes sense. Because if I add $5000 on a day that doesn't equal profit but just an account balance addition. Hope that makes sense.

HI Janmorris,

Yes, the screenshot is not the same as the file. I had already tried changing things around. Your screenshot appears to be what I'm looking for. Thank you for your help.

-YumaCyclist