# HELP! QQQQ options unavailable in database

**URL:** <https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807>\
**Category:** C2\
**Created:** [April 15, 2010, 9:38am UTC](https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807 "2010-04-15T09:38:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![DeanPignon](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/deanpignon/32/308_2.png) [@DeanPignon](https://forums.collective2.com/u/DeanPignon)\
**Post date:** [April 15, 2010, 9:38am UTC](https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807/1 "2010-04-15T09:38:21Z")

</div>

Hi Matthew,  
  
I am trying to place a trade with QQQQ Jan2012 40 puts but the trade entry screen shows only a very limited number of expiry months. So I constructed the code myself (QQQ1220M40) but then I get an error that the code is unrecognised in the database.  
  
  
  
Please can you fix this soon. I was hoping to place a trade on the open but I cannot, so now the earlier the better.

---

<div class="post-metadata">

**Author:** ![DeanPignon](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/deanpignon/32/308_2.png) [@DeanPignon](https://forums.collective2.com/u/DeanPignon)\
**Post date:** [April 16, 2010, 6:49am UTC](https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807/2 "2010-04-16T06:49:25Z")

</div>

OK, I have found the code to be “WD1221M40” but it is a pain to construct the code as the lookup function in C2 does not have any options beyond six months in the future so I had to find the “WD” prefix symbol elsewhere.  
  
  
  
This new option symbolism has turned out to be worse than before - at least before I could look up the symbol anywhere and then copy&paste into C2 or into my broker trade screen, whereas now different quote websites, brokers and C2 have slightly different ways of constructing the code, or no code at all! For instance, optionsXpress doesn’t display any code that can be copied elsewhere and the C2 code is different from Yahoo Finance and Marketwatch.  
  
  
  
What logic turns the “QQQ” prefix into “WD” for 2012 LEAPS??  
  
  
  
Dean.

---

<div class="post-metadata">

**Author:** ![MatthewKlein](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/matthewklein/32/25317_2.png) [@MatthewKlein](https://forums.collective2.com/u/MatthewKlein)\
**Post date:** [April 16, 2010, 8:04am UTC](https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807/3 "2010-04-16T08:04:17Z")

</div>

Funny you should ask.  
  
  
  
The Options Symbology Initiative (OSI) – this big effort by the options industry to change their symbols to something more rational – is actually occurring in two phases. The first phase introduced the long symbols which contain a root, strike, expiration, and put/call information in very verbose way. The second phase (not yet completed) is designed to rationalize the root symbols so that the roots in options will exactly match the stock symbols in question. No more having to look up some random string in order to signify a stock symbol that is completely different.  
  
  
  
I think the second phase of OSI is being completed over the next few months. If anyone knows more about this (or wants to correct any of my mis-information), please add to this thread.

---

<div class="post-metadata">

**Author:** ![AnonymousAnonymous](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@AnonymousAnonymous](https://forums.collective2.com/u/AnonymousAnonymous)\
**Post date:** [April 20, 2010, 11:28am UTC](https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807/4 "2010-04-20T11:28:00Z")

</div>

I’m going to be using [collective2.com](http://collective2.com) to test a computer AI for trading based on technical analysis. I need to construct strings for both call and put options for stock index futures (Nasdaq Composite, S&P500, Dow Jones Industrial, etc.) trading on the CME, with the expiration date and strike price occasionally varying. However, as has been mentioned in this thread, C2 doesn’t have the same symbol string conventions as various other sources. Where is all of this documented, and how can I verify the meaning of a symbol string before entering a trade into C2? I especially don’t want to buy a call option when I mean to buy a put option, but I generally want to make sure the strings mean what I intend.

---

<div class="post-metadata">

**Author:** ![DeanPignon](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/deanpignon/32/308_2.png) [@DeanPignon](https://forums.collective2.com/u/DeanPignon)\
**Post date:** [April 21, 2010, 5:40am UTC](https://forums.collective2.com/t/help-qqqq-options-unavailable-in-database/3807/5 "2010-04-21T05:40:59Z")

</div>

Hi James,  
  
In case it helps, this is how I constructed the option code:  
  
  
  
Get the ‘prefix’ code from Yahoo Finance. Then construct the rest of the code using the algorithm shown here:  
  
[http://www.collective2.com/symbology\_stockoptions.htm](http://www.collective2.com/symbology_stockoptions.htm)  
  
  
  
The “Expiration Day of Month” is the Saturday. So in my case it was the 21st, not 20th as I was originally trying.  
  
  
  
What I call the “prefix” is called the “Security Symbol” in the C2 page above. As Matthew says, eventually (and hopefully!) it will really be the security symbol but that is not yet the case.
