private bool parse(String respond)
{
historyDatabase.Clear();
simpleDates.Clear();
SimpleDate calendar = new SimpleDate();
String[] stockDatas = respond.Split(new string[] { "\r\n", "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries);
// There must be at least two lines : header information and history information.
int length = stockDatas.Count();
if (length <= 1)
{
return(false);
}
Symbol symbol = Symbol.newInstance(code.toString());
String name = symbol.toString();
Stock.Board board = Stock.Board.Unknown;
Stock.Industry industry = Stock.Industry.Unknown;
try
{
Stock stock = getStockServer(this.country).getStock(code);
symbol = stock.getSymbol();
name = stock.getName();
board = stock.getBoard();
industry = stock.getIndustry();
}
catch (StockNotFoundException exp)
{
log.Error(null, exp);
}
double previousClosePrice = Double.MaxValue;
for (int i = length - 1; i > 0; i--)
{
// Use > instead of >=, to avoid header information (Date,Open,High,Low,Close,Volume,Adj Close)
String[] fields = stockDatas[i].Split(',');
// Date,Open,High,Low,Close,Volume,Adj Close
if (fields.Count() < 7)
{
continue;
}
try
{
DateTime curcalendar = DateTime.ParseExact(fields[0], "yyyy-MM-dd", CultureInfo.InvariantCulture);
calendar = new SimpleDate(curcalendar);
}
catch (FormatException ex)
{
log.Error(null, ex);
continue;
}
double prevPrice = 0.0;
double openPrice = 0.0;
double highPrice = 0.0;
double lowPrice = 0.0;
double closePrice = 0.0;
// TODO: CRITICAL LONG BUG REVISED NEEDED.
long volume = 0;
//double adjustedClosePrice = 0.0;
try
{
prevPrice = (previousClosePrice == Double.MaxValue) ? 0 : previousClosePrice;
openPrice = Double.Parse(fields[1]);
highPrice = Double.Parse(fields[2]);
lowPrice = Double.Parse(fields[3]);
closePrice = Double.Parse(fields[4]);
// TODO: CRITICAL LONG BUG REVISED NEEDED.
volume = long.Parse(fields[5]);
//adjustedClosePrice = Double.Parse(fields[6]);
}
catch (FormatException exp)
{
log.Error(null, exp);
}
double changePrice = (previousClosePrice == Double.MaxValue) ? 0 : closePrice - previousClosePrice;
double changePricePercentage = ((previousClosePrice == Double.MaxValue) || (previousClosePrice == 0.0)) ? 0 : changePrice / previousClosePrice * 100.0;
SimpleDate simpleDate = calendar;
Stock stock = new Stock(
code,
symbol,
name,
board,
industry,
prevPrice,
openPrice,
closePrice, /* Last Price. */
highPrice,
lowPrice,
volume,
changePrice,
changePricePercentage,
0,
0.0,
0,
0.0,
0,
0.0,
0,
0.0,
0,
0.0,
0,
0.0,
0,
simpleDate
);
historyDatabase.Add(simpleDate, stock);
simpleDates.Add(simpleDate);
previousClosePrice = closePrice;
}
return(historyDatabase.Count > 0);
}
// Update on 19 March 2009 : We cannot assume certain parameters will always
// be float. They may become integer too. For example, in the case of Korea
// Stock Market, Previous Close is in integer. We shall apply string quote
// protection method too on them.
//
// Here are the index since 19 March 2009 :
// (0) Symbol
// (1) Name
// (2) Stock Exchange
// (3) Symbol
// (4) Previous Close
// (5) Symbol
// (6) Open
// (7) Symbol
// (8) Last Trade
// (9) Symbol
// (10) Day's high
// (11) Symbol
// (12) Day's low
// (13) Symbol
// (14) Volume
// (15) Symbol
// (16) Change
// (17) Symbol
// (18) Change Percent
// (19) Symbol
// (20) Last Trade Size
// (21) Symbol
// (22) Bid
// (23) Symbol
// (24) Bid Size
// (25) Symbol
// (26) Ask
// (27) Symbol
// (28) Ask Size
// (29) Symbol
// (30) Last Trade Date
// (31) Last Trade Time.
//
// s = Symbol
// n = Name
// x = Stock Exchange
// o = Open <-- Although we will keep this value in our stock data structure, we will not show
// it to clients. As some stock servers unable to retrieve open price.
// p = Previous Close
// l1 = Last Trade (Price Only)
// h = Day's high
// g = Day's low
// v = Volume <-- We need to take special care on this, it may give us 1,234. This will
// make us difficult to parse csv file. The only workaround is to make integer
// in between two string literal (which will always Contains "). By using regular
// expression, we will manually remove the comma.
// c1 = Change
// p2 = Change Percent
// k3 = Last Trade Size <-- We need to take special care on this, it may give us 1,234...
// b = Bid
// b6 = Bid Size <-- We need to take special care on this, it may give us 1,234...
// a = Ask
// a5 = Ask Size <-- We need to take special care on this, it may give us 1,234...
// d1 = Last Trade Date
// t1 = Last Trade Time
//
// c6k2c1p2c -> Change (Real-time), Change Percent (Real-time), Change, Change in Percent, Change & Percent Change
// "+1400.00","N/A - +4.31%",+1400.00,"+4.31%","+1400.00 - +4.31%"
//
// "MAERSKB.CO","AP MOELLER-MAERS-","Copenhagen",32500.00,33700.00,34200.00,33400.00,660,"+1200.00","N/A - +3.69%",33,33500.00,54,33700.00,96,"11/10/2008","10:53am"
public List <Stock> parse(String source)
{
List <Stock> stocks = new List <Stock>();
if (source == null)
{
return(stocks);
}
String[] strings = source.Split(new string[] { "\r\n", "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries);
foreach (String str in strings)
{
/// String tmp = YahooStockFormat.digitPattern.matcher(string).replaceAll("$1");
var tmp = YahooStockFormat.digitPattern.Matches(str);
string strtmp = YahooStockFormat.digitPattern.Match(str).Value;
foreach (var item in tmp)
{
// ??
}
// Some string contain comma, remove them as well. If not, we face problem during csv parsing.
String stringDigitWithoutComma = stringCommaPattern.Match(strtmp).Value;
String[] fields = stringDigitWithoutComma.Split(',');
int length = fields.Count();
Code code = null;
Symbol symbol = null;
String name = null;
Stock.Board board = Stock.Board.Unknown;
Stock.Industry industry = Stock.Industry.Unknown;
double prevPrice = 0.0;
double openPrice = 0.0;
double lastPrice = 0.0;
double highPrice = 0.0;
double lowPrice = 0.0;
// TODO: CRITICAL LONG BUG REVISED NEEDED.
long volume = 0;
double changePrice = 0.0;
double changePricePercentage = 0.0;
int lastVolume = 0;
double buyPrice = 0.0;
int buyQuantity = 0;
double sellPrice = 0.0;
int sellQuantity = 0;
double secondBuyPrice = 0.0;
int secondBuyQuantity = 0;
double secondSellPrice = 0.0;
int secondSellQuantity = 0;
double thirdBuyPrice = 0.0;
int thirdBuyQuantity = 0;
double thirdSellPrice = 0.0;
int thirdSellQuantity = 0;
SimpleDate calendar = new SimpleDate();
do
{
if (length < 1)
{
break;
}
code = Code.newInstance(quotePattern.Match(fields[0]).Value.Trim());
if (length < 2)
{
break;
}
name = quotePattern.Match(fields[1]).Value.Trim();
// We use name as symbol, to make it more readable.
symbol = Symbol.newInstance(name);
if (length < 3)
{
break;
}
try
{
board = (Stock.Board)Enum.Parse(typeof(Stock.Board), quotePattern.Match(fields[2]).Value.Trim());
}
catch (Exception exp)
{
board = Stock.Board.Unknown;
}
industry = Stock.Industry.Unknown;
if (length < 5)
{
break;
}
try
{
prevPrice = Double.Parse(fields[4]);
}
catch (FormatException exp)
{ }
if (length < 7)
{
break;
}
try { openPrice = Double.Parse(fields[6]); }
catch (FormatException exp) { }
if (length < 9)
{
break;
}
try { lastPrice = Double.Parse(fields[8]); }
catch (FormatException exp) { }
if (length < 11)
{
break;
}
try { highPrice = Double.Parse(fields[10]); }
catch (FormatException exp) { }
if (length < 13)
{
break;
}
try { lowPrice = Double.Parse(fields[12]); }
catch (FormatException exp) { }
if (length < 15)
{
break;
}
// TODO: CRITICAL LONG BUG REVISED NEEDED.
try { volume = long.Parse(fields[14]); }
catch (FormatException exp) { }
if (length < 17)
{
break;
}
try { changePrice = Double.Parse(quotePattern.Match(fields[16]).Value.Trim()); }
catch (FormatException exp) { }
if (length < 19)
{
break;
}
String _changePricePercentage = quotePattern.Match(fields[18]).Value;
_changePricePercentage = percentagePattern.Match(_changePricePercentage).Value;
try { changePricePercentage = Double.Parse(_changePricePercentage); }
catch (FormatException exp) { }
if (length < 21)
{
break;
}
try { lastVolume = int.Parse(fields[20]); }
catch (FormatException exp) { }
if (length < 23)
{
break;
}
try { buyPrice = Double.Parse(fields[22]); }
catch (FormatException exp) { }
if (length < 25)
{
break;
}
try { buyQuantity = int.Parse(fields[24]); }
catch (FormatException exp) { }
if (length < 27)
{
break;
}
try { sellPrice = Double.Parse(fields[26]); }
catch (FormatException exp) { }
if (length < 29)
{
break;
}
try { sellQuantity = int.Parse(fields[28]); }
catch (FormatException exp) { }
if (length < 32)
{
break;
}
String data_and_time = quotePattern.Match(fields[28]).Value.Trim() + " " + quotePattern.Match(fields[29]).Value.Trim();
DateTime serverDate;
try
{
serverDate = DateTime.ParseExact(data_and_time, "MM/dd/yyyy hh:mmaa", CultureInfo.InvariantCulture);
calendar = new SimpleDate(serverDate);
}
catch (FormatException exp)
{
// Most of the time, we just obtain "N/A"
// log.error(fields[23] + ", " + fields[24] + ", " + data_and_time, exp);
}
break;
} while (true);
if (code == null || symbol == null || name == null)
{
continue;
}
if (calendar == null)
{
calendar = new SimpleDate();
}
Stock stock = new Stock(
code,
symbol,
name,
board,
industry,
prevPrice,
openPrice,
lastPrice,
highPrice,
lowPrice,
volume,
changePrice,
changePricePercentage,
lastVolume,
buyPrice,
buyQuantity,
sellPrice,
sellQuantity,
secondBuyPrice,
secondBuyQuantity,
secondSellPrice,
secondSellQuantity,
thirdBuyPrice,
thirdBuyQuantity,
thirdSellPrice,
thirdSellQuantity,
calendar
);
stocks.Add(stock);
}
return(stocks);
}
