Forum Discussion

cuong's avatar
cuong
Icon for Microsoft rankMicrosoft
Jun 05, 2019

Stocks Data Type in Excel

See this PR and blog for the latest announcement on Stocks Data Type in Excel

 

Animated screenshot of the Stocks Data Type in action in Excel.

 

Cuong

Microsoft

  • Sanjay Patel's avatar
    Sanjay Patel
    Copper Contributor

    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...)

     

    thanks! 

     

  • Dividends per year and last dividend are vital pieces of data for those trying to live on fixed income etc

Share

Resources