Just paste the below code within the ThisWorkbook Microsoft Excel Objects folder within the Visual Basic Editor (make sure you double-click ThisWorkbook to properly open its code page).

This feature was never truly supported in Excel until now, even though many Excel users used to pull stock data from Yahoo Finance until the capability end in 2018 (thanks Verizon ).

Excel now has the ability to pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin.

Microsoft is working with Nasdaq and Refinitiv to pull current financial data directly into your spreadsheets under a new feature called Data Types.

They allow you to take an entity such as the country of France and automatically pull in current data related to it (ie population, leaders, GDP, etc).

I could see some cool uses for medical info, vocabulary, and sports statistics.

What is Available Within Stocks Currently, these are the categories of data that can be accessed via the Stock Data Type: Stocks Bonds Mutual Funds Currencies Cryptocurrencies Converting Ticker Symbols Into Stock Data How do you get started pulling stock data into your spreadsheet There are two methods you can use to get setup.

Start Typing Stocks One neat feat that has come with Data Types is Excel now has the ability to realize when you are working with stock information.

After you have typed three consecutive stock names or ticker symbols, Excel will most likely recognize what you are trying to do and give you a prompt to convert the cells into a Stock data type.

Simply select the cells that contain the stock namesticker symbols and navigate to the Data tab in the Excel Ribbon.

After click the Stocks button, Excel will attempt to convert as many of the selected cells values into stock data types.

If Excel needs help, it will provide suggested options for your entered value in the right pane.

When you select a cell that is linked to stock data, youll notice a small Add Field icon in the upper right-hand corner of your selected cell.

If you click the icon, youll see a list of various fields you can add associated with that particular stock.

Select one and the field will be added to the right of your current data set.

Not all fields are available to all data types, so you may want to wrap your formulas with IFERROR formulas if you are comparing separate data types (ie currency wouldnt have the employee count field available to it).

Also, note that the new field data is only added to originally selected stock.

You will need to drag down the formulas in order to get the rest of the data populating with all of your stocks.

Once you convert text to a linked data type, an external data connection is established in the workbook.

Excel Stock Quotes Update It By

That way, if the data changes online, you can update it by refreshing it in Excel.

To refresh the data, right-click a cell with the linked data type and click Data Type Refresh.

Excel Stock Quotes Plus Any Other

That will refresh the cell you selected, plus any other cells that have that same data type.

If you want to refresh all linked data types and all data connections that may be in the workbook (including queries, other data connections, and PivotTables), click Data Refresh All or press CtrlAltF5.

Excel For Mac Stock Quotes