Simple US stock watchlist

I need to do VB code in the Sheet “WATCHLIST” which consists of a table with 5 sections. I need to download financial and technical metrics of any ticker/symbol I write in column (C) and updated daily on section 2. Macro VB code should be able to download the following metrics from Yahoo finance and update them daily.



Market Cap
Enterprise Value
P/E Trailing
P/E Forward
P/S
Profit Margin
Operating Margin
ROA
ROE
Revenue
EBITDA
Debt/Equity
Shares outstanding
Average Volume (10 days)
Average Volume (3-months)


Please be informed that I may need your assistance in the future on the same scope. I am working on creating a full customized portfolio with watchlists and execution process.



Check the attached spreadsheet file.