EXCEL HELP

[CAPT1239]

Hi
just started using the betting assistant and a bit new to this trigger betting, it seems quite interesting but i have searched this forum trying to find excel sheets to use or to help could someone point me in the right direction
regards capt1239

[Smokin Joe]

What are you looking to do?

[CAPT1239]

looking to trigger lays in horse racing if it falls in the right odds

example can you lay the 3rd fav in every race if its odds are between 4.0 >8.0

cheers capt1239

[Smokin Joe]

Take it step by step.

For a trigger to work you need formula or code to enter a value of BACK or LAY into Column Q, you also need to have a value in Columns R and S for the odds and stake amount.

If you enter the following formula in Col Q in row 5 onwards it will create a LAY trigger if the selection can be laid between 4.0 and 8.0

=IF(AND(H5>4,H5<8),"LAY","NO BET")

That isn't exactly what you wanted, as we haven't yet determined whether it is the 3rd favourite, but it's a start.

To determine who is the 3rd favourite enter this formula somewhere on your spreadsheet:

=SMALL(H5:H44,3)

In my example I have entered that formula in AA5.

To incorporate both parts of your request your formula in Cell Q5 will read:

=IF(AND(H5>4,H5<8,H5=AA$5),"LAY","NO BET")

Copy this down for all the rows that you have runners for.

Note that AA$5 is the cell where you have entered the SMALL formula.

I haven't tested the code, but I think it does what you want.

[Smokin Joe]

BTW, the sunglasses character above appears when you type 8 ) (only without the space)

[CAPT1239]

Thanx smokin joe
your not kidding a step at a time ,the 3rd fav 4.0>8.0 was just an example don't even know if this would work,is there anywhere i can get a
working spreadsheet to help me get started, i seem to keep finding on the forum everybody talking about different triggers etc ,but surely they all had to start and learn somewhere too


Thanx again capt1239

[Smokin Joe]

Capt do you know how to competently use Excel? That is a must.

The triggers are listed in the Help file

What you have to do is determine what you want to do and then work out how to get Excel to deal with your request.

There is no sample sheet, I'm guessing that everyone has a sheet created to do what they specifically want it to do. I have one that I use but I am quite sure it wouldn't be any use to you as it is specific to my modus operandi.

[CAPT1239]

Thanx again smokin joe
to be honest i know how to use excel so so through my work so i am probable better to learn this before going any further maybe excel for dummies would help


thanx capt1239

[yantz]

@Smokin Joe
could you help me with something? say i have a figure in cell A1 that keeps on changing. how do i put the highest figure in that cell into another cell say A2?

eg. A1 = 1.5, so A2 becomes 1.5
then A1 = 1.8, so A2 becomes 1.8
then A1 = 1.2, A2 stays at 1.8
then A1 = 2.1, A2 becomes 2.1

the value of A1 keeps changing because of other cell's behaviour.

thx
yantz

[Smokin Joe]

I think that you would need to use VBA code as otherwise the solution I am recommending below would return a circular argument.

Using VBA code I would make Cell A3 = to the value of A2.

Right click the current sheet you are working on, click View Code and enter the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
' Only process whole updates

If Target.Columns.Count <> 16 Then Exit Sub


' Stop any further updates until we have completed
Application.EnableEvents = False

ActiveSheet.Range("A3").Value = ActiveSheet.Range("A2").Value


' Re-enable updates
Application.EnableEvents = True
End Sub

In A2 I would then use the formula:

=IF(A1>A3,A1,A3)

That should work.

Though I am sure you are aware that you can't use cell A1 or A2 in BA as that is used for the standing data, but the above gives you an idea of what you need to do.

[Smokin Joe]

Nah, that doesn't seem to work.

Perhaps it will give you an idea, but I don't have any more time right now to spend on it, sorry.

[Smokin Joe]

I think I got it working. Instead of A1 and B1 I have used A20 and B20.

Enter the following as code:

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
  ' Only process whole updates
 
  If Target.Columns.Count <> 16 Then Exit Sub
 
 
  ' Stop any further updates until we have completed
  Application.EnableEvents = False
 
  ActiveSheet.Range("C20").Value = ActiveSheet.Range("B20").Value
   
 
  ' Re-enable updates
  Application.EnableEvents = True
 End Sub

In B20 enter this formula:

=IF(A20>C20,A20,C20)

I think that B20 will now contain the largest Value that A20 ever was, which is what you wanted.

[yantz]

Smokin Joe
thanks a lot for the code!!! i will try it later and see if it works. thx once again, really appreciate it

yantz

[yantz]

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
  ' Only process whole updates
 
  If Target.Columns.Count <> 16 Then Exit Sub ' <- What does this do?
 
 
  ' Stop any further updates until we have completed
  Application.EnableEvents = False
 
  ActiveSheet.Range("C20").Value = ActiveSheet.Range("B20").Value
   
 
  ' Re-enable updates
  Application.EnableEvents = True
 End Sub

what does that line do? the script only worked after i comment out that line. now its just the way i want it!! thx very very much Smokin Joe!!

yantz

[Roger]

That line is looking for a full race-prices load from BA, and if it doesn't find it, it stops running the sub.