/// <summary>
/// Gets the Last trading day by year. This takes an array of years.
/// </summary>
/// <param name="exchangeCommodityName">Name of the exchange commodity.</param>
/// <param name="yearsArray">The array of years as integers.</param>
/// <param name="mainCycle">if set to <c>true</c> [main cycle].</param>
/// <returns>A range of dates.</returns>
public object[,] LastTradingDayByYear(string exchangeCommodityName, Excel.Range yearsArray, Boolean mainCycle)
{
List <int> unqVals = DataRangeHelper.StripIntRange(yearsArray);
var dates = LastTradingDayHelper.GetLastTradingDays(exchangeCommodityName, unqVals.ToArray(), mainCycle);
var resVals = RangeHelper.ConvertArrayToRange(dates);
return(resVals);
}
/// <summary>
/// Gets the Last trading based on a given month.
/// </summary>
/// <param name="exchangeCommodityName">Name of the exchange commodity.</param>
/// <param name="monthsArray">The array of months.</param>
/// <param name="yearsArray">The array of years as integers.</param>
/// <returns></returns>
public object[,] LastTradingDayByMonth(string exchangeCommodityName, Excel.Range monthsArray, Excel.Range yearsArray)
{
List <int> unqMonths = DataRangeHelper.StripIntRange(monthsArray);
List <int> unqYears = DataRangeHelper.StripIntRange(yearsArray);
List <DateTime> dates = LastTradingDayHelper.GetLastTradingDays(exchangeCommodityName, unqMonths.ToArray(), unqYears.ToArray());
var resVals = RangeHelper.ConvertArrayToRange(dates);
return(resVals);
}
