intergrating "Greening up" spreadsheet in mine.

[sjaak1943]

My spreadsheet code has only declarations in VBA like this:

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

Where do i put them in the code from Gary's worksheet?

My trigger is this one:
=IF(OR(T5="CANCELLED";AND(X5>0;W5>0));"CLEAR";IF(AND(start="YES";AF5>=tick_gap;AC5>=rank;R5<>"";X5>=0);"LAY-TL" &tick_offset&"-F"&fill_kill&"-SL1";""))
Gary;s trigger is:
=IF($T$2="Y";Y5;"") and must be part of mine.

Who can help, tried a lot with no effort until now?

Sjaak

[alrodopial]

I assume in AF5, something like this

=TickDiff(F5,H5)
or
=getPreOdds(F5)

[sjaak1943]

It's not what i mean. I want to use my own workbook "trading Gaps" in conjunction with Gary's workbook "Greening Up".

[sjaak1943]

Problem solved thanks to Dave.