eTrader Zone       

The script below downloads Earnings data from Yahoo finance website and subsequently gather all fundamental data from MoneyCentral website.

All these information are useful to perform analysis before a company announces quarterly earnings results. You can also modify the script to suit to your own needs.

Earning Calendar shows the date a company announces their quarterly earnings result, there are many speculation before the earning announcement. Earnings usually be announced before the market open or after the market closed, and it will cause a big swing in the price movement after the announcement, hence there are many people trying to analyze the stock past performance and to predict the stock movement.

This tool will gather all the earnings data from the website according to the date you enter. Data downloaded are from MoneyCentral website such as StockScouter Rating, Analyst Consensus, Last Price, 50 and 200 Days Moving Average, Relative Strength and many others.

Login or Register to download this Excel Spreadsheet

You can take a look at the Yahoo Finance's website for the latest earnings calendar at the link below:

http://biz.yahoo.com/research/earncal/today.html

This script is one of the demonstrations of combining scripts found on this website, by customizing and consolidating scripts together you can produce a much more meaningful that better suit to your own needs. Script used here can be found on the following pages.

Finance Portal data
Options Clearing Corp
Stock Chart

Here are the functions of this script:

• Click on the 'Import' button and you will be prompted to enter the date you wish to import the earnings data.

• As this script is mainly focuses on the stock that are providing Options, it will check on options data stored on this spreadsheet and download a latest one from theOCC's website if it is too old (refer here for the script).

• Once all the announcements are downloaded, click on the 'Scan' button to gather all the required data. This will take some time to process depends on the number of earnings data you have.

• Once all data are gathered, a ‘Form View’ button will appear, click on it and you will see the scan result presented in another windows with the 1 year stock chart as follow: