New Excel STOCKHISTORY Function - Definitive Guide 

You blew my mind with this formula and your teaching method. Excellent work and Excellent teacher.

I always enjoy your videos because you promote creative use cases and examples, as opposed to channels that only provide basic functions. I really like it!

Definitely a “world first” & not just the new feature. Tons of investment analysis one can now do easily with this feature & the tips you showcased. Thanks & great video

Thanks a lot.. the last part is what I really needed. For others please do watch the full video the most needed is at the end. Appreciate ur hardwork. Pls continue

Learned a lot and especially liked how the STOCKHISTORY function works with spilled ranges, thank you Mynda!

Just came across this video while searching Stockhistory function. Brilliant examples and a lovely presentation. Well done. I subscribed immediately. Keep up the good work.

Fantastic stuff. I learned quite a bit in this video and will use it to update my own apps.

Thanks a lot .... your teaching skill is too good ... though while watching the videos it seems very easy but when we try it's different. One should admit that you are teaching us a lot 🙏

Can't wait to give it a try! Hopefully the function will be available soon! Thx again for a very valuable tutorial!

Always such a great teacher….❤

Marvellous, Wonderful - think of a superlative and you deserve it!

Great information and explanation. Thank you.

Hi Mynda, thanks for a great walk through re StockHistory - excellent as always!

Wow... This is amazing function. I am waiting for this function in my 365. Come on Microsoft...

Superb video Mynda, for what looks like a superb function. Thank you!

i can't waiting your every tutorial. i love and you are super genious Keep it up!

Finaly!!! Thank you very much for this video! I was searching how to get portfolio value chart which is filling up automatically. This video made me shout Eureka!!! I guess I can choose the date I started buying stocks for my portfolio, enter stockhistory function to get prices for each stock which are in horizontal order. For dates which are in vertical order I can use sequence function as well. Like this I will get prices for each stock I own. Next step is to create a column to get share quantity at each price. I guess this should be entered manually. And then on a new column which is stock value, just need to multiply prieces each day with share quantity each day. I hope my interpretation of second part is right. Or is there any other way to get daily portfolio value chart? I tried to search it on the internet for so many days now and there is no info about it. And actually you are right! You are the first one to explain this method. Once again, thank you very much and hopefully will get an answer to my question on this comment board, or even in a new video explaining that. :*

Mynda, this is a great tutorial thank you very much. Also your website has lots of great content.

Hi Mynda, a great teaching. I have a question: What are the symbols for "NASDAQ", "DJIA", "S&P 500" that I can use in STOCKHISTORY function?

You're doing a wonderful job!!

Exceptional content and presentation Mynda! Thank you and please continue to do what you do :)

I have used all your methods for my reports 😍

Very useful and well done. Thanks for sharing this with us.

Hi Mynda!Really Looking Forward To Trying STOCKHISTORY Out...Thank You For The Great Tutorial :)

Thanks that was helpful. How can I hall all the stocks in one table with the stock symbol in the first row?

Nice presentation and content, could you also guide us how to include close, open, high, low, volume based on date for list of stocks

This is GREAT Myndy. I'm not much into stocks......but what is High and Low??

excellent video. Thank you again

Sublime! Thank you, Mynda!

Thanks for this great tutorial, a great video!

thank you for the video, very very informative, but i have an issue if you can help me, 1. can you help me get the data starting with the latest stock price first, 2. i tried getting data for say 10 stocks for 10 years but some of the stocks in the list are listed for less than 10 years than the price and date did not match is there a way to correct this, thanks in advance.

Hi Mynda.. thanks for the 1080p version :))

Thanks Sir I will try this again

Great video---i have one issue though---the dates will not refresh and give latest data for this new dates, even after refreshing all data----dates do no move on using =TODAY()

Hi Mynda, very nicely done. I want to know if the StockHistory function can incorporate the array and sequence for multiple stock prices over the same periods. I don't want the date displayed for each stock but just a dynamic date in column, Stock Price Headers in Rows and prices for each below. Tx

Hi Mynda, Very fine video that help a lot. Did I miss a trick to get the P/E history data from Stocks in DATA TYPES or do you have a intro to this? Thanks in advance Karsten

thank you so much for the video.

Great video, as always. Is there a way to get historical dividend data? Thanks

Really useful tutorial, thank you.

Hi Mynda, Happy New Year! As formula name signifies, I guess it can't provide real-time (or slightly delayed) data, right?

Awesome! Thank you. Is there a way to get just One day extracted, as opposed to showing the whole list of dates? , Thanks

How can I get the % change for stock the last 5 trading days?

This is great! Just wanted to ask, is it possible to obtain % change in prices for the last month or 1 year for example. Entering a stock into any cell allows us to obtain information such as high, low, % change e.t.c. However, the % change applies to todays change. I would like to obtain the % change over the last month. Is this possible?

Thanks for sharing, this is awesome. You’re awesome!

OMG!!! Simply magic!!! LOVE IT! Thank you so much. So relevant with all that's happening in the cryptocurrency space! Stay awesome o/

Great video! I'm trying to get data inputed for the last month, 3m, 6m, year. Is there a way to take out weekends and holidays from creating errors in the history (for stocks only traded on weekdays and non holidays?

I see that you are in Australia, how would I incorporate the Stockhistory from the NYSE? Or an American company that provides historical stock data like Yahoo? Thanks for the great videos.

Hi Mynda, I am trying to understand why monthly end dates are at the first of the new month? Is there a way to get the 31st or 30th closing price?

What if I wanted to reference, say for example, the March high and low to compare months?

Thanks Mynda, great video Just need to wait for it - I'm not in the 50% :(

Is there a way to get the S&P 500 index prices with this function?

So bummed. On Insider Beta and the function still isn't there. Thanks for sharing it though!

FANTASTIC !!!! How much did you invest..lol

Hi, thankyou for the video, but at 9:00 i copied that same code and it did not display 30 days of prices from current date, but only the current days price... Ive checked it probably 10 times now and don't know why it won't work

There is great flaw in stockhistory. It doesn't map the market events. For example, if the the stock has gone through stock split then the prices extracted shall be unadjusted, so before the stocksplit the prices will be significantly higher than the prices after stock split. Is there any way to overcome this problem.

Hi Mynda, i have noticed that the STOCKHISTORY function returns data one day delay, while in the Microsoft data documentation it says it should be only 20 min delay... do you know what is happening here? Thanks in advance!

Hi Mynda, great video as always! It seems that STOCKHISTORY function would show #N/A when there is a whole day trading halt on a certain date. Any ideas to skip the trading halt date or hide it as the #N/A value makes calculating MA a bit troublesome?

The STOCKHISTORY function 'autopopulates' when I start typing in the first few letters, but when I enter the whole formula including sort, I get '0'. Do I need to update something?

Game changer!

Is there a way to get data for the stock indexes like SP500 or Dow Jones?

Finaly!!! Unlick you tried to add the dates from sequence for stocks (not currencies) and dates were market are not open returns #value! any insight

Hy Minda! I've just signed for Beta Channel but.. It doesn't work yet, it doesn't seem to recognize function arguments. Should I wait for some update or notifications... Thanks!!!!

Hi, I see that you have at least one unreleased rich data type, namely “Organization” (visible at 4:53). Can you please introduce this/these in a video? The recording shows: Organization, Stocks, Geography … and the expand button. This makes me curious. Have any other data types been added?

Heyecan verici

Hi there , There was certain formulation that i wanted to learn. It was about creating a master sheet and flowing that info into various sheets . I have created one but couldnt find the formulation. Would you be able to help if i email the details ? Thank you

Hello, I do have office 365, but It looks like the function STOCKHISTORY is not available....Could It happen?

Mynda, two years on and the functionality has changed. At 15:00 onwards, when the functions looks up data for a weekend or a non-trade day, it no longer reports the prior date's value as it did for you in your video; now it reports a #VALUE! error. This is incredibly frustrating! We want it to report the prior date's value. What a pain.

How to remove the weekend/holiday data from evaluating?

I've been trying to return indices like DJIA or S&P500 with no success. How can we do this? Thanks.

Lovely :) thanks.

not sure why my excel 365 cannot work with Stockhistory even I downloaded the workbook/example...

MS Excel is heading to the moon!

THANK YOU

Hi Mynda, why Can't find stockhistory?

Love the videos. Is there a way in excel to get stock data from a url? I’m trying to import data from www.finviz.com.

The sort function didn't sort correctly from most current to oldest, is there a fix?

Able to connect to hong kong stock market ?

Currency is very interesting. A lot of companies I work for pay an annual subscription for this type of data in the UK (in order to automatically upload to their finance system). It'll be interesting to see if this data access will be free in the future or we'll have to pay to access various data types in future as an addition to the 365 subscription once Microsoft hold the monopoly on people accessing the data. I like the idea behind the data types, but it seems strange that it's not presented via the data model/power query. It would seem that refreshable data like this would be better served via the refresh all button rather than the busy notification. Hopefully it paves the way for better interaction with the data model than the cube functions and perhaps the ability to have a function to change number formatting in the spill formula

Thank you for another great video, I would love to see a video to create a dashboard for intraday trading, to analysis performance, like p/l , expectancy, win loss ratio.. etc! I have been finding hard to organize the data from IRESS to get those metrics!

Great video but the real Bitcoin is BTC, definately NOT BCH!!! (offensive to Bitcoin community)

Why bother with making a video when you keep doing so fast that people can't understand . You are gloating over your successful completion of this function not teaching step by step to those who want to learn. Many other features you use but you don't bother to talk about them at all. This is not worth learning from .

What a waste of time - other systems have had better than this for years ! Good luck making money - lol

Please provide me the formula like GOOGLE Finance (A3,high52) and GOOGLE Finance ( A3, low52) for 3 month maximum high price formula and 6 month maximum high price formula GOOGLEFINANCE (A3,. )

I am getting errors when I try to do anything on the spreadsheet "Excel ran out of resources while attempting to calculate one or more formulas, As a result these formulas can't be evaluated" Please help.. Thx