Stocks Data Type in Excel!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-964804%22%20slang%3D%22en-US%22%3ERe%3A%20Stocks%20Data%20Type%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-964804%22%20slang%3D%22en-US%22%3EAnyone%20have%20a%20way%20to%20get%20dividend%20data%20into%20a%20spreadsheet%3F%3C%2FLINGO't%20be%20widely%20adopted%20until%20dividend%20information%20is%20include

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.




3 Replies

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




Anyone have a way to get dividend data into a spreadsheet?

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