Discussions
»
Product and Service Development
»
Data Related Questions
»
Downloader invalid symbol problems caused by .O and .K stocks
Rank: Newbie
Groups: Registered, Registered Users Joined: 2/9/2010(UTC) Posts: 2
|
I like to keep my daily stock universe with you bang up-to-date by using symbols from the proper Exchange websites.
However this way has been leaving 119 US stocks with "invalid symbols"
Upon digging further, lets take Juniper Networks. On Yahoo finance the symbol is JNPR. On my two different stockbrokers (one a PRIME broker) the symbol is JNPR.
Even on NYSE.com the symbol is JNPR.
However on the Equis network the symbol is JNPR.K.
This appears to be the case with all 119 stocks, an extra letter .O or .K
This is totally unworkable from a trading point of view and ridiculous that your symbols are DIFFERENT from even the major exchanges these stocks trade on.
I send baskets of orders to my brokers - this cannot be done if the symbols are not correct!
So please will you look at the list below and remove the .K / .O from them all so they are in line with the rest of the world?!
Many thanks
Abovenet Inc ABVT Daily Invalid Symbol ADDvantage Technologies Group Inc. AEY Daily Invalid Symbol AGCO Corporation AGCO Daily Invalid Symbol Alexander & Baldwin Inc. ALEX Daily Invalid Symbol American DG Energy Inc. ADGE Daily Invalid Symbol ATS Corporation ATSC Daily Invalid Symbol Automatic Data Processing Inc. ADP Daily Invalid Symbol Bacterin International Holdings Inc. BONE Daily Invalid Symbol Beazer Homes USA Inc. BZMD Daily Invalid Symbol Black Diamond Inc. BDE Daily Invalid Symbol BMC Software Inc. BMC Daily Invalid Symbol CA Inc. CA Daily Invalid Symbol CACI International Inc. CACI Daily Invalid Symbol Camden National Corporation CAC Daily Invalid Symbol Cascade Corporation CASC Daily Invalid Symbol Cato Corporation (The) CATO Daily Invalid Symbol Celera Corporation CRA Daily Invalid Symbol Chemtura Corp. CHMT Daily Invalid Symbol China Armco Metals Inc. CNAM Daily Invalid Symbol Citigroup Inc. ILB Daily Invalid Symbol CME Group Inc. CME Daily Invalid Symbol CommonWealth REIT CWHN Daily Invalid Symbol Communications Systems Inc. JCS Daily Invalid Symbol Compass Diversified Holdings CODI Daily Invalid Symbol Conmed Healthcare Management Inc. CONM Daily Invalid Symbol Crestwood Midstream Partners LP CMLP Daily Invalid Symbol Cross (A.T.) Company ATX Daily Invalid Symbol Crystal Rock Holdings Inc. CRVP Daily Invalid Symbol CVD Equipment Corporation CVV Daily Invalid Symbol Cypress Semiconductor Corporation CY Daily Invalid Symbol Deerfield Capital Corp. DFR Daily Invalid Symbol DGSE Companies Inc. DGSE Daily Invalid Symbol DIRECTV DTV Daily Invalid Symbol Ecology and Environment Inc. EEI Daily Invalid Symbol eMagin Corporation EMAN Daily Invalid Symbol Ener1 Inc HEV Daily Invalid Symbol ENGlobal Corporation ENG Daily Invalid Symbol eResearch Technology Inc. ERT Daily Invalid Symbol Evans Bancorp Inc. EVBN Daily Invalid Symbol Fair Isaac and Company Incorporated FICO Daily Invalid Symbol FairPoint Communications Inc. FRP Daily Invalid Symbol GAIN Capital Holdings Inc. GCAP Daily Invalid Symbol Gas Natural Inc. EGAS Daily Invalid Symbol GFI Group Inc. GFIG Daily Invalid Symbol Globe Specialty Metals Inc. GSM Daily Invalid Symbol GMX Resources Inc. GMXR Daily Invalid Symbol Gold Resource Corporation GORO Daily Invalid Symbol Hasbro Inc. HAS Daily Invalid Symbol Hawaiian Holdings Inc. HA Daily Invalid Symbol Houston American Energy Corporation HUSA Daily Invalid Symbol Hovnanian Enterprises Inc HOVU Daily Invalid Symbol iBio Inc. IBIO Daily Invalid Symbol Inergy L.P. NRGY Daily Invalid Symbol InfuSystems Holdings Inc. INFU Daily Invalid Symbol Institutional Financial Markets Inc. IFMI Daily Invalid Symbol IntriCon Corporation IIN Daily Invalid Symbol Inuvo Inc INUV Daily Invalid Symbol J. Alexander's Corporation JAX Daily Invalid Symbol Juniper Networks Inc. JNPR Daily Invalid Symbol KSW Inc KSW Daily Invalid Symbol Madison Square Garden Inc. MSG Daily Invalid Symbol Main Street Capital Corporation MAIN Daily Invalid Symbol Materion Corporation MTRN Daily Invalid Symbol Mattel Inc. MAT Daily Invalid Symbol Meritor Inc. MTOR Daily Invalid Symbol MicroFinancial Incorporated MFI Daily Invalid Symbol Micron Technology Inc. MU Daily Invalid Symbol Mid Penn Bancorp MPB Daily Invalid Symbol Mission West Properties Inc. MSW Daily Invalid Symbol MSCI Inc MSCI Daily Invalid Symbol Mylan Inc. MYL Daily Invalid Symbol Network Engines Inc NEI Daily Invalid Symbol Network Equipment Technologies Inc. NWK Daily Invalid Symbol New Energy Systems Group. NEWN Daily Invalid Symbol News Corporation NWS Daily Invalid Symbol Northeast Bancorp NBN Daily Invalid Symbol Optical Cable Corporation OCC Daily Invalid Symbol Orion Energy Systems Inc. OESX Daily Invalid Symbol Park City Group Inc. PCYG Daily Invalid Symbol Peapack-Gladstone Financial Corporation PGC Daily Invalid Symbol Potlatch Corporation PCH Daily Invalid Symbol Providence and Worcester Railroad Company PWX Daily Invalid Symbol Psychemedics Corporation PMD Daily Invalid Symbol Pulse Electronics Corporation PULS Daily Invalid Symbol Quepasa Corporation QPSA Daily Invalid Symbol R.G. Barry Corporation DFZ Daily Invalid Symbol R.R. Donnelley & Sons Company RRD Daily Invalid Symbol Reading International Inc RDI Daily Invalid Symbol RealPage Inc. RP Daily Invalid Symbol rue21 inc. RUE Daily Invalid Symbol SciQuest Inc. SQI Daily Invalid Symbol Semgroup Corporation SEMG Daily Invalid Symbol Shaw Group Inc. (The) SHAW Daily Invalid Symbol Silicon Graphics International Corp SGI Daily Invalid Symbol Simulations Plus Inc. SLP Daily Invalid Symbol Southern Copper Corporation SCCO Daily Invalid Symbol Spansion Inc CODE Daily Invalid Symbol Superior Uniform Group Inc. SGC Daily Invalid Symbol Tandy Leather Factory Inc. TLF Daily Invalid Symbol Tech/Ops Sevcon Inc. TO Daily Invalid Symbol TGC Industries Inc. TGE Daily Invalid Symbol The Charles Schwab Corporation SCHW Daily Invalid Symbol The Corporate Executive Board Company EXBD Daily Invalid Symbol The Fresh Market Inc. TFM Daily Invalid Symbol Trex Company Inc. TREX Daily Invalid Symbol Triangle Capital Corporation TCAP Daily Invalid Symbol TriMas Corporation TRS Daily Invalid Symbol Union Bankshares Inc. UNB Daily Invalid Symbol United-Guardian Inc. UG Daily Invalid Symbol Uroplasty Inc. UPI Daily Invalid Symbol USANA Health Sciences Inc. USNA Daily Invalid Symbol Valpey Fisher Corporation VPF Daily Invalid Symbol Vera Bradley Inc. VRA Daily Invalid Symbol Vringo Inc. VRNG Daily Invalid Symbol Westfield Financial Inc. WFD Daily Invalid Symbol Woodward Inc. WWD Daily Invalid Symbol WSB Holdings Inc. WSB Daily Invalid Symbol Zion Oil & Gas Inc ZN Daily Invalid Symbol Zipcar Inc. ZIP Daily Invalid Symbol
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 92 times Was thanked: 155 time(s) in 150 post(s)
|
Reuters Datalink uses at RIC (Reuters Instrument Code) for denoting all stock symbols. This is the same format used with Thomson Reuters products sold to Brokerages and Banks. The RIC is a ticker symbol followed by an exchange code.
Originally, all NYSE symbols were 3 letters or less and all NASDAQ symbols were 4 or 5 letters. As such, the Downloader automatically appended the .O or .K for those exchanges. However, with that rule no longer being in effect, the .O and .K have to manually added to the symbols that do not follow the older standard.
I realize this may cause an inconvience with some automated processes. We felt the access to the world wide data offer by Thomson Reuters was an acceptable trade off for the few symbols affected. We are monitoring this as more symbols cause exceptions, it is possible some change may be sought. However we are currently bound to the RIC format.
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Data Related Questions
»
Downloader invalid symbol problems caused by .O and .K stocks
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.