yahoofinance.quotes.csv.StockQuotesRequest Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of YahooFinanceAPI Show documentation
Show all versions of YahooFinanceAPI Show documentation
This library provides some methods that should make it easy
to communicate with the Yahoo Finance API.
It allows you to request detailed information, some statistics
and historical quotes on stocks.
Separate functionality is available to request a simple FX quote.
Please check the javadoc to get a complete overview of the available methods
and to get an idea of which data is available from Yahoo Finance.
package yahoofinance.quotes.csv;
import java.util.ArrayList;
import java.util.List;
/**
*
* @author Stijn Strickx
*/
public class StockQuotesRequest extends QuotesRequest {
/**
* Yahoo Finance is responding with formatted numbers in some cases. Because
* of this, those number may contain commas. This will screw up the CSV
* file.
*
* It's not possible to choose a different delimiter for the CSV or to
* disable the number formatting
*
* To work around this, we surround the vulnerable values by the stock
* symbol. This forces us to do manual parsing of the CSV lines instead of
* using the easy String.split
*
*/
public static final List DEFAULT_PROPERTIES = new ArrayList();
static {
// Always keep the name and symbol in first and second place respectively!
DEFAULT_PROPERTIES.add(QuotesProperty.Name);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.Currency);
DEFAULT_PROPERTIES.add(QuotesProperty.StockExchange);
DEFAULT_PROPERTIES.add(QuotesProperty.Ask);
DEFAULT_PROPERTIES.add(QuotesProperty.AskRealtime);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.AskSize);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.Bid);
DEFAULT_PROPERTIES.add(QuotesProperty.BidRealtime);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.BidSize);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.LastTradePriceOnly);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.LastTradeSize);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.LastTradeDate);
DEFAULT_PROPERTIES.add(QuotesProperty.LastTradeTime);
DEFAULT_PROPERTIES.add(QuotesProperty.Open);
DEFAULT_PROPERTIES.add(QuotesProperty.PreviousClose);
DEFAULT_PROPERTIES.add(QuotesProperty.DaysLow);
DEFAULT_PROPERTIES.add(QuotesProperty.DaysHigh);
DEFAULT_PROPERTIES.add(QuotesProperty.Volume);
DEFAULT_PROPERTIES.add(QuotesProperty.AverageDailyVolume);
DEFAULT_PROPERTIES.add(QuotesProperty.YearHigh);
DEFAULT_PROPERTIES.add(QuotesProperty.YearLow);
DEFAULT_PROPERTIES.add(QuotesProperty.FiftydayMovingAverage);
DEFAULT_PROPERTIES.add(QuotesProperty.TwoHundreddayMovingAverage);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.SharesOutstanding);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.SharesOwned);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.MarketCapitalization);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.SharesFloat);
DEFAULT_PROPERTIES.add(QuotesProperty.Symbol);
DEFAULT_PROPERTIES.add(QuotesProperty.DividendPayDate);
DEFAULT_PROPERTIES.add(QuotesProperty.ExDividendDate);
DEFAULT_PROPERTIES.add(QuotesProperty.TrailingAnnualDividendYield);
DEFAULT_PROPERTIES.add(QuotesProperty.TrailingAnnualDividendYieldInPercent);
DEFAULT_PROPERTIES.add(QuotesProperty.DilutedEPS);
DEFAULT_PROPERTIES.add(QuotesProperty.EPSEstimateCurrentYear);
DEFAULT_PROPERTIES.add(QuotesProperty.EPSEstimateNextQuarter);
DEFAULT_PROPERTIES.add(QuotesProperty.EPSEstimateNextYear);
DEFAULT_PROPERTIES.add(QuotesProperty.PERatio);
DEFAULT_PROPERTIES.add(QuotesProperty.PEGRatio);
DEFAULT_PROPERTIES.add(QuotesProperty.PriceBook);
DEFAULT_PROPERTIES.add(QuotesProperty.PriceSales);
DEFAULT_PROPERTIES.add(QuotesProperty.BookValuePerShare);
DEFAULT_PROPERTIES.add(QuotesProperty.Revenue);
DEFAULT_PROPERTIES.add(QuotesProperty.EBITDA);
DEFAULT_PROPERTIES.add(QuotesProperty.OneyrTargetPrice);
DEFAULT_PROPERTIES.add(QuotesProperty.ShortRatio);
}
public StockQuotesRequest(String query) {
super(query, StockQuotesRequest.DEFAULT_PROPERTIES);
}
@Override
protected StockQuotesData parseCSVLine(String line) {
List parsedLine = new ArrayList();
// first get company name, symbol, currency and exchange
// because we need the symbol and currency or exchange might be the same as the symbol!
// pretty ugly code due to the bad format of the csv
int pos1 = 0;
int pos2 = 0;
int skip = 2;
if(line.startsWith("\"")) {
pos1 = 1; // skip first \"
pos2 = line.indexOf('\"', 1);
} else {
pos2 = line.indexOf(",\""); // last comma before the first symbol (hopefully)
skip = 1;
}
String name = line.substring(pos1, pos2);
pos1 = pos2 + skip; // skip \",
pos2 = line.indexOf('\"', pos1 + 1);
skip = 2;
String fullSymbol = line.substring(pos1, pos2 + 1);
String symbol = fullSymbol.substring(1, fullSymbol.length() - 1);
pos1 = pos2 + skip;
if (line.charAt(pos1) == '\"') {
pos1 += 1;
pos2 = line.indexOf('\"', pos1);
skip = 2;
} else {
pos2 = line.indexOf(',', pos1);
skip = 1;
}
String currency = line.substring(pos1, pos2);
pos1 = pos2 + skip;
if (line.charAt(pos1) == '\"') {
pos1 += 1;
pos2 = line.indexOf('\"', pos1);
skip = 2;
} else {
pos2 = line.indexOf(',', pos1);
skip = 1;
}
String exchange = line.substring(pos1, pos2);
parsedLine.add(name);
parsedLine.add(symbol);
parsedLine.add(currency);
parsedLine.add(exchange);
pos1 = pos2 + skip; // skip \",
for (; pos1 < line.length(); pos1++) {
if (line.startsWith(fullSymbol, pos1)) {
parsedLine.add(symbol);
pos1 = pos1 + fullSymbol.length() + 1; // immediately skip the , as well
pos2 = line.indexOf(fullSymbol, pos1) - 1; // don't include last ,
parsedLine.add(line.substring(pos1, pos2));
parsedLine.add(symbol);
pos1 = pos2 + fullSymbol.length() + 1;
} else if (line.charAt(pos1) == '\"') {
pos1 += 1;
pos2 = line.indexOf('\"', pos1);
parsedLine.add(line.substring(pos1, pos2));
pos1 = pos2 + 1;
} else if (line.charAt(pos1) != ',') {
pos2 = line.indexOf(',', pos1);
if (pos2 <= pos1) {
pos2 = line.length();
}
parsedLine.add(line.substring(pos1, pos2));
pos1 = pos2;
}
}
return new StockQuotesData(parsedLine.toArray(new String[this.properties.size()]));
}
}