As far as betfair is concerned for Australian racing, the only time their prices are relevant is when they are getting matched. This is usually only the last 3-4 minutes of betting... Just not much action except for Sats....

Another question if I can pick your brain again....

When I import the odds, most of my formulas become irrelevant. For example:
$8 $12.5
$3 #Ref!
$2 #Ref!
$4 #Ref!
$5 #Ref!

The autorefresh works, but as soon as I edit the query to choose the next race, this happens...
Sorry but that is the best I can explain it... All I have to do is drag the formula from 12.5 down, but I am presuming there is a setting I can choose....

It seems to me that it is inserting new cells, therefore leaving references to what was there before irrelevant....