I used the PortfolioDataRequest aspect of the Bloomberg API in C++; however, when attempting to request the portfolio of the TAIL US EQUITY (an ETF), it returns an invalid symbol.

I also tried using the portfolio id "H195151-74" but to no avail.

  • $\begingroup$ Leaving aside the Bloomberg API for the moment, does the Bloomberg terminal have data for this fund? What identifier (ticker) did you use? $\endgroup$ – noob2 Jun 11 at 14:41
  • $\begingroup$ @noob2 The Bloomberg terminal shows me the portfolio under the PORT <GO> command $\endgroup$ – Jake Freeman Jun 11 at 15:29
  • 2
    $\begingroup$ Did you ask the help desk? They will not explain you c++ but there is nothing in the API that excel cannot do (in fact, excel is more versatile than c++). $\endgroup$ – AKdemy Jun 11 at 22:00
  • $\begingroup$ I don't think constituents are available through the API for ETFs, only for indices. So you would have to manually download the holdings from PORT. You can double check with HELP HELP. $\endgroup$ – assylias Jun 13 at 9:39

I am assuming you just refer to Portfolio look-through in PORT? If so, that is the same as TAIL US Equity MEMB. That is not a portfolio data request. The ID H195151-74 is just what PORT assigns to TAIL US Equity if you load it directly. I cannot comment on tickerized portfolios (these need extra enablement) but apart from that, in API, the only solution you have is BQL which you cannot use in C++ .

=BQL("members('TAIL US Equity',type='holdings')","id().weights") 

Generally, there is INDX_MEMBERS but if you try that in FLDS you will see that it does not support any Equity tickers like @assylias explained as well (which means no ETFs like SPY, TAIL etc.). You can type SPX Index FLDS DS325 in the command line to see what I mean. If you switch to an ETF, that field disappears because the filter is set to equity (which is not supported).

So I guess the easiest solution would be to automate an import from a sheet that pulls the ETF holdings via BQL. Or you ask your sales rep whether tickerized portfolios could do that or if they have some premium feed (data license) offering for holdings data.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.