Home        XLQ Overview        Download        Purchase        Screen Shots        Support        FAQ        History        Comments Resources

1 February 2015

XLQ 5.2 released

 XLQ Quick Links

Program History


Support or Questions:

Special Offer

xlqPlus = $149.00
xlqLite = $89.00

1 year of free upgrades included

XLQ Recommended in Paul King's latest book


XLQ Recommended in Van Tharp's book

Definitive Guide to Position Sizing

XLQ Users Forum
Click here to join xlqusers
Click to join xlqusers

XLQ is Recommended and Used by:


Steve Sjuggerud and DailyWealth


Van Tharp and the International Institute of Trading Mastery



Stansberry and Associates




Investment U E-Letter


Julie Stav





Under Construction

This page will take shape based on user feedback.

It will grow to hopefully become a valuable resource to find information on how others are using xlq, and become a quick reference for xlq users for useful information (either directly related to xlq or supplementing it).

Please email me your suggestions as well as any information on spreadsheets etc. you may wish to share.

If you have an application or spreadsheet etc. that uses XLQ and would like other users to know about it, send me an email with the details and I will include it on this page.
Page Index

Symbol Information Information on finding and constructing symbols
3rd Party Links Links to user provided spreadsheets and examples, including products using xlq, or formulae used in xlq

Symbol information  
InteractiveBrokers Symbol Information http://www.interactivebrokers.com/en/p.php?f=products
IQFeed Symbol Lookup http://www.iqfeed.net/symbolguide/index.cfm?symbolguide=lookup&displayaction=support&section=guide&web=iqfeed
(From this page, it is also possible to download a text file containing all symbols with descriptions.)
Yahoo Symbol Lookup http://finance.yahoo.com/lookup?s=a
Google Finance Symbol Lookup https://www.google.com/finance
S&P index information http://www.standardandpoors.com/indices/main/en/us
requires free registration to access various excel downloads, including constituents, dividend information
Option Month Codes
  Calls Puts  
January A M  
February B N  
March C O  
April D P  
May E Q  
June F R  
July G S  
August H T  
September I U  
October J V  
November K W  
December L X  
Option Symbols
InteractiveBrokers UPS 130720C00092500[SMART,OPT,USD] Symbol taking 6 spaces. For UPS, 3 spaces after, for MSFT 2 spaces after etc./
13 for 2013 / 07 for month / 20 for day / C for Call / 00092500 = $92.5
IQFeed IBM1319V190 Symbol / 13 for year / 19 for expiry date / V = October Put / 190 = $190
SymbolYYDD(option month code)Price  $30.50 entered as 30.5
TDAmeritrade CI_072013C67.5 Symbol / _ / 07 for month / 20 for day / 13 for year / C for Call / 67.5 for $67.5
Yahoo not available  
Google not available  
3rd Party Links (QMatix has no affiliation with any link. Content may be useful, but has not been validated or endorsed.)
ConnorsRSI Guidebook Guidebook and explanation on using ConnorsRSI included since xlq 5.0. Provided by Connors Research
Modern Portfolio Theory Example covering Modern Portfolio Theory (MPT) /  (Mean-Variance / Markowitz Model), includes free xlq spreadsheet

 If you require further information or have any suggestions please contact:  webmaster@QMatix.com

All other product names mentioned herein are trademarks or registered trademarks of their respective owners.

This page was last updated on 13-Feb-2015.

Copyright 2000 - 2015 Leo van Rijswijk
All Rights Reserved
(privacy policy)