Auto-Refresh STOCKS in Excel | Pull Live Stock Data in Excel | New Feature

Posted on:  04/12/2022
Auto-Refresh STOCKS in Excel | Pull Live Stock Data in Excel | New Feature

The STOCKS data type in Microsoft Excel required manual refresh until now. A new feature released for Microsoft Excel on Desktop for Windows, Mac as well as Excel on the Web, fixes that problem, by allowing you pull almost live stock data into Excel.

Excel Stock data type Refresh 5 minutes

Stock data type Refresh every 5 minutes

In this video, I show you how to add various STOCKS to your spreadsheet, how to configure which columns you can see (such as price, last trade time, etc.) and also demonstrate how to enable this new feature, to Refresh Stocks quotes every 5 minutes or when you open the worksheet again.

YouTube Video

Chapters

  • 00:00 Introduction
  • 00:43 Add Stocks in Excel Desktop
  • 01:30 Customize columns
  • 02:07 Create table from data
  • 03:17 Refresh options
  • 03:51 Add Stocks in Excel Web
  • 04:29 Closing remarks
Other articles

Stock data type fields

  • 52 week high
  • 52 week low
  • Beta
  • Change
  • Change (%)
  • Currency
  • Description
  • Employees
  • Exchange
  • Exchange abbreviation
  • Headquarters
  • High
  • Industry
  • Instrument type
  • Last trade time
  • Low
  • Market cap Name
  • Official name
  • Open
  • P/E
  • Previous close Price
  • Shares outstanding
  • Ticker symbol Volume
  • Volume average
  • Year incorporated

Recent Excel articles

Excel Sorting Tips with Chris Menard on January 24, 2023

Excel Sorting Tips with Chris Menard on January 24, 2023

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

TOP 5 Excel Features Released in 2022

TOP 5 Excel Features Released in 2022

Getting Started With PivotTables - Live on 2-22-2023

Getting Started With PivotTables - Live on 2-22-2023

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories