Tags: automatically, bloomberg, connect, download, excel, links, microsoft, msdn, software, spreadsheet

Bloomberg links

On Microsoft » Microsoft Excel

19,268 words with 8 Comments; publish: Fri, 23 May 2008 02:42:00 GMT; (30662.50, « »)

Does anyone know of a good site where I can find info on how to connect

Bloomberg to an Excel spreadsheet? I want to download some data automatically

(like once every day) to a spreadsheet and then if possible connect that

spreadsheet to other spreadsheets. If anyone has any link tips (or direct

tips) please help me! Thank you!

All Comments

Leave a comment...

  • 8 Comments
    • If you are referring to the Bloomberg.com website as your source you can

      click on "Data/Import External Data/New Web Query" and choose the webpage and

      portion thereof to link to. That's better than paying the fee for direct

      links to Bloomberg which requires a dedicated pc with double=screens.

      Jim

      "Viktor Ygdorff" wrote:

      > Does anyone know of a good site where I can find info on how to connect

      > Bloomberg to an Excel spreadsheet? I want to download some data automatically

      > (like once every day) to a spreadsheet and then if possible connect that

      > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > tips) please help me! Thank you!

      #1; Fri, 23 May 2008 02:44:00 GMT
    • more detail and the url involved. At the website, have you tried a right

      click>import to microsoft file?

      --

      Don Guillett

      SalesAid Software

      dguillett1.excel.questionfor.info.austin.rr.com

      "Viktor Ygdorff" <ViktorYgdorff.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:76269F12-FFFF-4BCE-A39F-29F05A3E3F71.excel.questionfor.info.microsoft.com...

      > Does anyone know of a good site where I can find info on how to connect

      > Bloomberg to an Excel spreadsheet? I want to download some data

      > automatically

      > (like once every day) to a spreadsheet and then if possible connect that

      > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > tips) please help me! Thank you!

      #2; Fri, 23 May 2008 02:45:00 GMT
    • Well at my company we have a proper bloomberg connection and terminal so that

      is the bloomberg I am referring to. Thanks anyway!!

      "Jim Jackson" skrev:

      > If you are referring to the Bloomberg.com website as your source you can

      > click on "Data/Import External Data/New Web Query" and choose the webpage and

      > portion thereof to link to. That's better than paying the fee for direct

      > links to Bloomberg which requires a dedicated pc with double=screens.

      > Jim

      > "Viktor Ygdorff" wrote:

      > > Does anyone know of a good site where I can find info on how to connect

      > > Bloomberg to an Excel spreadsheet? I want to download some data automatically

      > > (like once every day) to a spreadsheet and then if possible connect that

      > > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > > tips) please help me! Thank you!

      #3; Fri, 23 May 2008 02:46:00 GMT
    • Well at my company we have a proper bloomberg connection and terminal so that

      is the bloomberg I am referring to. I would like to export data automaticaly

      from a bllomberg terminal onto a spreadsheet. The website does not do it

      since it is not in real time and does not have all the stuff that the

      terminal has.Thanks anyway!!

      "Don Guillett" skrev:

      > more detail and the url involved. At the website, have you tried a right

      > click>import to microsoft file?

      > --

      > Don Guillett

      > SalesAid Software

      > dguillett1.excel.questionfor.info.austin.rr.com

      > "Viktor Ygdorff" <ViktorYgdorff.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > news:76269F12-FFFF-4BCE-A39F-29F05A3E3F71.excel.questionfor.info.microsoft.com...

      > > Does anyone know of a good site where I can find info on how to connect

      > > Bloomberg to an Excel spreadsheet? I want to download some data

      > > automatically

      > > (like once every day) to a spreadsheet and then if possible connect that

      > > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > > tips) please help me! Thank you!

      >

      >

      #4; Fri, 23 May 2008 02:47:00 GMT
    • Hi Viktor,

      Do you want to use DDE, RTD or the Active X control? How many instruments

      are you looking at and how many data fields per instrument?

      You cannot actually put this on a remote server and there are data license

      issues - you should be aware of these before proceeding. If you put some

      answers on here then I'll reply with an answer shortly.

      John

      www.alignment-systems.com

      "Viktor Ygdorff" wrote:

      > Well at my company we have a proper bloomberg connection and terminal so that

      > is the bloomberg I am referring to. I would like to export data automaticaly

      > from a bllomberg terminal onto a spreadsheet. The website does not do it

      > since it is not in real time and does not have all the stuff that the

      > terminal has.Thanks anyway!!

      > "Don Guillett" skrev:

      > > more detail and the url involved. At the website, have you tried a right

      > > click>import to microsoft file?

      > >

      > > --

      > > Don Guillett

      > > SalesAid Software

      > > dguillett1.excel.questionfor.info.austin.rr.com

      > > "Viktor Ygdorff" <ViktorYgdorff.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > > news:76269F12-FFFF-4BCE-A39F-29F05A3E3F71.excel.questionfor.info.microsoft.com...

      > > > Does anyone know of a good site where I can find info on how to connect

      > > > Bloomberg to an Excel spreadsheet? I want to download some data

      > > > automatically

      > > > (like once every day) to a spreadsheet and then if possible connect that

      > > > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > > > tips) please help me! Thank you!

      > >

      > >

      > >

      #5; Fri, 23 May 2008 02:48:00 GMT
    • Thank you for your answer John! As my parsimonious presentation of my problem

      might have revealed I am no close acquantance to neither Bloomberg nor Excel

      VBA. Thus, the aswer to your question is that any method that does is fine

      for me...Is there an easy and a hard way to do it or what are the differences

      between e.g. DDE and Active X? I thought about the licence issue too and you

      night be right there... I am sorry but I cannot give more info at the moment

      since I have not yet looked into the problem. Perhaps you can help me some

      general questions and then I will dig into the sunject myself?

      1) How hard is this task to do? Might be hard to say but is it doable for

      someone with "ordinary" computer skills?

      2)Do you know any good books, links etc about connecting Bloomberg to Excel

      (automatic connection)

      Thank you very much for your help John. I know I have not been very specific

      but I dwell in ignorance too here..

      "John.Greenan" skrev:

      > Hi Viktor,

      > Do you want to use DDE, RTD or the Active X control? How many instruments

      > are you looking at and how many data fields per instrument?

      > You cannot actually put this on a remote server and there are data license

      > issues - you should be aware of these before proceeding. If you put some

      > answers on here then I'll reply with an answer shortly.

      > John

      >

      > --

      > www.alignment-systems.com

      >

      > "Viktor Ygdorff" wrote:

      > > Well at my company we have a proper bloomberg connection and terminal so that

      > > is the bloomberg I am referring to. I would like to export data automaticaly

      > > from a bllomberg terminal onto a spreadsheet. The website does not do it

      > > since it is not in real time and does not have all the stuff that the

      > > terminal has.Thanks anyway!!

      > > "Don Guillett" skrev:

      > >

      > > > more detail and the url involved. At the website, have you tried a right

      > > > click>import to microsoft file?

      > > >

      > > > --

      > > > Don Guillett

      > > > SalesAid Software

      > > > dguillett1.excel.questionfor.info.austin.rr.com

      > > > "Viktor Ygdorff" <ViktorYgdorff.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > > > news:76269F12-FFFF-4BCE-A39F-29F05A3E3F71.excel.questionfor.info.microsoft.com...

      > > > > Does anyone know of a good site where I can find info on how to connect

      > > > > Bloomberg to an Excel spreadsheet? I want to download some data

      > > > > automatically

      > > > > (like once every day) to a spreadsheet and then if possible connect that

      > > > > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > > > > tips) please help me! Thank you!

      > > >

      > > >

      > > >

      #6; Fri, 23 May 2008 02:49:00 GMT
    • Hi Viktor,

      "I dwell in ignorance". That's not a bad state to be in, all of us are in

      the gutter, but some of us are looking at the stars...

      OK, so, this is not a terrifically difficult thing to do. If you are not a

      programmer then ignore the ActiveX control - it's a bit trickier to use. If

      you use Excel 2002 or above the use RTD, 2000 and below then use DDE. Note

      that DDE is a damn awful technology - avoid at all costs. RTD is much better.

      General questions to find answers for:

      How many instruments?

      Will the instruments change from day to day?

      How many data fields per instrument?

      You can see some examples of this in the bloomberg directory - it's going to

      be something like c:\blp\dde\examples. There is also an online help - WAPI

      <go> from your bloomberg page.

      Finally, try asking your bloomberg account manager for some help on this.

      Your firm will be paying about $1500 per machine per bloomberg, so those guys

      should be willing to help you out on this. And if your Bloomberg account

      manager won't help, call your bloomberg sales guy and tell him you are moving

      to Reuters Kobra as the Reuters helpdesk is better (by the way, that's true -

      the reuters helpdesk is a heck of a lot better than bloomberg, the default

      blomberg answer is basically that you are a dummy and they cannot help -

      first line help are useless).

      Have a go with that and post back if you get stuck.

      www.alignment-systems.com

      "Viktor Ygdorff" wrote:

      > Thank you for your answer John! As my parsimonious presentation of my problem

      > might have revealed I am no close acquantance to neither Bloomberg nor Excel

      > VBA. Thus, the aswer to your question is that any method that does is fine

      > for me...Is there an easy and a hard way to do it or what are the differences

      > between e.g. DDE and Active X? I thought about the licence issue too and you

      > night be right there... I am sorry but I cannot give more info at the moment

      > since I have not yet looked into the problem. Perhaps you can help me some

      > general questions and then I will dig into the sunject myself?

      > 1) How hard is this task to do? Might be hard to say but is it doable for

      > someone with "ordinary" computer skills?

      > 2)Do you know any good books, links etc about connecting Bloomberg to Excel

      > (automatic connection)

      > Thank you very much for your help John. I know I have not been very specific

      > but I dwell in ignorance too here..

      > "John.Greenan" skrev:

      > > Hi Viktor,

      > >

      > > Do you want to use DDE, RTD or the Active X control? How many instruments

      > > are you looking at and how many data fields per instrument?

      > >

      > > You cannot actually put this on a remote server and there are data license

      > > issues - you should be aware of these before proceeding. If you put some

      > > answers on here then I'll reply with an answer shortly.

      > >

      > > John

      > >

      > >

      > >

      > > --

      > > www.alignment-systems.com

      > >

      > >

      > > "Viktor Ygdorff" wrote:

      > >

      > > > Well at my company we have a proper bloomberg connection and terminal so that

      > > > is the bloomberg I am referring to. I would like to export data automaticaly

      > > > from a bllomberg terminal onto a spreadsheet. The website does not do it

      > > > since it is not in real time and does not have all the stuff that the

      > > > terminal has.Thanks anyway!!

      > > > "Don Guillett" skrev:

      > > >

      > > > > more detail and the url involved. At the website, have you tried a right

      > > > > click>import to microsoft file?

      > > > >

      > > > > --

      > > > > Don Guillett

      > > > > SalesAid Software

      > > > > dguillett1.excel.questionfor.info.austin.rr.com

      > > > > "Viktor Ygdorff" <ViktorYgdorff.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > > > > news:76269F12-FFFF-4BCE-A39F-29F05A3E3F71.excel.questionfor.info.microsoft.com...

      > > > > > Does anyone know of a good site where I can find info on how to connect

      > > > > > Bloomberg to an Excel spreadsheet? I want to download some data

      > > > > > automatically

      > > > > > (like once every day) to a spreadsheet and then if possible connect that

      > > > > > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > > > > > tips) please help me! Thank you!

      > > > >

      > > > >

      > > > >

      #7; Fri, 23 May 2008 02:50:00 GMT
    • Hi guys,

      Very useful and interesting discussion. I have a similar problem and almost

      no experience in working with bloomberg.

      For me there is a huge list of companies and missing financial indicators,

      which have to be taken from Bloomberg automatically, but have no idea how to

      do this.

      Probably , there is a simple task once you are experienced in using B.

      Maybe you know some links where I could find examples how to do this?

      Thanx in advance

      "John.Greenan" wrote:

      > Hi Viktor,

      > "I dwell in ignorance". That's not a bad state to be in, all of us are in

      > the gutter, but some of us are looking at the stars...

      > OK, so, this is not a terrifically difficult thing to do. If you are not a

      > programmer then ignore the ActiveX control - it's a bit trickier to use. If

      > you use Excel 2002 or above the use RTD, 2000 and below then use DDE. Note

      > that DDE is a damn awful technology - avoid at all costs. RTD is much better.

      > General questions to find answers for:

      > How many instruments?

      > Will the instruments change from day to day?

      > How many data fields per instrument?

      >

      > You can see some examples of this in the bloomberg directory - it's going to

      > be something like c:\blp\dde\examples. There is also an online help - WAPI

      > <go> from your bloomberg page.

      > Finally, try asking your bloomberg account manager for some help on this.

      > Your firm will be paying about $1500 per machine per bloomberg, so those guys

      > should be willing to help you out on this. And if your Bloomberg account

      > manager won't help, call your bloomberg sales guy and tell him you are moving

      > to Reuters Kobra as the Reuters helpdesk is better (by the way, that's true -

      > the reuters helpdesk is a heck of a lot better than bloomberg, the default

      > blomberg answer is basically that you are a dummy and they cannot help -

      > first line help are useless).

      > Have a go with that and post back if you get stuck.

      >

      >

      > --

      > www.alignment-systems.com

      >

      > "Viktor Ygdorff" wrote:

      > > Thank you for your answer John! As my parsimonious presentation of my problem

      > > might have revealed I am no close acquantance to neither Bloomberg nor Excel

      > > VBA. Thus, the aswer to your question is that any method that does is fine

      > > for me...Is there an easy and a hard way to do it or what are the differences

      > > between e.g. DDE and Active X? I thought about the licence issue too and you

      > > night be right there... I am sorry but I cannot give more info at the moment

      > > since I have not yet looked into the problem. Perhaps you can help me some

      > > general questions and then I will dig into the sunject myself?

      > >

      > > 1) How hard is this task to do? Might be hard to say but is it doable for

      > > someone with "ordinary" computer skills?

      > > 2)Do you know any good books, links etc about connecting Bloomberg to Excel

      > > (automatic connection)

      > >

      > > Thank you very much for your help John. I know I have not been very specific

      > > but I dwell in ignorance too here..

      > >

      > > "John.Greenan" skrev:

      > >

      > > > Hi Viktor,

      > > >

      > > > Do you want to use DDE, RTD or the Active X control? How many instruments

      > > > are you looking at and how many data fields per instrument?

      > > >

      > > > You cannot actually put this on a remote server and there are data license

      > > > issues - you should be aware of these before proceeding. If you put some

      > > > answers on here then I'll reply with an answer shortly.

      > > >

      > > > John

      > > >

      > > >

      > > >

      > > > --

      > > > www.alignment-systems.com

      > > >

      > > >

      > > > "Viktor Ygdorff" wrote:

      > > >

      > > > > Well at my company we have a proper bloomberg connection and terminal so that

      > > > > is the bloomberg I am referring to. I would like to export data automaticaly

      > > > > from a bllomberg terminal onto a spreadsheet. The website does not do it

      > > > > since it is not in real time and does not have all the stuff that the

      > > > > terminal has.Thanks anyway!!

      > > > > "Don Guillett" skrev:

      > > > >

      > > > > > more detail and the url involved. At the website, have you tried a right

      > > > > > click>import to microsoft file?

      > > > > >

      > > > > > --

      > > > > > Don Guillett

      > > > > > SalesAid Software

      > > > > > dguillett1.excel.questionfor.info.austin.rr.com

      > > > > > "Viktor Ygdorff" <ViktorYgdorff.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > > > > > news:76269F12-FFFF-4BCE-A39F-29F05A3E3F71.excel.questionfor.info.microsoft.com...

      > > > > > > Does anyone know of a good site where I can find info on how to connect

      > > > > > > Bloomberg to an Excel spreadsheet? I want to download some data

      > > > > > > automatically

      > > > > > > (like once every day) to a spreadsheet and then if possible connect that

      > > > > > > spreadsheet to other spreadsheets. If anyone has any link tips (or direct

      > > > > > > tips) please help me! Thank you!

      > > > > >

      > > > > >

      > > > > >

      #8; Fri, 23 May 2008 02:51:00 GMT