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.morri...@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]]
_______________________________________________
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.
