I have a list of 2000 stocks. I want to get data from yahoo finance for each of these stocks. I want to have all of this information in a spreadsheet (excel preferred) and this information needs to be refreshed or updated from the website periodically(whenever I want) by a macro or other means.I need the following information for each stock:outstanding shares, price, ebitda, revenue, debt, cash, operating cash flow,
earnings, P/E, payout ratio, levered free cash flow. This information can be found on yahoo finance for each stock.