Thanks, John, that did the trick!

That error message threw me off, I guess.
(I usually just use the .Net API, where you pass in DateTime objects.)
I was going to look in the documentation for bar or tick, but I can't find it right now - where is it?

Thanks for supporting Rbbg, John - it's major for many of us!
-- David

From: John Laing [mailto:john.laing@gmail.com]
Sent: Tuesday, April 16, 2013 6:16 AM
To: George Wang
Cc: David Reiner; r-sig-finance@r-project.org
Subject: Re: [R-SIG-Finance] Rbbg in R 3.0.0

This isn't an installation problem. If the desktop API weren't installed David's script would be failing on the connection step instead of the data request.

I think it's a simple time formatting thing. Bloomberg is strict about the start/end times it accepts, and Rbbg doesn't do any intelligent conversion of user input (although it probably should). These changes make it work:
start <- "2013-04-15 13:30:00.000"
end <- "2013-04-15 14:00:00.000"

Lastly, the issue isn't specific to R 3.0. The script fails in the same way (and with the same resolution) on 2.15.

HTH,
John

On Tue, Apr 16, 2013 at 6:18 AM, George Wang <grandtiger@gmail.com<mailto:grandtiger@gmail.com>> wrote:
You need to install the Bloomberg desktop API by WAPI<go>.

But there seems to be an issue with the windows api download on Bloomberg side recently. Hope it's resolved now.

Sent from my iPad

On Apr 15, 2013, at 4:58 PM, David Reiner <David.Reiner@xrtrading.com<mailto:David.Reiner@xrtrading.com>> wrote:

> I tried Rbbg in R 3.0.0, but I'm getting a Java-related error I think.
> Hints?
>
>> install.packages("Rbbg", repos="http://r.findata.org/", dependencies = TRUE)
> trying URL 'http://r.findata.org/bin/windows/contrib/3.0/Rbbg_0.4-155.zip'
> Content type 'application/zip' length 41069 bytes (40 Kb)
> opened URL
> downloaded 40 Kb
>
> package 'Rbbg' successfully unpacked and MD5 sums checked
>
> The downloaded binary packages are in
>        C:\Users\davidr\AppData\Local\Temp\RtmpAvhuq1\downloaded_packages
>> require(Rbbg)
> Loading required package: Rbbg
> Loading required package: rJava
>> conn <- blpConnect()
> R version 3.0.0 (2013-04-03)
> rJava Version 0.9-4
> Rbbg Version 0.4-155
> Java environment initialized successfully.
> Looking for most recent blpapi3.jar file...
> Adding C:\blp\API\APIv3\JavaAPI\v3.4.3.2\lib\blpapi3.jar to Java classpath
> Bloomberg API Version 3.4.3.2
>> ticker <- "GOOG US Equity"
>> start <- "2013-04-15 13:30:00" # These are UTC, right?
>> end <- "2013-04-15 14:00:00"
>> interval <- "1"
>> bar(conn, ticker, "BID", start, end, interval)
> Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  :
>  java.lang.ArrayIndexOutOfBoundsException: 6
>> sessionInfo()
> R version 3.0.0 (2013-04-03)
> Platform: i386-w64-mingw32/i386 (32-bit)
>
> locale:
> [1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252    LC_MONETARY=English_United States.1252
> [4] LC_NUMERIC=C                           LC_TIME=English_United States.1252
>
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
>
> other attached packages:
> [1] Rbbg_0.4-155 rJava_0.9-4
>
> loaded via a namespace (and not attached):
> [1] tools_3.0.0
>
> Any help is much appreciated!
> David L. Reiner
> XR Trading LLC
>
>
>
> This e-mail and any materials attached hereto, including, without limitation, all content hereof and thereof (collectively, "XR Content") are confidential and proprietary to XR Trading, LLC ("XR") and/or its affiliates, and are protected by intellectual property laws.  Without the prior written consent of XR, the XR Content may not (i) be disclosed to any third party or (ii) be reproduced or otherwise used by anyone other than current employees of XR or its affiliates, on behalf of XR or its affiliates.
>
> THE XR CONTENT IS PROVIDED AS IS, WITHOUT REPRESENTATIONS OR WARRANTIES OF ANY KIND.  TO THE MAXIMUM EXTENT PERMISSIBLE UNDER APPLICABLE LAW, XR HEREBY DISCLAIMS ANY AND ALL WARRANTIES, EXPRESS AND IMPLIED, RELATING TO THE XR CONTENT, AND NEITHER XR NOR ANY OF ITS AFFILIATES SHALL IN ANY EVENT BE LIABLE FOR ANY DAMAGES OF ANY NATURE WHATSOEVER, INCLUDING, BUT NOT LIMITED TO, DIRECT, INDIRECT, CONSEQUENTIAL, SPECIAL AND PUNITIVE DAMAGES, LOSS OF PROFITS AND TRADING LOSSES, RESULTING FROM ANY PERSON'S USE OR RELIANCE UPON, OR INABILITY TO USE, ANY XR CONTENT, EVEN IF XR IS ADVISED OF THE POSSIBILITY OF SUCH DAMAGES OR IF SUCH DAMAGES WERE FORESEEABLE.
>
> _______________________________________________
> R-SIG-Finance@r-project.org<mailto: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.

_______________________________________________
R-SIG-Finance@r-project.org<mailto: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]]

