+ Reply to Thread
Results 1 to 3 of 3

Excel 365: Stock Quote

  1. #1
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    408

    Excel 365: Stock Quote

    https://support.microsoft.com/en-us/...0-623cf07fbc54

    I did exactly as the above link shows (today). For stock price, I know it is not live quote, there is delay. For Google sheet, there is also delay. Delay (20 minutes or 30 minutes) is not an issue for me.

    But the issue for excel is: it seems the data will not update unless you manually click Refresh button. For google sheet, I guess there is no such issue (no refresh is needed).

    Question: Is it true that stock price will not automatically updated? Or is there any setting I can do to fix it?

    Thanks.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,431

    Re: Excel 365: Stock Quote

    Look at this link. https://www.michael-saunders.com/sto...ages/info.html

    Then set the Connections to refresh every x minutes. The Connections is on the Data Tab

  3. #3
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    408

    Re: Excel 365: Stock Quote

    Quote Originally Posted by alansidman View Post
    Look at this link. https://www.michael-saunders.com/sto...ages/info.html

    Then set the Connections to refresh every x minutes. The Connections is on the Data Tab
    Thanks for the information.

+ 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. Excel 2003 Any way to get real time stock quote
    By sumdumgai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2020, 04:40 PM
  2. [SOLVED] Use of Microsoft Stock Quote and et cetera information on a stock
    By zyzzyva57 in forum Excel General
    Replies: 3
    Last Post: 08-19-2019, 02:10 PM
  3. Automatic Stock Quote Updates with Excel
    By NewJerichoMan in forum Excel General
    Replies: 5
    Last Post: 07-02-2016, 10:45 PM
  4. Excel Stock quote Help
    By PadawanLearner in forum Excel General
    Replies: 0
    Last Post: 06-23-2012, 05:05 PM
  5. stock quote lookup query for Excel 2000
    By cyclist4444 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-04-2006, 02:20 PM
  6. Adding Stock Quote to EXCEL
    By JasonSB in forum Excel General
    Replies: 0
    Last Post: 06-22-2005, 04:05 PM
  7. [SOLVED] How do I get a stock quote updated automatically in excel 2000?
    By PBXGuy in forum Excel General
    Replies: 0
    Last Post: 04-20-2005, 06: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