Hi Friends,
I have got the Option Data for DLF Contract on 4 Sep 2015 in Excel Sheet for different strikes. I want to write a formula in the last column that will identify the ATM Strike Automatically. Can you please help me to find out, what condition should I put in the [ L Column ] of this sheet. I have attached the snapshot and I have also uploaded the original excel file as well.
Thanks a lot for your help.
Regards
https://www.sendspace.com/file/uza3kj
I have got the Option Data for DLF Contract on 4 Sep 2015 in Excel Sheet for different strikes. I want to write a formula in the last column that will identify the ATM Strike Automatically. Can you please help me to find out, what condition should I put in the [ L Column ] of this sheet. I have attached the snapshot and I have also uploaded the original excel file as well.
Thanks a lot for your help.
Regards
https://www.sendspace.com/file/uza3kj