call put option

  1. A

    Excel Copying

    Hi All, I have attached an auto refreshing excel sheet of HCL tech. I am able to get the max volume using MAX formula. I want to copy the related strike price where max volume falls for CALL & PUT. Max volume in call put change on every refresh, so cannot use simple copy paste. please help...