Google Apps Script linked to a Google Spreadsheet - Collect data from an external API and write to it also (in PYTHON?) - Est time req’d - 4 hours

Hi there,

I have a Google spreadsheet that I want to populate with some external data from a site called Betfair. The data will then be evaluated and if it matches certain criteria I will then want to execute a bet via the same site’s API.

Fuller details are in the attached sheet but here’s an outline. As Betfair publish code examples in PYTHON I thought that might be the easiest language to construct it in but I am open to suggestion on this. There will almost certainly be follow-on work but let’s start small with this task and see how we work together.

1. App Script collects data from Betfair API. Documentation on it is here: https://api.developer.betfair.com/services/webapps/docs/display/1smk3cen4v3lu3yomq5qye0ni/Getting+Started+with+API-NG

The data will be prices for UK Horse Races.

A login for testing purposes will be provided to the successful bidder.

2. Prices are fed into a Google sheet in real time. Each price will then be evaluated against a set of criteria (for example >x or <y). These criteria will change over time - I will create this part as formulae in the sheet. This does not need Scripting. The end results of the formula will be a value of 1 or 0 in response to each piece of price information.

3. The Script will then take the value of 1 or 0 given by the sheet.

3.1 If value is 0 (it will be most of the time) then Script will simply loop around and get more price data until the specified Event finishes.

3.2 If value is 1 then Script will place bet. How to do this is listed in the API docs (again fuller details are in the attached sheet).

https://api.developer.betfair.com/services/webapps/docs/display/1smk3cen4v3lu3yomq5qye0ni/Example+Requests#ExampleRequests-PlacingABet

Again Script will collect more price data until Event finishes.

In brief that’s all it needs to do. I’ve tried to list the steps from a User perspective in more detail in the attached sheet and have also shown an example with imaginary data to show how the sheet might look like in practice. A couple of further points.

4. Lots of people on [url removed, login to view] quote for work without bothering to read the brief. To prove you are not one of them, please include the word ‘Crocodile’ in the Subject line of your response. I’ll give higher priority to these responses :-)

5. The API is pretty well documented so if you are used to creating API calls in JSON-RPC it shouldn’t prove too tricky. I’m guessing at around 4 hours work? I’ll then need to test it and that will be it - I’ll then come back with amends / refinements etc but this will be additional work with of course additional fees for you.

6. One final note on speed. Prices on Betfair move fast! I think with the free Developer API version I want to utilise it is possible to make requests at [url removed, login to view] intervals. Bear this in mind when constructing your Script - speed is of the essence.

Questions / Thoughts etc - just let me know I’ll do my best to respond within a few hours provided I’m awake! (I’m in the UK).

Google App Engine Python

Project ID: #5941446

About the project