Hi,
Id like to place a back bet in C2 at desired odds in D2.
So basically i want to enter "BACK" in C2 and have it to place a back bet when type it in. "Back at odds" is the cell where I enter manually my own odds.
I know how to display actual odds but cant figure out how to back bet from my sheet.
The original bet angel spreadsheet is in the spreadsheet as you can see in the bottom part.
THanks in advance.
How to place a bet from my own sheet using BA
- ilovepizza82
- Posts: 493
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
You do not have the required permissions to view the files attached to this post.
- ilovepizza82
- Posts: 493
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
45 people seen this post and nobody knows or is it not possible ?
-
- Posts: 40
- Joined: Sun Oct 13, 2019 6:23 pm
You may be able to use Vlookup to put the values in the BA sheet.
I assume you have a market live in the Bet Angel tab?
Then you need to get the data from your Today3 tab to the Bet Angel tab and in the correct place.
As sphilipmyer has said you could use Vlookup functions in the Bet Angel tab to retrieve the data but personally I would use some VBA to give you more control.
I would write some VBA code that executes on a button click on the Today3 tab, when you have made your manual entries in the sheet you click on the button and your VBA then takes the data and places it in the correct areas on the Bet Angel sheet. BA will then fire off the bets to BF.
Then you need to get the data from your Today3 tab to the Bet Angel tab and in the correct place.
As sphilipmyer has said you could use Vlookup functions in the Bet Angel tab to retrieve the data but personally I would use some VBA to give you more control.
I would write some VBA code that executes on a button click on the Today3 tab, when you have made your manual entries in the sheet you click on the button and your VBA then takes the data and places it in the correct areas on the Bet Angel sheet. BA will then fire off the bets to BF.