How to Use the STOCKHISTORY Function in Excel 📈

The Stock History function in Excel allow you to easily pull historical stock data into Excel.
Easily pulling stock data into Excel has been one of the most requested features. With the brand new STOCKHISTORY function this is now possible. It fills the gaps in the Stocks data type by providing access to historical data.

Here's what you'll explore:
STOCKHISTORY Function Explained: Learn about this new Excel function that fetches historical stock information, including daily, weekly, and monthly data.

Creating Comprehensive Reports: Discover how to twist this simple function to create visually appealing reports showcasing trends for multiple stocks at a glance.

Setting Up STOCKHISTORY: Understand the prerequisites, including Excel version requirements and supported exchanges.

Function Parameters and Customization: Get to grips with different parameters like start and end dates, intervals, and what data points (like high, low, volume) you can retrieve.

Dynamic Dates for Flexibility: See how using dynamic dates with functions like TODAY and EDATE enhances the flexibility and accuracy of your stock analysis.

Visualizing Trends with Sparklines: Learn how to insert sparklines to visualize stock trends directly within your Excel cells.

STOCKHISTORY is available to Microsoft 365 Subscribers.

00:00 How to Get Historic Stock and Currency Information in Excel
01:08 How to Use STOCKHISTORY in Excel
05:15 How to Use Dynamic Dates with STOCKHISTORY in Excel
08:04 How to Prepare History Stock Data for Multiple Stocks in Excel
12:26 How to Use Sparklines to Visualize Trends with STOCKHISTORY in Excel
14:12 Sponsor AlchemyJ

🚩Let’s connect on social:

This video is sponsored by AlchemyJ

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

[LeilaGharani]

Stockhistory is now available to all Office 365 subscribers!

[OldDogNewTrick]

Just found this recently, and I am excited about trying out some of these features myself. Never too old (81 years old now) to learn another new trick. Thank you so much.

[AdvantageWealth]

as a 30+ year excel user, I am humbled with your knowledge and new ideas. Thank you very much!

[vijayarjunwadkar]

Leila is always adding to our knowledge "STOCK" and creating "HISTORY" with her unique teaching style and long list of videos on practically everything needed in office work! Glad to watch this neat video, thank you! 😊👍👏

[ManojKumar-skfw]

I was desperately looking for this function in excel. Thank you very much. Very informative

[sean]

Fantastic! Never in a million years could I have figured this out without your video

[RichErmlick]

Leila, you are an amazing teacher with deep knowledge, awesome content, and a wonderful style of presenting things quickly and cleanly. Well done and Big Kudos on the success of your brand!

[robertbyers]

Fabulous, I'm looking forward to STOCKHISTORY appearing in the main Excel release channel. Thank you for the walkthrough!

[upendrasharma]

Not sure how do you know most Indians are appreciating your work. Just noticed you highlighted India is covered like emerging market, emerging investors in India. :)

[chidieberenjoku]

This has made me grown one more bit today, many thanks Leila

[dl]

Leila is the crush of all Geeks! Love you and your work! 😍

[jesusaltamiranoagente]

I learn a lot of excel with you and also an excellent English pronunciation, 2x1. Muchas Gracias

[PierreFromCanada]

I've followed your channel for about a year now. I've learned so much. Thanks.

[denconstutube]

Excellent! I have been using the Stock function from the time you posted your video on the function, and it has been perfect. Obviously, this function is so much better. I will start it today. Thank you again for all of your great videos.

[rays]

Hi Leila, Thank you for sharing your knowledge! You do an excellent job at explaining Excel and make it easy.

[SavageGothamChess]

This video is super useful. I think you will have to put up a question and answer session for your viewers.

[mehranhourmozdi]

Found this and am excited to use the features. Thank you for your education.

[ManojKumar-skfw]

Thank you for mentioning INDIA is included in the covered exchanges

[mariamnassar]

You are amazing teacher with mastery very impressive!

[yoliedepaz]

Excellent, Leila! As always, you’re a big help for me. Thanks a lot and more power to you. Stay safe, God bless you! I did not skip the ads, grateful meh here! 🤗