How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?: Difference between revisions
From MultiCharts
No edit summary |
No edit summary |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 8: | Line 8: | ||
# 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'''. | ||
<br> | |||
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-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. | <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: | ||
* '''Windows 8.1'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br> | * '''Windows 8.1'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br> | ||
Line 19: | Line 17: | ||
* '''Windows 2012 Server Standard'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br> | * '''Windows 2012 Server Standard'''<br> MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit<br> | ||
* '''Windows 10''' | * '''Windows 10''' <br> MS Office 64 + RTD64 + MultiCharts/.NET 64-bit</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> | <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> | ||
The following chart types are '''not supported''': | The following chart types are '''not supported''': | ||
* Volume Delta | * Volume Delta | ||
* Cumulative Delta | * Cumulative Delta | ||
* Bar Delta | * Bar Delta | ||
* Imbalance Delta | * Imbalance 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. | 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. | ||
Line 35: | Line 31: | ||
[[Category:FAQ]] | [[Category:FAQ]] | ||
[[Category:Managing Data]] | [[Category:Managing Data|L]] |
Latest revision as of 13:25, 17 September 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.
Note 1
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:
- Windows 8.1
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit
- Windows 2012 Server Standard
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit
- Windows 10
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit
Note 2
RTD is provided only for MultiCharts and MultiCharts .NET, not available for MultiCharts .NET Special Edition/MultiCharts .NET64 Special Edition.The following chart types are not supported:
- Volume Delta
- Cumulative Delta
- Bar Delta
- Imbalance 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.