1,102
edits
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
To feed an Excel file with real time data from MultiCharts, use the RTD Server: | 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]. | # 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. 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 '''RTD Server.exe''' and follow the installation wizard. | ||
# Run MultiCharts and create a chart with real-time data. | # 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. | # 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 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. | # Choose required data in the '''Insert MultiCharts Symbol''' window and click '''OK'''. | ||
Now real-time data should be streaming into the Excel file. | Now real-time data should be streaming into the Excel file. | ||
<div class="note">The combination of '''MultiCharts, RTD, Windows and MS Office bit''' you are using is very important. | <div class="note-no-title"><div class="note-title">Note 1</div>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 21: | Line 21: | ||
* '''Windows 10''' <br> MS Office 32 + RTD32 + MultiCharts/.NET 32-bit<br> MS Office 64 + RTD64 + MultiCharts/.NET 64-bit</div> | * '''Windows 10''' <br> MS Office 32 + RTD32 + MultiCharts/.NET 32-bit<br> MS Office 64 + RTD64 + MultiCharts/.NET 64-bit</div> | ||
<div class="note">RTD is provided only for MultiCharts and MultiCharts .NET, '''not available for MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition'''.</div> | <div class="note-no-title"><div class="note-title">Note 2</div>RTD is provided only for MultiCharts and MultiCharts .NET, '''not available for MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition'''.</div> | ||
<br> | <br> | ||
The following chart types are '''not supported''': | The following chart types are '''not supported''': | ||
Line 29: | Line 28: | ||
* Cumulative Delta | * Cumulative Delta | ||
<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. | |||
[[Category:FAQ]] | [[Category:FAQ]] | ||
[[Category:Managing Data]] | [[Category:Managing Data]] |