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.
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.
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
#msexcel #personalfinance #chrismenardtraining #microsoftexcel
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
#excel #msexcel #chrismenard
