Cell refresh order?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Nero Tulip
Posts: 686
Joined: Wed Apr 15, 2009 5:29 pm

Did I imagine it, or was there a thread here somewhere that conclusively listed the order in which cells in bet angel linked sheets refresh ? Or if not, can anyone advise on what is the best way to go about deciphering this ? Help greatly appreciated..
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

There's a thread about 'Last updated cells' that may be what you are looking for, but the conclusion was that the C2:C6 range is the last to be updated
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

$A$1:$B$1 ‘ ident & race
$G$1:$H$1 ‘ in-play & suspended
$C$2:$C$6 ‘traded, last update etc
$F$2:$F$4 ‘ off time,mins til off
$A$9:$K$18 ‘runners & details GOES BEYOND K18 (dependant on runners)
$T$9:$AE$18 ‘PLACED BET DETAILS

Last time i checked.
Wolf1877
Posts: 367
Joined: Fri Sep 08, 2017 10:59 am

This is the sequence of the cell refresh on the latest 1.51.1 Betfair version (with optional VWAP loaded into column AF)
Re-checked on todays opening race the 13:35 at Haydock with 13 runners.
No change from recent previous versions.

$A$1:$B$1
$G$1:$H$1
$F$2:$F$4
$A$9:$K$34
$T$9:$AE$34
$AF$9:$AF$34 <---- optional VWAP loaded into column AF.
$C$2:$C$6
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”