1. #1
    Barrakuda
    Barrakuda's Avatar Become A Pro!
    Join Date: 02-28-18
    Posts: 50
    Betpoints: 295

    MLB Odds into Excel?

    Anyone know of a live odds source that be used for Excel web queries? Pinnacle won't work bc it's Javascript. BOL almost works, except it won't let you choose an individual sport via persistent URL.

    Looking strictly for something that can be easily accessed via Excel web query -- would be refreshing every 10 min or so. Not looking for second-to-second line moves. Pls post if you use anything with success.

  2. #2
    danshan11
    danshan11's Avatar Become A Pro!
    Join Date: 07-08-17
    Posts: 58
    Betpoints: 80

    vegasinsider

  3. #3
    Barrakuda
    Barrakuda's Avatar Become A Pro!
    Join Date: 02-28-18
    Posts: 50
    Betpoints: 295

    Turns out, downloading the Power Query Excel addin from Microsoft allows for querying json tables. I.e., you can query Pinnacle with it.

  4. #4
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 294
    Betpoints: 2181

    Quote Originally Posted by Barrakuda View Post
    Turns out, downloading the Power Query Excel addin from Microsoft allows for querying json tables. I.e., you can query Pinnacle with it.
    How's this working for you? and how do you do it? Sorry for my ignorance to json tables and Power Query.

  5. #5
    Barrakuda
    Barrakuda's Avatar Become A Pro!
    Join Date: 02-28-18
    Posts: 50
    Betpoints: 295

    It's a little funky, actually. It improves the web query interface to identify more tables in complex web pages. That;s the good part. The bad part is that it's somewhat hard to figure out -- a lot of trial and error.

    I think if I put more time into it, it will make web scraping much easier.

  6. #6
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 294
    Betpoints: 2181

    I looked at it briefly, I miss the old import queries where all you have to do is click the box beside the table you want lol!

Top