MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Stock & Exchange Rate History in Excel


June 29, 2020 - by Bill Jelen

A new STOCKHISTORY function debuted in the beta channel of Excel for Office 365 last week. The function is able to pull historical stock prices and exchange rates at a daily, weekly or monthly interval.

STOCKHISTORY is an example of one of the new Dynamic Array formulas. A single formula will spill into adajent cells. For an overview of Dynamic Arrays, read Excel 2019: Dynamic Arrays Can Spill article.

continue reading »

More Reading


Walk / Ride / Run #ForSmitty This Week »

June 23, 2020 - by Bill Jelen


Our good friend Chris “Smitty” Smith is in hospice this week, after a three year battle with cancer. I met Smitty when he was in the process of writing 29,536 answers at the MrExcel Message Board. Smitty became a Microsoft MVP for many years. He then actually joined the Excel team, and worked on cleaning up the Excel Help files.

What Is The Difference Between Microsoft Office Classic and Premium »

June 15, 2020 - by Bill Jelen


The retail box for Microsoft Office 2019 Home & Student makes it clear that you are not getting Outlook, Access or Publisher when you buy Excel 2019. But in the feature description for Word, Excel, Power Point and OneNote it says that you are getting “Classic” instead of “Premium”. What does that really mean?

read more articles »


Supercharge your career with training from MrExcel

Featured Products


Excel Custom Functions Straight to the Point

Excel Custom Functions Straight to the Point »


Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.

Cleaning Excel Data With Power Query Straight To The Point

Cleaning Excel Data With Power Query Straight To The Point »


This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

MrExcel LX – The Holy Grail of Excel Tips

MrExcel LX – The Holy Grail of Excel Tips »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »


Learn Power BI Dashboarding Techniques by Watching A Pro!

Microsoft Excel 2019 VBA and Macros

Microsoft Excel 2019 VBA and Macros »


Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.

Excel Dynamic Arrays Straight to the Point

Excel Dynamic Arrays Straight to the Point »


The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.

see more products »