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

excel

5 Replies

  • Hedge_Fund_Manager's avatar
    Hedge_Fund_Manager
    Brass Contributor
    Nov 13, 2022
    Dividends per year and last dividend are vital pieces of data for those trying to live on fixed income etc
  • Sanjay Patel's avatar
    Sanjay Patel
    Copper Contributor
    Sep 05, 2019

    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! 

     

    • mko07's avatar
      mko07
      Copper Contributor
      May 10, 2022
      Dividend Yield Information is very important!
    • dniezby's avatar
      dniezby
      Copper Contributor
      Oct 30, 2019
      Anyone have a way to get dividend data into a spreadsheet?
      • James_Duade's avatar
        James_Duade
        Copper Contributor
        Jul 08, 2020

        dniezby , cuong ,

         

        Is there a roadmap for when dividends and dividend yield will be added to Excel stock data types? About a year ago I wrote a bog post on the popular finance website Seeking Alpha regarding Excel stock types, and I received a lot of feedback that stock types won't be widely adopted until dividend information is included. Any feedback would be greatly appreciated.

         

        A link to the blog post is below, please review the comments section.

        https://seekingalpha.com/instablog/510561-james-duade/5305602-using-excel-stock-data-types-to-create-live-portfolio-tracker

         

        Best,

        James

Resources