Getting Started

• Introduction
• Download
• Installation & Activation
• Troubleshooting
• Data Refresh/Updates
• Software Updates
• Manage Your Subscription
• Example Spreadsheets

General Formulas

• Black-Scholes Option Pricing

Technical Indicators (Coming Soon)

• Introduction
• Simple Moving Average (SMA)
• Exponential Moving Average (EMA)
• Volume Weighted Average Price (VWAP)

Yahoo Finance

• Formula Reference
• • Stocks
  • Stocks: Income Statement
  • Stocks: Balance Sheet
  • Stocks: Cash Flow
  • Stocks: Analysis
  • Stocks: ESG Risk Ratings
  • Options Chain
  • Stock Options
  • Mutual Funds
  • ETFs
  • FX Rates
  • Cryptocurrencies
  • Commodities
  • Historical Market Data
  • News
• Historical Array Formulas
• Historical Data Download

IG Index / IG Markets

• Account Setup
• Formula Reference
• VBA Functions Reference
• Historical Price Data Download To Excel
• Historical Price Data Download To File
• Historical Client Sentiment Data Download
• Watchlists
• Live Positions, Transactions & Activity History

EODHistoricalData.com

• Overview & Setup
• Historical Price Data
• Stocks Fundamental Data
• Stocks Financial Analysis

Quandl

• Overview & Setup
• Formula Reference

Example Excel Spreadsheets

The Add-in provides a huge range of new Excel formulas. Discovering which ones are available and how to use them can be a bit daunting.

Therefore, we have built and provide easy access to a bunch of example spreadsheets to help you quickly get started.

To download a spreadsheet either click on its name or image; and do let us know if you have built a useful spreadsheet which you would like to share with others.

Yahoo Finance

All Yahoo Finance Excel Formulas

This spreadsheet is a great introduction to the Add-in. It includes almost all the Excel formulas available for Yahoo Finance data.

It is structured similar to the Yahoo Finance website so should look familiar:

ESG Ratings Stock Analysis

This spreadsheet demonstrates how to compare Environment, Social and Governance (ESG) Risk Ratings across various companies (in this case the 30 DJIA constituents.

It also makes great use of some Excel visualization features such as data bars and heatmaps:

ETF Performance Heatmap

This spreadsheet shows how you can compare the historical performance of a set of sector specific ETFs.

It is structured as a heatmap so you can quickly see which sectors have performed the best. Please follow the instruction on the spreadsheet in order to refresh the data: