How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?
To feed an Excel file with real time data from MultiCharts, use the RTD Server:
- Download the RTD Server installer here.
- Close MultiCharts and all its applications. Make sure there are no MultiCharts Processes left in Task Manager -> Details tab -> Description column.
- Run RTD Server.exe and follow the installation wizard.
- Run MultiCharts and create a chart with streaming real time data.
- Right-click the chart -> Insert Study -> in the Indicator tab select the Symbol Data indicator. Click OK to apply it to the chart.
- Open up an Excel file -> Add-Ins toolbar -> select MultiCharts:InsertSymbolData in the Custom Toolbars section.
- Choose required data from a pop-up window and click OK.
Now real-time data should be streaming into the Excel file.
Please make sure that one of the following combinations is used:
1. MS Office 32 + RTD32 + MultiCharts/.NET 32-bit using any 32-bit Operation System.
2. Windows 8.1
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.
3. Windows 2012 Server Standard
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.
4. Windows 10
MS Office 32 + RTD32 + MultiCharts/.NET 32-bit
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit.
The following chart types are not supported:
- Volume Delta;
- Cumulative Delta;
To stream indicator values into a chart in Excel it is necessary to add the SendPlotsValues command to your indicator code. Then apply this indicator to a chart in MultiCharts and select MultiCharts:InsertIndicatorData in Excel under Add-Ins tab.