Put the latest Stock and Fund prices in Excel workbooks


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Excel 365 for Windows and Mac has a clever way to add the latest stock prices into spreadsheets in a truly quick and easy way.

Stock data type has been in Excel 365 for Windows since late last year but has gradually improved as the development team react to feedback and changeover to a better financial data feed.  Along the way, the same feature was added to Excel 365 for Mac.

Get a stock price into Excel

The basics are very simple. Type into a cell the name or ticker code of a stock then click Data | Data Types | Stocks.

put the latest stock and fund prices in excel workbooks microsoft excel 27815 - Put the latest Stock and Fund prices in Excel workbooks

Excel 365 send that cell text to Microsoft’s cloud service and it replies with the latest data on that stock.  You know it’s happened because of the little building icon in the cell.  The exchange and ticker code may be confirmed as well.

put the latest stock and fund prices in excel workbooks microsoft excel 27816 - Put the latest Stock and Fund prices in Excel workbooks

Behind the scenes, Excel 365 has saved many different details about that stock, listed fund or index. See them by adding extra columns.

put the latest stock and fund prices in excel workbooks office 365 27817 - Put the latest Stock and Fund prices in Excel workbooks

Add more stocks and you quickly get a full and up-to-date financial picture of your choice of stocks. All the columns are filled and updated automatically.

put the latest stock and fund prices in excel workbooks office 365 27818 - Put the latest Stock and Fund prices in Excel workbooks

From that base you can do your own analysis, update your portfolio value and much more. Updating all that info is a single click at Data | Refresh All.

Of course, there’s a lot more you can do with Stock data type which is why we’ve revised our Real Time Excel ebook to include all the latest info, tips and tricks. Including Excel workbooks (like the one above) to open on your computer and try for yourself.

Want other types of live data like Weather, currency exchange rates?

Real Time Excel shows how to get latest currency and cybercurrency exchange rates plus weather details.

Don’t have Excel 365? 

No problem, Real Time Excel includes examples and detailed help for Excel 2019, 2016 and 2013 for Windows.

Real Time Excel is available right now for $11.95 or $6.95 for Office Watch subscribers. The whole ebook with example workbooks, presentations and VBA code can be on your computer in just a few minutes.

2330 Real time Excel small - Put the latest Stock and Fund prices in Excel workbooks

subs profile e1563205311409 - Put the latest Stock and Fund prices in Excel workbooks
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address