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
 
(9 intermediate revisions by 4 users not shown)
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://drive.google.com/open?id=0B_aFLJZIlhWvTUtRcEFzRDJjd1k | 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://drive.google.com/open?id=0B_aFLJZIlhWvQ2FwQjMtOTJENm8 | 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.
+
Now real-time data should be streaming into the Excel file.
# 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.
 
<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:
 
Please make sure that one of the following combinations is used:
Line 16: Line 14:
 
'''1.''' MS Office 32 + RTD32 + MultiCharts/.NET 32-bit using any 32-bit Operation System.<br>
 
'''1.''' MS Office 32 + RTD32 + MultiCharts/.NET 32-bit using any 32-bit Operation System.<br>
  
'''2.''' Windows XP x64, Windows Vista x64:
+
'''2.''' Windows 8.1<br>
 
 
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>
 
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>
  
'''5.''' Windows 2012 Server Standard<br>
+
'''3.''' Windows 2012 Server Standard<br>
  
 
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>
 
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br>
  
'''6.''' Windows 10  
+
'''4.''' Windows 10  
  
 
MS Office 32 + RTD32 + MultiCharts/.NET 32-bit <br>
 
MS Office 32 + RTD32 + MultiCharts/.NET 32-bit <br>
Line 49: Line 36:
 
# Volume Delta;
 
# Volume Delta;
 
# Cumulative Delta;
 
# Cumulative Delta;
# Renko with resolution > 1;
 
# Heikin-Ashi with resolution > 1.
 
 
<br>
 
<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.
+
'''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.
  
  

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.