Initial STOCKHISTORY Announcement
Microsoft just announced a new Excel function called STOCKHISTORY. This function provides a way to retrieve historical stock quotes directly into Excel.
As it is being rolled out over time, I haven’t had a chance to use it yet. But as soon as my copy of Excel receives the function, I’ll write a post about it. I’ll include screenshots and a video as well.
In the meantime, if you’d like to learn more about this function, check out these Microsoft links:
I’m very excited to give this function a try, and I’ll be sure to write a full post when I get my hands on it 🙂
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.
Hahaha, now you know how those of us with Office Administrators who won’t let us get on Fast Track feel!!! I’m still waiting for Let function, dynamic functions, XLOOKUP, etc, etc. PQ to pdf will be a huge game changer from me when I finally get it in a year from now!
Hope you and your family are doing well, Jeff. With your tutelage I’ve been creating some pretty awesome content for my company’s clients and still pass along so many of your emails. Keep doing what you do and stay well!
Thanks Kathi … I TOTALLY understand 🙂
Thanks for your kind note, and hope you are well!
Thanks for all your work – you consistently do great stuff that’s easy to understand.
stockhistory is a great addition but has major problems when you’re trying to construct a portfolio. I would like the dates to be across the page rather than vertical. I would like to multiply the # of shares by the price and then sum the portfolio. All of this is hard to do because stockhistory has 2 columns – so you have to manually insert a column between stock symbols – creates major headaches with a portfolio of more than a dozen stocks.
a few other problems: a stock such as Constellation Brands has #VALUE for a number of days – this is a big company and had shares traded. A company such as Terumo Corp (XFRA:TUO) must not have traded shares on particular days so rather than use the previous day’s price, the date is skipped – that misaligns that column with the other price columns. Just now, a lot of my dates have gone #NULL.
I’m sure there are other issues – look forward to your help.
Wow, fun! I love to hear about cool new bells and whistles. 🙂