Skip to main content

Watchlist Historical Price

Garden City Consultants
A tool to get historical prices for a list of securities in a watchlist or portfolio

This add-in is requested by users who need to have a tool to get the historical prices for a list of securities. This add-in can be used for portfolio/watchlist performance analysis.

There are 2 types of prices data can be selected: last price and return data.

There are 2 frequencies are supported: Weekly data and Monthly Data.

You also can select period by using the period drop down. There is a custom option for you to enter the date range.

This add-in is a task pane add-in. You can select the "GCC Addin" menu to show the addin after you download/purchase the add-in.

In order to support more platform, this add-in did not include the feature to color the cell by return data that the coloring function only support Excel 2016 or higher.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet