BSRCH Options

[jackwelder]

Does the BSRCH command support options as in Excel? Looking to run the following query: =BSRCH("BI:TPD","BIKEY=WAC_UNIT_BY_NDC11","BIARG0=378395205") in R and pull into data frame object. Please advise - thanks!

[johnlaing]

This does not seem to be implemented currently. I actually can't even find documentation for this corner of the API. The function was written by @wmorgan85 , maybe he can point us in the right direction?

[jackwelder]

@eddelbuettel please let us know if you have any additional clarity on this item as well - thank you i

[eddelbuettel]

I have nothing to add here. We often get asked to replicate some obscure Excel Bbg function. That generally reveals a misunderstand of what the API is against which we code, and how the Excel plugin is seen simply have some extra bells and whistles---that are generally not available to us. Sorry.

[gsmccomas]

At the risk of being annoying, I'm going to +1 this request. Bloomberg in a few instances has been increasingly using the bsrch function to query non-tickerized content. A great deal of their weather data is accessed through bsrch with a series of mandatory additional arguments

`library(Rblpapi)
#> Rblpapi version 0.3.10 using Blpapi headers 3.8.18.1 and run-time 3.8.18.1.
#> Please respect the Bloomberg licensing agreement and terms of service.

blpConnect()

bsrch("comdty:weather", verbose = TRUE)
#> Sending Request: ExcelGetGridRequest = { Domain = "comdty:weather" }
#> Processing Response
#> GridResponse = {
#> NumOfFields = 0
#> NumOfRecords = 0
#> ColumnTitles[] = {
#> }
#> DataRecords[] = {
#> DataRecords = {
#> DataFields[] = {
#> }
#> }
#> }
#> ReachMax = true
#> Error = "Missing the following mandatory input(s): LOCATION, MODEL"
#> SequenceNumber = 0
#> }
#> 0 records returned
#> Returned columns:
#> ColumnTitles[] = {
#> }
#> Columns converted to C++ vector
#> 0 Rows expected
#> data frame with 0 columns and 0 rows`

[eddelbuettel]

Well we are busy professionals too, and it may take us a (long) time until our plates are empty with what we need to work on --- so if you need it badly maybe you can work on it, or find someone who can. Clean code contributions are always welcome, and we will help.

[gsmccomas]

@eddelbuettel I'll take a stab at it! I've been using Rblpapi for a long time and would be happy to contribute back to the code base. As an aside, python's pdblp also lacks this particular function. Thanks for the feedback!

[sergejlazuk]

Hi gsmccomas, any lack with extending BSRCH?
Would like to use it to get some model data...

[gsmccomas]

Hi @sergejlazuk I haven't made much progress on this I'm afraid. I've gotten about as far as looking over the API documentation, which is lamentably very spare on its detailing of BSRCH calls.

[sergejlazuk]

Thx for reply Garrick, let me know if you decide to look into this further, maybe I can help as well, but I would not wage it on my own... Regards, Sergej Lazuk Am Fr., 5. Juli 2019 um 20:49 Uhr schrieb Garrick MComas < notifications@github.com>:

…

Hi @sergejlazuk <https://github.com/sergejlazuk> I haven't made much progress on this I'm afraid. I've gotten about as far as looking over the API documentation, which is lamentably very spare on its detailing of BSRCH calls. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#260?email_source=notifications&email_token=AIAMYVOC3ELOYAKDXPCXJILP56JTPA5CNFSM4EOYARIKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZKEDGQ#issuecomment-508838298>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AIAMYVPVAE3KKBXWHBPBGYDP56JTPANCNFSM4EOYARIA> .

[gioxc88]

+1