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

Posted on: 04/12/2022

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

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

Chris Menard will be live on YouTube and Linked showing Sorting Tips in Excel on January 24, 2023.

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

Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds.

TOP 5 Excel Features Released in 2022

Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022.

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

Chris Menard, Microsoft Certified Trainer, will be LIVE on YouTube and LinkedIn on 2-22-2023 at 12:30 pm for Getting Started with PivotTables in Excel.

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