Quick start

  1. before starting you need a QuoteLink subscription QuoteLink - you have two choices an account with only access to RTD Level I quotes formulas or a full featured professional account.
  2. download and install QuoteLink using the username/password that you received by email.
  3. once QuoteLink is installed a green icon qL appears in the icon tray on the right of your PC task bar. The qL icon holds the menus necessary to control and operate QuoteLink. You can also access it anytime by pressing Ctrl and Q keys simultaneously at anytime.
  4. configure on or more data providers feed using these feed specific instructions
  5. set your data provider or your main data provider as the default feed
  6. click on the qL icon and choose the menu Worksheets Examples > Basic example . This example sheet contain level I quotes that should be updating during market hours if your feed is a streaming one.
  7. Open a new empty Excel workbook.
  8. Type one or more stock symbols (one per row) (symbols are case sensitive most symbols use capital letters) and select them using the mouse or the keyboard.
  9. display the cell shortcut menu by pressing Ctrl and Q keys simultaneously
  10. Select the Quotes menu Quote wizards → Quotes to display a quote list using the current feed (see result ).

All menu wizards paste worksheet formulae on the spreadsheet and do nothing else there are no macros running behind the scenes. The worksheet formulas do all the real work themselves by connecting to the underlying framework and retrieving data. Level 1 RTD formulas have 3 parameters the ticker, the field and the feed abbreviation.

=RTD("quotein.rtd",,"CSCO", "LAST", "IQ")   

Feed abbreviations are defined when the feed is configured. QuoteLink supports many feeds each feed is identified by its abbreviation. If no abbreviation is given as the third argument in a formula then the default feed is used. You can use multiple feeds and, multiple accounts from the same provider at the same time.