Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
What concerns me is what the guy is up to with his validation.
SEDOL (Stock Exchange Daily Official List) Number is a number provided by the London Stock Exchange for stocks of various types which come under their listing control. CUSIP (never knew what it meant) is something similar for the US
So, SEDOL and CUSIP are reference data. The LSE, and whoever in the US, provide filess (or data, these days, I suppose) for you, with the numbers on, names of the stock, issuer, details, blah, blah. The files used to be on tape (we took the LSE, and they kindly included CUSIP automatically where necessary).
So, what is he up to? Is he working on some trade input system, where he is going to validate those references, so he can send a message back to the data enterer (too late at night to think of a proper word) saying that it is invalid - and then, if valid, access a database to see if the record is there?
What he hasn't told you is that not every character is valid in every position. Or that they use check digits (different systems as well, I see from google).
I'm sorry not to have noticed earlier, but because he stuck it on the end of an old thread and I looked at the thread without looking at the dates, I ignored it (I've never used anything fancy from SPECIAL-NAMES) until I saw the post-count going up like a fast-moving-post-count. |
|
