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

From MultiCharts
Jump to navigation Jump to search
 
(30 intermediate revisions by 9 users not shown)
Line 1: Line 1:
−
<div style="background-color: #E3FBE5;">Note: Please make sure that you are using 32-bit version of MultiCharts and 32-bit version of Microsoft Excel</div>
 
  
−
In order to feed Excel file with real time data from MultiCharts you should use RTD Server on this PC. Please see the instruction 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/32572618/RTD%20Server.1.0.32.0.exe |RTD Server 32 bit for MultiCharts 32 bit],
+
# 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 the 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 have 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 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 Excel file. then select Add-Ins Toolbar and 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 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 8.1<br>
 +
 
 +
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>
 +
 
 +
'''3.''' Windows 2012 Server Standard<br>
 +
 
 +
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>
 +
 
 +
'''4.''' 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;
 +
<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:FAQ]]

Latest revision as of 14:11, 16 January 2024

To feed an Excel file with real time data from MultiCharts, use the RTD Server:

  1. Download the RTD Server installer here.
  2. Close MultiCharts and all its applications. Make sure there are no MultiCharts Processes left in Task Manager → Details tab → Description column.
  3. Run RTD Server.exe and follow the installation wizard.
  4. Run MultiCharts and create a chart with real-time data.
  5. Right-click the chart → Insert Study → in the Indicator tab select the Symbol Data indicator. Click OK to apply it to the chart.
  6. Open up an Excel file → Add-ins tab → in the Custom Toolbars select MultiCharts:InsertSymbolData.
  7. Choose required data in the Insert MultiCharts Symbol window and click OK.

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


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.

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.


RTD is provided only for MultiCharts and MultiCharts .NET, will not work in MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition.



The following chart types are not supported:

  1. Volume Delta;
  2. 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.

Retrieved from "https://www.multicharts.com/trading-software/index.php?title=How_to_Feed_Excel_File_With_RT_Data_From_MultiCharts_(Use_RTD_Server)%3F&oldid=11056"