Enable Bloomberg excel add-in in embedded excel

Question

Hi, may I ask how to let the Bloomberg excel add-in work in the embedded excel? The embedded excel was inserted into the page by selecting the availalbe macro called "Office Excel", and the Bloomberg excel add-in enables users to extract data from the Bloomberg Terminal using formulas like bdp=(...), bdh=(...), etc.

Currently, the fields with Bloomberg formulas are showing #NAME? on the embedded excel, and none of these fields is pulling data. May I also know if there is a work-around if the Bloomberg excel add-in cannot be directly enabled? Thank you very much!

Tom Senoyer · Answer

Hi, I know it's been 5 years but did you find a way to fix this issue?

I have the same with BBG it's very frustrating not to be able to use BDH, and BDP.

@Davin Studer  the bloom addin just allow user to use a few function to retrieve data from the main terminal!

When I open a workbook manually and load the addin, no problem, but when the workbook is opened with C# i'm not able to retrieve the formulas even if the addin seems to be enabled.

Many thanks for your time!

Davin Studer · Answer

Well, the first question I have would be what does the Bloomberg Excel add-in do?

Sven Lan · Answer

I see, thanks Davin! If so, may I ask if there is any work-around that you could possibly know of?