bot builder recommendation

We were all new to Bet Angel once. Ask any question you like here and fellow forum members promise not to laugh. Betfair trading made simple.
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

You cynical bunch!

But seriously, trust is an important aspect of what you want. But a lot can depend on what you want as market selection is obviously key also.

I built up a relationship with LeeCal before I felt I could recommend him. But if you want excel stuff you should check out: -

https://www.tigerspreadsheetsolutions.co.uk/

I've got to know Chris and he speaks the write language and is very professional.
jamesg46
Posts: 3769
Joined: Sat Jul 30, 2016 1:05 pm

Euler wrote:
Wed Apr 28, 2021 8:35 pm
You cynical bunch!

But seriously, trust is an important aspect of what you want. But a lot can depend on what you want as market selection is obviously key also.

I built up a relationship with LeeCal before I felt I could recommend him. But if you want excel stuff you should check out: -

https://www.tigerspreadsheetsolutions.co.uk/

I've got to know Chris and he speaks the write language and is very professional.
I see what you did there, speaks the write language :D

Thanks for the recommendation.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Might be more for beginners but I'd recommend looking at this website too

https://www.excel-easy.com/

Step-by-step screenshots which are very well put together and easy to understand.
jamesg46
Posts: 3769
Joined: Sat Jul 30, 2016 1:05 pm

paspuggie48 wrote:
Sat May 01, 2021 8:21 am
Might be more for beginners but I'd recommend looking at this website too

https://www.excel-easy.com/

Step-by-step screenshots which are very well put together and easy to understand.
I'll take a look into that... I would really like to do more in VBA but learning through videos on topics that just don't interest me drains my attention span :)

Whenever I need to learn something Excel I go here,

https://youtube.com/user/ExcelIsFun

Look at the play list this guy has put together, it's impressive. I don't know why but what he says seems to sink in too, I think it's because he says pretty much everything twice.
User avatar
Eyesnack
Posts: 283
Joined: Fri May 29, 2009 1:26 pm

Lots of excellent code available at https://www.excelforfreelancers.com/ you can download the workbooks to learn as you go
excellent for people who want to learn excel. visit the youtube channel
jamesg46
Posts: 3769
Joined: Sat Jul 30, 2016 1:05 pm

Eyesnack wrote:
Sat May 01, 2021 12:02 pm
Lots of excellent code available at https://www.excelforfreelancers.com/ you can download the workbooks to learn as you go
excellent for people who want to learn excel. visit the youtube channel
Nice, they offer a VBA course.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

jamesg46 wrote:
Sat May 01, 2021 11:00 am
paspuggie48 wrote:
Sat May 01, 2021 8:21 am
Might be more for beginners but I'd recommend looking at this website too

https://www.excel-easy.com/

Step-by-step screenshots which are very well put together and easy to understand.
I'll take a look into that... I would really like to do more in VBA but learning through videos on topics that just don't interest me drains my attention span :)

Whenever I need to learn something Excel I go here,

https://youtube.com/user/ExcelIsFun

Look at the play list this guy has put together, it's impressive. I don't know why but what he says seems to sink in too, I think it's because he says pretty much everything twice.

Aye, Mike is great and explains even the most complicated formulas easily...reminds me of the way Johnny Ball used to teach us on TV :D
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

Am always happy to help people with VBA issues or code not working, within reason though.

I'd rather see people learn for themselves, on top of the fact that I have a full-time job, whilst treating trading as if it were full-time whilst having the benefit of not going into the office for the last year hence why I wouldn't volunteer even for payment to help someone create a bot as what I get paid doing it for a full time job most people on here would want it cheaper, and I just simply don't have the time.

My one bit of advice is to put error trapping in and destroy objects at the end of routines when you're done with them. VBA isn't like the .Net languages in that it doesn't have automatic garbage collection of objects.

Every routine I write the first bits to go in are as follows

Code: Select all

Private Sub mMySubGoesHere()
on error goto err_Catch
' Code goes here

finally:
 On Error Resume Next
 ' Kill your objects here
 Exit Sub
 
 err_Catch:
 Msgbox "Error encountered in mMySubGoesHere" & vbNewline & Err.Number & ": " & Err.Description, vbcritial
 Resume finally
 Resume
The second resume goes into the error catch as I can put a break point on the msgbox and just drag it down to the resume to jump to the bit of code that has the issue.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

There's quiet few VBA nuggets hidden around the forum. Thankfully VBA is fairly unique thing to search for.

I remebered I did this viewtopic.php?p=148328#p148328 but it was a couple of years ago and I'm not sure even I understand it now. And pls no comments about how it could be better :), it was just to give some sort of idea about reading a writing cells.

Once you can read cells, compare or do maths on them, and write something back to a cell, you're half way there. Add a button to your sheet that runs that bit of code and your starting to feel pretty fancy. Then change that code to read a whole sheet full of numbers and put the outputs in a column where a chart is pointing and....tada!

Coding is really just a set of instructions describing what you'd do if you did it by hand, but written so a really stupid person could do it. Don't be afraid to start with 'pseudo code', literally all the little steps written down in plain English. If you find any that repeat then mark them as candidates for making a little chunk of code you can write once and reuse. If you have line that says pick the Racing Post nap then you know you have issues unless it somehow knows it.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

ODPaul82 wrote:
Sat May 01, 2021 9:28 pm
My one bit of advice is ...
Go easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

ShaunWhite wrote:
Sun May 02, 2021 5:18 am
Go easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
It's not that bad to be fair, the fact that you used named ranges is better than 90%!
Although you didn't declare SourceSheet so it's defined as a variant rather than a string
There's no need to use Call before a routine, that was discontinued about 20 years ago, you're showing your punchcard age :lol:

Worksheets I tend to declare the reference to them and am super explicit that its an Excel worksheet rather than using Sheets for example

Code: Select all

Dim objWs as Excel.Worksheet
Set objWs = Thisworkbook.worksheets("Bet Angel")
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

ShaunWhite wrote:
Sun May 02, 2021 5:18 am
ODPaul82 wrote:
Sat May 01, 2021 9:28 pm
My one bit of advice is ...
Go easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
I thought when I first saw a BBC Computer using Basic at the age of 16 was ancient stuff but yours beats that LOL. I recall the days of writing:
5 Goto Line 10
10 Type "Hello"
20 Goto Line 5

....and watch in amazement as it filled the screen :D

Here is the beast > https://www.bbc.co.uk/news/technology-15969065
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

First chance I had at a BBC Micro was when I was 6-7
Taught myself basic on that, then got an Atari XL 800 and thought me copying out code snippets from the magazines and getting them to work I was the lord almighty himeself.

Moved onto the Amiga 500 where I learnt C at about the age of 11-12 for the Motorola 6800 chip
Followed by assembler on the first generation PCs that had come out about 5-6 years beforehand (I started on MS Dos 3.0 so they had been about a few years, this was before the x86 architecture)

The fact I was learning C & assembler at 11-12 should have indicated to me earlier that I was a touch on the spectrum.

These days most of what I do in day job via VBA is connect to Oracle via ODBC connections to our local DBs and via HTTP to our cloud options, trigger some SQL and go and make myself a brew.
lotora
Posts: 629
Joined: Thu Dec 24, 2009 9:20 am
Location: Surin City, Thailand

I am looking for an easy way to analyze my Betfair Profit/Loss from UK/Australian horse racing and greyhound. I suppose it makes most sense to do it through Excel. Since I don't know much about Excel I want a very simple way to do it. I want to filter the results by at least country/type of race/odds. If you would like to help me out, when can you have it done and how much will it cost?

(Have also been in contact with [email protected], but for the last 2 months he has been too busy)
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

lotora wrote:
Wed Jun 23, 2021 1:35 pm
I am looking for an easy way to analyze my Betfair Profit/Loss from UK/Australian horse racing and greyhound. I suppose it makes most sense to do it through Excel. Since I don't know much about Excel I want a very simple way to do it. I want to filter the results by at least country/type of race/odds. If you would like to help me out, when can you have it done and how much will it cost?

(Have also been in contact with [email protected], but for the last 2 months he has been too busy)
https://www.udemy.com/courses/search/?p ... ce&src=ukw

Much faster, and free. Spend 20-30mins a day on your personal development and in a few weeks you'll have a useful new skill.
Post Reply

Return to “Bet Angel for newbies / Getting started”