JackJackson54
asked on
Automate betting on Trifectas and Superfectas
First of all, I live in a state where I can bet online. There is nothing illegal about this. I have attached a Worksheet that shows an example of a race and the structure that would be bet.
There might be 8 races, 9 races, 10 races up to 14 races from this sheet. This is just an example of 1 race. I want to send this bet to a TEXT file on the Desktop in the structure.
I would like to be able to send all the bets for all races for the day. There may be a race that will not be bet. In other words, I might bet 9 races of a 10 race card, having skipped maybe the 5th race or some other race. Here is the bet structure I need:
2008-12-29,PEN,2,SUPERFECT A,(3;4)-(1 ;3;4;6;7)- (1;3;4;5;6 ;7;10)-(1; 3;4;5;6;7; 8;10),1,,W HEEL
2008-12-29,PEN,2,TRIFECTA, (3;4)-(1;3 ;4;6;7)-(1 ;3;4;5;6;7 ;10),1,,WH EEL
Please note that between the 1 and wheel is a field that needs to be blank as indicated by the , ,
The betting amounts might change from race to race. This particular bet has a bet of $1.
Any number in the "spot" that has a 1 will be in the first as indicated by (3:4). 3 or 4 are the program numbers to bet. Any number in "spot" that is 1 or 2 will be in the second position as indicated by (1:3;4;6;7) and then the numbers for the 3rd position (trifectas) and 4th position (superfecta). You get the picture. These are 2 separate types of bets - trifecta and superfecta.
Bets.xls
There might be 8 races, 9 races, 10 races up to 14 races from this sheet. This is just an example of 1 race. I want to send this bet to a TEXT file on the Desktop in the structure.
I would like to be able to send all the bets for all races for the day. There may be a race that will not be bet. In other words, I might bet 9 races of a 10 race card, having skipped maybe the 5th race or some other race. Here is the bet structure I need:
2008-12-29,PEN,2,SUPERFECT
2008-12-29,PEN,2,TRIFECTA,
Please note that between the 1 and wheel is a field that needs to be blank as indicated by the , ,
The betting amounts might change from race to race. This particular bet has a bet of $1.
Any number in the "spot" that has a 1 will be in the first as indicated by (3:4). 3 or 4 are the program numbers to bet. Any number in "spot" that is 1 or 2 will be in the second position as indicated by (1:3;4;6;7) and then the numbers for the 3rd position (trifectas) and 4th position (superfecta). You get the picture. These are 2 separate types of bets - trifecta and superfecta.
Bets.xls
I've little idea about betting so please explain the terms you are using:
SUPERFECTA
TRIFECTA
SUPERFECTA
TRIFECTA
Does:
SUPERFECTA mean 4th position
and
TRIFECTA mean 3rd position
and what about
WHEEL
what does that mean?
SUPERFECTA mean 4th position
and
TRIFECTA mean 3rd position
and what about
WHEEL
what does that mean?
ASKER
Trifecta means to pick the first 3 finishers in exact order.
Superfecta means to pick the first 4 finishers in exact orfer.
Jack
Superfecta means to pick the first 4 finishers in exact orfer.
Jack
ASKER
Wheel is a constant term with the provider I upload the bets to.
It just needs to be a constant term and always there.
It just needs to be a constant term and always there.
OK, now please explain how these are achieved from the table that you have provided:
2008-12-29,PEN,2,SUPERFECT A,(3;4)-(1 ;3;4;6;7)- (1;3;4;5;6 ;7;10)-(1; 3;4;5;6;7; 8;10),1,,W HEEL
2008-12-29,PEN,2,TRIFECTA, (3;4)-(1;3 ;4;6;7)-(1 ;3;4;5;6;7 ;10),1,,WH EEL
2008-12-29,PEN,2,SUPERFECT
2008-12-29,PEN,2,TRIFECTA,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Many of us live countries where on-line betting is legal.