odds

Hi, I would love for some help in writing some VBA code such that it will scrape data from a given URL for betting sites, and will return the specific betting odd values as required within a sheet. I then want it so that these values can always be refreshed as required. For example: Using...

I have simple table below that will work out return and place into E1 if a W is placed into C1 Back Odds W/L Formula Result 15.00 2.5 W =IF(C1,"W",A1*B1 37.50 how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure...

Hello. I have a dynamic array B2:G2600 (6 columns), on Col "M" would like to see how many odd numbers there are in the rows, and on Col "N" the even numbers. So I workout first with the macro recorder, ("this is a short version as example, only"), Sub CORR_ECT()Range("H2").Select...

Hi guys and gals. At this stage Im not looking for a specific solution to a problem but rather ideas on how to approach something. I have several spreadsheets of football data covering several seasons of results and odds. eg: <tbody> Date HomeTeam AwayTeam Home Goals Away Goals Result...

Hi I'm looking for some advice/ help. I'd like to import data (betting odds) from a website into Excel - admittedly I have no idea where to start as I've never attempted anything like this before. Here's what I'm trying to achieve... Source of odds; Oddsportal (http://www.oddsportal.com/)...

I have been doing some calculations on the Vegas odds for the NBA Championship series. I'd like to calculate the odds for every possible combination of wins and losses for the rest of the playoffs. I'd like to set up a table something like this: <tbody> C/R C D E F G H I J 7 Game 3 Game 4...

I have a UDF that calculates the odds for various events. One of the formats it can use for the result is the fractional odds (5:1, 3/4, etc.). I would like to display these in the most compact form possible. That is, no trailing zeroes. Here's some sample data the results I want: <tbody>...

I want to track the Vegas odds for the NBA playoff teams for the last few games of the season and through the playoffs. I have created a worksheet with tables like this. <tbody> R/C C D E 3 Team Odds Prob 4 Golden State Warriors 6/5 45.45% 5 Houston Rockets 8/5 38.46% 6 Cleveland...

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

This is a bit of a rush order, since it's for an NCAA pool due tomorrow. i have sorted my teams by odds of winning, but different seeds cost me differently. So I have 3 columns: team-odds-cost and I would like Excel to tell me: "If cost can't go over 100, these are the N teams to choose to...

I am looking for a way to return a count of odd numbers after the number 24. It is being used for trials in an experiment and the first 24 are not counted (I am not setting up the experiment - just the tech guy). I want to return the number of odds after 24 and the number of evens after 24. I...

Greetings; I spent some time searching but did not seem to find the answer I'm looking for, so hopefully this is not a repeat question. Nevertheless, I feel like this should have a simple answer; I just don't know what it is. Say I have a finite list of multiple independent events (no real...

Hello . I have a request for you . I want a dutching calculator who can change the profit on certain selections as I want . As an example , lets say 3 correct scores , with odds of 3 and a stake of 30 . A simple dutching calculator will spread the stake evenly on the odds to generate the same...

Looking for a programmer who is able to write or has a stable Macro for Excel that pulls live sports odds from an online source, like SBRodds.com. The Macro will need to cover all listed tabs "Today, NFL, College Football, NBA, NCAA Basketball, MLB, NHL, Soccer, Tennis, WNBA, Arena Football...