I'm trialing a 1st four selecton method and i want to use a speadsheet to udate the results.

outlay
% of div
amt won
Profit/Loss

I want tpo update the starting bank which is a $1000

Most of this is easy except updating the bank at the end of each day.