#Import stock quotes excel for mac how to

However, there’s a VBA trick to configure auto-refresh, which helps when you’re trying to create a live dashboard. You’ll need to select Refresh All to get the latest stock data. You can get updated data by selecting the Refresh All icon in the Queries & Connections group on the ribbon. You’ll see the latest data from the web show up in the next column to the right. When you select the Insert Data icon, you’ll see a drop-down list of data points you can import from the web.Īdd each data point, one at a time.

Quick Analysis (bottom): This normally appears when you select multiple cells to quickly add tables or charts.

Insert Data (top): This lets you import data from the web into the column to the right of the stock symbol.

One will appear at the top, and the other at the bottom. Select all of the symbol cells again, and you’ll see two icons appear. Now you’re ready to add stock data to your spreadsheet. You’ll know this was successful because the symbol will change to the correct name of the company. Then, select Data from the menu, and in the Data Types group in the ribbon, select Stocks.Įxcel will access the internet and obtain the data for the symbols you’ve selected. To get started, create a column in Excel and list all of the stock ticker symbols you want stock quotes for.

However, if you don’t know how it works, just clicking on the Stocks tool won’t do anything at all. Stock prices are very easy to bring into Excel.

#Import stock quotes excel for mac how to

Refreshing Stock and Geography Data in Excelīefore trying to create a full dashboard, it’s a good idea to learn how to do a simple data import first.