Microsoft Excel facilitates the recovery of stock prices. Its Stock data type is connected to an online data source that allows you to access rich and interesting information that you can use and update. Let’s see how to get Stock quote in Excel.
Get real-time stock prices in Excel
You can retrieve stock quotes in Excel using the MSN MoneyCentral web query – but things have changed a lot now. The new system provides rich and interesting information with which you can work and update in an instant! The way to do it is as follows:
- Create a table
- Enter a stock symbol
- Let Excel find the match for your entries
- Add a column to extract more information
- Space table entries
Since data such as the stock price is constantly changing, you can always get the latest data by updating the connection.
1]Create a table
To do this, go to ‘Insert“And select”Table“
To add a stock price to your Excel spreadsheet, convert the text to the “Actions” data type. Then you can choose another column to extract the relevant details, such as the share price, price change, etc.
Enter the text describing the company name or the fund name in each cell. You can also enter a stock symbol.
Select cells and go to ‘The dataThe “tab. Then click ‘Stocks“
If Excel finds a match between the entries you made in the cells and its online sources, it will easily convert the text to the Stocks data type. This can be checked when “Linked record icon for stock»Becomes visible to you.
2]Add a column to extract more information
Now choose one or more cells with the data type. The ‘Add a columnShould appear.
Once visible, click on this button, then on a field name to extract more information. For example, for stocks, you might be interested in choosing the most important determinant – the price.
Click the ‘Add a column»To add other fields. For example, you can track the performance of a stock over a period of weeks, months, or years.
To space the entries in the table, select all the columns and go to ‘HomeThe “tab.
Then go to the ‘Cells“And press the”Format’On the down arrow.
Select ‘Column width with automatic adjustment“And you’re done!
Very cool!