bet

  1. B

    fibonacci sequence folmula

    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...
  2. G

    Golf Bet Sheet

    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)...
  3. H

    Put result of ActiveWorkbook.Queries in Array instead of in a Worksheet

    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"" =...
  4. P

    How to set up an effective formula for testing a betting system.......

    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...
  5. P

    Formula for testing a betting system

    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...
  6. M

    Horse racing treble permutations

    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...
  7. M

    Creating a betting system for personal use.

    <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...
  8. N

    Formula that maintains a persistent profit margin

    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...
  9. R

    Odds Formula

    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...
  10. T

    Caculating odds in excel?

    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...
  11. K

    help with formula based on criteria

    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...
  12. D

    opening the excel working file -> opens an additional one with empty contents - how get rid of 2nd ws

    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...
  13. B

    IF Formula replacement instead of using EXACT

    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...
  14. M

    Sports Betting Excel Spreadsheet

    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...
  15. M

    Simple if and question

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top