Readme.txt

The resource files include seven sql files, one SSRS project folder (Comparison of Trading Rule Gain_Loss), ten csv files, and two txt files.

This readme.txt file is meant to be the first file that you read and use.  It provides an overview of the tip's resources.

The other txt file (URLs_for_securities.txt) includes the 10 URLs for downloading csv files from Google Finance with ohlcv stock historical data.  If you prefer to bypass downloading the data, the ten csv files already include the data downloaded from Google Finance for the tip.

It is recommended that you create a database named stock_price_histories_trades on the server instance.  This is important for selected sql script files as well as the SSRS project.  One sql file named sql to create stock_price_histories_trades db.sql can create the database for you.

Four sql files correspond to the four long scripts in the article importing, pre-processing, and implementing the rising-stock and buy_low models.  This sql files should be run in the following order at least initially:
* import_downloaded_data_into_SQL_Server.sql
* compute_trade_inputs.sql
* compute_buy_and_sell_recommendations.sql
* create_and_populate_gain_loss_tables.sql

Two additional sql files generate result sets for screen shots in the tip.  In order of display, these sql files are:
* trades in 2016 for ulta and crus.sql
* gains_losses in 2016 for ulta and crus

The SSRS project folder is named Comparison of Trading Rule Gain_Loss.  The project in the folder references the stock_price_histories_trades database to create the three reports described in the tip.

