(Bloomberg) BDP Formula question [closed]

Good Morning,

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?

=BDP("odcn8c_*400*_comdty","vega")*I68*50


closed as off-topic by Daneel Olivaw, Bob Jansen♦Jun 7 '18 at 14:13

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "Basic financial questions are off-topic as they are assumed to be common knowledge for those studying or working in the field of quantitative finance." – Daneel Olivaw, Bob Jansen
If this question can be reworded to fit the rules in the help center, please edit the question.

Just concatenate the string (and replace the _ with spaces to form a valid ticker):
=BDP("odcn8c " & T2 & " Comdty", "vega") * I68 * 50

• with 400 in cell T2 it works for me, unless you have something incorrect in cell I68. – assylias Jun 7 '18 at 14:28
• the value in I68 i don't think would be able to cause an #N/A Invalid result, as that's what bbg returns. – will Jun 8 '18 at 12:57
• @Dominic So =BDP("odcn8c 200 Comdty", "vega") works, but =BDP("odcn8c " & T2 & " Comdty", "vega") with 200 in T2 doesn't? – assylias Jun 8 '18 at 15:03