MSN Stock Price Add-In For Excel

One of the handiest investing tools I've come across is a free download available from Microsoft that allows you to automatically update an Excel spreadsheet with stock prices from MSN Money. After installing the tool in Excel, an "Insert Stock Quotes" button will appear in the toolbar at the top of your spreadsheets. When clicked, the button opens a dialog box in which you specify the stock ticker you'd like to track, and a list of market data you can have imported into your spreadsheet. After you choose which ones you'd like to import and hit "OK," formulas like this will appear in whatever Excel cells you're working in: =MSNStockQuote($B25,"Ask Price","US")

You'll also see a button labelled "Update Quotes" in the Excel toolbar. When you click this, whatever stock quotes you've added to your spreadsheet will be updated automatically with the latest price data from MSN Money.

The quoting tool allows you to track information about your stocks including their:

• 52 Week High
• 52 Week Low
• Day's High
• Day's Low
  
• Open Price
• Last Price
• Ask Price
  
• Ask Size
• Bid Price
• Bid Size
• Company Name
• Quoted Currency
• Date of Last Sale
• Earnings Per Share
• Market Capital
• P/E Ratio
• Percent Change
• Previous Close
• Shares Outstanding
• Size of Last Sale
• Time of Last Sale
• Volume

I use this tool to quickly update historical price data about my portfolio of stocks, which I then run through various technical analysis equations to determine whether any of them have reached a good buying or selling point.

All in all, the MSN stock quote add-in can be a very convenient way to import key data about your stock portfolio directly into a spreadsheet. To get this free add-in, just download it from Microsoft's site and go through the quick installation process. Here's where to download the stock quote add-in.

Happy trading!

Brokerage Services

The following companies provide discount and retail brokerage services to individual investors seeking to buy or sell stocks, options, mutual funds and ETFs:

Banc of America Investment Services

About Banc of America Investment Services:

Now offers no-commission online equity trades for customers maintaining $25,000 minimum Bank of America account balances (not yet available in all regions). Build and manage a diversified portfolio that could include mutual funds, stocks, bonds, and other investment products. Includes access to industry leading tools, news, and research to help manage your portfolio.

CyberTrader

About CyberTrader:

Active traders choose CyberTrader because they get: the ability to trade equities and derivatives in one platform, competitive commissions, Ken Tower research, a large selection of online education, and more. And they get it all with equity pricing as low as $.006 per share up to 2,000 shares.

E*TRADE Securities

About E*TRADE:

Whether you are an active trader, serious investor, or just getting started, E*TRADE Securities offers you a wide array of products and services with the power, price, and service you need to make the most of your investments. Choose from investments including stocks, options, mutual funds, bonds, and IPOs (Initial Public Offerings).

Interactive Brokers

About Interactive Brokers:

Offers advanced trading tools including: integrated technical, fundamental and price/risk analysis tools, real-time margin and activity reporting, over forty order types, and a paper trading facility to test trading strategies. In 2006 Barron's awarded Interactive Brokers its top star ranking overall and for lowest cost broker.

Scottrade

About Scottrade:

Scottrade offers easy-to-use trading platforms and low transaction fees for Listed and Nasdaq Stocks, Bulletin Board Stocks, Pink Sheet, and Canadian Stocks. Investors may also request an options account, or choose from thousands of funds, both load and no-load, including more than 1,000 No-Load, No-Transaction Fee (NTF) mutual funds.

SogoInvest

About SogoInvest:

SogoInvest.com is an online brokerage that allows investors of any kind, beginner or expert, to buy and sell stocks in real-time for $3 or less. We offer sophisticated stock trading tools like our new search engine scanning software, free to customers with funded accounts, as well as some of the lowest commissions in the industry.

Do you have an additional brokerage service to suggest? Please feel free to post your recommendation in the comments below.

Financial News & Information Services

The following news and information services provide updates on stocks, bonds, ETFs and mutual funds, commodities, options, futures and other financial markets:

Bloomberg.com

About Bloomberg:

Bloomberg's media services provide real-time and archived financial and market data, pricing, trading, news and communications tools in a single, integrated package to corporations, news organizations, financial and legal professionals and individuals around the world.

Investors.com: Investors Business Daily

About Investors.com:

Subscription services include market updates and commentary, stock analysis and rankings, lists of stocks posting dramatic gains and substantial institutional ownership, ETF research and analysis, and tutorials on Investors.com's proprietary CAN-SLIM investment philosophy.

MarketWatch

About MarketWatch:

Owned by Dow Jones & Company, MarketWatch is a leading provider of business news, financial information and analytical tools. MarketWatch also offers subscription products for individual investors, including the Hulbert Financial Digest suite of products, Retirement Weekly and ETF Trader.

Reuters Investing News

About Reuters:

Reuters is the world's largest international multimedia news agency, providing investing news, world news, business news, technology news, headline news, small business news, news alerts, personal finance, stock market, and mutual funds information.

WSJ.com: The Wall Street Journal Online Edition

About The Wall Street Journal Online:

Subscription services include complete coverage of global financial markets, extensive research and charting capabilities, current and historical stock quotes, 90-day archived news, personalization features, and a variety of e-mail and alert services.

Yahoo! Finance

About Yahoo! Finance:

Provides new on recent market activity, stock screening and analysis tools, current and historical price data, investor education articles and tutorials, personal finance advice and commentary, and updates on stocks, industry sectors, mutual funds, ETFs, bonds, options, and international markets.

Do you have an additional financial news or information service to suggest? Please free free to post your recommendation in the comments below.

Trading Signal Services

The following services provide trading signals recommending the purchase or sale of stocks, options, futures, commodities, ETFs and mutual funds:

Elliott Wave International: Specialty Services

Based on the Elliott Wave principle of market behavior, Elliott Wave International provides Intraday Forecasts, Opportunity Alerts, and On-Demand Forecasts for traders to use in identifying price targets and planning trades. Expert analysts are available for subscribers to contact for specific market predictions.

GStock.com

About Gstock:

GStock is a Virtual Supercomputer formed by many computers calculating a huge amount of investment stratagies with one goal - to pick the best profit making strategy for each stock.

Prosignal.com

About Prosignal:

Prosignal is a web site that provides professional trading signals for the financial markets. These markets currently include U.S. stocks, indices, mutual funds, and bonds. We provide a subscription service for the average investor, as well as premium products for investment firms which utilize our proprietary services for their clients.

StockSignals.com

About Stock Signals:

Stock Signals provides investors with technical analysis of global equity markets and has outperformed benchmark indexes with own portfolios. Currently Stock Signals covers the Scandinavian, US, UK and German equity markets.

Stock Signals Ltd.

About Stock Signals Ltd.:

Stock Signals is an innovative Canadian Company that publishes a daily Buy - Sell - Watch List for North American Equities that compose the major North American Indexes. These include the S&P TSX Composite, Dow Jones Industrial Average, Nasdaq 100, and the S&P 500.

Timing Signals

About Timing Signals:

Market beating results trading QQQQ (Nasdaq index ETF) or Mutual Funds in minutes a day. Easy, powerful, and accurate market timing signals from a sophisticated computer program. Clear, unambiguous timing signals posted daily in the member area - updates posted online each market day. Since June 2004, the NASDAQ 100 timing signals are up 665% while buy and hold returned only 21%

Do you have an additional signal service to suggest? Please feel free to post your recommendation in the comments below.