Accu-JD

Tool for upcoming fixtures

Recommended Posts

Hi I've have managed to put an excel file together that can "scrape" the upcoming fixtures from BetExplorer.com similar to Lunatism's thread "Extracting Fixtures From SOCCERWAY." but reading the text file rather than a web query. On the menu sheet I have added the following options menuscreen.jpg For Fixtures Fixtures : options (today;tomorrow) + no of days : (0 - +7 days) - include fixtures up to 7 days sport : (soccer;hockey) - seems to work for hockey as well Preferred leagues: (No;yes) - If you are only interested in certain leagues then you can copy and paste these into the "Preferred Leagues" worksheet and then it will only pull these into the spreadsheet. The odds it pulls in here are the "best-odds" (i think) fixturesf.jpg If you would also like to see all the odds offered by all the bookies for 1X2,Under and overs , Asian handicap, I have added the option to select any of these and on pressing the "Get Odds" button it will visit each individual match page and scrape the odds for all bookies and put these in seperate spreadsheets which you can reference to the fixtures via the matchID. Obviously this can take some time to complete so be sure you know what you really want. As an example, a download of tomorrow's fixtures + 7 days gave me 2192 fixtures in about 20 seconds. 611 of these had odds against them, but downloading 1X2,U&O's and AH for these took 16 minutes for me as there were 63000 records (especially for unders/overs). oddsh.jpg It doesn't seem that I am able to attach the spreadsheet here as I don't have the rights so I have put a link to it here (hopefully) ######For new link see Post #16########## It's an excel 2007 macro enabled workbook. I can add a 97-2003 workbook one if anyone would like but I would like someone to test it for bugs first as I do only have 2007 version.

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures You have done an amazing work :) thank you for that. I have a question though. I've tried to limit the number of bookies which odds to be extracted by make the needed changes in betexplorer. However, I still get the odds from all the bookies. Another question of mine is how to get the average odds for every match which I see in betexplorer, but not in the excel file. Just to say it again - you have done something really helpful, thank you for that.

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures Yup, I can only echo sjuesju's post - you made a great tool, it's very handy and fast; thanks for the efforts and sharing! :clap I haven't seen any bugs in these couple of days I've been trying it.

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures Hi Thanks for the positive feedback. I found many helpful tips and spreadsheets on this forum and it's a pleasure to give something back. I will update the spreadsheet so that you can select which bookmakers you want the odds from and I will include the "average" odds option for each odds category. Please just be patient as I have a lot of other things to do at the moment.

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures Thanks for the comments. As requested, I have a new version where you can select which bookies you would like to see the odds from, including the average odds as displayed on the webpage. On the "bookmakers" page , a "y" in Column B means that those bookies odds will be read (if present), when you opt to download all odds. Average odds is also an option in here which are the figures displayed on the webpage and not calculated by me. bookies.jpg Here is the link to the new file ######For new link see Post #16##########

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures Looks like they changed something. This one should work ######For new link see Post #16########## I should also have something for you on your other request in your own thread shortly. I have a problem with utf-8 characters not being read correctly on import from the soccerstats site so will go the webquery way.

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures Great job mate and thank you for this, but just one question. I try it right now and i.e France League 2 there is just 1 match for Friday but when I go to betexplorer there are all matches. Anyway this is fantastic and just keep going. EDIT: Just notice same for tomorrow Europa League matches :unsure

Share this post


Link to post
Share on other sites

Re: Tool for upcoming fixtures Yes sorry good spot. I haven't had time to use it myself as I'm working on something else at the moment. This one should fix it (hopefully) ##########For new link see Post #23################# let me know if it doesn't JD

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


    • Free Bets
    • Offers
    • Casino

    • £10 Free Bet at Mr Green! New & Recommended Bookmaker! New Customers. T&C's apply. 18+ begambleaware.org
    • Bet £10, Get £30 Free Bets! PLUS £5 Free Bet Every Week! New Customers. T&C's apply. 18+ begambleaware.org
    • Bet £10, Get £40 Free Bets! £30 Free Bets & £10 Casino Bonus. New Customers. T&C's apply. 18+ begambleaware.org
    • Join the No.1 Bookmaker! The World's Leading Bookmaker! New Customers. T&C's apply. 18+ begambleaware.org
    • Bet £10, Get £30 Free Bets! PLUS £10 Free Bet Every Week! New Customers. T&C's apply. 18+ begambleaware.org
    • £100 in Free Bets! Up to 5 x £20 Free Bets! New Customers. T&C's apply. 18+ begambleaware.org
    • £20 Risk Free Bet! Refunded as £20 CASH! New Customers. T&C's apply. 18+ begambleaware.org
    • £30 Risk Free Bet! Refunded as a Free Bet if losing! New Customers. T&C's apply. 18+ begambleaware.org
    • £60 in Free Bets! £30 Free Bets & £30 Casino Bonus! New Customers. T&C's apply. 18+ begambleaware.org
    • Bet £5, Get £20 Free Bets! 4 x £5 Free Bets! New Customers. T&C's apply. 18+ begambleaware.org
    • £20 Risk Free Bet for #WhatsOddsPaddy! PLUS Money Back in CASH if it loses! New Customers. T&C's apply. 18+ begambleaware.org
    • £10 Free Bet Every Week! £10 free bet every week in VIPP Club! EXISTING Customers too! New Customers. T&C's apply. 18+ begambleaware.org
    • £10 No Deposit + £500 Bonus! New Players Only. T&C's apply. 18+ New Customers. T&C's apply. 18+ begambleaware.org
    • £100 Welcome Bonus! New Players Only. T&C's apply. 18+ New Customers. T&C's apply. 18+ begambleaware.org
    • £200 Bonus +200 Free Spins! New Players Only. T&C's apply. 18+ New Customers. T&C's apply. 18+ begambleaware.org
    • £100 Deposit Bonus! New Players Only. T&C's apply. 18+ New Customers. T&C's apply. 18+ begambleaware.org

    Betting Tools

    Most Visited

    Shortcuts

    Strategic Partners

  • Popular Members