Gå til hovedinnhold

Watchlist Historical Price

Garden City Consultants

3.0 (2)

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/watch-list performance analysis.

The user can select 2 types of prices data: last price and return data.

The user can select 2 frequencies: Weekly data and monthly Data.

The user can select period by using the period drop-down. A custom option is for user to enter the date range.

This add-in is a task pane add-in. The user can select the "GCC Add-in" menu to show the add-in after downloading/purchasing the add-in.

To support more platforms, this add-in does not include the feature to color the cell by return since the coloring function only support Excel 2016 or higher.


  • Download this add in and start Excel 2016 or later.

  • Select GCC Add-in in the menu bar of Excel.

  • Click Watch-list Historical Price button in the GCC Add-in ribbon.

  • Select a desired data type in the Data drop-down.

  • Select Monthly or Weekly from Frequency drop-down.

  • Select a desired period in the period drop-down.

  • Click Price button to get the data.

DISCLAIMER: Quotes are delay data from Quandl Data API and are provided "as is" for informational and price analyzing purposes. They are not intended for trading or advice. GCC is not liable for any informational errors, incompleteness, or delays.

Funksjoner for tillegget
Når dette tilleggsprogrammet brukes, kan det gjøre følgende:
  • lese og gjøre endringer i dokumentet ditt
  • sende data over Internett
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680203/Asset_90b1fd64-a276-42b5-8a5c-ae542e31fe4b/WatchlistHistPrice.png