Quaccess - Download Yahoo! stock quotes into an Access database

Quaccess - Download Yahoo!Finance™ stock quotes into a MS Access™ database

Quaccess Download

Program requirements:

Operating System: Windows XP, VISTA, Windows 7. MS Access does not have to be installed.
For installation into a non-standard directory or installation of more than one instance please read the Installation Details.

Download setup.exe for Quaccess (filesize = 1.3MB)
(Installing over a previous version will not overwrite the existing database)

Download Wealth-Lab 3 & 4 static data adapter (filesize = 0.6MB)

Quaccess is Freeware. (Disclaimer)

If Quaccess has been useful for you and you'd like to support it's further development, a small donation would be much appreciated:

Quaccess Version History


2012-01-16 -	Since the last changes reg. Dow Jones indices, "empty" days were saved when downloading on weekends. That bug is squished now.
2012-01-06 -	This versions has no new or changed features. It only fixes screen display problems which users had, when using enlarged text size (DPI) settings. Like 125% or 150%.
2011-12-11 -	To accomodate the ever higher volume figures of indices like the ^NDX, a change of the volume field type in table "Quotes" became necessary. This new version will take care of it automatically during the first startup. The conversion can fail in case a database has almost reached its max. size of 2GB. The only workaround would be to reomve some data - and try again. Sorry for the inconvenience. Some NASDAQ groups are back again in the predefined groups. Plus some new groups. From now on, saved group CSV and TXT files go into their own directories. I'm giving up on the ^DJI workaround since INDU is dead now as well. But historical ^DJI data and that of other DJ indices will still be available though. Despite the fact that their tickers are invalid for intraday data.
2011-12-03 -	New: Download dividend payment history from Yahoo!. Results get stored in the new table "Dividends". Fixed: Negative volume figures for large-cap stocks. If volume of shares is important to you, delete all historical data (with button 'X' in ChartView). It will be downloaded again during the next update.
2011-09-20 -	Actually there is no new version of Quaccess.exe available. But the demo spreadsheet enclosed (QuaccessLib_Demo.xls) had a VBA sub 'RunAndWait' which failed when trying to open a database located on another drive. That sub is fixed now. There is a bug fix out for the good old Wealth-Lab static data adapter. (See version history down below. Use download link above)
2011-08-26 -	Installer fixed after Win7 users couldn't find their data any more. For more info please read the Installation Details. New: Create and maintain special ticker groups (All Tickers, GroupMembers, Orphans) under "Settings" on the main menu.
2011-07-17 -	Since recently many requests for daily quotes yield crippled data (like date = 1/1/70). This data will be ignored from now on. And hopefully Yahoo! fixes this soon. (Update 2011-08-26: They fixed it in the meantime) New: Optional loading of all historical data for chart display with horizontal scrolling / panning.
2011-06-19 -	Predefined group 'OTCBB' fixed. New: Predefined group 'Other-OTC'. This new group - also called the Pinksheets - has more than 17,000 members. Their tickers have the suffix '.pk' New: Logarithmic chart scale.
2011-02-13 -	Workaround for errors 10054 "Connection reset by peer" during updates. The enclosed sample Excel file now shows how to open Quaccess from Excel and update quotes, while Excel waits until Quaccess has finished.
2010-12-07 -	Adaption to Yahoo! changes in group 'Yahoo! Germany Indices'. The group has 35 members now. Group 'Yahoo! STOXX Indices' no longer available. Yahoo! stopped providing the components.
2010-11-27 -	Group 'Yahoo! Major European Indices' no longer maintained. All of it's components are part of group 'Yahoo! Major World Indices' anyway. Groups MDAX, SDAX, HDAX and all XETRA groups no longer available. Yahoo! stopped providing the components.
2010-10-11 -	One more bug fix regarding the overwriting of previous intraday snapshots.
2010-10-07 -	Bug fix: Each intraday snapshot will now overwrite the previous one. Adaption to Yahoo! changes in the group lists of: Yahoo! Major World Indices Yahoo! Major US Indices Group 'Wilshire 5000 Total Market Index' no longer available. Yahoo! stopped providing the components.
2010-10-02 -	This version has a workaround for the latest problem with the Dow Jones Industrial ticker ^DJI. As can be seen in 'TickerTest', a request of today's data returns 'Missing Symbols List'. What the fix does is, it bluntly replaces the ticker ^DJI with INDU when retrieving today's data. That seems to work fine for now, except the today-volume is totally out of whack though.
2010-06-27 -	Minor bugfixes in 'Edit Groups'.
2010-06-23 -	New: Autosaving of predefined groups as textfiles.
2010-05-15 -	Adaption to changes in 'NASDAQ Biotechnology' group list.
2010-05-02 -	Adaption to changes in 'AMEX' group list.
2010-04-24 -	Adaption to changes in 'Yahoo!World' and 'US Indices'.
2010-02-28 -	Problem with predefined group 'NYSE Composite' fixed.
2009-06-24 -	New: Import and export of tickers via clipboard.
2009-05-16 -	Calculation of 'Vol. vs 3MonthAvgVol.' fixed.
2008-09-06 -	Update of group 'XETRA all share CDAX' fixed.
2008-07-20 -	Overhaul of UpdateGroups. New: Ticker export.
2008-07-06 -	Adaption to Yahoo! MarketCap data format changes
2007-07-18 -	New: Proxy support.
2007-07-09 -	Download speed now 30% faster.
2007-06-02 -	Adaption to Yahoo! changes reg. localized servers.
2007-05-08 -	New: Import of tickers from textfiles. LastDate fixed.
2007-04-03 -	Adaption to Yahoo! date format change.
2005-07-07 -	'Multiple step operation generated errors' during calculation fixed.
2005-06-30 -	Workaround for this new 200 day history data download limit.
2005-06-17 -	Update in batch mode now possible (parameter is 'update').
2005-06-03 -	Overhaul of UpdateGroups after some Yahoo! changes.
2005-05-17 -	Enhanced ActiveX DLL exports latest price data now.
2005-03-09 -	Regserver error 216 during installation now fixed.
2005-03-05 -	A comma in a security name doesn't cause troubles any more.
2005-03-04 -	Overhaul of 'UpdateGroups' after some Yahoo! changes.
2004-11-14 -	QuaccessLib: Auto-disconnect after 5 seconds of non-usage.
2004-11-11 -	New: ActiveX DLL makes key statistics available to Wealth-Lab.
2004-10-06 -	New: Candle charts. Other chart colors.
2004-09-22 -	Missing SEC info of some 'NASDAQ' groups now available.
2004-09-04 -	25 more predefined groups added.
2004-08-31 -	Invalid URL in 'UpdateGroups' ('Major US Indices') fixed.
2004-06-18 -	Vertical chart grid lines now visible again.
2004-06-02 -	History download in 'TickerTest' now visible again.
2004-05-27 -	Error 217 during startup fixed.
2004-05-14 -	Oldest history year possible is now 1930 instead of 1951.
2004-05-12 -	I/O Error 105 bug during downloads fixed.

Wealth-Lab 3 & 4 Static Data Adapter Version History


2011-09-20 -	Group list going blank during 'Create a New DataSource' fixed. (again)
2005-01-29 -	'Access Violation' error during 'Create a New DataSource' fixed.
2004-11-17 -	Group list going blank during 'Create a New DataSource' fixed.
2004-11-14 -	Data loading speed up to 3 times faster; with auto-disconnect.
2004-11-03 -	Data loading speed now faster by about 20%.
2004-10-01 -	Group name selected gets copied into clipboard.
2004-08-31 -	Minor form layout changes.

Software Disclaimer

The user of this software is granted a nonexclusive license to use it solely for internal private or business purposes. The user may not commercially distribute, sublicense, resell, or otherwise transfer for any consideration, or reproduce for any such purposes, the software or any modification or derivation thereof, either alone or in conjunction with any other product or program. Further, the user may not modify the software, other than for its own internal use.

This software is provided to the user "as is". No warranties, either expressed or implied, are made with respect to this software and/or associated materials provided to the user.

Other product and company names mentioned in the software or on this website may be trademarks of their respective owners.