Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Larger cap for lookupSecurity maximum results #375

Open
mauritzvdworm opened this issue Oct 19, 2022 · 8 comments
Open

Larger cap for lookupSecurity maximum results #375

mauritzvdworm opened this issue Oct 19, 2022 · 8 comments

Comments

@mauritzvdworm
Copy link

Currently it looks like lookupSecurity is capped at a max of 1000 results, can we increase that number?

@eddelbuettel
Copy link
Member

eddelbuettel commented Oct 19, 2022

Sure -- can you recompile and try that it actually works with larger requests, i.e. that the backend doesn't just say 'no thanks' ?

@mauritzvdworm
Copy link
Author

Hi Dirk, thanks for the speedy reply. I'll try that. In BBG it states the list if a couple thousand lines long but you can only export 250 at a time. I don't want to manually go through that process.

@eddelbuettel
Copy link
Member

It sounds reasonable -- the result fields for this, as I recall, are small-ish so we may as well consume 10k or more, and as I recall for some classes (corportate bonds, say) there could indeed be a bazillion results. But I switched jobs and industries and don't currently have access to the backend so I have to rely on you (or @johnlaing).

@johnlaing
Copy link
Contributor

I'm not sure I understand. Can you provide an example of something you're trying to do that doesn't work?

@klin333
Copy link

klin333 commented Oct 20, 2022

seems like a bloomberg server side limit

response <- Rblpapi::lookupSecurity('a', maxResults = 1001)
nrow(response) # 1000

lookupSecurity_verbose.txt

Verbose print out shows processing of only 1 single Response event, ie no partial responses. Hence, probably Bloomberg server side limitation.

To fully put this to bed, probably will have to print out what events we are getting back other than Response and Partial Response, as we are currently just silently ignoring them. However, I couldn't be bothered.

@mauritzvdworm
Copy link
Author

I tried the recompile. Still capped at 1000 lines.

@eddelbuettel
Copy link
Member

So looks like it is the backend as @klin333 reminded us.

So sadly I think we can close this here as there is little we can do.

@johnlaing
Copy link
Contributor

I guess we could warn if maxResults > 1000, that's easy and potentially useful

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants