[R-SIG-Finance] Question regarding Tick Data

Gandhi, Puneet - RSCH AMRS p.gandhi at baml.com
Tue Jul 27 21:42:27 CEST 2010



I tried multiple things.

This command worked very well
a = tick(conn, "TYA COMDTY", "TRADE", "2010-07-20 07:00:00.000",
"2010-07-20 22:00:00.000" )

But this doesn't include all the data

The excel equivalent which gives all the data I need is 

=BDH($A$1,"TRADE","7/27/2010 9:00:00
AM","","Dir=V","Dts=S","Sort=A","IntrRw=True","CondCodes=H","QRM=S","Exc
hCode=H","BrkrCodes=H","RPSCodes=H","cols=4;rows=20477")

I did some testing and "QRM=S" helps me get this extra data.If I remove
QRM="S" then that data vanishes

Now, I tried
b = tick(conn, "TYA COMDTY", "TRADE", "2010-07-20 07:00:00.000",
"2010-07-20 22:00:00.000",option_names = "includeQRMCodes",
option_values = "TRUE")

b = tick(conn, "TYA COMDTY", "TRADE", "2010-07-20 07:00:00.000",
"2010-07-20 22:00:00.000",option_names = "includeQRM", option_values =
"TRUE")
b = tick(conn, "TYA COMDTY", "TRADE", "2010-07-20 07:00:00.000",
"2010-07-20 22:00:00.000",option_names = "QRM", option_values = "S")
b = tick(conn, "TYA COMDTY", "TRADE", "2010-07-20 07:00:00.000",
"2010-07-20 22:00:00.000",QRM="S" )

None of these work. 

Thanks

-----Original Message-----
From: Brian G. Peterson [mailto:brian at braverock.com] 
Sent: Tuesday, July 27, 2010 11:06 AM
To: Gandhi, Puneet - RSCH AMRS
Subject: Re: [R-SIG-Finance] Question regarding Tick Data

On Tue, 2010-07-27 at 10:50 -0400, Gandhi, Puneet - RSCH AMRS wrote:
> Hi
> 
> I was successfully able to download tick data from Bloomberg using the
> tick command as described in the rbloomberg help manual. But to get
all
> the data I need to pass an option QRM ="S". I saw this option in Excel
> but when I am unable to use it in Rbloomberg.
> This options adds some extra Trade data in the regular Tick data. This
> extra data is missing by default.

Please reply to your *list* posting with a reproducible code example.
What commands did you try?
You said one command worked... what was it?
You said one failed.... what was that?
What happened when you tried it?

-- 
Brian G. Peterson
http://www.braverock.com/brian/
Ph: 773-459-4973
IM: bgpbraverock

----------------------------------------------------------------------
This message w/attachments (message) is intended solely ...{{dropped:7}}



More information about the R-SIG-Finance mailing list