List of the Triggers for the Q2 Cell in Excel

[throwmeadisc]

Hi Gary/Mark,

Is it possible to have an update list of triggers for the Q2 cell in Excel please?

I know of a few but I think there are some extra ones I don't know about and can't find in the forum. eg. Updating of the Log Bets Sheet (I might be dreaming that).

Would be great to have a comprehensive list and maybe in the help file too...

Cheers Guys

Al

[GaryRussell]

The help file for Excel functions is up to date for version 1.1.0.20 which is the official release. I have been working on the next release for a while which includes the following triggers not included in version 1.1.0.20.

-5: select first market in quick pick list
-6: update bet results (only valid when logging bet results)
-7: clear bets results (only valid when logging bet results)

You can download the version I am working on from http://www.gruss-software.co.uk/Betting ... a_Test.msi (version 1.1.0.24). You first need to uninstall the current version using the control panel.

[throwmeadisc]

Thank you Gary. These will be most useful especially in finding out what prices you got if you are betting at Betfair-SP and can't wait for the off.

Al

[mikedmc]

So does that mean u can now trigger the an update to the bet results from excel rather than waiting for the next race?

If so what is the trigger please?

Thank you.

[GaryRussell]

So does that mean u can now trigger the an update to the bet results from excel rather than waiting for the next race?

If so what is the trigger please?

Thank you.

Yes, but it still depends on Betfair settling the market. Put -6 in cell Q2. Make sure you are using ver 1.1.0.24 or it will not work.

[throwmeadisc]

I'm only after getting the price that my SP Bet got matched at, Bet results are not a concern.

Cheers

Al

[mikedmc]

So does that mean u can now trigger the an update to the bet results from excel rather than waiting for the next race?

If so what is the trigger please?

Thank you.

Yes, but it still depends on Betfair settling the market. Put -6 in cell Q2. Make sure you are using ver 1.1.0.24 or it will not work.

Thank you. Rather than hi-jack this thread I'm going to throw up another excel query take a read please .

All the best.
Michael.

[throwmeadisc]

Hi Gary,

If I put in -6 in Q2 then the betlog does not update with bets placed. Does the trigger just update the results and not fill the Bet Log sheet like it should do when auto selecting the markets? If so, can the -6 trigger please fill and update the Bet Log sheet?

Example.
Excel Link setup and Bet Logging enable, inc Links to Bet Log sheet (Sheet 2). Bet placed via Trigger in excel. Bet matched. -6 put in Q2. No Bet info in Bet Log Sheet.

Extra Info.
I am using version .39
Don't use Autoselect Markets, just -1 in Q2 to change markets.

Thanks,

Al

[GaryRussell]

The bet logging sheet is updated on every single refresh of Excel, it does not have to be triggered. You could even place bets via Betfair's website and they will appear on the MyBets sheet. Are you sure you ticked 'Log current bets' and provide a worksheet named MyBets?

[throwmeadisc]

Thanks for the reply Gary.

The mybets sheet is no good for me as I am trying to record what price I get Betfair SP at. I want to be able to place a SP bet get the Bet ref and then move to another market. A bit later I will then use the BetRef to look up the Betlog and see what price I got at the off. I know I could wait until the off, but when races are delayed this causes issues. Also I don't use autoselect so I wanted a way to update the BetLog table.

Hope this makes sense.

Thanks.

Al

[throwmeadisc]

Hi Gary,

Have you had any thoughts on how I could get the Betfair SP price after I have navigated away from the market? It would really help me a great deal...

The Bet log Sheet will not update unless I have Autoselect markets on

Thanks,

Al