/// <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); }