Home

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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
cuong
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

1 Reply

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! 

 

Related Conversations