How to calculate PV01 when the Yield is negative

Hi, given a bond Yield one can calculate the basis point value (PV01) of a bond using the Excel PRICE formula via PV01 = PRICE(bond with Yield) - PRICE(bond with Yield+1bp). However when the Yield is negative this calculation fails. Do you have a workaround for this. Thanks.

Nick's picture

hi Tim..Initial

hi Tim..
Initial thought:
depends on how accurate u need... if approximation, add a constant to the yield until it's +ve, then calc the PV01... as long as the yield isn't significantly -ve, this shld be close.
To get more accurate, add some convexity.