Investment portfolio

[JulieB]

Hello,

I would like to set up a portfolio spreadsheet where I would have a table with the following fields:

Stock name
Ticker
Price
Dividends
... maybe other available information...

The stock would be listed in either the NY stock exchange, or in the Toronto stock exchange.
There would be a button I would click on to update the information.
Thank you for your help.

 

[vletm]

JulieB​

Have You tested below ( Stocks ) Yourself?

Excel data types: Stocks and geography - Microsoft Support

Get stock prices and geographic-based data using the Stocks and Geography data types. These two data types are new, and they are considered linked data types. This articles explains how to insert them.

support.microsoft.com