Formula featured "=GOOGLEFINANCE(Stock, "ALL", DATE(year(today())-5, 1, 1), TODAY(), "weekly")
Auto-Populated Columns: Date, Open, Low, High, Close, Volume
Using the method in this video, you can even change the stock ticker easily (dynamic charts) and populate the chart of the stocks on the exchanges. You can easily convert the populated table into a chart by clicking Insert, Chart and changing the chart to a Candlestick. Google Sheets can be weird in that it doesn't align the columns correctly.
You'll need to change which columns the chart pulls from. After that, you can send it to its own page, publish it, customize it, embed it in your website, and more.Awesome for Stock Traders or Investors using Google Sheets.