+ Reply to Thread
Results 1 to 3 of 3

UK Stock Prices

Hybrid View

RWJ UK Stock Prices 08-11-2017, 06:00 AM
AB33 Re: UK Stock Prices 08-11-2017, 07:16 AM
RWJ Re: UK Stock Prices 08-11-2017, 12:10 PM
  1. #1
    Registered User
    Join Date
    08-10-2007
    Posts
    15

    UK Stock Prices

    Hi

    I have read a number of threads on this but still cannot work it out. I have been using the following =NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&D1&"&f=l1")) where D1 is the EPIC (with ".L" added) to get live stock quotes, and now it doesn't work. I am assuming that Yahoo have closed down this service. So, can anyone help ?

    Cheers

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: UK Stock Prices

    There are a number of threads on this topic. In fact, I have commented on some of them. You get mixed views if Yahoo has closed down the API. Some people say, yes, and they now have shifted to Google which seems to work fine. Just search this site and see if you make any progress.
    Last edited by AB33; 08-11-2017 at 11:40 AM.

  3. #3
    Registered User
    Join Date
    08-10-2007
    Posts
    15

    Re: UK Stock Prices

    Thanks for that. Have found a solution, using both Google and Yahoo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pull Stock Prices with VBA
    By xavior1325 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2017, 11:10 AM
  2. Trying to build Function to calculate average of stock returns, with stock prices as input
    By jameslaughlin129 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2017, 05:18 PM
  3. Stock prices - how to insert?
    By Heiserman in forum Excel General
    Replies: 2
    Last Post: 09-08-2012, 12:32 PM
  4. Stock Prices import
    By roger00782006 in forum Excel General
    Replies: 9
    Last Post: 12-09-2010, 11:23 AM
  5. Importing AUS stock prices
    By oldpos in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2008, 07:56 AM
  6. Updating Stock Prices
    By cheshajim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2007, 07:51 AM
  7. historical stock prices
    By Stevo in forum Excel General
    Replies: 1
    Last Post: 01-24-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1