public static object[,] Quote(
[ExcelArgument("is the security ID from the quote service.", Name = "security_id")] string secId,
[ExcelArgument("is the name or abbreviation of the quote service (b, Bloomberg, g, Google, y, Yahoo, etc.). Defaults to Bloomberg.",
Name = "source")] string source,
[ExcelArgument("is a list of which values to return. Accepts any combination of \"px%dtbahlv\" (price, change, % change, date, time, bid, ask, high, low, volume). " +
"Bid/ask are not available through Google. Use =QuoteParams() for help if necessary. Defaults to price.", Name = "params")] string names,
[ExcelArgument("is whether you want this function to return continuously stream live quotes to the cell. Defaults to false.",
Name = "live_updating")] bool liveUpdating,
[ExcelArgument("is the number of seconds between update requests (if live_updating is true). " +
"Defaults to 15 seconds.", Name = "frequency")] double freq,
[ExcelArgument("is whether to display the headers for each column. Defaults to false.", Name = "show_headers")] bool showHeaders)
{
if (names == "")
{
names = "p";
}
QuoteSource src = QuoteSourceCollection.GetSourceByName(source);
string url = src.FullURL(secId);
string[] patterns = src.GetQuoteParamsByChars(names);
string[] headers = (showHeaders ? QuoteSourceCollection.GetQuoteNamesByChars(names) : new string[] { });
return(liveUpdating ? Import(url, patterns, ONE_RESULT_PER_PARAM, true, freq, headers) :
GetWebData(url, patterns, ONE_RESULT_PER_PARAM, headers));
}
public static string FullTicker(
[ExcelArgument("is the security ID from the quote service.", Name = "security_id")] string ticker,
[ExcelArgument("is the name or abbreviation of the quote service (b, Bloomberg, g, Google, y, Yahoo, etc.). Defaults to Bloomberg.",
Name = "source")] string source,
[ExcelArgument("forces FinAnSu to guess at a suffix if none exists if set to true (may result in errors).",
Name = "force_interpret")] bool forceInterpret)
{
return(QuoteSourceCollection.GetSourceByName(source).FullTicker(ticker, forceInterpret));
}
public static string QuoteHistoryParams(
[ExcelArgument("is whether you wish to return the date.")] bool date,
[ExcelArgument("is whether you wish to return the day's opening price.", Name = "open")] bool openPrice,
[ExcelArgument("is whether you wish to return the day's high price.")] bool high,
[ExcelArgument("is whether you wish to return the day's lowest price.")] bool low,
[ExcelArgument("is whether you wish to return the day's closing price.", Name = "close")] bool closePrice,
[ExcelArgument("is whether you wish to return the day's volume.")] bool volume,
[ExcelArgument("is whether you wish to return the day's closing price.")] bool adjClose)
{
return(QuoteSourceCollection.HistoryParams(new bool[] { date, openPrice, high, low, closePrice, volume, adjClose }));
}
public static string QuoteParams(
[ExcelArgument("is whether you wish to return the current price or value.")] bool price,
[ExcelArgument("is whether you wish to return the day's change.")] bool change,
[ExcelArgument("is whether you wish to return the day's percentage change.", Name = "pct_change")] bool pctChange,
[ExcelArgument("is whether you wish to return the latest trade date.")] bool date,
[ExcelArgument("is whether you wish to return the latest trade time.", Name = "close")] bool time,
[ExcelArgument("is whether you wish to return the current bid price.")] bool bid,
[ExcelArgument("is whether you wish to return the current ask price.")] bool ask,
[ExcelArgument("is whether you wish to return the day's opening price.", Name = "open")] bool openPrice,
[ExcelArgument("is whether you wish to return the day's high price.")] bool high,
[ExcelArgument("is whether you wish to return the day's low price.")] bool low,
[ExcelArgument("is whether you wish to return the day's closing price.")] bool volume,
[ExcelArgument("is whether you wish to return the market capitalization.", Name = "market_cap")] bool marketCap,
[ExcelArgument("is whether you wish to return the price/earnings ratio", Name = "p/e")] bool pe)
{
return(QuoteSourceCollection.QuoteParams(new bool[] { price, change, pctChange, date, time,
bid, ask, openPrice, high, low, volume,
marketCap, pe }));
}
public static string ShortenSource(
[ExcelArgument("is the name or abbreviation of the quote service.", Name = "source")] string source)
{
return(QuoteSourceCollection.GetSourceByName(source).Abbreviation.ToString());
}
