1. #1
    Beni1111
    Beni1111's Avatar Become A Pro!
    Join Date: 02-25-10
    Posts: 8
    Betpoints: 528

    Import data from the web in excel mac and pc

    Hi,
    This is what I'm using to import data on mac;

    WEB
    1
    http://www.betexplorer.com/streaks/b.../?sport=soccer


    Selection=EntirePage
    Formatting=All
    PreFormattedTextToColumns=false
    ConsecutiveDelimitersAsOne=false
    SingleBlockTextImport=true

    It is working fine... but it does not import the odds. When I copy paste this page in excel, the odds are there... not when I import it, there should be a way to import the odds.

    It does the same with pc; import from the web.
    Someone?

  2. #2
    a4u2fear
    TEASE IT
    a4u2fear's Avatar Become A Pro!
    Join Date: 01-29-10
    Posts: 8,147
    Betpoints: 35459

    I quickly tried this and arrived at the same conclusion.

    I believe the answer is that the team's stats (i.e. GP, P) exist on the page, and the current odds are pulled from another table somewhere else (HTML coding); but do not exist on the page. So when you import using code, you get the team stats but not the odds. But if you copy/paste you are actually copying the data on the page, so you are able to paste it into excel.

    Sites use these types of tables so they can constantly update the odds.

    I do not know how to code with HTML so I cannot offer any help.

Top