Building a Bloomberg BDP Ticker from a Spreadsheet Cell

Summary

This brief spreadsheet example shows how to make a Bloomberg BDP query use a strike stored in another cell instead of a fixed value. The method is to concatenate the ticker’s text components with the cell reference, while formatting the ticker with spaces as required by Bloomberg.

The example applies this to a request for a contract’s vega and retains the existing quantity and multiplier terms. It is a narrow formula tip rather than a discussion of options valuation or market risk; it provides no broader guidance on ticker conventions or error handling.

Key ideas

• A BDP ticker can be assembled by concatenating text with a spreadsheet cell value.
• Use spaces between ticker components when forming the Bloomberg security string.
• This example retrieves vega for a contract whose strike is stored in a cell.

Tags

# (Bloomberg) BDP Formula question


# (Bloomberg) BDP Formula question












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
```

## Answer by assylias (score 2)

https://quant.stackexchange.com/a/40212

Just concatenate the string (and replace the `_` with spaces to form a valid ticker):

```
=BDP("odcn8c " & T2 & " Comdty", "vega") * I68 * 50
```

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.