The Lemon Fool

Heres an excel file which uses the beautiful dynamic range feature of excel to present ohlc prices for a specified period. It's nicer than having to go and download a .csv from yahoo finance or wherever. Try it out on a few tickers. Macros will need to enabled.

Dynamic arrays are available in Office 365 only, not excel 2019 or before as far as I am aware.
If you're using an earlier version you can make it work using array formulas.

All you vba types on here can have some fun figuring out how it works too. I've done my best to make it a challenge.

https://www.dropbox.com/s/kyvz4s0urs0avxl/hist.xlsm?dl=0

Many thanks for this Eventide, it's good to get new contributions.
I'll try to have a look at it, but I'm way behind Excel 365..... I'm on Excel 2010, and I think we have some users on Excel 2000!

--kiloran

You probably know this, but then you can just expand the function from a single cell to a range which is 5 rows wide and as many deep as days you are seeking the data for, and use ctrl-alt-enter (instead of just enter) to set the array formula.

I've resaved the file with an example of this on the RHS.