blp icon indicating copy to clipboard operation
blp copied to clipboard

A question about BDS api

Open Piggy-hammer opened this issue 3 years ago • 1 comments

The result returned by the BDS request is usually a table, but for the convenience of my data processing, I would like to compress the entire table into a single element or something similar. If using Bloomberg's Excel interface, I would use the following formula:

=BDS("299461SL8 Muni","PARTICIPANTS_TABLE", "Aggregate=Y","Separator=C")

with the above formula, the table will be aggregated into a list, and the list will be presented as a string, to be shown in a single cell in excel

Can I do something similar with blp package? Like pass the parameter of "Aggregate = Y" to the BDS api so I can get a list in stead of a whole table?

Piggy-hammer avatar Feb 23 '23 04:02 Piggy-hammer

Why wouldn't you just do this yourself using DataFrame.to_csv? I don't think it makes much sense for the package to do this.

gandhis1 avatar Feb 23 '23 11:02 gandhis1