Requests

[xraymitch]

Hi Os,

Not much activity here I see.

I guess my suggestion doesn't press the right buttons for you then !!

Ray

Sorry Ray, was not ignoring this. I've just been much more busy than expected and to top it all have had both a hard drive fail and my router blow up in the same week. Thankfully all is sorted now so will take a look at your suggestion.

Os

Thanks OS - that's a tough break

Glad to hear all is sorted now


Ray

[mak]

xraymitch
the code below clears the bet ref column (t) when the market turns in play

i don't know when your conditions are met or how but probably you or we could aadjust


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Columns.Count = 16 Then
If Cells(2, 5).Value = "In Play" Then
If Cells(1, 33).Value = "" Then
Cells(1, 33).Value = Now()
Range("T5:T55").Clear
End If
End If
If Cells(2, 5).Value = "Not In Play" Then
Cells(1, 33).Value = ""
End If
End If


End Sub

[xraymitch]

Hi xraymitch,

Not sure why you can't just use an excel formula, except If I have misunderstood what you are after or what you are after is more complex than I think.

Thanks danjuma,

No you have understood perfectly and I will give your method a try.

What should have been a fairly simple exercise - using VBA code to check the cells and place CLEAR all seemed to work perfectly but for the fact that the bet reference still remained

After many hours of frustration and confusion I sought help here. I did partially achieve what I wanted by using the matched bet flag in column Y.
Now all is achieved just with triggers.

Cheers,

Ray

As a footnote in the last few days I am seeing unexplained errors with macros that have worked perfectly for many months. I suspect I may have some corruption or some undetected virus. Anyhow this weekend I shall wipe my pc and start again from scratch.

[xraymitch]

You could do that easy with a few if statements and a few macros. it may be a bit crude for some but it would work , im a nuts and bolts sort of person but i useully get the job done

Thanks U.F.O.

I am sure you are right - look at danjuma's example or my own method just using triggers and Gary's matched bet flag in Y.

For a week or so I became obsessed with getting my VBA code right as I really want to get up to speed. Mastery of VBA, combined with BA makes for powerful tools at your disposal

Cheers,

Ray

[xraymitch]

xraymitch
the code below clears the bet ref column (t) when the market turns in play

i don't know when your conditions are met or how but probably you or we could aadjust


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Columns.Count = 16 Then
If Cells(2, 5).Value = "In Play" Then
If Cells(1, 33).Value = "" Then
Cells(1, 33).Value = Now()
Range("T5:T55").Clear
End If
End If
If Cells(2, 5).Value = "Not In Play" Then
Cells(1, 33).Value = ""
End If
End If


End Sub

Sorry Mak I didn't notice your reply. I will play around with your sample code this evening.

I see you are using ".value" which might explain why my sheet was not working correctly. Here is my code:

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

For n = 5 To 34

If Cells(n, 22) > 0 And Cells(n, 22) < Cells(n, 27) And Cells(n, 31) <> 1 Then Cells(n, 17) = "CLEAR"

If Cells(n, 17) = "CLEAR" And Cells(n, 31) <> 1 Then Cells(n, 17) = "BACK"

If Cells(n, 17) = "BACK" Then Cells(n, 31) = 1

Next n

Application.EnableEvents = True

End Sub

Thanks for taking the time to post. You have been a great help

Ray

[danjuma]

Hi osknows,

If you are still looking for a project to work on, I have a request or two.

1. The ability to be able to display the price over time for a selection as a graph in excel. A simple line or column chart for each selection (displayed all at once if possible) will do. I know you can see this on the ladder interface for each selection (one at a time) or by clicking on individual selection in the grid interface for the pop-up graph. However, if you want to view for all selections at once (achieved by ticking the option to display 'price history' in preferences), it's not brilliant on the grid interface the way BA displays it. If you have ever trialled Fairbot (grid interface), you will see what I mean.

2. A way to be able to tell whether the last price matched in column O is a back bet or lay bet. Probably not possible?

Cheers
Dan