Auto Trade All Day - Spreadsheet

Example spreadsheets and comments on example spreadsheets.
joaopbento
Posts: 1
Joined: Fri Dec 03, 2010 12:59 pm

pashulik wrote:Hi to all. I'm newbie here. I've tried to load this spreadsheet, but after I'd clicked "Open Wordbook" BA answererd "Unable to open Wordbook - Old format used or wrong type of dll. (Exception of HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))". I use Microsoft Excel 2010 (Russian) and BA Professional, 1.26.3. I've created new file and tried to load it but there is the same result again. What's wrong with this? Thank you very much. Sorry for poor English.
Hello Russian friend.
Please contact BA support. They solved a similar problem with my regional settings.
Cya
pashulik
Posts: 4
Joined: Sun Jan 16, 2011 9:11 am

Thank you. I am in comtact with them now and we try to fix it. Seems there is some trouble with russian version of Excel. Hope we fix it soon.
Zenyatta
Posts: 1143
Joined: Thu Mar 11, 2010 4:17 pm

It's a very tricky business the automation, especially getting the In-Play to work. You can have fun trying to get it to work, but its hard yards I'm afraid - no easy road to riches.

I haven't looked at this particular sheet, but over the past year I had been dabbling in designing a simple sheet of my own customized for swing trades, but it kept doing silly things and costing me money, especially, trying to get the In-Play to work was starting to reach the tear-my-hair-out stage.

The trouble is that there are so many possible things that can go wrong, there are all sorts of constraints you need to put on it, you really need to understand the details of how BetAngel, Betfair and Excel work, so many things can catch you out, and even minor errors will wipe out your bank eventually.
pashulik
Posts: 4
Joined: Sun Jan 16, 2011 9:11 am

Thanks a lot to everybody. My problem is fixed with version 1.27 beta. It all works. :)
stefano7
Posts: 1
Joined: Mon Feb 07, 2011 11:34 pm

hi
i've dowload the auto-trade but i've a problem, later it do first 2 bet it doesn't betting anymore.. give me bet on excel but in bet angel doesn't betting..anyone can help me?
waltond
Posts: 5
Joined: Tue Mar 09, 2010 10:15 am

Hi, I've tried the all day spreadsheet but was wondering if anybody could advise me which is the best boxes to tick or untick so that on most or all occassions that there is some profit rather than a loss. I've been trying to use it on Greyhound racing should it still work for that or is it best suited for Horse racing.
Thanks
Lagos
Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

I have just tried to load a trial version of microsoft office 2010 onto the VPS but it says I need SP3. Does anyone know where I can download an older version of Excel that will work?

Thanks

Martin
Photon
Posts: 206
Joined: Mon Nov 29, 2010 10:14 pm

I like the functionality that clears placed bets at specified interval and I'm trying to replicate this in a new spreadsheet but it doesn't work if I place the following code in a tab that I want to creat:

Private Sub Worksheet_Calculate()

If Range("I4") = "TICK" And Range("A25") = 0 Then Call TIMEODD
If Range("I4") <> "TICK" And Range("A25") = 1 Then Call TIMEEVEN

End Sub

I think its the cell A25 which is causing the problem. Does anyone know if I'm missing another code that is required in order for the cell A25 to be updated? The code in the module 1 that clears the actual bets require A25 to get to 0 and I don't that requires tinkering but I may be wrong.

All I want is code/s that clear placed bets at seconds I specify so any help will be much appreciated.
Photon
Posts: 206
Joined: Mon Nov 29, 2010 10:14 pm

Any chance of this type of spreadsheet available for Betdaq? I'm mainly interested in the ability to clear placed bets section at time interval I specify.
hutcho74
Posts: 8
Joined: Mon Sep 05, 2011 5:58 am

Hi,

I am very new to this and I have just started using the automated spreadsheet as a trial to see how it all works. I have found that when it bets based on the WOM indicators the bets often go against what I want it to and this then ends up in a loss rather than a profit.

I have some ideas on how to turn this around but I am not able to re-code the spreadsheet so if anyone could help me with some small modifications I would be very appreciative.

Cheers,

Mat.
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

You need to modify the formula in cell I7
hutcho74
Posts: 8
Joined: Mon Sep 05, 2011 5:58 am

Hi,

Thanks for your post. I had a look there and what I am looking to do is reverse the bets if WOM Rules are checked as True. At present the indicator IF WOM >= 60% LAY means that if the condition is met a LAY bet will be placed but I want to reverse it so a BACK bet is placed.

I can't see in that cell where I could change this or where the reference to cell L26 or L27 is located in the code.

Cheers,

Mat.
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

Just click on the cell and do a 'trace dependents'. We didn't write the spreadsheet but it's easy to find how it's put together.
hutcho74
Posts: 8
Joined: Mon Sep 05, 2011 5:58 am

Ok thanks, sorry for the obvious lack of Excel knowledge in my posts, still very much a beginner in this area.

Cheers,

Mat.
mike1973
Posts: 2
Joined: Sun Oct 30, 2011 1:04 pm

Hi,
I have been trying out the "BetAngel-auto-trade-v2" spreadsheet last few days. I have ticked the WOM box, but is only triggering the lay bet when goes over 60%, then ofsets with the back bet. But it wont bet when goes under %40. How do i get it to back then lay? as it is only doing lay then back?
Cheers.
Post Reply

Return to “Bet Angel - Example spreadsheets”