Any advice would be appreciated . . .

[Bob147]

Hi.

I am currently developing an Excel football betting spreadsheet / model and need to find a way of linking upcoming football matches and odds from the Betfair exchange website into my spreadsheet.

I am an advanced Excel user, but not have technical IT / programming (Python / R) knowledge. Also, terms like 'endpoint', 'ssoid' etc. are new to me, and in getting back to basics, have googled 'API' to understand the main principles.

I have followed the instructions in creating an application name in the API-NG demonstrate tool, where I now have two application key's (demo and live), however have hit a brick wall in what to do next. I am keen to learn, but have become overwhelmed by the technical terms, numerous IT avenues to learn, when all I want to do in link the upcoming football markets and odds into my Excel spreadsheet.

I cannot seem to find any video 'step by step' tutorial's online, therefore any advice would be gratefully appreciated.

Thanks in advance.

[bfexplorer]

and how can you help others, for instance me?

[jabe]

Hi.

I am currently developing an Excel football betting spreadsheet / model and need to find a way of linking upcoming football matches and odds from the Betfair exchange website into my spreadsheet.

I am an advanced Excel user, but not have technical IT / programming (Python / R) knowledge. Also, terms like 'endpoint', 'ssoid' etc. are new to me, and in getting back to basics, have googled 'API' to understand the main principles.

I have followed the instructions in creating an application name in the API-NG demonstrate tool, where I now have two application key's (demo and live), however have hit a brick wall in what to do next. I am keen to learn, but have become overwhelmed by the technical terms, numerous IT avenues to learn, when all I want to do in link the upcoming football markets and odds into my Excel spreadsheet.

I cannot seem to find any video 'step by step' tutorial's online, therefore any advice would be gratefully appreciated.

Thanks in advance.

It's rather a lot to answer in a single post. If you're an advanced Excel user, I'd take that as meaning you're well versed in VBA. Whatever you do, you'll need to take it step by step. It could take a year for you to get to where you want to be. Start by getting some way to log into Betfair. Then code a call to do something simple like getting competitions or countries. Then look at getting other data and work out how it fits together. Some work it all out by learning Python or VB.Net or C#.Net as they go along. You'll really need to know about classes and objects. I don't know how well those fit with VBA. There are almost 8000 posts on this forum, many asking common questions, and many answering those questions. The documentation is decent. Read until it sinks in and makes sense. It's far from easy. Google might get you related info; I found my login routine elsewhere.

[Bob147]

jabe, thanks for taking the time to respond. I will continue to research and digest, then may come back to you with a couple of more educated questions as my journey progresses. Thanks again.

[bfexplorer]

I cannot seem to find any video 'step by step' tutorial's online, therefore any advice would be gratefully appreciated.

Here is how I code Excel data integration:

http://bfexplorer.net/Articles/Content/422

what you should do in your code and in your programming language you will use, is on lines 72 - 91, so on 19 lines of code.

[Dishlicker]

For an advanced Excel user, if you are similarly advanced in VBA check out https://github.com/betfair/API-NG-sample-code. Otherwise BFexplorer and Bet Angel have integration to Exfel worksheets. I haven’t used either as I code my bots in C#. Took me a day to get up and running.