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
(Created page with "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: # Download the required version of RTD...")
 
 
(32 intermediate revisions by 10 users not shown)
Line 1: Line 1:
−
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:
+
 
−
# Download the required version of RTD Server installer:
+
To feed an Excel file with real time data from MultiCharts, use the RTD Server:
−
#* [https://dl.dropboxusercontent.com/u/32572618/RTD%20Server.1.0.32.0.exe |RTD Server 32 bit for MultiCharts 32 bit],
+
# 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.33.0_x64.exe |RTD Server 64 bit for MultiCharts 64 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"