Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking a bloomberg or reuters graph (Excel 2002)

    Does anyone know if it would be possible to link a reuter or bloomberg graph into an excel sheet so that when you click on a link it would bring up the graphs...if so how could this be done

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linking a bloomberg or reuters graph (Excel 2002)

    Where do you get the graphs from?

    If they are on a website, you may need to link to the underlying data and make your own chart.

    Steve

  3. #3
    New Lounger
    Join Date
    Aug 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking a bloomberg or reuters graph (Excel 2002)

    The Graphs would come from reuters.

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking a bloomberg or reuters graph (Excel 2002)

    I'm not clear exactly what you're asking. Here's my interpretation - you'd like to put a link in your spreadsheet that will take you to a graph on the web. If that's what you want, Here's how to do that.

    For Bloomberg - it depends whether you have a dedicated Bloomberg terminal or you're using their website, you can right click on the graph and copy image location. For example http://www.bloomberg.com/apps/chart?h=152&...l&ticks=SPX:IND or
    http://images.bloomberg.com/banner/ilba.png shows you the S&P or the front page graph respectively. If you are using a dedicated terminal, then you have to use the proprietary API to download data.

    I don't know how reuters is set up, but on their website you can do something similar, however they aren't formatted quite as well. For example, the S&P chart link doesn't have labels. See http://www.reuters.com/charts/us_spx122425...-1002072731.gif

    If you want to have a graph in your spreadsheet that updates with the most current data, that's a tougher programming problem. You'll need to be able to download the data and update it automatically. I've been trying to do that for a while (not successfully). Here's my general outline of how I would go about getting an updated graph of the S&P 500. I wouldn't use Bloomberg or Reuter's data unless they have something that will automatically download the data for you. (Of course, there are much smarter people than I who could figure out a way to do it.)

    1. Use the MSN Stock Quotes Add-in. Download here .
    2. Download stock prices or index values that you want.
    3. Create a macro to automate the process.

    Seems simple, but I haven't devoted the time or energy to get step 3 finished.

    If someone can come up with something, I'd appreciate it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •