Grab the file I used in the video from here 👉 pages.xelplus.com/stockhistory-file Stockhistory is now available to all Office 365 subscribers!

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.

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

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! 😊👍👏

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

Thank you for mentioning INDIA is included in the covered exchanges

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

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!

You are amazing teacher with mastery very impressive!

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

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

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

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

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

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

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. :)

Thank you this video. Would love to see more videos on stocks functions....

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

Excellent function and a very good explanation as always by Leila. Well done and keep it up.

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.

Very instructive and informative video. Thank you so much for share it.

Great video. Thanks.

Neat! I like how you made the formula more dynamic. Your mastery of Excel is impressive and does qualify you as a geek---just like it shows on the cup. :) Thank you for sharing your knowledge!

Awesome content..explained in most easiest way..Thankyou..

Looking forward to see more Formative stock functions which can generate reports

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

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! 🤗

This is a brilliant add-on to Excel! Thanks!

This is a great Video Presentation. Very useful tips and tricks.Thank you Leila.

Extremely Marvelous Tutorial.. I have been following up every time.. You are Magnificent Leila

Thank you Leila, this was VERY helpful.

Excellent video! Clear and crisp tutorials as always!

Tank you Leila for your help and may God bless you

Thank you, Leila. You are awesome!

I need this to be this way for my double bottom strategy code.

Excellent video tutorial, Leila! Keep it up! Thanks!

Very Great introduction. Will get it and try soonest. Amazing

Leila ,Do u know U r so amzaing ... and keep rocking..enjoy !

Excel is getting more and more stocks friendly

Thank you for this video, keep growing.

really beautiful video. Amazing

Awesome, thanks for this!

Thank you so much for explaining it really well. I had looked up other tutorials for this function, but failed to fully understand it. Two questions if you haven't answered them already: 1) How to align daily data for several stocks (eg I have some stocks that don't go back a year and their results are misaligned to the others). 2) the present setup shows the oldest data first, how can we set it to show today's price in the leftmost cell and then go backwards? Thanks much

Looking Forward for more Excel Hacks

Mam you are looking gorgeous in your office. Stay blessed.

Works, when not #BUSY!, which is always...

this function is amazing and you explained it very well. can we get adjusted close price of stocks as there is no option for that to select. Mostly calculation on stocks are done on adjusted close price basis which is downloadable from yahoo finance website. But If I am working on any research of around 50-100 companies . Can we get adjusted close price in excel with this formula?

thank you very much for all these wonderful and valuable information you are providing And just now I was telling my mom I wanna learn and know whatever she knows from the excel sheet 😓 Because I'm an accountant.

For daily info, I just passed the array of dates outputted in the date row as the "start date" for all the other rows (it handles dynamic array). Performance might not be as good but it worked just fine for ~10 companies with 5 years of data. Also, you want to pick a ticker for the date row that has been traded consistently for your time period.

Super video, Leila. You've got to be careful with applying that technique to a portfolio of stocks. Sometimes there are missing dates from trading halt orders or you've got stocks across different exchanges with different days off, especially for holidays between countries.

Excelent lesson.

I love this function! Great video, thanks for sharing.

Thank you so much for this… it was extremely helpful. Good job!

Awesome video, thanks

Thanks Leila, indeed a useful video. Can you please help to derive the daily moving average in one cell of the last 30 days closing as that will help to compare with the current price. this function is there in Google Sheet but unable to found in MS Excel.

Finally got around to setting this up, thank you. Is there a way to reverse the date sequence from newest to oldest?

Thanks, You made that look easy.

Really really very very amazing function great 👍👍

Ma'am can u make more videos on accounts? Your previous accounts videos were very clear and much easier to understand. Thank u for making such a great videos❤😊✨

Thank you so much - great video as are the others!

Terrific explanation. thank you

Very interesting and useful information. Thanks a lot

Great class. I am not able to see the stock button on my Excel version. Do I have an older version? I think I have Microsoft 365. I also want to input other stock information like MACD, RSI, Stochastics, and other technical data. Can I do that? Thank you.

Can you please explain how we can get the closing price o stocks for consecutive days (say 10 days) instead of months? Thank you!

You Rock Girl!

Thanks a lot Leila for this video. It has really helped me in my trading plan/strategy. But another challenge that I have faced is when it comes to fetching data based on the one-hour time frame. The Stockhistory function gives data only on the daily, Weekly and Monthly. But I need data for hourly time frame. How can I go about that?

Amazing work. Thank you

Just what I was looking for, thanks a lot.👌

Thank you, I like it.

Great video...thanks for sharing...Leila...👍

Leila, as always, brilliant. I knew this function, but I don't remember whether I saw it in your previous videos or in your courses. Thank you.

Great video...always learning from your work.

How can you download the dividend amount or percentage? is it possible? thx

this is like the reviews for the latest GPUs/CPUs, most of the people don't have access to these nice features of the coming months...

Love your videos. Q.why are some stock prices not shown, e.g.Lloyds Bank, BT etc on the London stock exchange.?

thank you for such wonderful trainings!! very clear and easy to follow. I'm able to replicate effectively.

Thanks for this informative video. Sadly not in Excel 2016

Excellent video & excellent formula! It would be nicer for the formula to show also the number of outstanding shares though.

Thank you Leila, excellent video. How do i get Commodity prices, like Spot Gold, Silver, Maize, Coffee, etc... ?

Nice tutorial, nicely explained.

I would like to show the year to date performance of spy as a percentage. Is there a way to use stockhistory to do that? Do you know of some other way to get excel to show me the year to date performance of spy as a percentage? Thanks so much in advance. We really love your videos. They are so helpful and they age well.

FYI - This function still does not work for me if I open the file in the Excel App but..... DOES WORK if I open the same file in my web browser. I'm on version 2008 (Build13127.21668)..also great video Leila...love your channel.

You look good in this new look ❤️

timely video! 🚀🚀🚀

Great tutorial. Thanks a lot. A question though. If you have stocks from different exchanges (for example XNYS and XBRU), the exchange have different days that the stock markets are closed/open and the timeline is not the same. Would there be a way to force the values to use a unique timeline ?

Great mam very knowledgeable, thanku you also suggest me delivery quantity of stocks for one week

The stockhistory formula is in Microsoft 365 Excel Financial formulas not in the Lookup and Reference Family of Formulas as stated in the Guide. To get current 1 year data use Today()-365 as start date and Today() as end date.

I am unable to find stockhistory function! I have updated version of 365. What should I do?

This will change my life! Thankyou 🙏

Don't have 365. In the future maybe you can do some videos on non-365 Excel versions. Thank you Leila

I been watching your videos lately. Thanks for all the information. It’s really helpful. I want to create an interactive dashboard for my stock portfolio. Do you have a video on that?

Thanks Leila. Great intro to get started with the new STOCKHISTORY function! Too bad Sparklines Data Range will not accept #SPILLED range as input. Maybe some day. Thanks for sharing :)) Thumbs up!!

How would you make the date’s descending (ie current to oldest) and still only show one row for dates?

thx a lot

Hi Leila, thanks for all the videos that you post. very clear and helpful. I have a problem I am trying to create a table with only the daily %change. and i cannot figure it out. could you help me please

Hi been looking for a while now but nothing mentions if this feature is exclusive to office 365 or if it is available to the home & student/professional is this function in these? if not is there a way to create a macro that does this function?

Thank You! Is there similar approach to download daily stock options prices?

Please can you make a video on how to to draw AOA and AON diagrams for CPM calculation?

Thanks for the excellent expose to STOCKHISTORY Function. I have a question in regard to this. Some of my Stock actually doesn't start at the same time. When I try to do the above, the number of entries are different when I use a monthly 2 years data (from 9/1/2019). To be specific, XNAS:UPST will give you the #N/A error for the 11/1/2020 entry but will have all other prices up to 9/1/2021. My question is how do I actually make the data and dates to be placed in the correct dates at the top which starts at 9/1/2019 an ends with 9/1/2021? Secondly, Why does it provide the #N/A error? Thanks in advance.

Hellow Leila, I watch quite a bit your tutorial for stock, can you suggest how to down load portfolio history from Robinhood.