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...