Remove this ad
avatar

birchy

Betfair Elite

Posts: 593 Member Since: May 11, 2008

Lead

September 30, 2012 16:36:45

Tags : :

[NOTE: This post has been deleted from "Introduce Yourself" and moved to the correct area]

How long does it take to learn how to write an excel bot. And then how long does it take to actually build a bot. Would it not be quicker to hire someone to build it for you and pay them 20/30euro. If the strategy works great, if not its back to research and new strategies.
-tomfla

When you say "Excel bot", are you referring to using standard cell formulas on a commercial software such as Gruss Betting Assistant or do you refer to a complete bot from scratch? The first one should be VERY simple to do and only requires basic Excel knowledge. The latter requires in-depth knowledge of Visual Basic and VBA. For the latter, it would be quicker (and easier) to learn Python and then you'd have the ability to create your own bots. If you used an existing API library, you'd only have to program the strategy. DIY bots would also be much cheaper long term than paying someone else to program every strategy for you.

It would take a couple of weeks to learn the basics of Python and then you'd be learning from experience as time went by. The thing with programming is that you will never learn everything as you will only need to use a limited number of features for bot development. I've used Python for a few years now and am still learning new things on a regular basis.

Your main concern is that you don't seem to have much sense of time or value at present. If you only have a budget of 20 to 30 euro, you would be lucky to get more than 1 or 2 hours of a programmers time for that amount. A very basic strategy would take a minimum of a few days to develop and test, and that is assuming that the programmer already has a decent bot framework to begin with. Botting requires a LOT of patience and can easily take up months and years of your spare time. Unless you have a massive budget to pay for someone else's time, programming your own bots is the only way forward. The other option is to buy a commercial bot that allows custom strategies and program them yourself, but that usually involves a monthly subscription.

Quote    Reply   
Remove this ad
Remove this ad
avatar

blackmagic

bot addict

Posts: 70 Member Since:June 26, 2008

#1 [url]

September 30, 2012 17:21:01

It also depends on what you are trying to do. If you are just looking at loading a load of data into a spreadsheet doing some calculations and then placing a single or a few bets in the exchange then it should be quite easy. If you are looking at trading where you need to know your position and you are looking to back and lay then this can be a pain in the ass. The patience comes from if everything works on betfair then its all hunky dory, but if runners pull out then all the odds change, sometimes bets are rejected, sometimes your connections goes down, etc etc. So i suppose what i am getting at is if you are running something where you fire up a spreadsheet, it places some bets and you can check that what you think your exposure to that market is, is exactly what bf tells you it is then you should be ok. Once you want something more complex or something that can truly look after its self you are entering a whole world of pain.

Quote    Reply   
avatar

vonnch

rookie botter

Posts: 24 Member Since:November 24, 2013

#3 [url]

December 12, 2014 00:48:21

Most of them are paid ones. I was actually looking to see if there are free ones so far? image

Quote    Reply   
Remove this ad
avatar

birchy

Betfair Elite

Posts: 593 Member Since:May 11, 2008

#4 [url]

December 14, 2014 15:51:50

vonnch wrote:
Most of them are paid ones. I was actually looking to see if there are free ones so far? image

I very much doubt anyone will spend many hours of their time writing free bots and strategies for other people. Granted, there is a free API-NG bot on my website, but it only serves as an example to get other programmers up and running. The only exception is that you MIGHT get a freebie if you are using a commercial bot and are paying a monthly subscription.

www.bespokebots.com

"This time next year Rodney, we'll be millionaires!"

Quote    Reply   
avatar

jazzfan

rookie botter

Posts: 7 Member Since:September 12, 2010

#5 [url]

September 7, 2015 13:46:08

Resurrecting an old thread :)

It is now possible to run Python code from an excel spreadsheet as though it was VBA. It would therefore be possible to integrate birchy's excellent Python library directly into excel...

"Make Excel fly with Python!" - http://xlwings.org/

Quote    Reply   
avatar

birchy

Betfair Elite

Posts: 593 Member Since:May 11, 2008

#6 [url]

September 11, 2015 19:20:34

The free LibreOffice package has had Python, VBA, etc support for a number of years now. I've never tried it, but I should imagine my library could be imported into LibreCalc (Excel equivalent). Be interesting to see if anyone fancies trying it...

Having said that...if a user is capable of programming in Python, then surely it would make more sense to write the complete bot in Python?

www.bespokebots.com

"This time next year Rodney, we'll be millionaires!"

Last Edited By: birchy September 11, 2015 19:23:20. Edited 1 time.

Quote    Reply   
Remove this ad
Add Reply

Quick Reply

bbcode help