How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?: Difference between revisions
From MultiCharts
How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)? (view source)
Revision as of 14:11, 16 January 2024
, 16 Januaryno edit summary
No edit summary |
No edit summary |
||
(6 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
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]. | ||
# Close MultiCharts and all its applications. Make sure there are no [[MultiCharts Processes]] left in Task Manager → Details tab → Description column. | |||
# Run RTD Server.exe and follow the installation wizard. | |||
# Close MultiCharts and all its applications. | # Run MultiCharts and create a chart with real-time data. | ||
# Run RTD Server.exe | # 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 | # Open up an Excel file → Add-ins tab → in the Custom Toolbars select '''MultiCharts:InsertSymbolData'''. | ||
# | # Choose required data in the Insert MultiCharts Symbol window and click OK. | ||
# Open up | Now real-time data should be streaming into the Excel file. | ||
# Choose required data | |||
Now real-time data should be streaming into the | |||
<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 | '''2.''' Windows 8.1<br> | ||
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<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> | MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br> | ||
''' | '''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 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. | |||