How to Make a Real Time Excel Spreadsheet

Written by james highland
  • Share
  • Tweet
  • Share
  • Email

Microsoft Office Excel is a spreadsheet application that organises data into columns and rows. It is most often used by individuals to store and manipulate data. The program supports a wide variety of content types. Usually, Excel files are "static" in that the data does not change until the user makes edits. However, the program also supports real-time data feeds. Powerful spreadsheets can be created to automatically update based on data fed by external sources. It is not complicated to set up a real-time Excel spreadsheet. With some patience and an Internet connection, Excel may be configured to pull data from a variety of sources.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Launch Excel. Create a new spreadsheet by clicking the "New" button or the "New" command under the "File" menu.

  2. 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. 3

    Click in the cell on the spreadsheet where you wish to place the results from a real-time data feed.

  4. 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. 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. 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. 7

    Click the "Insert Price" button. The current real-time stock price for the ticker symbol is inserted in the spreadsheet.

Tips and warnings

  • The possibilities for real-time spreadsheets are limited only by the availability of quality data feeds for Excel. Download and install the Office Web Services Toolkit from the Microsoft Download Center to extend the available data feeds for Excel.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.