Excel Help
 

I need a spreadsheet that records the horese i bet the amount of the bet the return the profit and a running balance.

Can someone help?

Mad Gambler

Gday Mad

Try the attached it may help you .. if no no harm done.. some others may be able to help you more but this works fine for me...

In column D be sure there is a number one in each row... I am sorry I don't know how to do it otherwise... and just enter the info as you go along... Hope it helps

I put in the data from the start of the year. There have been 9 bets for 4 winners. It's telling there has been 9 races for 9 winners which is incorrect there should be 9 races and 4 winners for a strike rate of 44.4%. All the other information is correct.


Mad Gambler

U Have been putting the number 1 in column D? Or you have a divvie in each divvie column? coz it really should work.. see attached.. I ahve added a couple of fictional races to show you how it works...

It works fine. Thanks.


Mad Gambler

One thought. How about changing the number of races to the number of selections as I sometime bet 2 or 3 horses in a rave if the prices permit.

Mad Gambler

Gday mad

just insert another row and format accordingly, that will do the same job..

I tried, but it doesn't seem to format correctly.


Mad Gambler

I'm confused, are you a gambler or a punter, are you mad or not?

Am i the only one on the forum without a split personality? :)
Are you out there Whiteycat?