Skip to content

Is there a way to automate Bloomberg?

10 messages · Michael Jungle, Brian G. Peterson, julien cuisinier +2 more

Original
Michael Jungle
# 
Is there a way to automate Bloomberg?
Typing all those same buttons daily is really boring.
Anybody know if I could automate BB?
For example:
Currently I do the following manually:
I use Matlab to generate some of my own price data (write into an Excel
sheet),
and then I use BB's Customized Index Uploader to upload my own price Excel
sheet into BB,
And need to fill a few blanks, click a few buttons, assign a new name, etc.
so I could plot it with other data.
What's the best way to automate the above process?
I don't think BB's own macro can handle ALL of these things, am I right?
I mean, it can do a small portion, by creating a customized button, 
but I want to automate the whole process, including the "Matlab generate
Excel file" part, 
(btw, this also applies to using R to interface with BB, which is the reason
why I post here...)
Thanks!
Brian G. Peterson
#
Michael Jungle wrote:
Please Please PLEASE search before posting.

You have R, with

help.search()

and you have

RSiteSearch()

I assure you that

RSiteSearch('Bloomberg')

would have solved your problem.

and I assume you have Google.

If you can't access Google or RSiteSearch from work, it's not my problem 
or the problem of the people you are leaching time from.  This list has 
a relatively high signal to noise ratio.  I'd like to keep it that way.  
Please do just a little tiny bit of homework before posting.

  - Brian
julien cuisinier
# 
Michael,



I really do not think this is a way you'll get anyone sympathy or help  
on this list.

Several points on your recent messages posted here:

1. you're sending to a R list a message of how to automate a process  
involving BB & Matlab....not a good idea, if you have Matlab you are  
paying the hefty fees that comes with it...hence you have access to  
their customer services which would be much better placed than this  
list to help you.

2. Bear in mind that R is free & that any help you may receive through  
this list is also free & provided by people who have their own job/ 
agenda (i.e. unlike Matlab's support, they are not sitting & paid to  
solve your problems). Hence any question asked should be as concise  
and focused as possible and you should have clearly searched  
beforehand, which was far from obvious from your recent posts...

3. Everyone on this list has a limited time capital to spend asking  
questions and not posting properly (I will not pretend it never  
happened to me...), you've been clearly dilapidating this capital of  
late. People are not there to solve your prbls and spare you some  
time, rather to try helping you on a voluntary basis if you're facing  
a blocking point in your research / development. Asking people to  
solve your Bloomberg process for uploading from Excel is none of this  
list problem. Again if you have bloomberg station you have access to  
their customer support which should be the people to answer your  
question.

4. Reacting the way you did below will definitely alienate you most of  
this list participants. You would have made some research into the   
previous posts, you would have seen Brian is quite an intensive  
contributor and often provides helpful guidance when it is properly  
asked. Again this is a free help, so you have to adapt to it no the  
other way around.

5. "if you don't add value to the discussion" >> which discussion?


Sorry for this direct tone, but as Brian said this list has a quite  
interesting high signal to noise ratio which makes all its value.
Thank you for your collaboration in keeping it this way.


Rgds,
Julien
On Feb 24, 2010, at 4:44 PM, Michael Jungle wrote:

            

      
      
      
    

        

      
      
    

  
  


  


      

    

    

      
      

        
      

    

    

      
      

        


  

        

      Robert for Groups
    

    

      
      #
    

  


  

      
Michael,

you should have asked for a tool automating not bloomberg or R but windows?

I would suggest you look at http://www.autohotkey.com/

It's a little tricky at the beginning - but it can really automate
everything: Cross applications, mouseinput, keyinput, variables,
systemcalls, etc ...

Cheers,

Robert

  
    

      
      
    

  


  


      

    

    
1 day later

    

      
      

        
      

    

    

      
      

        


  

        

      Michael Jungle
    

    

      
      #
    

  


  

      
My goodness - you spent such a great deal of energy bashing me on a public
forum?
How much bandwidth/time you are wasting of all other people?
------------
I asked a question - how to automate BB from R/Matlab. Notice, it's not
about "importing data".
I am sure this is of interest to many other fellow R users. 
But you came back with an extremely length bashing?