Security Trading Analytics

How to Populate a Trading Database with Refinitiv, Excel, and SQL Server—Update 1 The Excel STOCKHISTORY function downloads historical market data—such as stock prices and index values—directly into Excel worksheets from LSEG Data & Analytics (formerly Refinitiv).  The “ How to Populate a Trading Database with Refinitiv, Excel, and SQL Server ” post summarizes and demonstrates a three-step process for building a data source inside SQL Server for historical stock  prices and/or indexes.  The three steps are as follows. Populate one worksheet tab per ticker with historical prices using Excel’s STOCKHISTORY function. Save each worksheet tab as a CSV file—one CSV per ticker. Bulk insert the CSV files into a tall SQL Server table indexed by ticker and date. While the three steps worked when properly executed, it was found that Excel formatting issues could lead to processing errors if not manually resolved.  Additionally, the T-SQL code in the third step required ...

  Comparative Market Performance for a Buy-Sell Model Versus a Buy-and-Hold Strategy for Eight Tickers The last couple of Security Trading Analytics blog posts introduced and examined the logic of a buy-sell model based on close prices and two exponential moving averages (EMAs).  The first post pulled data from the Google Finance site and showed how to implement the model manually within a Google Sheets workbook for two tickers (SPY and SPXL) over a couple of different timeframes.  The second post illustrated how to use T-SQL to programmatically implement the buy-sell model and perform backtests from their original close price with a Google Sheets workbook of the model for eight tickers (SPY, SPXL, QQQ, TQQQ, GOOGL, MSFT, NVDA, and PLTR).  The current post compares the market performance of the buy-sell model to a buy-and-hold strategy for the eight tickers in the second post.  All eight tickers in this post are compared from the first trading date in 20...