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
 
(6 intermediate revisions by 3 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=1N_JEbW2O35uE9c7_S1Sr5vVS7RoIeqVV | 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 and follow the instalaltion wizard.  
+
# 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, click Insert Study, select Indicator tab, or just hit F7, and select the indicator called '''Symbol Data'''. Click OK button to 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 51: Line 38:
 
<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.

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"