Stocks Data Type in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-671761%22%20slang%3D%22en-US%22%3EStocks%20Data%20Type%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-671761%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20this%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fstocks-data-type-PR%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPR%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fstocks-data-type-blog%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eblog%3C%2FA%3E%20for%20the%20latest%20announcement%20on%20Stocks%20Data%20Type%20in%20Excel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fblog%2Fwp-content%2Fuploads%2Fsites%2F2%2F2019%2F06%2FNasdaq-stocks-data-type.gif%22%20border%3D%220%22%20alt%3D%22Animated%20screenshot%20of%20the%20Stocks%20Data%20Type%20in%20action%20in%20Excel.%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-671761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-838247%22%20slang%3D%22en-US%22%3ERe%3A%20Stocks%20Data%20Type%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-838247%22%20slang%3D%22en-US%22%3E%3CP%3ELove%20this%20function%20and%20using%20it%20to%20manage%20my%20own%20portfolio.%20Great%20replacement%20for%20the%20old%20yahoo%20webservice%20and%20super%20to%20have%20this%20integrated%20into%20Excel%20directly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20few%20items%20would%20like%20to%20see%20in%20the%20roadmap%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Live%20Stock%20Indices%20FTSE100%2C%20DAX%2C%20DJI%20etc..%20if%20possible.%3C%2FP%3E%3CP%3E2.%20Adding%20the%20ability%20to%20auto-refresh%20specific%20stock%20data%20type%20(Price)%20cells%20every%20xx%20Minutes%20natively.%3C%2FP%3E%3CP%3E3.%20Historical%20price%20close%20data%20for%20a%20given%20date%20value%3C%2FP%3E%3CP%3E4.%20Dividend%20Yield%20Information%20(Yield%2C%20payment%20date%20when%20available...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks!%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-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1507446%22%20slang%3D%22en-US%22%3ERe%3A%20Stocks%20Data%20Type%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F436009%22%20target%3D%22_blank%22%3E%40dniezby%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20roadmap%20for%20when%20dividends%20and%20dividend%20yield%20will%20be%20added%20to%20Excel%20stock%20data%20types%3F%20About%20a%20year%20ago%20I%20wrote%20a%20bog%20post%20on%20the%20popular%20finance%20website%20Seeking%20Alpha%20regarding%20Excel%20stock%20types%2C%20and%20I%20received%20a%20lot%20of%20feedback%20that%20stock%20types%20won't%20be%20widely%20adopted%20until%20dividend%20information%20is%20included.%20Any%20feedback%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20link%20to%20the%20blog%20post%20is%20below%2C%20please%20review%20the%20comments%20section.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fseekingalpha.com%2Finstablog%2F510561-james-duade%2F5305602-using-excel-stock-data-types-to-create-live-portfolio-tracker%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fseekingalpha.com%2Finstablog%2F510561-james-duade%2F5305602-using-excel-stock-data-types-to-create-live-portfolio-tracker%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3EJames%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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

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

 

thanks! 

 

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.

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

 

Best,

James