Hi londolozi,
I've tested near_sp and it does seem to return correct figures which are equal to the selection's Near SP. It may be null if Near SP is null as well, e.g. in a low-liquidity market (as AUS races often are).
You can always compare the variable against the SP value, see the attached picture.