Documentation

Quick start:

Before starting you need a : QuoteLink account

There are two types accounts:

  • standard account which offers access to Level I quotes
  • or a full featured professional account: Quotes, Time series, Options chains
  • Install QuoteLink using the username/password that you received by email.
  • Once QuoteLink is installed a green icon qL is added to the icon tray on the right of your PC task bar.

    Installing the new add-ins:

    The new add-ins implement one feed or feature per add-in.
    Run the Installer using the QuoteLink credentials you have received. then open the examples after the add-in for documentation.

    Feed related add-ins:

    • For IQFeed:always install qliq and if you use series install the others. In the icon qL find the menu Login IQFeed
      • qliq - Level I quotes dow, spx, examples
      • qliqS - updating indexed quotes series
      • qliqB - indexed bars at a apst time quotes bars
      • qliqH - historical using time history
      • qliqT - indexed ticks at specified time ticks

    • For IEX:

    • For Ally Invest:

    • For TDA and IB see below.

    Other add-ins:

    QuoteLink installation all in one add-in: for IB and TDA

    • Download and install QuoteLink using the username/password that you received by email.
    • Once QuoteLink is installed a green icon qL is added to the icon tray on the right of your PC task bar. The qL icon holds the menus necessary to control and operate QuoteLink. The same menu can also be accessed using the keyboard by pressing Ctrl and Q keys simultaneously at anytime.
    • Follow the link for your feed:

      Configure Interactive Brokers

      Configure TDAmeritrade

      Configure IQFeed with the all in one ad-in.

    • set your data provider or the preferred data provider, if you have more than one, as the default feed
    • click on the qL icon and choose the menu Worksheets Examples > Basic example . The basic example spreadsheet contains level I quotes that should immediately start updating during market hours.
    • Open a new empty Excel workbook.
    • Type one or more stock symbols (one per row) (symbols are case-sensitive but most symbols use capital letters) and select them using the mouse or the keyboard.
    • display the cell shortcut menu by pressing Ctrl and Q keys simultaneously
    • Select the Quotes menu Quote wizards > Quotes to display a quote list using the current feed (see result ).
    • You can use the menu examples as basis for your own sheets as they cover the main features.

    Keep in mind that formulae do all the work on QuoteLink. The menu wizards are simply a means to write formulae on the spreadsheet. Any other way (automated or manual) of writing the same formulas will produce the same results.


    Finally replace "IB" by your feed (i.e. "TDA", "IB", "MB" or "IQ") on the formula below and try it:


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


    Feed abbreviations are defined when the feed is configured. You can configure multiple abbreviations for the same data provider if you have multiple accounts with that provider.
    If no abbreviation is given as the third argument in a formula then the default feed is used.


    Generic documentation:

    Worksheet formulae

    Options pricing

    Troubleshooting