asked on

Using excel with Bloomberg BLP functions

I am using Visual Basic within Excel to run a Bloomberg BLP function that tells me the CUSIP of a security. Within Excel VB I am testing for any N/A's prior to closing. My problem is that the code only works for a small set of securities. If I try it with a large file it appears the BLP function does not run/update any of the securities within the file. Interestingly if I input a message box at the start of the code the BLP function/VB code runs fine after clicking on "ok" on the message box. If I remove the message box the BLP functions does not seem to run. As mentioned at the start if there only a few rows of data the code runs fine.

I have taken a look at a few of the other posts on the site regarding BLP/Excel in terms of timers, etc. but I have the same results as explained above....

Thanks in advance.

ASKER CERTIFIED SOLUTION

Chris Bottomley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pbo1

ASKER

I am not at the office right now, but tomorrow I will post the code where nothing happens. There is only one BLP function that I run and as mentioned above it just does not seem to run if greater than a few hundred records. If I insert a message box and step-thru it works. If there is less than a few hundred records it works without a message box.

Chris Bottomley

OK will await that post, fo rnow I am assuming something like a range bound issue which will hopefully be apparent from sight of the code.

Chris

SOLUTION

Éric Moreau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial