View source for How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?


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:
# Download the RTD Server installer corresponding to your version of MultiCharts:
#* [https://drive.google.com/open?id=0B_aFLJZIlhWvTUtRcEFzRDJjd1k | RTD Server for MultiCharts 8.8 and lower];
#* [https://drive.google.com/open?id=0B_aFLJZIlhWvQ2FwQjMtOTJENm8 | RTD Server for MultiCharts 9.0 and higher];
# 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 that you downloaded. 
# Run MultiCharts and create a chart with streaming real time data.
# Make a right click on the chart or hit F7 and select the indicator called '''Symbol Data'''. Apply it to the chart.
# 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.
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.<br>

'''2.''' Windows XP x64, Windows Vista x64:

MS Office 32 + RTD32 + MultiCharts/.NET 32-bit.<br>
MS Office 32 + RTD64 + MultiCharts/.NET 64-bit.<br>
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit.<br>

'''3.''' Windows 7 x64<br>

MS Office 32 + RTD32 + MultiCharts/.NET 32-bit<br>
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit.<br>

'''4.''' Windows 8.1<br>

MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>

'''5.''' Windows 2012 Server Standard<br>

MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>

'''6.''' Windows 10 

MS Office 32 + RTD32 + MultiCharts/.NET 32-bit <br>
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit.

<br><div style="background-color: #E3FBE5;"> '''RTD is provided only for MultiCharts and MultiCharts .NET, will not work in MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition.</div></div>
<br>
----
<br>

The following chart types are '''not supported''':

# Volume Delta;
# Cumulative Delta;
# Renko with resolution > 1;
# Heikin-Ashi with resolution > 1.
<br>

To get '''indicator values from 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]]