Managing Graph of Portfolio with Deposits/Withdrawals

[cscott]

I use Excel to manually enter my trading balance at the end of every month, and then turn it into a graph. With withdrawals and deposits, the graph isn't accurate. How do I enter and graph my trading balance to take into account withdrawal or deposits?

 

[nazzdack]

Only make a graph of your cumulative profit & loss. Your account balance won't matter.

 

[cscott]

How do I do that?

 

[Wayne Gibbous]

Quote from cscott:

How do I do that?

You should log every trade in Excel. Yep, every single one. Even if there are thousands.

This log should include date, basis, method, security, P&L, commish, notes, etc. With that data you can create any chart or stats you want.

 

[cscott]

Quote from Wayne Gibbous:

You should log every trade in Excel. Yep, every single one. Even if there are thousands.

This log should include date, basis, method, security, P&L, commish, notes, etc. With that data you can create any chart or stats you want.

Thanks, Wayne, but that's more work that I really wanted to do.

 

[JimmyJam]

Here's an example of how you can keep track of the aggregagate totals. You'll have to customize the spreadsheet to your specific situation for best results.

JJ

 

[cscott]

Quote from JimmyJam:

Here's an example of how you can keep track of the aggregagate totals. You'll have to customize the spreadsheet to your specific situation for best results.

JJ

Thanks, but why ending and beginning balance. Isn't one enough? My ending balance is always the same as my beginning for the next month.

 

[JimmyJam]

Quote from cscott:

Thanks, but why ending and beginning balance. Isn't one enough? My ending balance is always the same as my beginning for the next month.

It's just an example spreadsheet.

I don't know your specific situation, so feel free to modify the spreadsheet/formulas to suit your needs.

Good trading,

JJ