Data Source (Yahoo Finance): https://finance.yahoo.com/quote/GOOGL/history?p=GOOGL

You may download one year range of data (default on the webpage), or last 30 days of data. It does not matter too much.

I would like to know how to write VBA to pull data from web first, then I will modify the code to pull data for a list of symbols (List of S&P 500 companies).

Thanks.