Skip to content

RBloomberg

8 messages · thomas.browne at mac.com, John Laing, krisan haria

thomas.browne at mac.com
# 
First of all may I thank everybody involved in creating this RBloomberg add-in, and the various R finance libraries. I am a salesperson in fixed income emerging and developed bond markets, specializing in RV, and since having "migrated" from Excel to R a few months ago, I haven't looked back. I am doing analyses which my clients - major macro hedge funds - have never seen before. This project is a real game changer for me and I owe everybody involved, bigtime. Thank you. 

Second - I have had some conversations with Bloomberg on their data API. The point below is correct - it cannot be redistributed - and if you produce charts with Bloomberg data you're supposed to include the source in them. There is however a Data licence, and this does allow for redistribution under certain conditions, but at high cost. Your bloomberg rep can advise because it's all turnkey and case-by-case. 

Finally I have a question. How difficult would it be to access Bloomberg data from a Linux or OSX platform? I'm finding Windows increasingly constraining. 

Tom
On 30 Aug 2011, at 15:04, Jos? Fernando Moreno Guti?rrez wrote:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

        

      
      
    

  
  


  


    

    
14 days later

    

      
      

        


  

        

      krisan haria
    

    

      
      #
    

  


  

      
Hi

I am trying to use RBloomberg in R

The version is R 2.13.1

When I type

conn <- blpConnect()

I get the following error:

---------------------------
CFields_InvisibleWindow: Rgui.exe - Unable To Locate Component
---------------------------
This application has failed to start because XLCall32.dll was not
found. Re-installing the application may fix this problem.
---------------------------
OK
---------------------------


Any idea what is going wrong? It is the first time I've used this.

Regards

Krisan

  
  


  


      

    

    

      
      

        


  

        

      John Laing
    

    

      
      #
    

  


  

      
Krisan,

Do you have the Bloomberg Java API installed? Generally the files will
be in C:\blp\API\APIv3\JavaAPI\...
The packages are available through the Bloomberg WAPI screen.

John

        
On Mon, Sep 19, 2011 at 4:00 AM, krisan haria <krisanharia at gmail.com> wrote:

            

      
      
      
    

        

      
      
    

  
  


  


      

    

    

      
      

        


  

        

      krisan haria
    

    

      
      #
    

  


  

      
I didnt have it, but now have it installed. But the error msg is still the same.

        
On Mon, Sep 19, 2011 at 12:48 PM, John Laing <john.laing at gmail.com> wrote:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

  
  


  


      

    

    

      
      

        


  

        

      John Laing
    

    

      
      #
    

  


  

      
Please run the following code and copy the results to this thread:

library(RBloomberg)
sessionInfo()
list.files("C:\\blp\\API\\APIv3\\JavaAPI", pattern = "jar$", recursive = TRUE)
conn <- blpConnect()

Thanks,
John

        
On Mon, Sep 19, 2011 at 8:33 AM, krisan haria <krisanharia at gmail.com> wrote:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

  
  


  


      

    

    

      
      

        


  

        

      krisan haria
    

    

      
      #
    

  


  

      
Tried the first three lines

Output is the following


R version 2.13.1 (2011-07-08)
Platform: i386-pc-mingw32/i386 (32-bit)

locale:
[1] LC_COLLATE=English_United Kingdom.1252
[2] LC_CTYPE=English_United Kingdom.1252
[3] LC_MONETARY=English_United Kingdom.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United Kingdom.1252

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base

other attached packages:
[1] RBloomberg_0.1-11    chron_2.3-39         zoo_1.7-4
[4] RDCOMClient_0.92-0.1

loaded via a namespace (and not attached):
[1] grid_2.13.1     lattice_0.19-30

But on the last line I get the same erro msg

---------------------------
CFields_InvisibleWindow: Rgui.exe - Unable To Locate Component
---------------------------
This application has failed to start because XLCall32.dll was not
found. Re-installing the application may fix this problem.
---------------------------
OK
---------------------------

        
On Mon, Sep 19, 2011 at 2:09 PM, John Laing <john.laing at gmail.com> wrote:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

  
  


  


      

    

    

      
      

        


  

        

      John Laing
    

    

      
      #
    

  


  

      
Your version of RBloomberg is very old: 0.1-11. You will need to
upgrade to the most recent release (0.4-150), which can be done like
this:

install.packages("RBloomberg",repos="http://r.findata.org/")

You will also need to install rJava 0.9, which is available from CRAN.

John

        
On Mon, Sep 19, 2011 at 9:17 AM, krisan haria <krisanharia at gmail.com> wrote:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

  
  


  


      

    

    

      
      

        


  

        

      krisan haria
    

    

      
      #
    

  


  

      
nice one. Thanks.

Much appreciated

        
On Mon, Sep 19, 2011 at 2:48 PM, John Laing <john.laing at gmail.com> wrote: