![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 1%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
In Excel 2024, if you do not have Microsoft 365, you won't have access to the STOCKHISTORY function or the advanced data types for stocks that are available in Excel for the web and Microsoft 365. However, you can still manually enter stock quotes or use other methods to get stock data into your spreadsheet.
One option is to use a web service or an API to fetch stock quotes. You can create a custom function that retrieves stock data from an external source using Excel's capabilities to make web requests. This would require some programming knowledge, as you would need to write a script that interacts with the API to get the stock quotes and update them in your spreadsheet.
Alternatively, you can periodically copy and paste stock quotes from a financial website into your Excel spreadsheet if you do not need real-time updates.
For automatic updates, consider using Excel's custom functions feature, which allows you to create functions that can fetch data from the web, but keep in mind that this feature may have limitations based on your version of Excel.
If you are looking for a more straightforward solution, you might want to consider upgrading to Microsoft 365, which offers more integrated features for fetching and updating stock data directly in Excel.