Přeskočit na hlavní obsah

Security Historical Prices with Charts

Garden City Consultants

A tool to get security historical prices and draw performance charts based on the prices


Security Historical Price with Charts Add-in retrieves the security historical prices and draws column/line/area charts.


  • Price grid color highlighted by price change

  • Percentage daily change is calculated

  • 3 types of Price charts

  • Multiple securities on different or sames tabs


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

  • Enter a security symbol for getting the historical price.

  • Select a period, such as 3 months, 6 months, 1 year, 3 years, 5 years.

  • Select a frequency of monthly, weekly, quarterly.

  • Click Price button. The historical prices is shown in Excel grid with color.

  • Select a chart type and click Draw button to draw the price chart.

  • Create a new sheet and enter new symbol and repeat above steps.

Quotes Source:Quandl Data API

DISCLAIMER:Quotes are delayed 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.

Schopnosti doplňku
Když se tento doplněk použije, může
  • Číst a měnit váš dokument
  • Posílat data přes internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679355/Asset_80b80124-7c49-4946-9f4e-758db99e3033/OAIHistoricalPrice2.png