STOCKHISTORY Function In Excel - Episode 2334

У вашего броузера проблема в совместимости с HTML5

An awesome new function from Microsoft 365 debuted this afternoon for the beta channel. Load Daily, Weekly, or Monthly Stock Data into Excel using the new STOCKHISTORY function.
This video discusses the new #BUSY! error in Excel.
Learn about the awesome new FNV - Formatted Number Value and how XLOOKUP, IF, INDEX, and CHOOSE) can lookup a formatted number.
Also - how to do Exchange rates.

Table of Contents
(0:00) New Names for Microsoft 365 and Beta channel
(0:23) STOCKHISTORY function syntax
(0:49) Example using Zoom Video Stock
(1:50) #BUSY! error in Excel
(2:27) Updates a few hours after market close
(3:08) Forcing it to a certain stock exchange
(3:30) Returning historical exchanges rates in Excel
(3:36) NEW! Formatted Number Values (FNV) debut in Excel
(4:20) Need to be on beta channel of Microsoft 365