bet

If you can do this , you are a genius!! formula for a roulette betting system in excel based on the Fibonacci sequence. The sequence goes like this: 1 – 1 – 2 – 3 – 5 – 8 – 13 – 21 – 34 – 55 – 89 – 144 – 233 – 377 – 610 – 987 – … You might have noticed (or you already knew) that each of the...

So I am creating a bet sheet to track all of my bets for a golf tournament. The sheet has the bet amount and then a cell for my score and my openents score. I was trying to figure out a formula that stated that IF my score was higher than the opponents score to return a negative number (loss)...

I have a query: Bron = Excel.CurrentWorkbook(){[Name=""Finost_OI_1""]}[Content]," & Chr(13) & "" & Chr(10) & _ " #""Type gewijzigd"" = Table.TransformColumnTypes(Bron,{{""Date"", type date}, {""ArtNr"", type text}})," & Chr(13) & "" & Chr(10) & _ " #""Rijen gefilterd"" =...

Hi, What kind of excels functions that involved for setting up an effective formula to check and see if the following betting strategy would work for every 9,500 or so hands, and I'm using excel 2007: +10 +20 +10 -20 +20 +10 -20 -30 -70 -150 -10 -30 -70 +150 +10 -10 -30 +70 -10 +30 -10...

Hi, What kind of excels functions that involved for setting up an effective formula to check and see if the following betting strategy would work for every 9,500 or so hands, and I'm using excel 2007: +10 +20 +10 -20 +20 +10 -20 -30 -70 -150 -10 -30 -70 +150 +10 -10 -30 +70 -10 +30 -10...

Let's say I've selected 10 horses to bet on during a day and I would like to combine them into trebles covering all different permutations. There is more than 1 horse in each race that I want to bet on. For example, Race 1: Horses 6 & 9 Race 2: Horses 2, 4 & 7 Race 3: Horses 1, 3, 5 & 8 I know...

<tbody> ID TEAM (WIN) SCORE BET AOS </tbody> Hi, im new here, i really need help about the betting system i create. as you can see at the top. 1. ID 2. TEAM (WIN) 3. SCORE 4. BET 5. AOS i have problem when it comes to the score and the bet, which is i create like this: im using the...

Hi guys, World cup is around the corner and i'd like to do up a spreadsheet that highlights a persistent profit margin. I've done up a basic version of this. But i'd like there to be a column that highlights how much extra we will need to put in if we wanted the payout for each outcome to be...

I'm creating a spreadsheet to keep track of my hobby, sports betting. Of course, being a mediocre Excel nerd, I want to automate as much as possible, but now I'm running into a formula issue. I swear I'm so close, but now I need help from the pros. So here's what I have and what I'm looking for...

Hi Everyone, this might be super easy but was woul=ndering if someone could help me. What I want is a formula to tell me how much to bet to get as close to an amount back as possible using the odds for the bet. So Cell B3 is amount of return (for example £10) D3and F3 are the odds H3 is the...

Hi Guys, I have criteria in A:AA so for example from A2 to A12 its the same text/criteria I need to sum CF based on: If CC has "Bet" then sum 419130.572916666666667Salisbury in this case =5.39 but if the number is -1 next to "BET" then like in next case 419130.583333333333333Newcastle must be...

at the beginning with an excel working file only 1 workbook (wb1)opened. after filling wb1 with data from websites (webscraping) writing vba excel macros for analysis those data. After an excel crash (guess bad scripting) suddenly a 2nd workbook (wb2) opens (which is empty) now on each time...

I have an IF formula I've been using that uses EXACT function in it, so anytime something was in CAPS and it matched a cell it would come back with a 2. If it matched but wasn't caps it would be 1. Then those numbers would be tallied. I wanted to see if maybe there was another array I could...

Hello All, I have recently aquired Excel 2010 and still getting used to. As the new football season is about to start I am looking to make a Spreadsheet with my football accumilator selections on. I am hoping to have a column with the odds of each bet, and at the bottom a formula which will...

I am after a formula that tells me if a bet I have placed has won and in what way. It is to do with Asian handicap betting. I shall explain more. I have a bet in a1 that I have made. It may be -1, which means that I have bet on the away team to win by 1 or more goals. It could be a positive...