Is it possible to fetch Bloomberg data using Q? If so, can you give asimple example such at to get the close price of Google?Thanks!
compiled for win32:
http://kx.com/q/w32/bb.dll
=A0 Attila
Hi Attila,Thanks for the reply.How to use that dll? Can you please give an example?On Nov 9, 11:00?pm, Attila Vrabecz <attila.vrab…> wrote:> http://kx.com/q/c/feed/bb.c>> compiled for win32:http://kx.com/q/w32/bb.dll> ? Attila>>>>>>>> On Wed, Nov 9, 2011 at 5:19 AM, Wei Li <lavi…> wrote:>> > ?Is it possible to fetch Bloomberg data using Q? If so, can you give a> > simple example such at to get the close price of Google?> > Thanks!>> > –> >
Submitted via Google Groups</lavi…></attila.vrab…>
http://code.kx.com/wiki/Reference/TwoColon
Appreciate, no one yet mention you to first use search on kx wiki.
;-)
Thanks guys for the reply.As a beginner of q, I do not know how to run the examples above. Itried>q tick/bb.q localhost:1234but failed. I copied bbq to c:\q\tick\Can you please give more details such as do I need to download someother files from http://kx.com/q/tick or other sites? and put them inwhich directory? My q is in C:\qAnd can you please also provide the commands to run bb.q and theexample to query a stock close price from BBG? does it depend on otherfiles?I think other beginners may have the same question as me and a fullinstruction will be very helpful.Thanks a lotOn Nov 10, 6:32?pm, Charles Skelton <char…> wrote:> http://kx.com/q/tick/bb.qhttp://kx.com/q/tick/bb.txt>>>>>>>> On Thu, Nov 10, 2011 at 6:37 AM, Wei Li <lavi…> wrote:> > Hi Attila,> > Thanks for the reply.> > How to use that dll? Can you please give an example?>> > On Nov 9, 11:00 pm, Attila Vrabecz <attila.vrab…> wrote:> > >http://kx.com/q/c/feed/bb.c>> > > compiled for win32:http://kx.com/q/w32/bb.dll> > > ? Attila>> > > On Wed, Nov 9, 2011 at 5:19 AM, Wei Li <lavi…> wrote:>> > > > ?Is it possible to fetch Bloomberg data using Q? If so, can you give a> > > > simple example such at to get the close price of Google?> > > > Thanks!>> > > > –> > > > You received this message because you are subscribed to the Google> > Groups “Kdb+ Personal Developers” group.> > > > To post to this group, send email to personal-kdbplus@googlegroups.com> > .> > > > To unsubscribe from this group, send email to> > personal-kdbplus+unsubscribe@googlegroups.com.> > > > For more options, visit this group athttp://> > groups.google.com/group/personal-kdbplus?hl=en.>> > –> >
Submitted via Google Groups</lavi…></attila.vrab…></lavi…></char…>
To: personal-kdbplus@googlegroups.comX-Mailer: Apple Mail (2.1084)On Nov 9, 2011, at 5:19 AM, Wei Li wrote:> Is it possible to fetch Bloomberg data using Q? If so, can you give a> simple example such at to get the close price of Google?do you have a bb subscription?
Yes, I haveOn Nov 12, 10:23?am, Aaron Davies <aaron.dav…> wrote:> On Nov 9, 2011, at 5:19 AM, Wei Li wrote:>> > Is it possible to fetch Bloomberg data using Q? If so, can you give a> > simple example such at to get the close price of Google?>> do you have a bb subscription?</aaron.dav…>
Any more advise on this?On Nov 12, 3:14?pm, Wei Li <lavi…> wrote:> Yes, I have>> On Nov 12, 10:23?am, Aaron Davies <aaron.dav…> wrote:>>>>>>>> > On Nov 9, 2011, at 5:19 AM, Wei Li wrote:>> > > Is it possible to fetch Bloomberg data using Q? If so, can you give a> > > simple example such at to get the close price of Google?>> > do you have a bb subscription?</aaron.dav…></lavi…>
To: personal-kdbplus@googlegroups.com
X-Mailer: Apple Mail (2.1084)
>>> Is it possible to fetch Bloomberg data using Q? If so, can you give =
a simple example such at to get the close price of Google?
>>
>> do you have a bb subscription?
>
> Any more advise on this?
what’s your actual problem?
(btw i’ve never used bb w/q myself, only reuters, and that was quite a =
while ago)=
My actual problem as listed above is how to fetch BBG data in q?On Nov 15, 11:55?am, Aaron Davies <aaron.dav…> wrote:> >>> Is it possible to fetch Bloomberg data using Q? If so, can you give a simple example such at to get the close price of Google?>> >> do you have a bb subscription?>> > Any more advise on this?>> what’s your actual problem?>> (btw i’ve never used bb w/q myself, only reuters, and that was quite a while ago)</aaron.dav…>
you need access to a bloomberg terminal of a data server first.
once you have that, you can start playing with the data.
so, do you have any of the above?
2011/11/15 Wei Li :
> My actual problem as listed above is how to fetch BBG data in q?
>
> On Nov 15, 11:55=A0am, Aaron Davies <aaron.dav…> wrote:
>> >>> Is it possible to fetch Bloomberg data using Q? If so, can you give =
a simple example such at to get the close price of Google?
>>
>> >> do you have a bb subscription?
>>
>> > Any more advise on this?
>>
>> what’s your actual problem?
>>
>> (btw i’ve never used bb w/q myself, only reuters, and that was quite a w=
hile ago)
>
> –
>
Submitted via Google Groups</aaron.dav…>
Aaron Daviesdo you have a bb subscription?Wei LiYes, I have--------------------------------------------------------------------------------As Aaron asked and I replied, YES I HAVE!
hi wei,
can you run this?
sub:bb 2:(sub;`sym)
with bb.dll ?
ta, jack.
Hi Guys,
I have access to Bloomberg, but i still cannot retrieve Data using Q.
Could you please describe the steps for an absolute beginner? (Step 1,
Step 2, Step 3…etc)
I have saved the bb.dll file in C:\WINDOWS\system32 and tried to run
it by regsvr32 bb.dll.
I get the following error message - LoadLibrary(“bb.dll”) failed -
The specific module could not be found.
Thanks in advance!
GarryHolmer
1 ? ensure you have bbapi.dll in your path (should be included in your bb client)
2 ? put bb.dll in %QHOME%/w32 (eg: c:\q\w32) or c:\windows\system32
3 ? start q
4 ??q)sub:bb 2:(sub;1)
5 ? q)sub x
i don’t have bb access, so i can’t ?test this. ?the x on the last line is a symbol. ?i assume it is something like `C:US . ?
also, i think sub registers a callback so it handles data coming down the line in the event loop. ?i haven’t looked close enough to tell you where bb.dll puts the incoming data. ?and i haven’t used callbacks before, so i’m doubly blind :j
i suspect you may need to define q functions mon, stt and upd to handle the data as q receives it. ?
could be a good article to put on the wiki once we work out how to do it!
Hi Jack,
Thank you very much for your detailed answer! it helped me to get
started.
an article on wiki sounds like a great idea. I am sure that there are
many people around who would benefit from such article.
what is, for example, missing is how to get close prices or other
information from Bloomberg.
Does anybody know how to build such functions in order to get closing
prices from Bloomberg? It is still, unfortunately, a black box for
me.
Harry Holmer