Stock Quotes in Calc

Hi All,

I’ve perused the previous questions on the site and it seems like most of them are really outdated. Goal:

(1) Live stock quotes from any reputable ticker site;
(2) Max/Min of a particular stock for every day (essentially A column is a list of dates, B column is stock ticker, C would be Min for day, D would be Max for day).

I’d hope that there would be a way to pull this stuff but from what I’m seeing so far, I’m not finding an obvious answer. Thanks!