Get Latest Stock Data in Excel & Create Your Own Stock Portfolio

Easily pull live stock data in Excel with Stock data types.
With Excel's stock data feature you can get live stock information. Stock data types allows users to quickly pull stock information into Excel from various exchanges.

In this tutorial I'll show you how you can pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin into your spreadsheet. This way you can easily calculate your portfolio value directly from within Excel. You'll learn to build your very own stock portfolio in Excel. We'll use Excel tables together with conditional formatting.
With stock data types you can retrieve stock prices, stock volume, 52 week high, 52 week low, shares and a lot more. If the stock data type is showing you an incorrect stock or the wrong exchange, you can easily change it. I'll show you how to in the video.

Note: Excel Stock Data Types are available in Excel for Microsoft 365 and in Excel for the web.

00:00 How To Use Stock Data Types in Excel
04:27 How To Setup a Stock Portfolio in Excel
09:54 Use Conditional Formatting for Stock Portfolio
12:30 How To Setup Language for Stock Data Type

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #stockdata

[deepashankar]

This should be part of a series called 'Excel : Hidden gems in plain sight' . Thanks, as always brilliant!

[safensecure]

I keep getting smarter, every time I watch your videos.
I was talking to a customer about computers at work.
I mentioned I follow your channel.
He replied, "So do I".

[daseaton]

This is absolutely fantastic. I've been teaching my wife Excel and this is the perfect tutorial for managing our stock portfolio and teaching Excel simultaneously. Looking forward to continuing my Excel journey with you in 2021. Happy new year.

[jackfrost]

I just figured this out on my own. I wish I had watched your video first! I love the way you present how-to videos.

[darkshinigami]

Amazing video to finish the year. More videos on Excel finance please

[TylerStanczak]

This is such a helpful tutorial. Especially being an investor myself. Really great vid Leila! :)

[chrism]

This is great, thank you Leila. Have a Happy New Year!

[g.robredo]

Leila, I am subscribed to everything you do, and I can't be happier to have paid for your courses. So much value!!! Thanks

[diegocastanedafiestas]

Been watching you since 2018 and you always got me learning something new, thank you so much!! Cheers from Perú.

[andrewmoss]

It’s great how Microsoft is adding all these new data types to Excel. Certainly saves some leg work.

Happy New Year, Leila, and keep up the great work in 2021 — as you push closer and closer to one million subscribers.

[ablyndon]

Leila, you had me at Electronic Signatures, but this has rocked my world! It’s awesome, thank you!
You should seriously consider doing this kind of thing for a

[kmshlongwane]

Lady from now you going to be my lecture. They never taught me this in school.

[Zues]

Leila, for those of us who use the home version of Excel without the stock datatype, can you point me to a video on how I can import stock data from a website like Yahoo Finance, Google Finance, etc.. I need to import the stock's Sector and Industry. Thank you!

[cliftonsett]

Yet another reason why I love Excel. Great content as usual, always a pleasure to watch and learn from you.

[leksdic]

Can't wait for the rich data types to hit casual users. They seem super useful. Hopefully in 2021!

[dreddnaught]

Was trying to build something like this with API's and Power Query. This is so much simpler. Thank you for all the great tutorials.

[rajsahu]

Realy its a very good work. I have take a complete day to understand this. Its solve alot of problems in data base for correction. very very thanks.

[frannyl]

wow you are amazing. I've been struggling with Office 365 for several days now trying to figure this out. Your explanations are very clear and easy to follow.

[gurmeetsingh-cqbr]

criteria for using this facility is, we have to upgrade to office 365. no other method. Thanks for teaching us marvelously.

[naibahmadzada]

This is great "gift" for a new year.Thank you Leyla. Happy new year 🌺