...
Link real time data into Excel
The RTD feature allows user users to link real time data into Excel. KODIAK Excel To use the feature, the KODIAK Excel RTD add-on is required to use the RTD feature. .
| Info |
|---|
Note that KODIAK Excel RTD is not KODIAK Excel. KODIAK Excel provides additional functions and queries as well as more connectivity options. |
Enable RTD feature
1. Enable the RTD feature by clicking Tools in the top bar menu and selecting Enable Excel RTD.
...
2. KODIAK Pro will download a .msi file.
3. Restart Excel.
34. Select the cells from a the Watch list. Right click and select Select Copy RTD Link from the context menu.
45. Open a an Excel sheet , and paste the data from KODIAK Pro.
...
56. Now the data will update live within Excel.
...
The data will only update if KODIAK Pro is open.
Currently RTD links are only supported within data from Watch lists.It is possible to copy RTD from Watch Lists, Indexes and Returns.
...
Here are the links for the RTD download
Install for32 bit Excel
www.kodiak.is/downloads/oms/Kodi.Kodiak.ExcelRTD.Setup.msi
Install for 64 bit Excel
www.kodiak.is/downloads/oms/Kodi.Kodiak.ExcelRTD.SetupX64.msi
Some users need to right click the .msi file and choose Properties and press Unblock.
...
If there is a problem with the formula in Excel.
...
Open up Region Settings and then Additional Settings. Make sure that the List separator matches the Excel format.
...