refresh market

[dgs2001]

Hi All

Is there a q2 trigger that refreshes the current market?

Duncan

[GaryRussell]

Sorry, there isn't. It's down to the design. The Q2 trigger is read on each refresh so if it's not refreshing then it can't be read and trigger a refresh.

[dgs2001]

Hmm Okay Thanks Gary

It caused a minor problem for me when a market had a non runner but my unrefreshed worksheet tried to place a bet and got stuck with "SELECTION_REMOVED".

Serves me right I shall make an adjustment to my worksheet code.

Duncan

[GaryRussell]

Oh, you mean reload the market. I thought you meant force a refresh of prices. This is something I can consider.

[dgs2001]

Yes sorry Gary

I did indeed mean Reload the market.

Useful when changing from a long refresh back to a shorter one.

Duncan

[Spike]

Gary,

Would it be possible to force a refresh of prices via the COM?

Because that would be great....

[GaryRussell]

Gary,

Would it be possible to force a refresh of prices via the COM?

Because that would be great....

Not currently. I agree it would be useful and will try to include it in a future release.

[jrvoice]

Hi,

I've got the same issue - detecting NR's and refreshing the current market... is there any Q2 trigger which can do this?

Thanks,
Jon

[GaryRussell]

Hi,

I've got the same issue - detecting NR's and refreshing the current market... is there any Q2 trigger which can do this?

Thanks,
Jon

Not exactly sure whether your issue is the same. Can you describe exactly what you are trying to achieve?

[jrvoice]

Apologies... Basically I'm looking to do a refresh of the same market if I detect a (NR) string in the runner name.

I've got a flag to detect the (NR) bit, at which point I want to reload the same, currently selected market.

If there is no existing Q2 "reload current market" trigger, can I use:
[Q2] = "GO:" & Worksheets("Gruss").Range("N3").Value or would it be ignored?

Many thanks

[KESIMKESIM]

Hi, I think this Sub may help you. As I reload the market when I detect (NR) just as you are wanting to do by simply running the below.

Sub Reload()

Dim ba As BettingAssistantCom.ComClass

Application.EnableEvents = False
Application.ScreenUpdating = False

If ba Is Nothing Then Set ba = New BettingAssistantCom.ComClass
ba.TabIndex = 0
ID = Range("N3").Value
result = ba.openMarket(ID, 1)

Set ba = Nothing

Application.ScreenUpdating = True
Application.EnableEvents = True

End Sub


The ba.TabIndex =0 line is because this is to reload the first tab in BA, you need to increment this if you are using multiple tabs.

Best Regards.

[jrvoice]

Thats excellent - thank you very much... I suspect my life would be easier if I used more COM classes, there are only so many hoops you can have VBA jump through

Thanks again...