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 corresponding to your version of MultiCharts:
+# 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/27918922/Wiki/RTD_Server_8_8_lower.zip | RTD Server for MultiCharts 8.8 and lower];
+# Close MultiCharts and all its applications. Make sure there are no [[MultiCharts Processes]] left in '''Task Manager → Details''' tab → '''Description''' column.
-#* [https://dl.dropboxusercontent.com/u/27918922/Wiki/RTD_Server_9_0_higher.zip | RTD Server for MultiCharts 9.0 and higher];
+# Run '''RTD Server.exe''' and follow the installation wizard.
-# 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 MultiCharts and create a chart with real-time data.
-# Run RTD Server.exe that you downloaded.
+# Right-click the chart → '''Insert Study''' → in the '''Indicator''' tab select the '''Symbol Data''' indicator. Click '''OK''' to apply it to the chart.
-# Run MultiCharts and create a chart with streaming real time data.
+# Open up an Excel file → '''Add-ins''' tab → in the Custom Toolbars select '''MultiCharts:InsertSymbolData'''.
-# Make a right click on the chart or hit F7 and select the indicator called '''Symbol Data'''. Apply it to the chart.
+# Choose required data in the '''Insert MultiCharts Symbol''' window and click '''OK'''.
-# Open up the Excel file, select Add-Ins Toolbar, then select '''MultiCharts:InsertSymbolData''' from 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.
-<br><div style="background-color: #E3FBE5;">'''Note:''' The combination of '''MultiCharts, RTD, Windows and MS Office bit''' you are using is very important. You need to make sure that you have one of the following combinations:
-'''1.''' MS Office 32 + RTD32 + MultiCharts 32-bit using any 32-bit Operation System.<br>
+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:
-'''2.''' Windows XP x64, Windows Vista x64:
+* MS Office 32 + RTD32 + MultiCharts/.NET 32-bit using any 32-bit Operation System<br>
-MS Office 32 + RTD32 + MultiCharts 32-bit<br>
+* '''Windows 8.1'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br>
-MS Office 32 + RTD64 + MultiCharts 64-bit<br>
-MS Office 64 + RTD64 + MultiCharts 64-bit<br>
-'''3.''' Windows 7 x64<br>
+* '''Windows 2012 Server Standard'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br>
-MS Office 32 + RTD32 + MultiCharts 32-bit<br>
+* '''Windows 10''' <br> MS Office 32 + RTD32 + MultiCharts/.NET 32-bit<br> MS Office 64 + RTD64 + MultiCharts/.NET 64-bit</div>
-MS Office 64 + RTD64 + MultiCharts 64-bit.<br>
-</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]]