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
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680203/Asset_90b1fd64-a276-42b5-8a5c-ae542e31fe4b/WatchlistHistPrice.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680203/Asset_90b1fd64-a276-42b5-8a5c-ae542e31fe4b/WatchlistHistPrice.png