As part of a project at university, I have randomly generated a random share-price using =B39+NORMINV(RAND(),0,1) and generated 10000 observations. I want to get an open high low and close for each 8 periods on a new page.
How could I go along with this task