Difference between revisions of "How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?"
Line 2: | Line 2: | ||
In order to feed an Excel file with real time data from MultiCharts you should use an RTD Server on this PC. Please see the instructions below: | In order to feed an Excel file with real time data from MultiCharts you should use an RTD Server on this PC. Please see the instructions below: | ||
# Download the RTD Server installer corresponding to your version of MultiCharts: | # Download the RTD Server installer corresponding to your version of MultiCharts: | ||
− | #* [https:// | + | #* [https://drive.google.com/open?id=0B_aFLJZIlhWvTUtRcEFzRDJjd1k | RTD Server for MultiCharts 8.8 and lower]; |
− | #* [https:// | + | #* [https://drive.google.com/open?id=0B_aFLJZIlhWvQ2FwQjMtOTJENm8 | 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 that you downloaded. | # Run RTD Server.exe that you downloaded. |
Revision as of 12:16, 2 June 2016
In order to feed an Excel file with real time data from MultiCharts you should use an RTD Server on this PC. Please see the instructions below:
- Download the RTD Server installer corresponding to your version of MultiCharts:
- 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 that you downloaded.
- Run MultiCharts and create a chart with streaming real time data.
- Make a right click on the chart or hit F7 and select the indicator called Symbol Data. Apply it to the chart.
- Open up the Excel file, select Add-Ins Toolbar, then select MultiCharts:InsertSymbolData from 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.
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.