eTrader Zone       

The script below makes use of MSN MoneyCentral web queries to download stock quote into excel spreadsheet, there is no script required for this to run and the output format is already customized by MoneyCentral.

MoneyCentral allows you to pull data into the worksheet in a simple way via the web query, with this you can gather and study the stocks of interest to you. All data will be downloaded to the worksheet, where you can refresh your quotes when you want, or change and manipulate it any way you like.

Web query is useful for data that is frequently updated and the best part is it remembers where the data came from. This means, right after you created the web query, you can just refresh the web query to get the most recent data from the same URL again.

Login or Register to download this Excel Spreadsheet

The data downloaded from MSN website are last price, previous close, high, low, volume, % change, 52 week high, 52 week low, market cap, EPS, P/E ratio, # share outstanding.