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.
file link: 4shared
.com/file/v8KGdwOsce/hcl_sheet_2.html?
thax all. aman.
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.
file link: 4shared
.com/file/v8KGdwOsce/hcl_sheet_2.html?
thax all. aman.
Last edited: