I have an Excel spreadsheet that I set up to keep track of my stock portfolio. Given a stock symbol in a cell, is there an easy way for Excel to retrieve the current stock price via a macro or some other option?

A. Caraktir

In Excel , there are several different ways to get the information you want. Check to make sure you have Smart Tags enabled, then select AutoCorrect Options... from the Tools menu and click on the Smart Tags tab. Once this feature is enabled, a smart tag will appear when you point your mouse cursor at a cell containing the stock symbol. Clicking on the tag's down arrow will present a menu of options (see screen). You can choose Insert refreshable stock price.... to put the information into a worksheet or just choose Stock quote on MSN Money to display current information in your browser.

If you locate the stock information you want on a Web page, you can import it directly into Excel. Choose Data | Import External Data | New Web Query... from the menu and enter the URL (for example, http://moneycentral.msn.com/scripts/webquote.dll?ipage=qd&Symbol=BORL). The Web Query window will display the page with small arrow icons marking the page elements you can import. Click on the arrows for the desired elements, which will then change to check marks. Now click on the Import button to bring those elements into your spreadsheet. You can click on the Refresh Data button in the External Data toolbar at any time to update the information.

Copyright © Ziff Davis Media Inc. All Rights Reserved. Originally appearing in PC Magazine.

Commodity Traders Articles on the following subjects:

» Daytrading  

» Forex Daytrading  

» Daytrading Software  

» Daytrading Computers  

» Daytrading Stocks  

» Daytrading Futures  

» Daytrading School  

» Daytrading Online  

» Daytrading Eminis  

» Daytrading Tools  

» Daytrading Technique  

» Daytrading Online Brokers  

» Daytrading School  

» US Futures Daytrading  

» Commodity Futures  

» Commodity Futures Trading  

» Commodity Trading and Futures  

» Commodity Futures Options trading  

» Commodity Futures Trading Analysis  

» Commodity Futures Trading Commission  

» Commodity Futures Brokers  

» Commodity Futures Auditor  

» Commodity Futures Resource  

» Commodity Futures Exchanges  

» Commodity Futures Traders  

» Commodity Trading  

» Online Commodity Trading  

» Online Commodity Trading Analysis  

» Commodity Trading System  

» Commodity Trading Course  

» Commodity Trading Advisor  

» Commodity Trading Newsletter  

» Commodity Trading Software  

» Commodity Trading Charts  

» Commodity Trading eBook  

» Commodity Trading India  

» Commodity Trading Courses  

» Stocks  

» Stock Market  

» Stock Quotes  

» Penny Stocks  

» Stock Photos  

» Online Stock Trading  

» Stock Prices  

» New York Stock Exchange  

» Stock Investing  

» Free Stock Quotes  

» Stock Market Information  

» Stock Market Crash  

» Stock Ticker  

» Stock Loans  

» Stock Broker  

» Stock Research  

» Toronto Stock Exchange


home page for commoditytraders.com