Difference between revisions of "How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?"
(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: | ||
− | + | ||
− | # Download the | + | To feed an Excel file with real time data from MultiCharts, use the RTD Server: |
− | + | # 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. | |
− | # Close MultiCharts and all its applications. | + | # Run RTD Server.exe and follow the installation wizard. |
− | # Run RTD Server.exe | + | # Run MultiCharts and create a chart with real-time data. |
− | # Run MultiCharts and create a chart with | + | # 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'''. |
− | # Open up Excel file | + | # Choose required data in the Insert MultiCharts Symbol window and click OK. |
− | # Choose required data | + | Now real-time data should be streaming into the Excel file. |
− | Now real-time data should be streaming into | + | <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:
- 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.