Easiest way to establish which is the favorite?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
1clutch1
Posts: 12
Joined: Sun Feb 12, 2017 2:35 am

Hi,

I'm trying to create a Dashboard spreadsheet where I can edit the bet commands from.

I want all the bet commands to be the same to the multiple worksheets in the book.
When I load in 20 markets sometimes the favourites are not in selection one. Top row in the spreadsheet.

I'm not sure how to make my bet command go into the right cell if the price is less than 2.0
If I write an If statement it could fire in bets in the wrong command cell when the match goes in play.
I'm only doing tennis so there's only two runners.
What's the best way to do this?

Thanks
User avatar
ShaunWhite
Posts: 10509
Joined: Sat Sep 03, 2016 3:42 am

Create a cell for the market that identifies the favourite and include that in your logic.
Complex problems are always solved one small step at a time. Think about how you would do it manually, break it down into the smallest possible actions and replicate each step. Don't try and do it all in one mega statement.
User avatar
1clutch1
Posts: 12
Joined: Sun Feb 12, 2017 2:35 am

The problem is if I use a the price on either runner is an anchor to establish a fave. My fear is that when the match goes in play the odds flip I'll be posting to the wrong command cell.
With tennis times being inconsistent its hard to use a cell to reference
User avatar
ShaunWhite
Posts: 10509
Joined: Sat Sep 03, 2016 3:42 am

1clutch1 wrote:
Wed Feb 22, 2017 12:49 am
The problem is if I use a the price on either runner is an anchor to establish a fave. My fear is that when the match goes in play the odds flip I'll be posting to the wrong command cell.
With tennis times being inconsistent its hard to use a cell to reference
The 'Fav Y/N' cell will obviously need to be set against the selection with the smallest odds. It would be pointless if it was just a hard-coded marker.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

I posted something along these lines to deal with a similar problem another forum member had. Just changed slightly.

Sheet 2 B4 returns the minimum price of all the runners, C11 (and this is the important bit), shows what row number the fav is currently on, and D4, the name.

Looking at the BA sheet, there is a formula in each cell that looks at the runner name, and it it matches the one on sheet 2, puts a back command in.

change any of the odds in col H and the back command will change to suit the current fav

Obviously you'll need to add other criteria to suit, such as min odds.

Cheers,Nigel.
Sample.xlsx
You do not have the required permissions to view the files attached to this post.
User avatar
1clutch1
Posts: 12
Joined: Sun Feb 12, 2017 2:35 am

I got this to work on multiple sheets using a macro and a bit of VBA. Cheers for the sheet sample, I used some of the formulas which helped a lot :D
Russell
Posts: 9
Joined: Wed Nov 18, 2015 2:38 am

Can I offer an alternative way to solve this?

It is possible to identify the favourite in just one cell using the following formula...

=INDEX(B9:B17,MATCH(SMALL((G9,G11,G13,G15,G17),1),G9:G17,0))

The range can be adjusted to suit. In this example I am assuming that the favourite is likely to be in the first 5 runners.

The original question was looking at posting a bet if the odds were less than 2.0, in which case an "IF AND" formula would work. For instance, let's say the Favourite calculation above was entered into cell J3 and you were interested in the runner in cell B11. The formula would be...

=IF(AND($J$3=B11,G11<2),"Back","")

This could then be copied into the other cells.

Russell
User avatar
ShaunWhite
Posts: 10509
Joined: Sat Sep 03, 2016 3:42 am

Russell wrote:
Tue Feb 28, 2017 12:43 pm
Can I offer an alternative way to solve this?
=INDEX(B9:B17,MATCH(SMALL((G9,G11,G13,G15,G17),1),G9:G17,0))
ooooh that's slick Russell, I do love seeing code resolved down to a one-liner. But that comes from learning to code in 1k of memory.
hehe it reminds me that I once wrote a whole game of Breakout in under 900bytes :) ....but that was in 1981 so nothing fancy.
User avatar
mjmorris335
Posts: 180
Joined: Mon Jun 06, 2016 11:29 am

ShaunWhite wrote:
Tue Feb 28, 2017 5:37 pm
Russell wrote:
Tue Feb 28, 2017 12:43 pm
Can I offer an alternative way to solve this?
=INDEX(B9:B17,MATCH(SMALL((G9,G11,G13,G15,G17),1),G9:G17,0))
ooooh that's slick Russell
My old computing lecturer would've described that as elegant. Very nice.

Mike
Russell
Posts: 9
Joined: Wed Nov 18, 2015 2:38 am

Thanks guys :-)
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”