The current symbol field is varchar(10) [ stockapi.install ] but it is not sufficient for symbols like BSE-MIDCAP.BO . Never found symbol more than 15 letters, but think it should be made varchar(30) [ 2*15 ] for safety. Otherwise stock module won't show results for such symbols.

This is my first issue, sorry if this not according to norms.

Comments

torgospizza’s picture

torgospizza
he/him
Primary language English
Location Portland, OR
commented

I would also like to say, the same goes for the "name" field in the schema. For instance the name "Microsoft Corporation" is truncated to "Microsoft Corpora" when saved to the stockapi table.

fp’s picture

fp commented

@torgosPizza: I think though that the name is already truncated by Yahoo. For example: http://download.finance.yahoo.com/d/quotes.csv?s=MSFT&f=n

torgospizza’s picture

torgospizza
he/him
Primary language English
Location Portland, OR
commented
Status: Active » Closed (works as designed)

Interesting, I hadn't noticed that. Thanks! Will mark as By Design, in that case.