How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?: Difference between revisions

Latest revision as of 15:42, 18 June 2024

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 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 tab → in the Custom Toolbars select MultiCharts:InsertSymbolData.
Choose required data in the Insert MultiCharts Symbol window and click OK.

Now real-time data should be streaming into the Excel file.

Note 1

The combination of MultiCharts, RTD, Windows and MS Office bit you are using is very important.

Please make sure that one of the following combinations is used:

MS Office 32 + RTD32 + MultiCharts/.NET 32-bit using any 32-bit Operation System

Windows 8.1
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit

Windows 2012 Server Standard
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit

Windows 10
MS Office 32 + RTD32 + MultiCharts/.NET 32-bit
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit

Note 2

RTD is provided only for MultiCharts and MultiCharts .NET, not available for MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition.

The following chart types are not supported:

Volume Delta
Cumulative Delta
Bar Delta
Imbalance 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.

@@ Line 1: / Line 1: @@
-In order to feed an Excel file with real time data from MultiCharts you should use an RTD Server on this PC. Please see the instructions below:
+To feed an Excel file with real time data from MultiCharts, use the RTD Server:
-# Download the RTD Server installer:
+# Download the '''RTD Server''' installer [https://drive.google.com/file/d/1eFpzf08tot-JrgE62sE5Pq6a6JnJFN0r/view?usp=sharing%20|%20RTD%20Server%20for%20MultiCharts%209.0%20and%20higher here].
-#* [https://dl.dropboxusercontent.com/u/26340639/Soft/DO%20NOT%20DELETE%20THIS%20FOLDER/RTD%20Server.zip | RTD Server for MultiCharts],
+# Close MultiCharts and all its applications. Make sure there are no [[MultiCharts Processes]] left in '''Task Manager → Details''' tab → '''Description''' column.
-# Close MultiCharts and all its applications. Run Task Manager and make sure that [[MultiCharts Processes|all MC processes]] are shut down.<div style="background-color: #E3FBE5;">'''Note''': The list of processes your MultiCharts is currently running can be extended depending on the data feed and broker you are currently using.</div>
+# Run '''RTD Server.exe''' and follow the installation wizard.
-# Run RTD Server.exe that you downloaded.
+# Run MultiCharts and create a chart with real-time data.
-# 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.
-# Make a right click on the chart or hit F7 and select the indicator called '''Symbol Data'''. Apply it on a chart.
+# Open up an Excel file → '''Add-ins''' tab → in the Custom Toolbars select '''MultiCharts:InsertSymbolData'''.
-# Open up the Excel file, select Add-Ins Toolbar, then select '''MultiCharts:InsertSymbolData''' from the custom Toolbars section.
+# Choose required data in the '''Insert MultiCharts Symbol''' window and click '''OK'''.
-# Choose required data from a pop-up window and click OK.
-Now real-time data should be streaming into the excel file.
+Now real-time data should be streaming into the Excel file.
+<div class="note-no-title"><div class="note-title">Note 1</div>The combination of '''MultiCharts, RTD, Windows and MS Office bit''' you are using is very important.
+Please make sure that one of the following combinations is used:
+* MS Office 32 + RTD32 + MultiCharts/.NET 32-bit using any 32-bit Operation System<br>
+* '''Windows 8.1'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br>
+* '''Windows 2012 Server Standard'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br>
+* '''Windows 10''' <br> MS Office 32 + RTD32 + MultiCharts/.NET 32-bit<br> MS Office 64 + RTD64 + MultiCharts/.NET 64-bit</div>
+<div class="note-no-title"><div class="note-title">Note 2</div>RTD is provided only for MultiCharts and MultiCharts .NET, '''not available for MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition'''.</div>
+<br>
+The following chart types are '''not supported''':
+* Volume Delta
+* Cumulative Delta
+* Bar Delta
+* Imbalance Delta
+<br>
+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.
 [[Category:FAQ]]
+[[Category:Managing Data]]