search

matthewgilbert / blp

Pythonic interface for Bloomberg Open API
Apache License 2.0
112 stars 24 forks source link

A question about BDS api #24

Open Piggy-hammer opened 1 year ago

Piggy-hammer commented 1 year ago

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?

gandhis1 commented 1 year ago

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.