Hi Ajinkya,
This is my first post, i hope you will like below solution, if there is any error please suggest:
=IF(IF(B2>0,RANK(B2,$B$2:$B$9),RANK(B2,$B$2:$B$9,1))>3,"",IF(B2>0,RANK(B2,$B$2:$B$9)&" Gain",RANK(B2,$B$2:$B$9,1)&" Loss"))
Use above formula in cell c2 and drag down.