Linking a bloomberg or reuters graph (Excel 2002)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

The Graphs would come from reuters.

Reply | Quote

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%5B/url%5D or
http://images.bloomberg.com/banner/ilba.png%5B/url%5D 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%5B/url%5D

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.

Reply | Quote