Announcement

Collapse
No announcement yet.

Data from a web page into Excel ** with live updating if/when web page changes **

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data from a web page into Excel ** with live updating if/when web page changes **



    Hi all

    I am a (relative) newbie in Excel .. have some basic VBA skills .. but be gentle !!

    I am trying to scrape odds data from a range of bookmakers into Microsoft Excel and have the odds updating if/when the website changes.

    Essentially I am trying to create a sheet that looks a bit like this ...... (although I don't need all the bookmakers !! Just 1 or 2 would be a great start

    https://easyodds.com/horse-racing/wo...n-and-each-way

    Ideally it should be able to pull a list of the days racing from the front page , here

    https://easyodds.com/horse-racing


    Create a new Excel sheet for each race and populate with the data .

    What is really important (and annoying!!!) is I want to try to match the data to the individual bookmaker site (because there is a delay on easyodds.com) - so for example , in the wolverhampton event with the web link above - for the first horse listed , "Axe Axelrod" - it would need to
    - find the 1.20 Wolverhampton race on bet365 website (https://www.bet365.com/?&cb=103254828#/AS/B2/) .......
    - then find that link to the race (https://www.bet365.com/?&cb=10325482...F75756415/P10/)
    - find the horse ("Axe Axelrod") and then return the odds attibuted to that horse

    I am sure this is actually not as complicated as it might sound for someone with the correct HTTP / GET / JSON skills .. if anyone is able to just setup a very basic example code that I could then follow, copy and expand on - I would be very very grateful !!

    Thanks!!

    Jonny


  • #2


    Any ideas on this?

    Comment

    Working...
    X