unable to access portfolio data on Rbbg

[christianWilson]

Error message NOT_APPLICABLE_TO_PORT_DATA appears whenever I try and access portfolio data through bds

[wmorgan85]

You should use getPortfolio not bds. In Excel the Bloomberg implementation of bds routes these fields to a different service. In Rblpapi we introduced a new function.

On 14 Sep 2016 15:08, "christianWilson" [email protected] wrote:

Error message NOT_APPLICABLE_TO_PORT_DATA appears whenever I try and access portfolio data through bds

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Rblp/Rblpapi/issues/199, or mute the thread https://github.com/notifications/unsubscribe-auth/AA08VqSYk3LZnYoNPk4qtPJbYAnsEf96ks5qp__DgaJpZM4J80Et .

[eddelbuettel]

The request here was mostly invalid and a) incomplete and hence b) not reproducible. Please do better.

[christianWilson]

Thank you for your messages.

GetPortfolio doesn't appear as a command when I run Rblpapi either

"Error in getPortfolio("TS-PX1419-24 Client", "PORTFOLIO_MEMBERS") : could not find function "getPortfolio_Impl""

[christianWilson]

is I type Rblpapi::

a list of possible commands appear: getBars, getTicks etc but getPortfolio does not

[eddelbuettel]

Looks like this was added after the 0.3.4 release so you would have to build from source.

[wmorgan85]

One other point to note is that this is an AIM portfolio, as indicated by the TS- prefix of the security. IIRC it is not supported using the same service. Instead it is a separate product called TS-ADF I believe...

[test4GitHub]

You need to use Alpha instead of Client for an AIM portfolio. For example: getPortfolio("TS-PX1419-24 Alpha", "PORTFOLIO_MEMBERS")

[asilvaru]

I'm interested in pullying out portfolio data for a specific date. I'm using the excel function

=+BDS("<PortfolioID> Client";"PORTFOLIO_DATA"; ;"Reference date="20170830")

But I can't implement something similar in R.

I'm using overrd = c("START_DT" = "20170828") and calling the method port = getPortfolio(security = portID,field = DataField,overrides = ovrrd)

However, I'm retrieving the portfolio holdings for Today.

Any way to specify the date for portfolio holdings to be retrieved?

Thanks!

[eddelbuettel]

Ask Bloomberg Help to show you it is done via the (documented, supported) C++ API.

With a working C++ solution, come here and we integrate it. Until then, please don't mistake a few colleague volunteering their time in an open source project for the Bloomberg Help desk.

[joel23888]

@fonz88 see my comment in #238 where it describes how to override the reference date.

[eddelbuettel]

And I should note that @joel23888 is a saint.

[asilvaru]

@joel23888 Thanks for the reply. @eddelbuettel I'm afraid is not my intention to use this platform as a Blomberg help Desk. As a new user of Rblpapi, I'm still trying to find complete documentation on the full list of function parameters.

Best Regards

[racoon971]

Hi Wehere in bloomberg termnail do you get the TS- prefix of an AIM portfolio ?

[armstrtw]

You need the bbg helpdesk for that question. We are users just like you.

[racoon971]

Yes it did this , the answer is : the account number can be found under AIM>>Accounts under the num column the full TS code will be TSPXZZZZ-HHH as an example with pricine number ZZZZZ and account number HHH