#143 ISIN Support

Wishlist
open
7
2006-12-19
2006-12-19
No

ISIN numbers are commonly used in the European markets instead of the Symbol / Market system that AST uses. Internally AST fetches its quotes from the US Yahoo! Finance. This version of Yahoo finance does not support ISINs at all. However a European version does support ISINs, and it also translates them into symbol / market format. For example:

http://uk.old.finance.yahoo.com/d/quotes.csv?s=FR0000075160&f=sl1d1t1c1ohgv&e=.csv

Outputs:

"MLACO.PA",37.94,"12/11/2006","14:00",+1.94,37.94,37.94,37.94,0

That is, symbol is MLACO on Euronext Paris. One issue I see here is we have no way to lookup an ISIN, only to convert one into the system AST uses. However this is better than nothing. I will look into getting a database of ISIN numbers.

Another issue I see is what to do if the market does not exist? One furthur issue, if ISIN numbers are going to be stored by AST is that the length of the symbol field must be increased (its only 10 characters now which is enough to accomadate 9 letter CUSIPs).

Discussion

  • Logged In: YES
    user_id=1281708
    Originator: YES

    The problem here is knowing which market(s) a security trades in. If you enter the ISIN, its really doesn't describe the security full. ISIN + market does not work with Yahoo :(