Comments

Pages

How to Make a Real Time Excel Spreadsheet

Posted by at 7:18 AM Read our previous post

1. Launch Excel. Create a new spreadsheet by clicking the "New" button or the "New" command under the "File" menu.
2. Consider the type of real-time data you wish to use. Excel is often used to track stock prices and provide analysis on changing investment scenarios. Using real-time stock quotes is one example of Excel's ability to work with a data feed.
3. Click in the cell on the spreadsheet where you wish to place the results from a real-time data feed.
4. Click on the "Tools" menu, and select the "Research" command. A side pane will open on the right side of the Excel window.
5. Type in a stock ticker symbol in the "Search for" box at the top of the Research pane. Choose the "MSN Money Stock Quotes" data feed from the drop-down menu under the "Search for" field.
6. Press the green "Search" button to the right of the "Search for" field. The stock data for the desired ticker appears in the middle of the Research pane.
7. Click the "Insert Price" button. The current real-time stock price for the ticker symbol is inserted in the spreadsheet.

About