+ Reply to Thread
Results 1 to 5 of 5

Looking for profit in a betting spreadsheet

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2017
    Location
    Milan
    MS-Off Ver
    Pro Plus 16
    Posts
    2

    Looking for profit in a betting spreadsheet

    Hello,

    I'm a very basic user so forgive me if i'm going to ask something clearly impossibile or very naive.
    Also english is not my first language so I guess i'm the complete package

    I'll try to explain the best I can...

    I've a spreadsheet with several thousands of past soccer results with live game statistics (corners, shots on targets, free kicks, etc.), minutes, live betting odds, hypothetical profit/loss for each game and so on. These stats are listed in colums.

    Of course i'm trying to find some profitable strategies based on that.

    So far I've worked using filters manually, isolating matches with specific details - i.e. matches with more than 15 shots, 9 corners and 30 minutes left to play that ended or not with at least an additional goal. Then the spreadsheet calculate the hypothetical profit&loss of that sample and its return of investment.

    Of course is very time consuming because I have to check hundreds of possibile combinations of stats to discard the loosing "strategies" and fine tune the promising ones.

    In brief, my task is monumental.

    I'm wondering if there some kind of accessible "problem solving" feature/add on which can do it for me.
    It should check every possible combination of filters/stats checking their profitability.
    Ideally I would like to set some parameters as fixed and let it explore the remaining stats.

  2. #2
    Forum Contributor
    Join Date
    04-09-2013
    Location
    Philippines, Manila
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Looking for profit in a betting spreadsheet

    Hi Layne,

    Do you have a sample data that I could start working on?

    Tnx

  3. #3
    Registered User
    Join Date
    03-06-2017
    Location
    Milan
    MS-Off Ver
    Pro Plus 16
    Posts
    2

    Re: Looking for profit in a betting spreadsheet

    Hello Jarvin,

    thanks for the reply.

    Here it is.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-09-2013
    Location
    Philippines, Manila
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Looking for profit in a betting spreadsheet

    Hi Layne,

    Does your parameter keeps on changing? or is it fixed?

    Because if its keep on changing, then I think you need to use MACRO.. but, if the parameters are constant, then maybe we can do something about it... Do you have the parameters you want to set?

  5. #5
    Forum Contributor
    Join Date
    04-09-2013
    Location
    Philippines, Manila
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Looking for profit in a betting spreadsheet

    Layne.. By the way, the one you provided is RAW data.. do you have sample reports?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Profit / Loss calculation spreadsheet
    By cmb80 in forum Excel General
    Replies: 2
    Last Post: 09-26-2014, 04:35 AM
  2. [SOLVED] Fixed Profit formula/calculator for betting
    By eruption in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2014, 12:50 AM
  3. I need a simple betting staking spreadsheet
    By buthers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2013, 11:38 AM
  4. [SOLVED] Working out betting sums to return a specific profit
    By jessecain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2013, 07:24 AM
  5. [SOLVED] Formula for my Betting Spreadsheet
    By WayneI in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2012, 07:16 PM
  6. Replies: 1
    Last Post: 10-09-2012, 08:40 AM
  7. Replies: 0
    Last Post: 05-31-2006, 02:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1