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.