http://www.quotelink.net/dk/ 2010-02-18T20:13:14+00:00 http://www.quotelink.net/dk/ http://www.quotelink.net/dk/lib/images/favicon.ico text/html 2008-10-03T21:26:43+00:00 http://www.quotelink.net/dk/configure_data_feeds Configuring data feeds You need to have a subscription to one or more feed providers please follow instructions for your feed * Configuring DTN IQFeed * Setup OptionsXpress feed * Interactive Brokers setup * TDA Ameritrade Setup * Configure QuoteIN with QuoteTracker text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/configuring_data_feeds Configuring data feeds * Open the feeds configuration dialog box. * If your feed is not listed in the active feeds list click Full List button and add it. * Double click on its line and type the ID / Password you have received from your data vendor * Click OK * Click on your preferred feed and push button 'Set <feed> as Default' * close dialog box text/html 2008-10-28T08:32:01+00:00 http://www.quotelink.net/dk/configuring_interactive_brokers Before starting make sure you have TWS 864.4 or later installed and running properly Prepare TWS * Open TWS * check menu Configure > API > Enable Active X and Socket Clients * menu Configure > Trusted IP Address add 127.0.0.1 (that's a local address on your machine) text/html 2008-12-16T08:15:29+00:00 http://www.quotelink.net/dk/configuring_iqfeed Configuring DTN IQFeed Before starting Make sure: * you have a QuoteIN subscription * you have an IQFeed subscription and that you have on hand IQFeed's ID and password * that QuoteIN is installed * that IQFeed client software is installed text/html 2008-12-16T08:26:17+00:00 http://www.quotelink.net/dk/configuring_optionsxpress Setup OptionsXpress feed Configure OptionsXPress * Login into OptionsXpress site * Click tab Account * Follow link Profile; 3 other tabs will then appear below. * Click on Trading & web Preferences * Find 'Enable Site Access Via Software / XML API' and check it. * Scroll down until the end the page and push button 'Save Changes' text/html 2008-03-12T18:40:16+00:00 http://www.quotelink.net/dk/configuring_quotetracker_feeds Configure QuoteIN with QuoteTracker Before starting * You must be a QuoteTracker's subscriber to use this feature it will not work without it * Make sure that you have QuoteTracker version 3.6.3 or later installed * Make sure that you have QuoteIN version 0.70.1 or later (check using menu QuoteIN > About) * You must have one or more data provider accounts in QuoteTracker text/html 2008-10-03T21:27:08+00:00 http://www.quotelink.net/dk/configuring_tdameritrade TDA Ameritrade Setup * Open the feeds configuration dialog box - click 'qL' icon on the taskbar (if the 'qL' icon is not visible first Start > All programs > QuoteLink to make it appear) * click on the sub menu Feeds * You are in the Active feeds dialog box * Double Click on *TDA Ameritrade streamer* line and input your TDA Ammeritrade User name and Password * press OK it should be accepted without any errors * Set TDA as the default feed * close the dialog box text/html 2008-10-06T13:43:19+00:00 http://www.quotelink.net/dk/creating_quote_lists_with_predefined_quote_wizards Using predefined wizards * Type one or more stock symbols (one per row) * select them using the mouse or the keyboard. * Display the cell shortcut menu by * clicking over the selection with mouse * right button select one of the quote wizards shown. text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/creating_quote_lists_with_predefined_wizards Type one or more stock symbols (one per row) and select them using the mouse or the keyboard. Display the cell shortcut menu by clicking over the selection with mouse right button select one of the quote wizards shown. The following picture shows the result using quotes wizard. Quotes wizard uses a common set of fields using a custom wizard it is possible to show combinations of several feeds and calculations. text/html 2008-10-06T14:00:14+00:00 http://www.quotelink.net/dk/cross_module_examples Publishing data The data model and events are all that matter when working across machines or applications. Start by opening 1 or more Excel instances running in the same or different machines and type this formula: =P(“A_SYMBOL”,”A_FIELD”,”FEED”) text/html 2008-10-03T21:25:48+00:00 http://www.quotelink.net/dk/customizing_quote_lists_with_wizards Creating quote lists with wizards A QuoteIN wizard is an automatic tool to creating repeatedly ranges of cells in a spreadsheet. This is achieve by automatically copying/pasting ranges contained in another document. It works like a template working at the cell level. Wizards can be created automatically from existing quote lists or manually by creating a spreadsheet. The wizard file are saved as a common XLS files and can thus be edited normally using Excel. text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/data_representation_model QuoteLink platform structure QuoteLink is the common platform that unifies the different components by classifying them and creating abstraction layers for each class. Schematic view: EXCEL instances VB.6 AppsCOM apps VB.NET Apps c# Apps Python Apps(IronPython) VSTO ApplicationsRTD Interfaces COM .NET Framework 2.0 QuoteLink platform framework feed adapter 1 feed2 adapter 2......gateway adapter 1...... Feeds are either based in direct connections to external servers or connections to data … text/html 2008-10-03T19:51:27+00:00 http://www.quotelink.net/dk/documentation * QuoteLink standard service * QuoteLink Professional Service text/html 2008-04-23T08:44:18+00:00 http://www.quotelink.net/dk/enabling_quotelink_over_a_lan While working with a LAN one of the machines must be designated as the server. This machine will be the one responsible for holding the configuration file. Create a text file with this path My Documents\QuoteLink\Remote.cfg or Documents\QuoteLink\Remote.cfg (for Vista) containing: text/html 2008-12-16T09:26:29+00:00 http://www.quotelink.net/dk/examples QuoteLink Examples Standard service * Introduction example * A simple portfolio tracker * Currency converter Professional service Examples Built-in options pricing * Simple calculator demonstrating built-in functions VBA * Download Simple Request Example * Download RequestOptions Example * Download Async Example text/html 2008-10-03T16:19:44+00:00 http://www.quotelink.net/dk/feeds Feeds A feed is a network channel providing market data. There are two important feed categories: Streaming feeds and Snapshot feeds. Streaming Feeds A streaming feed is a feed able to send updates over the internet whenever the market changes. text/html 2008-01-25T16:14:39+00:00 http://www.quotelink.net/dk/historical_data_add-in Historical data Make sure you have version 0.74.1 or later EOD data: HD(<symbol>, <field>, <date>, <feed>) 1 Minute: HM(<symbol>, <field>, <date/time>, <feed>) any period multiple of minute: H(<symbol>, <field>, <date/time>, <period>, <feed>) If there are many historical quotes per symbol then it is better to use a series definition formula(SDF) which groups common parameters. The formula 'S' is then used request each quote. text/html 2008-10-07T18:56:01+00:00 http://www.quotelink.net/dk/historical_data_rtd_server Historical data RTD server Make sure you have version 0.74.1 or later EOD data: HD(<symbol>, <field>, <date>, <feed>) 1 Minute: HM(<symbol>, <field>, <date/time>, <feed>) any period multiple of minute: H(<symbol>, <field>, <date/time>, <period>, <feed>) If there are many historical quotes per symbol then it is better to use a series definition formula(SDF) which groups common parameters. The formula 'S' is then used request each quote. text/html 2009-08-10T14:00:30+00:00 http://www.quotelink.net/dk/how_to * Configure IQFeed * Configure OptionsXpress * Configure Interactive Brokers * Configure QuoteTracker feeds * How to use snapshot feeds with QuoteLink * Use Excel 97 with QuoteIN * Excel quick start * Configuring data feeds * update QuoteLink * get tick data in excel * Using QuoteLink with MatLab text/html 2008-09-16T07:24:52+00:00 http://www.quotelink.net/dk/how_to_get_tick_data_in_excel It is possible to have tick data in Excel using QuoteLink however I have noticed that some customers when they try to process tick start by using cell events which don’t work well because of the way Microsoft RTD technology is designed. To understand why, let me first explain how QuoteLink works for the case of Level I quotes. text/html 2008-10-23T09:57:38+00:00 http://www.quotelink.net/dk/how_to_update_quotelink How to Update QuoteLink Tools This is a common scenario: You have been running a version for a while and you want to try/see or check a new version. It is important to minimize any risk caused by the change. The best way to do it is to proceed as follows: text/html 2009-08-16T05:17:34+00:00 http://www.quotelink.net/dk/how_to_use_matlab_with_quotelink Using QuoteLink with MatLab It is possible to import data from QuoteLink into MatLab. Use QuoteLink version ql-0-77-106 or later. for now use MatLab 32 bits edition commands to use at the MatLab prompt: Create a Link object instance. The Link object represents QuoteLink inside MatLab and you need only to do it once text/html 2008-10-03T21:13:49+00:00 http://www.quotelink.net/dk/icon_tray_menu Tray icon menu [ qL icon] Preferences Throttle The throttle value is the shortest time allowed between two updates on the same symbol and same field expressed in milliseconds. The default is set 1 second (1000) and 0 means tick by tick. QuoteIN automatically adjusts speed so that excel never blocks the machine if there is not enough free CPU time a message is displayed in the status window. You will need to increase that interval if you come near to your machine limits when treating great n… text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/introduction * Unordered List Item * Unordered List Item [:wiki:dokuwiki-128.png] FIXME text/html 2008-10-03T20:52:20+00:00 http://www.quotelink.net/dk/level_2_rtd_server Level 2 RTD server The Level 2 RTD server allows you to get Level 2 data in Excel. You may use it to build a traditional customized depth view. The overall structure is extremely fast and thus can show it as reliably as dedicated applications. The work horse formula is: text/html 2008-10-23T14:12:59+00:00 http://www.quotelink.net/dk/limits preliminary Symbol limits All streaming feeds limit the number of symbols. QuoteLink adds a a field QUOTA to show if a symbol is within or without the limit. I also shows 'no quota' in the STATUS field when a field is over the limit. The system works as follows text/html 2008-10-02T06:58:21+00:00 http://www.quotelink.net/dk/links Reproduced with authorization from Chappatte globecartoon.com The following software is used to operate QuoteLink servers. * Debian - Server operating system * Lighttpd - Web server * Dokuwiki - Wiki text/html 2008-10-03T16:30:48+00:00 http://www.quotelink.net/dk/log_application The Log application QuoteLink has a permanent log feature that logs all errors on the platform This errors are most useful in troubleshooting scenarios. The Log can be seen interactively using WinQL application using Log menu or by starting it with 'log' as parameter. text/html 2010-01-30T21:16:06+00:00 http://www.quotelink.net/dk/news Please read Security recommendations. ql.0.77.* February 12, 2010: * ql.0.77.131 * OX: New OSI symbols working February 9, 2010: * ql.0.77.126 * IQ 4.7.* compatibility. Please install both QuoteLink and latest IQFeed 4.7.* * TDA options: corrected problem with options that have strikes that are not whole numbers text/html 2009-08-10T15:41:25+00:00 http://www.quotelink.net/dk/older ql.0.77.* August 10, 2009: * ql.0.77.106 * Added Matrix property to the COM interface to fast import series data into MatLab. <http://www.quotelink.net/dk/how_to_use_matlab_with_quotelink> July 27, 2009: * ql.0.77.101 * QuoteLink is able to create bars with periods less than 1 min back. Use an 's' in the period to mean seconds Example: 1s, 10s. From this version it is also possible to backfill using ticks from IQFeed. text/html 2008-10-04T22:17:47+00:00 http://www.quotelink.net/dk/options_pricing_add-in The options pricing add-in offers offers the possibility to the use extremely fast QuoteLink's options package pricing using cell worksheet functions. There are 2 groups of functions the Black Scholes based and Binomial method based. These formulas are intended to be used as the building blocks of your spreadsheets. These functions are written in native code and they are much faster then any spreadsheet only based equivalents. text/html 2010-02-16T20:36:57+00:00 http://www.quotelink.net/dk/osi Options symbology initiative OptionsXPress <root>^^^<year><month><day><C or P><strike whole 5 digits><strike fraction 3 digits> text/html 2007-12-17T09:16:31+00:00 http://www.quotelink.net/dk/ql_icon The qL icon appears on the right bottom off your PC once QuoteLink is installed. When clicked the menus shown below appear. [ qL icon] text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/quick_start This page explains how to have access to market quotes using QuoteLink through Microsoft Excel * You need a standard or professional subscription * download and install QuoteLink tools using the username/password received by email. * once QuoteLink is installed a new icon qL appears in the tray icon on the right of your PC task bar. The qL icon holds all the menus necessary to control and operate QuoteLink * configure a data provider feed using these feed specific instructions * se… text/html 2008-10-06T14:06:05+00:00 http://www.quotelink.net/dk/quotein_excel_add-in QuoteIN Excel Add-in Manual Getting started * Requirements Configuring feeds You need to have a subscription to one or more feed providers please follow instructions for your feed * Configuring data feeds QuoteIN * Using predefined wizards * Using formulas directly * Creating quote lists with wizards * QuoteIN Menu reference * Tray icon menu text/html 2008-10-03T21:24:23+00:00 http://www.quotelink.net/dk/quotein_menu_commands QuoteIN menu appears with a right mouse button click on a spreadsheet cell. Commands in the cell menu are associated with actions on the current selection. Quote List Contains sub-menus for all the predefined and custom wizards for quotes Templates Contains sub-menus for all the predefined templates and custom templates text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/quotein_menus QuoteIN creates 2 menus in Excel. The first menu is the main menu and is placed in the Excel menu tool bar once QuoteIN has been installed. The second menu is the cell menu. It appears with a right mouse button click on a cell. Commands in the cell menu are associated with actions on the current selection. text/html 2008-10-03T16:27:02+00:00 http://www.quotelink.net/dk/quotelink_applications A QuoteLink application is any application using the QuoteLink platform. A single QuoteLink platform may span over several machines. Typical applications are: * Any user application running on COM API * Any user application running on .NET API * WinQL application * Feed applications * Microsoft Excel becomes a QuoteLink application when it is running the available add-ins QuoteIN or uses RTD interfaces * Full Quote Application text/html 2008-10-03T15:28:40+00:00 http://www.quotelink.net/dk/quotelink_data_model The data model specifies how the the data is represented internally by the platform. QuoteLink uses a tree consisting of nodes which have one or more leafs each leaf may contain other nodes. A data provider for instance is represented by a node whose leafs are symbols, each symbol has a number of Node fields. text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/quotelink_excel_add-ins Add-ins included with the QuoteLink professional service * QuoteIN Excel Add-in Manual * Options pricing add-in * Depth formulas * Historical data * Tick data text/html 2008-10-03T10:17:00+00:00 http://www.quotelink.net/dk/quotelink_platform_structure QuoteLink platform structure QuoteLink is the common platform that unifies the different components by classifying them and creating abstraction layers for each class. Schematic view: EXCEL instances VB.6 AppsCOM apps VB.NET Apps c# Apps Python Apps(IronPython) VSTO ApplicationsRTD Interfaces COM .NET Framework 2.0 QuoteLink platform framework feed adapter 1 feed2 adapter 2......gateway adapter 1...... Feeds are either based in direct connections to external servers or connections to data … text/html 2008-10-03T20:40:50+00:00 http://www.quotelink.net/dk/quotelink_professional_service * Introduction to QuoteLink * QuoteLink framework * QuoteLink data model * QuoteLink concepts * Feeds * QuoteLink applications * The Log application * QuoteLink's Multiple Excel Add-ins * QuoteIN Excel Add-in Manual * Options pricing add-in * Level 2 RTD server * Historical data RTD server * Tick data RTD server * Using Excel RTD Servers separately text/html 2008-10-06T14:10:47+00:00 http://www.quotelink.net/dk/quotelink_standard_service QuoteLink standard service offers Level I quotes for all feeds. (Multiple feeds can be used simultaneously) * QuoteIN Excel Add-in Manual text/html 2008-10-06T14:07:28+00:00 http://www.quotelink.net/dk/requirements Requirements Hardware Requirements * Pentium III 500Mhz 192Mb Memory Software Requirements Operating System versions supported * Windows 2000 * Windows XP * Windows Vista Excel Versions supported * Excel 97 * Excel 2000 * Excel 2002 * Excel 2003 * Excel 2007 text/html 2009-11-21T09:10:28+00:00 http://www.quotelink.net/dk/security Security recommendations It is possible to see hackers increasingly using small business domain names to fake emails. For now they use automated systems that create non-sense messages that are easy to catch. However this could get much worst. They could for instance learn the names of the people working on the sites and pretend to be them. For this reason make sure you understand the following recommendations: text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/start * QuoteLink standard service * QuoteLink Professional Service text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/tick_data_add-in Tick data QuoteLink is able to download past tick data from the server site and to collect current ticks. The data maybe accessed using the historical data formula with 0 as period. The data collection is done by the underlying quotelink platform not by Excel and all ticks are collected. text/html 2008-10-03T20:54:26+00:00 http://www.quotelink.net/dk/tick_data_rtd_server Tick data RTD server QuoteLink is able to download past tick data from the server site and to collect current ticks. The data maybe accessed using the historical data formula with 0 as period. The data collection is done by the underlying QuoteLink platform not by Excel and all ticks are collected. text/html 2009-01-21T20:40:18+00:00 http://www.quotelink.net/dk/troubleshooting QuoteLink trouble shooting Most problems are related with network access, firewalls an anti-virus programs The installer is the program that is directly run form the web page. When it starts it just shows the available versions. When you click install it will access the server and download QuoteLink. Sometimes anti-virus will interfere with this process on that case I suggest you authorize the connection by configuring the firewall anti-virus program. (For a test you may also turn it off) text/html 2008-10-02T06:50:00+00:00 http://www.quotelink.net/dk/use_excel_97_with_quotein QuoteLink works with Excel 97 If you're using Excel 97 make sure both service releases 1, 2 are installed. Free installers from Microsoft: * Service Release 1 * Service Release 2 text/html 2007-12-21T12:11:40+00:00 http://www.quotelink.net/dk/use_snapshot_feeds_with_quotein How to use snapshot feeds with QuoteLink Snapshot feed works a bit like a web page, the data is requested to the feed and since there is no notification when it changes it is necessary to refresh it periodically. You can keep thousands of quotes within a minute using this method. A sophisticated system is used to control if the data effectively was retrieved from the server repeating the request if it fails. text/html 2008-10-06T13:50:19+00:00 http://www.quotelink.net/dk/using_feed_formulas_directly Using formulas directly QuoteIN uses the following fundamental formulas to get the data from the feeds. These can be also directly used or pasted in the cells with any valid automated method P formula (price) =P(<symbol>, <field>, [<feed>]) Where <feed> is a feed abbreviation parameter and it is optional. It specifies the feed where to request the data. Multiple feeds can be used simultaneously. The available feeds must be previously configured!: (read Configuring data feeds). When omit… text/html 2008-10-06T14:19:09+00:00 http://www.quotelink.net/dk/using_rtd_add-ins_separately Using Excel RTD Servers separately QuoteLink Multiple RTD Servers are independent from each other and maybe used together or separately. QuoteLink RTD Server * QLRTD provides the RTD server for quotes * QLSeries provides the RTD server for series (Historical & tick) * L2 provides the RTD server for Level 2 text/html 2008-10-04T21:34:18+00:00 http://www.quotelink.net/dk/using_the_.net_api We will go through a series of examples that will make clear how the API works. For deatils in all methods used please read the Reference documentation. Since you may want to try it at the same time read carefully the following notes they will save you time: text/html 2008-02-20T10:47:07+00:00 http://www.quotelink.net/dk/using_the_com_api QuoteLink offers COM based interfaces to request and access internal data. You may want to try and experiment at the same time read this notes: * To make this example work you need to add a Reference to QL Client 1.1 library. * Also if you have a streaming feed configure it first using the WinQL application and use it in the examples below instead of MSN. * You can use the debugger to inspect the different objects text/html 2008-10-06T13:58:22+00:00 http://www.quotelink.net/dk/what_is_quotelink QuoteLink framework QuoteLink groups data available from different data providers and make it available in a consistent way to different applications. This is achieved using a common framework. Other applications notably Microsoft Excel connect to this framework to present the data to user.