Wednesday, December 28, 2011

Using Stock Historical Data Download to Get Stock Quotes

 

Introduction

Stock Historical Data Download is software that can download historical prices of stocks, indices and mutual funds publicly traded in US and Canadian markets. It produces data output in a plain text format and the user can customize the format to make it compatible to the specific charting or technical analysis tools. Daily, weekly, monthly, or dividends only options are provided to choose the interval to download. Command line arguments are provided for automation.

The recent release version: 1.4

Currently supported operating systems: Windows Vista/Xp/7

Following is the sample screenshot of the main window

clip_image001[4]

Main Features

· Only one time purchase fee, no further subscription fee

· Batch downloads the symbol lists defined by you.

· Support the historical prices of stocks, indices, and mutual funds publicly traded in US and Canadian markets

· Quotes to download can be unadjusted or split/dividend justed

· GUI and console-only versions

· Support various stock exchanges

· Define your own data format to download

· the price duration could be daily, weekly, or monthly

· Support to download dividend only

· Customize the data file name with postfix option

· Fully automation through command mode

Quick Start

You can start downloading stock data just as easy as following 3 steps:

Step 1: Enter the stock symbol you would like to download next to the “Add Symbol” or you can open the .slist file to open the predefined list of stock symbols going to download. See the Frequently Asked Questions section for .slist file

clip_image002[4]

Step 2: Choose the setting options to meet your data output requirement. See the Settings for the detail

clip_image003[4]

Step 3: Hit the Update Button. The output data will be downloaded to the folder you specified in the settings.

clip_image004[4]

Settings

The following is the sample screenshot of setting options available:

clip_image005[4]

There are 5 setup sections in the setting window:

1. Data Output Setup:

Output Path: Specify the output path that the output data will be downloaded to

2. File Name Setup:

a. File Extension: Specify the file extension name

b. Postfix: Specify the postfix that is going to be added at the end of the file name. By default it is blank, which means no postfix will be added at the end of the default data output file name

3. Format Setup: This section provides you the flexibility to choose the data format you preferred

a. Date Format and Separator: By default the format is YYYYMMDD and separator is “/”. The dates in the output data file will look like “YYYY/MM/DD” (ex: 2001/12/01). You can specify the date format and separator according to your requirement

b. Add Symbol in Front: When this option is checked, the symbol name will be added in front of the output data

c. Reverse Order: By default the output data will have the most recently data as the first row. When this option is checked, the least recently data will be the first row

d. Add Header: When this option is checked, the text specified in the section “Header Content” will be added as the first line in the output data file.

e. Adj for Split/Dividend: Adjust the closing quote according to the split and dividend. By default this option is checked.

4. Header Content: This section provides you the flexibility to define the specific header text you would like to show in the output data file

5. Period Setup: This section provides you the option to specify the range of the historical data you would like to download. Besides that, you can choose daily, weekly, monthly, or dividends only data to download.

a. Time Interval: Specify the period of historical data you would like to download.

b. Custom Date: If this option is checked, you can specify the start date and end date of the historical data to download

Command Mode

Stock Historical Data Download supports command line argument to achieve the fully automation. It is done by reading the symbol list file (.slist), which includes the symbols going to be downloaded, and the setting file (.set), which includes the setting options that are going to be loaded to setting window.

Create/Load Symbol List file

We recommend you to create/load symbol list file (.slist) by following steps:

1. Add the symbols you want to save in the .slist file, then chose File->Save File->Symbol List to save the list into the file

clip_image006[4]

2. To load the saved .slist file, simply choose the file from File->Open->Symbol List

Create/Load Setting File

We recommend you to create/load setting file by following step:

1. In the setting window, choose the setting you would like to save, then click OK

2. In the main window, choose File->Save File-> Setting to save the current setting into .set setting file

3. To load the saved .set file, simply choose the file from File->Open->Setting

Use the Command mode

Stock Historical Data Download supports the command mode by directly activating the exe file “StockDataDownload.exe” from the Windows console. The command mode has the general format:

StockDataDownload.exe -s “slist file” -o “setting file”

“slist file” is the target symbol list file.

“setting file” is the predefined setting file

Frequently Asked Questions

Q1: What is Symbol List File (.slist) and what it can do for you?

A1: A symbol list file is a plain text file with a list of symbols. It helps you load the symbols in the list file at once.

Q2: What is Setting File (.set) and what it can do for you?

A2: A setting file is a plain text file that predefines the setting options. It helps you load the predefined setting options without manually entering those options.

Q3: Why do we need the command mode?

A3: Command mode is a powerful mode to automate the whole process. It allows you to build a script to automate the task after the data files are downloaded without human interruption.

Q4: Why I didn’t see today’s quotes in the data file?

A4: The quotes in the data file are extracted from Yahoo! Finance server. It means Yahoo! Finance server hasn’t updated today’s quote yet.

Q5: Why the quotes are different from what I saw from other sources?

A5: The quotes in the data file are extracted from Yahoo! Finance server. It means the data provided from Yahoo! Finance is different from other sources.

Q6: Why do I see "Not Valid Symbol" message?

A6: This message is a result of a incorrect stock symbol.

Q7: Why do I see “Connection Error” message?

A7: It means the internet is not accessible. Please check the network connection.

Q8: How do I download the stocks quotes not from American exchange (NASDAQ, NYSE or AMEX)?

A8: Please see the Supported Stock Exchanges

Supported Stock Exchanges

The follow table is the summary of the corresponding exchange suffix.

For example: If you want to download the data of “Research In Motion Limited”, which is traded at Toronto Stocks Exchange, the corresponding symbol name would be RIM.TO

Country

Exchange

Suffix

United States

American Stock Exchange (ASE)

.A

 

Boston Stock Exchange (BOS)

.B

 

Nasdaq Stock Exchange (NAS)

.O

 

NYSE Stock Exchanges (NYS)

.N

 

OTC Bulletin Board Market (OBB)

.OB

Argentina

Buenos Aires Stock Exchange (BUE)

.BA

Austria

Vienna Stock Exchange (VIE)

.VI

Australia

Australian Stock Exchange (ASX)

.AX

Brazil

Sao Paolo Stock Exchange (SAO)

.SA

Canada

Montreal Stock Exchange (MON)

.M

 

Toronto Stock Exchange (TOR)

.TO

 

Vancouver Stock Exchange (VAN)

.V

Chile

Santiago Stock Exchange (SGO)

.SN

China

Shanghai Stock Exchange (SHH)

.SS

 

Shenzhen Stock Exchange (SHZ)

.SZ

Denmark

Copenhagen Stock Exchange (CPH)

.CO

France

Paris Stock Exchange (PAR)

.P

Germany

Berlin Stock Exchange (BER)

.BE

 

Bremen Stock Exchange (BRE)

.BM

 

Dusseldorf Stock Exchange (DUS)

.D

 

Frankfurt Stock Exchange (FRA)

.F

 

Hamburg Stock Exchange (HAM)

.H

 

Hanover Stock Exchange (HAN)

.HA

 

Munich Stock Exchange (MUN)

.MU

 

Stuttgart Stock Exchange (STU)

.SG

 

XETRA Stock Exchange (GER)

.DE

Hong Kong

Hong Kong Stock Exchange (HKG)

.HK

India

Bombay Stock Exchange (BSE)

.BO

 

Calcutta Stock Exchange (CAL)

.CL

 

National Stock Exchange of India (NSI)

.NS

Indonesia

Jakarta Stock Exchange (JKT)

.JK

Israel

Tel Aviv Stock Exchange (TLV)

.TA

Italy

Milan Stock Exchange (MIL)

.MI

Korea

Korea Stock Exchange (KSC)

.KS

Malaysia

Kuala Lumpur Stock Exchange (KLS)

.KL

Mexico

Mexico Stock Exchange (MEX)

.MX

New Zealand

New Zealand Stock Exchange (NZE)

.NZ

Netherlands

Amsterdam Stock Exchange (AEX)

.AS

Norway

Oslo Stock Exchange (OSL)

.OL

Peru

Lima Stock Exchange (LMA)

.LM

Singapore

Singapore Stock Exchange (SES)

.SI

Spain

Barcelona Stock Exchange (BAR)

.BC

 

Bilbao Stock Exchange (BIL)

.BI

 

Madrid Fixed Income Market

.MF

 

Madrid SE C.A.T.S. (MCE)

.MC

 

Madrid Stock Exchange (MAD)

.MA

Sweden

Stockholm Stock Exchange (STO)

.ST

Taiwan

Taiwan OTC Exchange (TWO)

.TWO

 

Taiwan Stock Exchange (TAI)

.TW

Thailand

Stock Exchange of Thailand (SET)

.BK

United Kingdom

London Stock Exchange (LSE)

.L

Venezuela

Caracas Stock Exchange (CCS)

.CR

Contact Us

Please visit our website at www.analyxit.com or email us support@analyxit.com for technical support or any question