Preconfigured Market Data Database

Preconfigured Market Data Database

The download package contains the preconfigured project to download market data into CSV files.

The package also contains the SQL code, mssql-create-database.sql, to create a Microsoft SQL Server database to import loaded CSV data.

See Data Tables for Yahoo Finance.

Installing Microsoft SQL Server

You may use existing instances of Microsoft SQL Server 2008 or higher.

To use Microsoft SQL Server 2005, change the date and time(0) data types to datetime in the installation script.

You may download, install, and use Microsoft SQL Server Express for free.

It has a limit of a database size in 10 gigabytes that is quite enough.

Use the following link to download Microsoft SQL Server 2014 Express:

https://www.microsoft.com/en-US/download/details.aspx?id=42299

Select and download Express with Tools.

The package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio.

Installing Market Data Database

Start SQL Server Management Studio and open the MarketData\sql\mssql-create-database.sql file.

Press F5 to execute the script.

Removing Market Data Database

Start SQL Server Management Studio and open the MarketData\sql\mssql-remove-database.sql file.

Press F5 to execute the script.