HDTutorial
EN
Pull Live Stock Data in Excel | Excel Tutorial

The creator does not allow this video to be played on other websites. You can watch it directly on YouTube.

Pull Live Stock Data in Excel | Excel Tutorial

318,450 views October 28, 2019 5:28

Watch on YouTube
ChannelJie Jenn

Description from the creator

In this tutorial, I will show you how to retrieve LIVE stock information using the Excel Stocks Data feature.

The Excel Stock Data type is a feature available in Microsoft 365 to let users to quickly and easily retrieve stock information from various of exchanges. Currently, these are the categories of data that can be accessed via the Stock Data Type: Stocks, Bonds, Mutual Funds, Currencies, Cryptocurrencies.

Also check out:
-------------------
Getting Historical Stock Data With STOCKHISTORY Function in Excel: youtu.be/Jsewjerul8Y
How to get Live Stock Price in Google Sheets: youtu.be/oTwdQ78cEK8
How to retrieve Historical Stock Price Information in Google Sheets: youtu.be/0tquofL8F7w
How to auto refresh stock price in Google Sheets: youtu.be/wbLskFLYhYI
Pull Live Stock Data in Excel | Excel Tutorial: youtu.be/IaVPXRIhVQI
Create an Excel Macro (using VBA) to automatically refresh stock data: youtu.be/Pm6fApmnOaQ
How to create an Excel Investment Portfolio Tracker Template: youtu.be/I3eXetZ4T0k

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Paypal: paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood.com/jiej6

► Supported Exchanges list
learndataanalysis.org/microsoft-office-365-exce…

► For Office 365 Subscription users, you can now pull real-time stock information directly into Excel. This is a powerful and handy feature if you are constantly copying stock information back to Excel.

► Excel Stock Data Type Documentation
support.office.com/en-us/article/excel-data-typ…

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: patreon.com/JieJenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → facebook.com/MadeInPython/
📘 More tutorial videos on my website → LearnDataAnalysis.org
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: [email protected]

#livestockpriceexcel #stockdata #PullStockPrice

About this tutorial

Jie Jenn published this 5:28 video tutorial on October 28, 2019. It has been watched 318,450 times on YouTube.

Channel
Jie Jenn
Duration
5:28
Published
October 28, 2019
Views
318,450
Likes
2,172

Tags

Share

This tutorial in other languages