How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?: Difference between revisions
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: | |||
# Download the RTD Server installer | # Download the RTD Server installer: | ||
#* [https://drive.google.com/file/d/1eFpzf08tot-JrgE62sE5Pq6a6JnJFN0r/view?usp=sharing | RTD Server for MultiCharts 9.0 and higher]; | #* [https://drive.google.com/file/d/1eFpzf08tot-JrgE62sE5Pq6a6JnJFN0r/view?usp=sharing | RTD Server for MultiCharts 9.0 and higher]; | ||
# Close MultiCharts and all its applications. Run Task Manager and make sure that [[MultiCharts Processes|all MC processes]] are shut down.<div style="background-color: #E3FBE5;">'''Note''': The list of processes your MultiCharts is currently running can be extended depending on the data feed and broker you are currently using.</div> | # Close MultiCharts and all its applications. Run Task Manager and make sure that [[MultiCharts Processes|all MC processes]] are shut down.<div style="background-color: #E3FBE5;">'''Note''': The list of processes your MultiCharts is currently running can be extended depending on the data feed and broker you are currently using.</div> | ||
# Run RTD Server.exe | # Run RTD Server.exe and follow the installation wizard. | ||
# Run MultiCharts and create a chart with streaming real time data. | # Run MultiCharts and create a chart with streaming 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 | # Open up an Excel file -> Add-Ins toolbar -> select '''MultiCharts:InsertSymbolData''' in the Custom Toolbars section. | ||
# Choose required data from a pop-up window and click OK. | # Choose required data from a pop-up window and click OK. | ||
Now real-time data should be streaming into the | Now real-time data should be streaming into the Excel file. | ||
<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: |
Revision as of 12:13, 21 December 2022
To feed an Excel file with real time data from MultiCharts, use the RTD Server:
- Download the RTD Server installer:
- Close MultiCharts and all its applications. Run Task Manager and make sure that all MC processes are shut down.Note: The list of processes your MultiCharts is currently running can be extended depending on the data feed and broker you are currently using.
- Run RTD Server.exe and follow the installation wizard.
- Run MultiCharts and create a chart with streaming 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 toolbar -> select MultiCharts:InsertSymbolData in the Custom Toolbars section.
- Choose required data from a pop-up 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 XP x64, Windows Vista x64:
MS Office 32 + RTD32 + MultiCharts/.NET 32-bit.
MS Office 32 + RTD64 + MultiCharts/.NET 64-bit.
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit.
3. Windows 7 x64
MS Office 32 + RTD32 + MultiCharts/.NET 32-bit
MS Office 64 + RTD64 + MultiCharts/.NET 64-bit.
4. Windows 8.1
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.
5. Windows 2012 Server Standard
MS Office 2013 (x64) + RTD64 + MultiCharts/.NET 64-bit.
6. 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 get indicator values from 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.