Difference between revisions of "How to Feed Excel File With RT Data From MultiCharts (Use RTD Server)?"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
# Run RTD Server.exe that you downloaded. | # Run RTD Server.exe that you downloaded. | ||
# Run MultiCharts and create a chart with streaming real time data. | # 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 | + | # 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. | # 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. | # Choose required data from a pop-up 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. | ||
+ | <br><div style="background-color: #E3FBE5;">'''Note:''' The combination of '''MultiCharts, RTD, Windows and MS Office bit''' you are using is very important. You need to make sure that you have one of the following combination: | ||
+ | |||
+ | '''1.''' Office 32 + RTD32 + MC 32 using any 32-bit Operation System.<br> | ||
+ | |||
+ | '''2.''' Windows XP x64, Windows Vista x64: | ||
+ | |||
+ | MS Office 32 + RTD32 + MC 32<br> | ||
+ | MS Office 32 + RTD64 + MC 64<br> | ||
+ | MS Office 64 + RTD64 + MC 64<br> | ||
+ | |||
+ | '''3.''' Windows 7 x64<br> | ||
+ | |||
+ | MS Office 32 + RTD32 + MC 32<br> | ||
+ | MS Office 64 + RTD64 + MC 64<br> | ||
+ | |||
+ | </div> | ||
+ | |||
[[Category:FAQ]] | [[Category:FAQ]] |
Revision as of 16:18, 4 February 2015
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.
Note: The combination of MultiCharts, RTD, Windows and MS Office bit you are using is very important. You need to make sure that you have one of the following combination:
1. Office 32 + RTD32 + MC 32 using any 32-bit Operation System.
2. Windows XP x64, Windows Vista x64:
MS Office 32 + RTD32 + MC 32
MS Office 32 + RTD64 + MC 64
MS Office 64 + RTD64 + MC 64
3. Windows 7 x64
MS Office 32 + RTD32 + MC 32
MS Office 64 + RTD64 + MC 64