Logging results from bet reuslts

[jmini123]

Hi

What is the best way to track the results from the bet results in the spreadsheet? Is there anyway we can get an excel sheet that can be simply copied into and that calculates results or is there an easy way to do it for someone not exactly expert in excel?

What would you say was the easiest way to track personal results?

Looking like a decent day today 🙂

Cheers

[dan8e11]

Hi mate,

I’d be interested in this too.

Currently leave the workbook open with a simple “sum” Equation in 1 cell, and another to calculate unit stake. Been searching for a ratchet formula, but no luck yet.

I’m sure someone will know a better way, just need to get the results page to save, and not reset. But like you definitely no expert, and don’t want to totally screw things up messing with it

[dan8e11]

edit…..

just had a little play, click file (top left).. options…. save….. automatically save to this computer……..

bet results should then remain after closing.

choose an empty cell over on the right hand side, and enter simple formula to track P/L

=SUM(D2:D1000)

will be enough for 998 results. D2000 for 1998 results etc

I’ve added a starting bank, and current bank balances to help keep track too.

now just need that ratchet formula

Dan

[jmini123]

Hi Dan,

Good stuff, I’ll have a look at doing that temporarily and try and add to it to incorporate strike rate and ROI etc..

Also going to be looking at possibly using a ratchet staking formula that I’ll adjust daily if it looks worth it.

James

[Author]

Posts