There is currently 1 person viewing this thread.
hi in excel I have
column D that has runners,
column J that has betfair prices,
column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners
column W the result of the formula
and I want to add to column W a formula that would highlight cells ( say with a colour ) to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
hope that is clear...lol
please explain in detail because I am new to this
many thanks in advance
dave
column D that has runners,
column J that has betfair prices,
column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners
column W the result of the formula
and I want to add to column W a formula that would highlight cells ( say with a colour ) to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
hope that is clear...lol
please explain in detail because I am new to this
many thanks in advance
dave
sort by:
Show
per page
Replies: 106
|
By:
C*+(AG-W) DJ# then the colour, say [BLUE]
|
|
By:
blooming eck that was quick....
 will try it when I get backwhere do I put the 26.9% which is the most important bit |
|
By:
Format > Conditional formatting ... i've never used it but I think its in there that you can have a cell highlight if above a determined value
|
|
By:
You beat me to it, Deltâ.
|
|
By:
sorry Delta just tried that and it didn't work
|
|
By:
maybe it's me that didn't do it right, am now trying it in column BP because W is part of an array and it won't let me paste it there, it jsut pastes the formula in the cell.maybe I am missing something obvious here....I did say I was newto excel..
 |
|
By:
http://www.excelforum.com/
|
|
By:
cheers gandalf, I have tried them before and their not as clever as people on here, but will post the question too and see who comes up with best way
|
|
By:
http://www.techonthenet.com/excel/index.php
General Betting section is the best place on here to ask |
|
By:
Delta is pulling your leg
 |
|
By:
http://www.techrepublic.com/blog/10things/10-cool-ways-to-use-excels-conditional-formatting-feature/3166
|
|
By:
cheers Stow have posted on General betting as well because not sure which section had the brainiest forumites...
 and presently had no replies on there, will try those links as well ta |
|
By:
how do you get betfair prices into your excel, do you manually input?
|
|
By:
lol your asking me something now, the prog uses vba and macro I think and logs me in to lite.betfair and gets them for me and everytime they refresh it compares with original prices so I have an idea of whats being backed or drifting, but I want to have highlighted top 26.9% of runners to lay below say 16.0 that are not in the top 26.9% of my rankings
|
|
By:
http://www.contextures.com/xlCondFormat01.html
|
|
By:
You might be better off producing an odds forecast to 100% and betting those which were 15-20% better odds and laying those that were 15-20% under your odds forecast. It would very much depend upon the quality of your ratings. I believe Ghengis had a go at this a number of years ago. His ratings were the nuts mind.
|
|
By:
so you'll need a column with number of runners in every row of the field and another column to divide ranking number by the field size for what % of the field size each runner ranks, then a further column to ask if % is below 26.9% and price below 16 to return 1 for true and 0 for false and use conditional fomratting to highlight this cell if value is 1.
|
|
By:
lol...that sounds a bit complicated for a newbie like me to create,
|
|
By:
surely this is a conditional formatting solution
i'd have a read up on that i don't really understand what you want highlighted but this will highlight cells based upon a condition you set? |
|
By:
to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
i think i've got monday lethargy, i cannot understand this at all  |
|
By:
it would help to see how your spreadsheet is laid out is there a column with race number or time in it
|
|
By:
*tuesday even
 |
|
By:
stridingedge he has all runners in a race in order of rating, say there are 19 runners he wants to lay those in the list if you divide their position by 19 you get less than 26.9 ... in this cae 1-5 as 6/19 is over 26.9 and he wants to lay any of these 5 if their projected odds are 15.0 or lower
|
|
By:
sorry other way around those that aren't in his top 5
|
|
By:
so a simple conditional format of the odds position/number of runners when odds=
|
|
By:
goodyd is there anythin in column AH as the first thing you need to do is put a formula in there to make field size in every row
|
|
By:
half my post just disappeared
 i need to visualize this, find it hard without seeing the actual data it doesn't sound complicated am sure conditional formatting is what he's after |
|
By:
it is ultimately stridingedge but he needs to add formula to make a column read 1 for true and 0 for false
|
|
By:
i'll see if i can follow exactly what he wants in a spreadsheet
|
|
By:
goodyd, why don't you take a photo of whats on your screen and post it in this thread so we can see the spreadsheet
|
|
By:
hi the first vacant cell is BP the number of runners is in column A43 but it changes for every race have uploaded / inserted a screenprint but waiting for aproval for it, out now until tomorrow so will check back then
thanks again for all your help and advice dave |
|
By:
you read my mind grendel
|
|
By:
have you got some marker so the sheet recognizes each race?
|
|
By:
ie just having number of runners isn't helpful
need to be able to recognize what data each race covers in the sheet is there a colums with the race meet,time etc |
|
By:
column A43??? dont you mean two letters? ... a43 is a single cell
|
|
By:
does the spreadsheet only contain one race at a time then?
|
|
By:
need to see this on the screen
|
|
By:
i'm sure i've done far more complicated things than what's being asked for here
but without seeing how the sheet actually looks impossible to start trying to solve. |
|
By:
does he have a column wth the number of runners? If so its just a nested if formula ie if rating/columnrunners*100 >25 and if betfair price is less than 15 "1" otherwise "0". Then format the cell to go red if the value is "1"
|