General Betting
There is currently 1 person viewing this thread.
Column F has over 2500+ cells with numeric data as does Column G
Column F holds data for 'winning odds'
Column G holds data for 'losing odds'
Basically need to record how many of the cells in Column F which holds the winning odds - were 'favourites'
How do I automatically do this do this without manually working it out.
Is there a formula for this that anyone know of ?
Column F holds data for 'winning odds'
Column G holds data for 'losing odds'
Basically need to record how many of the cells in Column F which holds the winning odds - were 'favourites'
How do I automatically do this do this without manually working it out.
Is there a formula for this that anyone know of ?
sort by:
Show
per page
Replies: 21
|
By:
Do you have any columns giving you the market details as you'd need that to find the fav for each individual market, do the columns G and F have empty data i.e. if cell F11 is filled cell G11 is empty to show it was a winner
|
|
By:
Are the odds stored in ascii format copied from an online sorce like racing post, if so you can
use a bit of code to string search for F or FAV before you convert to a value, personally I edit them manually and omit the fav part of text . |
|
By:
Each and every cell from F2 down to cell F2677 has decimalised odds entered as does every cell from G2 down to G2677, so no cell is unfilled.
It's for tennis - so Column F has the odds for the winning player and G for the losing player, they are average odds taken on each match of the 2011 season from several bookmakers - so basically I wanted every cell in the F column that has a lower numeric value than it's neighbouring G cell to be calculated to give the total number of 'favourite wins' They are other columns with market data next to them - but that's just tournaments category info, 250, 500 masters, slams world tour finals - dates - times - location - sets scores etc. Thought it might be a long shot tbh. |
|
By:
how many outcomes are their in tennis, I assume its just 2 in which case the sub 2 prices are all favorites, but if its a leg of a competition price then its pretty tough or impossible to work out the favorite just from the price .
|
|
By:
If colums f and g have both odds of the indiviual match players then
make another column say x and do =If(g |
|
By:
=if(g
|
|
By:
sorry thuis stupid pop up wont print the various excel exclamations
|
|
By:
=if(g less than f;"favourite";"outsider")
|
|
By:
less than is the arrow head point to the left, cant print it on here!
|
|
By:
omit the ; for ,
|
|
By:
its sometime better to flag a met condition with "true" as you then dont have to string match later for result and makes for more compact and easy code.
|
|
By:
nearly all good programming involves using the simplest long term solution.
|
|
By:
Just do what bf said , in cell H do do a simple if statement to put 1 in the cell if F is less than G then simply do a sum of column H for the number of winning favs
=IF(F2 |
|
By:
=IF(F1
|
|
By:
bf_fanatic, thanks for guidance, will try soon and let you know how it goes but have to log off now and if it doesn't work - it's a lesson for 2012, wok it out manually as I go along - which obviously should have occurred to me in the first place - such is life.
cheers. |
|
By:
grr what's up with this forum :(
=IF(F2[b] |
|
By:
< >
http://chexed.com/ComputerTips/asciicodes.php Alt60 for < Alt62 for > |
|
By:
Another way.
Add a column H (or wherever), and insert formula to subtract losers from winners eg. =f-g. The formula you can then use is: =COUNTIF(h2:h2500,">0") |
|
By:
yep thats another way to do it stoat40, shame there isnt a programming department on this forum as
its needed and the developers forum isn't really a live environment as its based on some few projects that seem to be gathering dust in betfairs archives, presumably because of the effect of the top 500 on betfairs revenues  |
|
By:
fear not betfair, for we all code for the same thing and for the same reasons.
|
|
By:
Just seen this. How about putting =SIGN(F1-G1) in column H
It will return 1,0 or -1 meaning fav won ,Joint Favs or Fav lost. This will make further processing simpler |