I'm looking to create a macro that pulls daily, weekly, and monthly historical stock prices into three separate tabs. I want to be able to enter a company ticker and an "as of date" and have the macro pull from a website. I'd like the macro to be able to pull 10 years worth of historical stock data in the format shown in here at the following URL (i.e. open, high, low, close, volume, etc.). https://finance.yahoo.com/quote/TXT/history?ltr=1.

Does anyone know if such a macro already exists or could anyone provide advice?