Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I am using the below formula and need some help, how do I change the below strike price (400) to pull from a separate cell (T2) I have on the spreadsheet?
Just concatenate the string (and replace the _ with spaces to form a valid ticker):
=BDP("odcn8c " & T2 & " Comdty", "vega") * I68 * 50
=BDP("odcn8c 200 Comdty", "vega")
=BDP("odcn8c " & T2 & " Comdty", "vega")