← Back to X_TRADER® Help Library

X_STUDY® Documentation

Linking to and from Excel

You may link current and historical market values of drawing tools, technical indicators and bar data from X_STUDY to and Excel. Once linked, Excel updates in real-time as new prices are generated in X_STUDY. You can also link values from Excel into X_STUDY as horizontal Level Lines that dynamically update as the values change in Excel. These Level Lines help traders identify significant price levels on their charts.

To link from X_STUDY to Excel,

  1. Right-click the drawing tool or technical indicator that you want to link to Excel.
  2. Select Link to Excel | Current Value (or Previous Value).
  3. Open Excel and navigate to where you want to paste the data.
  4. Right-click the Excel cell and select Paste.

To link from Excel to X_STUDY,

  1. Open Excel and select the cell with the data that you want to link.
  2. Select Format | Cells.
  3. Click the Fill tab and select a cell color.
  4. Right-click the shaded cell and select Copy.
  5. Right-click the X_STUDY chart and select Paste Link. This displays a horizontal Level Line on the chart.