![]() |
|
![]() | ||
|
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. |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
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 |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |