• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup And Fetch Data From One Sheet To Second Sheet With Strike Price And Expiry Date

RUPESHRH

New Member
I want to fetch call open interest of 29-09-2022 expiry date in data sheet from nifty sheet(column F) .We can identify the Call Put as per identifiers column in nifty sheet(OPTIDXNIFTY29-12-2022PE7500).
Please let me know the formula Sir
 

Attachments

Last edited:

RUPESHRH

New Member
I want to fetch call open interest of 29-09-2022 expiry date in data sheet from nifty sheet(column F) .We can identify the Call Put as per identifiers column in nifty sheet(OPTIDXNIFTY29-12-2022PE7500).
Please let me know the formula Sir

Anybody is there for solve the problem sir
 

shili12

Member
Anybody is there for solve the problem sir
You have to be patient , there was a time i was given a solution here after a week or so, unless you go & hire excel experts and pay themselves.
when persons are volunteering , they move at their pace. So kindly be patient , humble and thankful
 
Top