Quaccess  -  download stock quotes into an Access database         

Quaccess Features

This free software downloads historical, end-of-day and intraday snapshot data from Yahoo!Finance.
Price open, high, low, close, volume and some key statistics

Calculates some more statistics.

Stores data in standard Microsoft Access MDB files (no encryption).

Automatic filling of holiday gaps.

Ticker symbols of stocks can be imported from text files or manually entered into groups. There is no limit in the number of user defined ticker groups and there is no limit in the number of tickers per group. One and the same ticker symbol in several groups is possible. During download the data of this ticker is downloaded only once.

Maintains predefined ticker groups via NASDAQ and Yahoo! Finance

For flexible download management, groups can be arranged in a tree-like structure and activated/deactivated with a few mouse clicks.

Data table with quick chart (bars or candles).

The tickers in the data table can be sorted or grouped by all key statistics.

Easy search for tickers or company names.

Data inspector / editor

Update in batch mode possible. (add parameter "update")

Static data adapter interface for Wealth-Lab available.

ActiveX DLL makes the latest price data and key statistics available to Excel, Wealth-Lab (or any other program that can embed ActiveX objects). This DLL and instructions on how to use it, are included in the Quaccess setup.

Quaccess stores the "Adjusted Close" as provided by Yahoo! but does not detect stock splits or dividend adjustments. In case of such events, it is up to the user to delete all (now invalid) history data of the stocks concerned and thus enforce a history data refresh.

Screen Shots

Main Menu:
 

Update Groups:
 

Edit Groups:
 

View Charts:

View Data:
 

 Ticker Test:
 

Quaccess downloads the following key statistics:

Full Name
Market Cap
EPS
EPS Estimate
PE
PE Growth
PPS
Dividend
Yield
Sales
EBITDA
Short Ratio
52 Week Low
52 Week High
Target Estimate 1 Year
Average Volume 3 Months
Exchange
Currency

Additionally Quaccess calculates the following statistics:

% Day Change
% Streak1 (The greater of Close-Low or High-Close)
% Average True Range of the last 60 days
Todays Volume vs Average Volume 3 Month
EPS Estimate vs EPS
Target Estimate 1 Year vs Current Price
Current Price vs 52 Week Range

The following ticker groups are predefined and maintained by Quaccess:

Copyright(c) 2003-2010  www.quaccess.com  All rights reserved.