The MarketData folder contains a ready-to-use solution for
The solution is configured for US exchanges.
You can adapt it to load data from exchanges in other countries like UK, Canada, Europe, or Australia.
You can 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 can test the following steps if you have Microsoft SQL Server installed.
That's all. You can 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 can use these files to import data into a database once again.
If you successfully import data and make a backup of your database, you can delete these files.
|logs||The folder contains log files.|
You can 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 can place your tickers into the file using any text editor, or export symbols from your database.
You can create multiple files for different modes.
For example, you can 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 can 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 can 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.|