Auto updating stock quotes
This data type works better with data stored in tables in Excel, so select one cell in your range of companies and press Ctrl T to format the data as a table.In the dialog that opens, confirm your data has headers and click OK.Select a cell with the bank icon, and a new Insert Data icon will appear to the right of the cell.Click the Insert Data icon for a list of available fields. A new column will appear in your table showing the exchange for each stock.Repeat this process to insert a column for Ticker symbol.For this article, I planned to show Barclays PLC, a stock traded under the BARC ticker symbol on the London Stock Exchange.Finally, choose the data source labeled "Investor Stock Quotes." Select the cell in the spreadsheet for the stock quote information input or choose the "Create New Worksheet" option to place the stock quote in a new worksheet.After selecting either option, select "OK" from the dialog box.
With it, you can get current data from the internet related to companies from 60 different stock exchanges around the world.One such function is the ability to import detailed stock quotes directly into a Microsoft Excel spreadsheet. First, select "Start" from the main operating system menu.Next, choose "Programs." Then, click on "Microsoft Office" in the programs menu.Type the stock ticker symbol into the next Microsoft Excel dialog box.
If the user wants to update the stock quote in the future, choose "Use this value/reference for future refreshes." Also check the second check box if you would like the information to refresh on its own.For example, if the value in cell A2 is Microsoft Corp., then the formula require brackets.