Difference between revisions of "How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?"
(18 intermediate revisions by 7 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: | ||
− | '''1.''' MS Office 32 + RTD32 + MultiCharts 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 | + | '''2.''' Windows 8.1<br> |
− | MS Office | + | MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br> |
− | |||
− | |||
− | '''3.''' Windows | + | '''3.''' Windows 2012 Server Standard<br> |
− | MS Office | + | MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.<br> |
− | |||
− | '''4.''' Windows | + | '''4.''' Windows 10 |
− | MS Office | + | 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:
- Download the RTD Server installer 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.
- Run MultiCharts and create a chart with 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.
- 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.
Now real-time data should be streaming into the Excel file.
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.
The following chart types are not supported:
- Volume Delta;
- 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.