Bet calculator using excel

truthandjustice_2

I am a regular better and love betting fullcover and as such am wishing to do as follows:

Liverpool win 1-0,2-0,2-1

Nottingham Forest win 1-0,2-0,2-1

Celtic win 1-0,2-0,2-1

Aston villa win 1-0,2-0,2-1

Blackpool win 1-0,2-0,2-1



I know as a permed bet it is 3x3x3x3x3=243however I wish to place the bets as lucky 63s that cover doubles, trebles, 4folds and an accumulator. Is they any way I can input the details in excel soit will not only list each “lucky 63” but as I can add the price taken it willalso work out the return as I am thinking of picking one team from each leagueand do this each week regardless who they play as it should if correct teamspicked work out well over the whole season. If possible can excel also keep atrack of my running profit/loss although this I guess will simply A1 “Team Name”,A2 1-0, A3 2-0, A4 2-1 Then in B2-F4 will be the price for each score. Then Ineed to know how to work out the 243 separate “lucky 63s” along with the returnfrom each. Although I will need to be able to see each of the 63 calculationsin each of the bets so as to cut out the losers.

Please note I am not asking on views of thebet or my logic behind it. I just wonder how to get excel to do such acomplicated thing.

Thank you so much for your help. I will beonline all night should any questions need answering.

neilwoods

May get a better response from this site.

http://www.mrexcel.com/forum/excel-questions/613233-lucky-63-bet.html

truthandjustice_2

neilwoods wrote: »

May get a better response from this site.

http://www.mrexcel.com/forum/excel-questions/613233-lucky-63-bet.html

Thanks will try it but will have to sign up etc so hope someone here will be able to help

debitcardmayhem

Hmmm five selections does not make lucky 63's that is 6 selections, 5 selections is lucky 31, these also include the singles too. If you want lucky 63s then that is 63 x (3^6) ie 45927 bets , 31s is 7533 bets.

truthandjustice_2

debitcardmayhem wrote: »

Hmmm five selections does not make lucky 63's that is 6 selections, 5 selections is lucky 31, these also include the singles too. If you want lucky 63s then that is 63 x (3^6) ie 45927 bets , 31s is 7533 bets.

So very true. Same idea although yes would need to add the extra team.


Point is working out how to have excel give me each answer I have already got the chart with:

1. TEAM 1-0 2-0 2-1 RESULT
2. TEAM 1
3. TEAM2
4. TEAM3
5. TEAM4
6. TEAM5
7. TEAM6

under each score will e the price for that days games.
Now I need to have a chart with each Lucky 63 in it, along with what each would return based on result. Finally one showing the running profit loss and total stake to date.it would take a grid sized around 87 by 87 to do this maybe a number of times depending on if it is possible to do the sums and break down of each bet in each cell.