Excel Bets sheet and RESULT_NOT_AVAILABLE

[MatGreenaway]

Hi,

I'm testing something new and it relies on knowing previous results. As I am using auto select, if a market switches before it is settled, the bet(s) from the previous race will show as RESULT_NOT_AVAILABLE and it would take a market switch to update again.

Is there a way I can force update this so after a market switch, it will check continually and update once that market has settled? I seem to remember triggers in J2 maybe to update the balance - would that do it?

Thanks,
Mat

[MatGreenaway]

I have realised I can use -2 and then -1 in Q2 to load the previous market and then the next market in the list which I guess will achieve what I need.

I'll test tomorrow

Thanks,
Mat

[Captain Sensible]

-6 in Q2 will refresh the bet results sheet

[bolpx001]

That is very good to know Captain - thank you for sharing
best regards - Paul

[Captain Sensible]

Always worth bookmarking the user guide , Paul


http://www.gruss-software.co.uk/Betting ... e/help.htm

[MatGreenaway]

Thanks for that - it is useful.

Hope you have a good weekends betting.

Cheers,
Mat

[bolpx001]

For Information Purposes:
All bets done manually using BA (not Excel)
My betting bank: 1437.84
BACK Stake 530.50 @3.85
New Balance; 777.76

LAYSP 500.00
LAYSP 500.00
LAYSP 437.84
LAYSP 74.09 (got sums wrong)

On race start BFSP was 4.27 and all LAYSP bets accepted, leaving the position as £0.08 for win and -£68.56 for a loss. Greened out for a loss of -£51.62
Sods law dictated that the horse won