
Have the same in Rbbg, but when trying in XL:
=BDH("FP FP Equity","ENERGY_CONSUMPTION","-4FY")

I am getting:

  #N/A N/A

???


> From: Gordon.Morrison@ftse.com
> To: R-SIG-Finance@r-project.org
> Date: Tue, 3 Jul 2012 15:00:23 +0100
> Subject: [R-SIG-Finance] Rbbg - curious performance of bdh?
> 
> I seem to be getting some surprising results when I run the function "bdh". The code I am running is as follows
> 
> 
> > library(RBloomberg)
> 
> Loading required package: rJava
> 
> > conn <- blpConnect()
> 
> R version 2.15.0 (2012-03-30)
> 
> rJava Version 0.9-3
> 
> RBloomberg Version 0.4-151
> 
> Java environment initialized successfully.
> 
> Looking for most recent blpapi3.jar file...
> 
> Adding C:\blp\API\APIv3\JavaAPI\v3.4.8.1\lib\blpapi3.jar to Java classpath
> 
> Bloomberg API Version 3.4.8.1
> 
> The connection seems to work OK
> 
> > bdp(conn, "AMZN US Equity", "NAME")
> 
>                          NAME
> 
> AMZN US Equity AMAZON.COM INC
> 
> And I can download a time series of sales/revenue - as shown below
> 
> 
> > bdh(conn, "FP FP Equity", "SALES_REV_TURN", start_date = "20080101")
> 
>                  date SALES_REV_TURN
> 
> 2008-03-31 2008-03-31          39287
> 
> 2008-06-30 2008-06-30          43300
> 
> 2008-09-30 2008-09-30          44039
> 
> 2008-12-31 2008-12-31          33705
> 
> 2009-03-31 2009-03-31          25468
> 
> 2009-06-30 2009-06-30          26574
> 
> 2009-09-30 2009-09-30          28816
> 
> 2009-12-31 2009-12-31          31295
> 
> 2010-03-31 2010-03-31          33161
> 
> 2010-06-30 2010-06-30          36327
> 
> 2010-09-30 2010-09-30          35228
> 
> 2010-12-31 2010-12-31          35760
> 
> 2011-03-31 2011-03-31          41602
> 
> 2011-06-30 2011-06-30          40465
> 
> 2011-09-30 2011-09-30          41525
> 
> 2011-12-31 2011-12-31          42958
> 
> 2012-03-31 2012-03-31          46775
> 
> ... and even get the same data for historic fiscal years
> 
> > bdh(conn, "FP FP Equity", "SALES_REV_TURN", start_date = "-4fy")
> 
>                  date SALES_REV_TURN
> 
> 2007-12-31 2007-12-31          37697
> 
> 2008-03-31 2008-03-31          39287
> 
> 2008-06-30 2008-06-30          43300
> 
> 2008-09-30 2008-09-30          44039
> 
> 2008-12-31 2008-12-31          33705
> 
> 2009-03-31 2009-03-31          25468
> 
> 2009-06-30 2009-06-30          26574
> 
> 2009-09-30 2009-09-30          28816
> 
> 2009-12-31 2009-12-31          31295
> 
> 2010-03-31 2010-03-31          33161
> 
> 2010-06-30 2010-06-30          36327
> 
> 2010-09-30 2010-09-30          35228
> 
> 2010-12-31 2010-12-31          35760
> 
> 2011-03-31 2011-03-31          41602
> 
> 2011-06-30 2011-06-30          40465
> 
> 2011-09-30 2011-09-30          41525
> 
> 2011-12-30 2011-12-30          42958
> 
> 2012-03-30 2012-03-30          46775
> 
> But when I run the same function for "ENERGY_CONSUMPTION" it returns an empty dataset
> 
> > bdh(conn, "FP FP Equity", "ENERGY_CONSUMPTION", start_date = "20080101")
> 
> [1] date               ENERGY_CONSUMPTION
> 
> <0 rows> (or 0-length row.names)
> 
> 
> > bdh(conn, "FP FP Equity", "ENERGY_CONSUMPTION", start_date = "-4fy")
> 
> [1] date               ENERGY_CONSUMPTION
> 
> <0 rows> (or 0-length row.names)
> 
> The data does exist in Bloomberg as I can use the same function to download the data into Excel and even see it on the Bloomberg terminal.
> 
> Does anyone have any ideas?
> 
> 
> Gordon Morrison
> 
> 
> ______________________________________________________________________
> This e-mail and any attachments may contain confidential...{{dropped:24}}
> 
> _______________________________________________
> R-SIG-Finance@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions should go.
 		 	   		  
	[[alternative HTML version deleted]]

