Get high and low price in play formula??

[Dogoa]

I was wondering if it is possible to get The high price in play?

I have this code who is supposed to get the low price in play.

=IF(AA5="";"";getLowPriceInPlay(A$1;E$2;F$2;O5))

Could i make something like this?

=IF(AA5="";"";getHighPriceInPlay(A$1;E$2;F$2;O5))

Hope any one can help or maybe show an easy way to do this..
Thanks

[Captain Sensible]

Try adding this to a worksheet , it should stick starting odds in AH , Lowest in AI and highest in AJ. Takes the price from last matched price


Private Sub Worksheet_Change(ByVal Target As Range)
Dim iRow As Integer
Dim iCol As Integer
Dim cell As Object

For Each cell In Target
iRow = cell.Row
iCol = cell.Column


' Update Max and Min Back Values
If Cells(2, 5) = "In Play" And iCol = 15 And iRow > 4 And iRow < 46 Then

Application.EnableEvents = False
If IsEmpty(Range("AJ" & iRow).Value) Then Range("AJ" & iRow).Value = 0
If IsEmpty(Range("AI" & iRow).Value) Then Range("AI" & iRow).Value = 1001
If IsEmpty(Range("AH" & iRow).Value) Then Range("AH" & iRow).Value = Range("O" & iRow).Value

If Not IsEmpty(cell.Value) Then
Range("AG" & iRow).Value = Range("O" & iRow).Value
If cell.Value < Range("AI" & iRow).Value And cell.Value > 1 Then Range("AI" & iRow).Value = cell.Value
If cell.Value > Range("AJ" & iRow).Value And cell.Value < 1001 Then Range("AJ" & iRow).Value = cell.Value
End If

Application.EnableEvents = True
End If



Next cell

End Sub

[Captain Sensible]

If you're just doing it as some data gathering exercise save yourself the bother and download betfairs own data filkes that contain max and min prices matched for pre off and in running

http://promo.betfair.com/betfairsp/prices/

[Dogoa]

Thank you very much.
So far it is just for getting some data. I would like to find out how much the odds change in play. And maybe make some sort of formulas that could help me make a little trade in play.

[Steve Voltage]

Thank you very much.
So far it is just for getting some data. I would like to find out how much the odds change in play. And maybe make some sort of formulas that could help me make a little trade in play.

Don't we all