Is there any formula to get this? Seems like this is too manual and time consuming. Thank you for your answers in advance.
You could try the approximate formula for convexity to save time:
The formula in column 7 is an exact formula that you could derive from the expression for duration - but ain’t nobody got time for that!!! 
1 Like
@breadmaker Can you explain with the above mentioned formula. Here there is no data for the Change in the Yield. Then how can we calculate. Kindly Elaborate.
Teh abive formula is an approximation for the convexity. Like with apprximate modified duration you calcualte it by changing yield , ie. +/- 0.1% , seeing what the prices would be (up and down) and then calculate convexity.
% ch Bod price = - duration x chnage in yield x
1 Like
Like my man @MikeyF posted, you could raise/drop the YTM by a few basis points, recalculate price, substitute for the P+, P-, P0 and the delta to get the approximate duration.