The MarketData folder contains a ready-to-use solution for
The solution is configured for US exchanges.
You may adapt it to load data from exchanges in other countries like UK, Canada, Europe, or Australia.
You may edit symbols in symbols.txt and run the batch file again.
The application will load data for new symbols and reload data for others if the market is open.
You may test the following steps if you have Microsoft SQL Server installed.
That's all. You may add your tickers to symbol files and add batch files to Windows Scheduler to load data automatically.
Do not hesitate to contact us, if you need a solution for your database platform.
|csv||The folder contains output CSV files to load into a database.|
The files are deleted after a successful import.
|cache||The folder contains outputs of the YahooFinanceHistoricalPrices provider (not actual since version 2.2).|
|downloads||The folder contains archives of downloaded data.|
Archives contain data for a single provider and trade date.
Keep these files to have the possibility to reparse the loaded data.
|zip||The folder contains archives of output CSV data.|
You may use these files to import data into a database once again.
If you successfully import data and make a backup of your database, you may delete these files.
|logs||The folder contains log files.|
You may delete these files at any time.
|bin||The folder contains SQL codes and format files used to import CSV files into SQL Server.|
Also, the folder contains SQL codes to create and remove MarketData Database.
|symbols.txt||The file contains symbols for download.|
You may place your tickers into the file using any text editor, or export symbols from your database.
You may create multiple files for different modes.
For example, you may load quotes for 2000 weekly monitored stocks
and daily option data for 200 most actively traded stocks.
|0-run-all.cmd||The batch file executes download and import operations.|
Use this file in Windows Schedule for automatic data download.
|1-export-symbols.cmd||This is a dummy file where you may add commands to export tickers from your database to symbol files.|
|2-download-data.cmd||The batch file executes download operations.|
The file contains commands for loading key statistics, quotes, industries, historical prices, dividends, and options.
|3-import-data.cmd||This file executes import operations.|
It contains calls of the sqlcmd utility to execute SQL scripts from the bin folder.
Edit the sqlcmd command if you have another SQL Server instance or other database credentials.
|bin\clean-data.cmd||This file cleans the loaded data and related files.|
Use it if you want to reset the loaded data completely.
|The format files are used by SQL Server to import CSV files.|
You may edit these files if you need to change column names.
Reflect such changes to SQL scripts in the bin folder.
|SQL scripts used to import CSV files into SQL Server.|
The files contain direct paths to CSV and format files like
Edit such paths if you place the MarketData folder in another location.
|SQL scripts to create and remove MarketData Database.|