Build a Excel function that will allow to pull stock market data off the web

Hello, I need an Excel function that will pull stock market data off the web and into the cell for me. I am not a trader, so I don't need anything that will update every minute. I need to use this to compare stocks, ETFs, and mutual funds against one another in building a portfolio. Ideally, I would like a new function where I can type in a cell "=stockdata(string ticker_symbol, string parameter)" and the function will call the web to find the data. There are open source APIs out there that should make this possible to do such as [login to view URL] and alphavantage.com. I have a lot of experience with Excel, and can do a lot of the formatting myself so the spreadsheet does not need to be pretty. I just need the function to be made and working. The requirements: 1. Build an Excel function that can be entered into a cell will extract data from an open source API source for stock market data. 2. The function should be able to extract at least Name, type, expense ratio, YTD return, 1-Year, 3-Year, 5-Year, 10-Year and 15-Year returns (if able), Morninstar Rating, beta, and other useful metrics.