Stock Market, Crypto, Forecasting, Monte Carlo, Probability.
do just from sheet? ' assumes 1000 days forward, rows 2 to 1002 ' copy this random walk path to the mc sheet, one column at a time (from the left) For irow = 2 To 2 + 1000 Sheets("mc").Cells(irow, monte).Value = Sheets("Sheet1").Cells(2 + (irow - 2), 2).Value Next ' report out to a sheet cell to