Enhancment for Stock Data Type
I really like the new data types, the stock data type is there a chance you pull Dividend pay dates and Dividend per share.
Dividend and yield would be fantastic.
Awesome feature addition! Two suggestions:
1) performance data for ETFs would be a major improvement
2) Automatic refresh
3) Real-time quotes .. not sure what the delay is currently but something "more" real-time would be very useful
Need to add price performance data to include 1mo performance %, 3 mo performance %, ytd performance %, 1 yr performance %, 3 yr performance %, 5 yr performance %, 10 yr performance %, and 15 yr perfornance %. This should be for all stocks, etfs and funds.
Madis Peterson commented
There have been almost 0 upgrades to the stock data function...
These concerns about incomplete dividend data were expressed over a year ago and multiple times since. It appears Microsoft is ignoring them. Without these fixes the stock data is almost useless.
and automatic refresh / update of the excel stock data when opening the file or the price changes!
It would be great if you can provide us historical stock price data using the stock data type.
Would be very useful for income forecasting of portfolio!