MC Trade runs on SQL, a powerful and flexible database structure that makes organizing and retrieving data very easy. For some users, the Reports and Query Tool are more than enough to extract and analyze data from MC Trade. For more advanced users, the SQL Code section of the Query Tool allows you to generate your own SQL Queries and run them against your own data.
Follow these steps to write your own custom SQL:
- Click on the Reports menu and then Query Tool.
- Click Create a New Query (top right).
- Click on the View the SQL Code tab.
- Place a check next to Use my custom SQL and enter your SQL Query in the text box.
- Click Run This Query.
If your SQL query was written correctly, the data grid will populate with information.
If your SQL Query was written incorrectly, you will receive an error message.
Best Practices in Using the SQL Query Tool
If you think you will use the same SQL Query multiple times, save it by clicking Save Query Definition (top right).
If you do not see the features in this article, please contact our sales team to get it enabled.