Bet Angel - Example spreadsheets : Auto Trade All Day - Spreadsheet

Example spreadsheets and comments on example spreadsheets.
waltond
Posts: 5
Joined: Tue Mar 09, 2010 10:15 am

Sat May 14, 2011 8:06 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

Wed Jun 01, 2011 4:03 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

Tue Jun 07, 2011 7:51 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

Wed Jun 15, 2011 6:57 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

Thu Sep 08, 2011 4:59 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: 3534
Joined: Tue Apr 14, 2009 3:47 pm

Thu Sep 08, 2011 11:45 am

You need to modify the formula in cell I7

hutcho74
Posts: 8
Joined: Mon Sep 05, 2011 5:58 am

Thu Sep 08, 2011 2:02 pm

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: 3534
Joined: Tue Apr 14, 2009 3:47 pm

Thu Sep 08, 2011 2:30 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

Thu Sep 08, 2011 2:50 pm

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

Wed Nov 02, 2011 12:51 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”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest