roozrob / yahoo-finance-managed

Automatically exported from code.google.com/p/yahoo-finance-managed
0 stars 0 forks source link

Illegal Commas in Stock Names Compromise CSV Output #88

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Some stock names have commas in their names. For example Baidu Inc.
2. Try this query: 
http://download.finance.yahoo.com/d/quotes.csv?s=BIDU&f=nj1&e=.csv

What is the expected output? What do you see instead?

The expected CSV output should be "Baidu Inc.,73.99B". But your API returns 
"Baidu, Inc.,73.99B". The comma after Baidu is illegal in CSV format as it 
misleads the algorithms. This extra comma splits the line into 3 instead of 2 
fragments and instead of 73.99B I get ".inc" as MarketCap of Baidu.

Do you have other informations?
It is likely that there are more stocks in your DB having illegal commas in 
their names

Suggestions to fix the defect?
Please remove all commas in the Stock Names in the database

Original issue reported on code.google.com by igor...@gmail.com on 15 Apr 2015 at 10:18