Templates

This page contains downloadable templates that users of Barchart for Excel can use that leverage the data in our ecosystem. We are regularly adding new templates so please check back for updates.

Template	Description	Download	Preview

Template	Description	Download	Preview
Popular ETFs	The Major ETFs sheet allows you to view worldwide ETFs, hand-picked by the Barchart.com ETF Research Analysts. Analyze each ETF in the broad global sectors and gain a quick look at how these ETFs are performing against one another. Groupings include Global, U.S. Industries, Specialty Industries, Commodity Producers, Fixed Income, Commodities, and Currencies.
Commodities Overview	The Futures Commodity Groupings lists the lead contracts of the major North American futures markets.
Dow Jones Indices	View all the major Dow indices and their constituents in addition to charts covering the indexes and percentage of components trading over various moving averages.
S&P Indices	View all the major S&P indices and their constituents in addition to charts covering the indexes and percentage of components trading over various moving averages.
Max Pain	Use the Max Pain template to find the strike at which equity option holders (both calls and puts) stand to loose the greatest while option writers reap the highest capital return.
Multiple Stock Comparison	Compare up to three different stocks using price, return, fundamental and financial ratio data. Change any of the tickers and the sheet will dynamically update with the underlying’s data.
Option Implied Volatility Smile	Chart the equity option smile (skew) for any underlying that has listed options. Update the ticker symbol, expiration, number of strikes and select the style of chart (bar or line) to customize the data displayed.
Option Term Structure	Plot the at the money (ATM) implied volatility of monthly, weekly or all expirations against the current ATM straddle price using the Option Term Structure template. Scan for upward or downward sloping term structure to assist in finding the best option maturity to trade.
Options Strategy Builder	Input underlying price, lot sizes, strikes and position to view the strategy’s cost, max profit and loss, risk reward ratio, net delta, break even levels and % change to the BE prices. Click on the refresh price to pull in the latest available price.
Options Theoretical Calculator	Calculate an option’s theoretical price, delta, gamma, vega, theta and rho using the options theoretical calculator template. Once input parameters are set, plot any of the values against an underlying price and time to maturity.
US Treasury Yield Curve	Use the US Treasury Yield Curve template to visualize bond yields and their respective maturities today versus this time last year and two years ago. Analyze yield spreads like the 10Y - 2Y to see if the yield curve is steepening, flattening or potentially inverting.
Portfolio	Use the Portfolio template to track buy/sell transactions of your investments and calculate a profit or loss. Enter in the Input Variables and the template will automatically populate the ‘Portfolio Holdings, Profit/Loss, and Portfolio Summary data fields. View the investments visually by holding weights, sectors breakdown and market cap breakdown.
Return Analysis	Enter in a ticker and quickly pull in a historical return analysis for any equity or index. Plot the return dispersion, frequency and price changes over various time frames in addition to kurtosis, skew and standard deviation.