Knowledge Base
Quick links to templates and tutorials to help you get the most out of Excel Price Feed.
They are grouped by data provider and include a sample spreadsheet.
Yahoo Finance
All Stock Formulas
This template demonstrates all Yahoo Finance stock related formulas.
ETF Performance Heatmap
Compare the historical performance of a set of sector specific ETFs as a heatmap.
Historical data formulas
This template demonstrates all Yahoo Finance historical data formulas.
Stock Fundamental Analysis
A template for analysing fundamental stock data.
Company Income Summary 10-K
Company income summary based on SEC form 10-K.
Stock Cash Flow
A template for analysing stock cash flow data.
Investment Portfolio
Build an investment portfolio spreadsheet with realtime data.
Stock Screener
Screen a selection of stocks based on a variety of criteria.
Live & Historic Currency Exchange Rates
A tutorial on adding realtime exchange rates to your Excel spreadsheet.
IG Index / IG Markets
Client Sentiment Analysis
Compare IG Index client sentiment across markets.
Amibroker Historical Data
Export IG Index historical price data to AmiBroker.
FRED (Federal Reserve Economic Data)
FRED Data Explorer
All the FRED Excel formulas available for accessing economic data.
FRED US Treasury Yield Analysis
FRED template with both current and historical US Treasury Bond yields.
EODHistoricalData.com
All Formulas
All formulas available including fundamentals, analysis and historical data.
Miscellaneous
Date/Time Formulas
Template with date/time "Now" and time zone conversion formulas.
Instrument Identifier Conversion
Demonstrates how to use the instrument identifier conversion formulas.
Technical Analysis Toolkit
Template demonstrating the technical analysis indicators.