See this PR and blog for the latest announcement on Stocks Data Type in Excel
Love this function and using it to manage my own portfolio. Great replacement for the old yahoo webservice and super to have this integrated into Excel directly.
A few items would like to see in the roadmap
1. Live Stock Indices FTSE100, DAX, DJI etc.. if possible.
2. Adding the ability to auto-refresh specific stock data type (Price) cells every xx Minutes natively.
3. Historical price close data for a given date value
4. Dividend Yield Information (Yield, payment date when available...)