1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
Hey Guest, we are running a Photoshop competition with a 32" monitor as the first prize - See here for details.

Pulling data from an API

Discussion in 'HTML, Graphics & Programming' started by danlightbulb, Sep 24, 2018.

  1. danlightbulb

    Wise Guy

    Joined: Jul 14, 2005

    Posts: 1,855

    Hi all.

    Im very capable on Excel and have some experience with Excel VBA.

    If I can get some data into Excel I can do stuff with it no problem.

    I want to be able to pull data from Betfair betting exchange using their API. Ive no idea how to do it. Ideally into Excel so I can then work some calcs etc on it.

    Can anyone help with where to start please?
  2. AHarvey


    Joined: Mar 6, 2008

    Posts: 9,253

    Location: Stoke area

    I can't access it at work but I doubt excel itself will be sufficient to use the API.

    I've pulled public xml feeds before now, scraped them with Python and saved to a csv file.

    Looks like the API can be used with Python so I'd use Python to pull all the data you want from the API down to a CSV file then use excel to format it as you like. Not sure on issues with Python updating it and Excel reading it.

    Other option would be to take the jump straight into Python and go 100% python solution.
  3. Spunkey


    Joined: Oct 18, 2002

    Posts: 13,609

    Location: The land of milk & beans

  4. AHarvey


    Joined: Mar 6, 2008

    Posts: 9,253

    Location: Stoke area

    Interesting, but I still wonder how well it will be able to interact with the API.

    Keep us updated @danlightbulb as I will be interested in how you find it :)