Google Answers Logo
View Question
 
Q: Share price quotes in MS Excel ( No Answer,   4 Comments )
Question  
Subject: Share price quotes in MS Excel
Category: Computers
Asked by: ozymandias-ga
List Price: $5.50
Posted: 23 Jun 2005 03:00 PDT
Expires: 23 Jul 2005 03:00 PDT
Question ID: 536224
How can I get free realtime share, unit trust, and fund price quotes
for stock traded on the London Stock Exchange in Microsoft Excel. It
seems to be possible only for U.S. Stock.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Share price quotes in MS Excel
From: saratpediredla-ga on 24 Jun 2005 00:46 PDT
 
ozymandias, the solution might be just to get someone to write a
custom script or program for you to download this information.
Subject: Re: Share price quotes in MS Excel
From: ozymandias-ga on 24 Jun 2005 08:28 PDT
 
Yes, I thought that might be a posibillity. I am not even slightly
sure how to begin doing this though and if anyone could give me some
guidance that would be of help. Could this work be undertaken through
google answers? I recognize that this would recquire more money but am
quite willing to re-post or tip gnerously to encompass that.
Indeed if there is another answer, and I have been too miserly in my
original price (Im a bit new to this!) then I could do likewise. I
guess I just hoped that someone might know straight off from personal
experrience and might be able to share.
Subject: Re: Share price quotes in MS Excel
From: seewright-ga on 24 Jun 2005 15:11 PDT
 
I'm not sure which version of Excel you are using, but I have 2002 and
I found something that may work for you.

* In a new worksheet, click on a cell, then go to Data > Import Data > Web Query.
* This brings up a browser.
* Now plug in this URL to the London Exchange's site:
http://www.londonstockexchange.com/en-gb/pricesnews/prices/system/detailedprices.htm?sym=GB00B01XYM75GBGBXAIM%20B01XYM7MSR
* You'll see a bunch of yellow boxes denoting areas where data can be
pulled. I checked the box next to Bid, Offer, Volume, High, Low and
Last Close.
* Click the Import button on the bottom right of the browser and it
should pull all of that table into your spreadsheet.
* Finally, right click on one of the cells with new data and choose
Data Range Properties.
* Check the box that says "Refresh every " and put in a sufficient refresh rate.

The quotes are delayed of course, but you get what you pay for and
that data is free!
Subject: Re: Share price quotes in MS Excel
From: owenoc-ga on 15 Jul 2005 07:58 PDT
 
If you go to
www.fundies.info
you will find an excel spreadsheet that can be downloaded for the FTSE350
can you tell me how to get US shares download for excel please

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy