eTrader Zone       

 

Home Free Scripts
  Toggle all descriptions Collapse all descriptions
Excel Script top
# Article Title
1 Options Data

The script below will check if a stock ticker you entered allow you to trade in Options. It will parses through Yahoo Finance website to look for those information.

2 Download Free Historical Quotes from Yahoo Finance

The script below will download FREE Historical Stock Quotes from Yahoo Finance base on the list of stock quotes you entered.

3 Historical Quotes - Google Finance

The script below will download Historical Stock Quotes from Google Finance, it is similar to one of the script in another page – download Historical Quote from Yahoo Finance,

4 Yahoo Stock Quotes

Yahoo Finance portal provides some URL parameters that you can use to download stock quotes information.

5 Financial Portal Data

The script below will parses through MoneyCentral website and get the stock information base on the stock symbols you enter.

6 Stock Chart

The script below will download stock chart from the stock quotes you entered and stock it locally for your viewing pleasure.

7 MSN Web Query

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.

8 Option Clearing Corp

This script below will download the latest and complete list of options data from The Options Clearing Corporation (TheOCC) website, it will also convert the downloaded file from plain text into excel format.

9 Technical Analysis - MACD Scan

This script will download past 60 days historical data from Yahoo Finance, then calculate for the MACD value and then check for fast and slow line crossover.

10 Technical Analysis - Bollinger Bands

This script will download past 60 days historical data from Yahoo Finance, then calculate the Bollinger Bands value.

11 Technical Analysis - EMA

This script will download past 60 days historical data from Yahoo Finance, then calculate the Exponential Moving Average (EMA) base on your input, options given are 12-days, 26-days and 50-days EMA.

12 Technical Analysis - Doji Star

We received many emails from our readers asking for a script on how to scan for Doji.

13 Earnings Data

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

Related Links