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

17 March 2014

XLQ 5.0 released

 XLQ Quick Links

Download
Program History
Videos

Support
Purchase

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

 

AAII.com
AAII

 


Investment U E-Letter

 




Julie Stav

 

 Useful Links

 
 
 

Resources

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
msn Symbol Lookup http://investing.money.msn.com/investments/find-symbol
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  
   
MSN option symbol day codes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31  
1C 2C 3C 4C 5C 6C 7C 8C 9C AC BC CC DC EC FC GC HC IC JC KC LC MC NC OC PC QC RC SC TC UC VC  
   
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
SymbolYYMMDD(CorP)Price[SMART,OPT,USD]
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
MSN 126.2.MSFT3GKC023000 Always 126.2. / Symbol / 3 for 2013 / G = July Call / KC = 20 (expiry day) / 023000 = $23.00
126.2.SymbolY(option month code)(day code)price
TDAmeritrade CI_072013C67.5 Symbol / _ / 07 for month / 20 for day / 13 for year / C for Call / 67.5 for $67.5
Symbol_MMDDYY(CorP)Price
Yahoo 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
http://www.management-logic.com/toolbox/finance/mpt/
   
   
   
   
   
   

 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 20-Mar-2014.

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