How to Populate a Trading Database with Refinitiv, Excel, and SQL Server Concocting trading strategies is an exciting and intellectually rewarding activity for many self‑directed traders and trading analysts. But before you risk capital or recommend a strategy to others, it’s highly beneficial to test your ideas against reliable historical data. A trading database or sometimes several, depending on your research goals, is the foundation for evaluating which strategies return consistent outcomes across one or several trading environments. This post demonstrates a practical, hands‑on framework for building a trading database using Refinitiv data (now part of LSEG Data & Analytics), Excel, and SQL Server to populate a trading database. LSEG Data & Analytics is one of the largest global data providers. Their data is used by banks, hedge funds, asset managers, academic researchers and the STOCKHISTORY function in Excel. Therefore, self-directed traders ...