Tweet
I'm pleased to announce the public beta test of QLink 3.0. We've taken a new approach with QLink 3.0 by using an all-new data engine and streaming protocol (RTD). We've also chosen to no longer use arrays when requesting historical bars in favor of creating individual data links for each cell. This allows for more flexibility when referencing various cells in other areas of your spreadsheets.
Because QLink 3.0 uses new technology, the cell syntax has changed. The good news for all QLink 2.0 users is that we have a built-in conversion tool to change QLink 2.0 arrays to their RTD counterparts in QLink 3.0 format (Click "Convert from QLink 2" under the Interactive Data RTD menu.)
Another benefit of QLink 3.0 and the use of RTD is cell referencing. This allows to you code QLink cells to point to data in other cells to make requests. For example, instead of hard-coding a cell like...
=RTD("esrtd",,"IBM","Last")
...you can reference other cells for the symbol and header information:
=RTD("esrtd",,A2,B1)
Once you have these cells built, you could edit the symbol or columns on the fly via the Symbol column or across the top column header area.
QLink 3.0 is installed separately from QLink 2.0, so you can run them together at the same time if needed. This makes it nearly risk-free to try out 3.0. We have run 3.0 through a battery of tests internally, however this is still an initial beta release. Be sure to back-up your spreadsheets in the 2.0 format before converting to 3.0's RTD format to ensure no data is lost.
Download QLink 3.0 Beta
Cell Referencing Sample
Please post your feedback / questions in this forum.
Because QLink 3.0 uses new technology, the cell syntax has changed. The good news for all QLink 2.0 users is that we have a built-in conversion tool to change QLink 2.0 arrays to their RTD counterparts in QLink 3.0 format (Click "Convert from QLink 2" under the Interactive Data RTD menu.)
Another benefit of QLink 3.0 and the use of RTD is cell referencing. This allows to you code QLink cells to point to data in other cells to make requests. For example, instead of hard-coding a cell like...
=RTD("esrtd",,"IBM","Last")
...you can reference other cells for the symbol and header information:
=RTD("esrtd",,A2,B1)
Once you have these cells built, you could edit the symbol or columns on the fly via the Symbol column or across the top column header area.
QLink 3.0 is installed separately from QLink 2.0, so you can run them together at the same time if needed. This makes it nearly risk-free to try out 3.0. We have run 3.0 through a battery of tests internally, however this is still an initial beta release. Be sure to back-up your spreadsheets in the 2.0 format before converting to 3.0's RTD format to ensure no data is lost.
Download QLink 3.0 Beta
Cell Referencing Sample
Please post your feedback / questions in this forum.
Comment