Stock Market, Crypto, Forecasting, Monte Carlo, Probability.
Sheets("mc").Range(Sheets("mc").Cells(irow, 1), Sheets("mc").Cells(irow, nmonte)) Let computedPercentile = 0 If (probValue = "mean") Then computedPercentile = WorksheetFunction.Average(theRange) Else ' this is a price computedPercentile = WorksheetFunction.Percentile(theRange, probValue) End If '