Excel integration with TT
Excel linking overview
TT supports linking from Microsoft Excel spreadsheets to a variety of TT widgets so you can leverage spreadsheet data. If you use spreadsheets to drive your trading strategies, you can feed the results of your spreadsheet calculations into TT and the widgets will update automatically when your spreadsheet calculations change.
You can use Excel links in the following widgets:
- MD Trader®
- Autotrader
Before you begin
To link from Excel spreadsheets, you first need to set up TT workspaces and Microsoft Excel 2010 or higher.
Alerts and messages displayed when the Excel and TT connection is disrupted
When you launch algos that use linked data from the Excel connection, TT requires the connection to be established during the life of the algo. As a safety precaution, TT automatically pauses all running algos with Excel links if the connection is broken while the workspace is open. If you close the workspace, however, the algos will not be paused and will continue to run.
When you close Excel
If you exit the Excel application while an algo using links is running, TT displays an alert dialog.
When you close widgets
The Autotrader or Algo Dashboard widgets keep track of algos that rely on Excel links, so the widget that launches an algo must remain open for the algo to continue running. If you try to close it while algos are running, TT displays the following dialog to confirm your choice.
When you close the workspace
If you try to close a workspace that contains running algos with Excel links, TT displays a dialog similar to the following.
Caution If you choose to Leave this Page, the workspace closes. However, the algos will not be paused and will continue to run. Also, the linked values will be converted to static values and will not change while the algos continue to run.