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,943
Thanks: 87 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.
