Simple trigger formula

[Torino33]

Hi all,

I'm requesting your help to create a simple formula to do this action:

My first bet is alway a back bet, so I need the VBA to level profit by laying 1 min before the off @ back price.

Your help would be greatly appreciated.

Thanks

[rourkem]

Looks like no one has ever done this yet. Would be nice to see if this can be done.

[Torino33]

Looks like no one has ever done this yet. Would be nice to see if this can be done.

It can be done. It's just that i'm thick when it come to code even simple excel formula.

This spreadsheet from Gary http://www.gruss-software.co.uk/Excel/GreenUp_Auto.xls would have done the job if i knew how to add this into the spreadsheet:

In column R you can use the plusTicks or minusTicks function.
eg. =minusTicks(H5,1) to subtract 1 tick to the lay odds which is the same as laying at the back odd

Function getPrevOdds(ByVal odds As Currency) As Currency
Dim oddsInc As Currency
Select Case odds
Case 1.01 To 2
oddsInc = 0.01
Case 2.02 To 3
oddsInc = 0.02
Case 3.05 To 4
oddsInc = 0.05
Case 4.1 To 6
oddsInc = 0.1
Case 6.2 To 10
oddsInc = 0.2
Case 10.5 To 20
oddsInc = 0.5
Case 21 To 30
oddsInc = 1
Case 32 To 50
oddsInc = 2
Case 55 To 100
oddsInc = 5
Case 110 To 1000
oddsInc = 10
End Select
If Math.Round(odds - oddsInc, 2) >= 1.01 Then
getPrevOdds = Math.Round(odds - oddsInc, 2)
Else
getPrevOdds = 1.01
End If
End Function

Function getNextOdds(ByVal odds As Currency) As Currency
Dim oddsInc As Currency
Select Case odds
Case 1 To 1.99
oddsInc = 0.01
Case 2 To 2.98
oddsInc = 0.02
Case 3 To 3.95
oddsInc = 0.05
Case 4 To 5.9
oddsInc = 0.1
Case 6 To 9.8
oddsInc = 0.2
Case 10 To 19.5
oddsInc = 0.5
Case 20 To 29
oddsInc = 1
Case 30 To 48
oddsInc = 2
Case 50 To 95
oddsInc = 5
Case 100 To 1000
oddsInc = 10
End Select
If Math.Round(odds + oddsInc, 2) <= 1000 Then
getNextOdds = Math.Round(odds + oddsInc, 2)
Else
getNextOdds = 1000
End If
End Function

Function plusTicks(odds As Currency, ticks As Byte) As Currency
Dim i As Byte
For i = 1 To ticks
odds = getNextOdds(odds)
Next
plusTicks = odds
End Function

Function minusTicks(odds As Currency, ticks As Byte) As Currency
Dim i As Byte
For i = 1 To ticks
odds = getPrevOdds(odds)
Next
minusTicks = odds
End Function

Unfortunately i have no idea how and where to put this code into GreenUp_Auto.xls spreadsheet.