• Skip to main content
  • Skip to footer

Investors FastTrack

Quality Data for Investing Strategies

  • Products
    • Products
    • Feature Comparison
    • Pricing
  • Subscribe
  • Download
    • FT4web
    • FT Cloud
  • Resources
    • Blog
    • FT Comm Manual
    • FT Cloud Manual
    • API Documentation
    • Investing Math
    • Videos
    • Data Status
  • About
    • About Us
    • FAQ
  • (866) 295-0166
  • Current Subscribers

Market Data in Excel

Streamline your investment process

If you know how to use Excel, you can use FastTrack Market Data Add-in.

Create, automate, and fine-tune investment analytics in Microsoft Excel with our Market Data Excel Add In.

  • 40+ data, statistical and reference functions
  • Export closing prices directly
  • Easy to try. Install here
  • Windows, Mac, or Browser compatible
  • 30k+ Mutual Funds, 2.5k+ ETFs, 5k+ Stocks, 1500+ Market Indexes
  • Free Support M-F 9AM-4PM EST
  • Starting at $25 a month
Start Free Trial
microsoft excel etf data

Get Started with Market Data Excel Add In

Available Functions
Download Templates
Price

Install Add-in - Sign In

excel add in mutual fund data


Data Coverage

30,000+ Open Ended Funds

2,200+ ETFs

5,500+ Stocks

1,200+ Indexes

500+ Closed End Funds

Corp and Gov Bonds

Search the Database

FastTrack’s database covers virtually all investable Funds, ETFs, and Stocks. Our data goes back to 1988.

We include 30,000+ open ended mutual funds, 500+ closed end funds, 2,500+ ETFs, 4,500+ stocks, and 1,200+ indexes. We update our catalog daily, pruning discontinued, merged, and liquidated funds while adding all requests and new issues.

FastTrack’s index catalog contains all major market indexes, commodity indexes, international indexes, and more. Notably, FastTrack’s index database contains comprehensive coverage of investment-grade, junk, and emerging market bond indexes.

Closing prices are updated three times a day, 7am, 6:35pm and 8:20pm Eastern. The status is available via the Data Status API.


Export Closing Prices

Export closing prices

Mutual funds, ETFs, Stocks, and Indexes

Quickly export a date range of closing prices with our Excel Add In Export Data tool

  • Data back to 1988
  • Include security name and ticker
  • Sort by date
  • Export vertical or horizontal

Custom Functions

FastTrack's Add In creates custom functions that draw FastTrack market data into excel. The full list of functions is below.

Dates

- All date values must be referenced from a cell or wrapped in quotes. Ex: "12/31/2019"
- Any "start" value left blank will default to a trailing 1 year of the most recent date
- Any "end" value left blank will default to the most recent market day

Date Short Codes

All start date parameters take the short codes below. Dates are calculated off of the end date parameter, defaulting to the latest market day when omitted.

Codes: "1M", "3M", "6M", "9M", "12M", "1Y", "2Y", "3Y", "5Y", "10Y", "Y" (YTD)
Volitile Functions

All the functions in the FastTrack Excel Add-in are non-volatile. This means the functions only recalculate when inputs (parameters) of the function are changed. Volatile functions recalculate when ANY cell changes (if you have lots of formulas always recalculating in your workbook, this can be VERY slow).

Use Ctrl + Alt + Shift + F9 to "Force Recalculate" FastTrack Excel Add-in functions.

Alternatively, add a Volitile function (such as =Today()) to any date parameter in the function and FastTrack's Excel Add In's custom fuction will act volitile (due to the volitile input as a date)

Both formulas below produce the same 1 year trailing return value.

Non volitile Trailing 1 year total return
=FastTrack.TotalReturn("JPM","1Y")

Volitile Trailing 1 year total return
=FastTrack.TotalReturn("JPM","1Y",Today())

Available Functions

Market Data Excel Add In Templates

Sector Heat Map

mutual fund data in excel for sector heat map

This excel template organizes 120 FastTrack tickers into a heatmap visualization. The template covers 11 sectors, such as Basic Materials, Communication Services, Consumer Cyclical, Tech, and Indexes. But modify with your own tickers as needed.

Portfolio Reallocation Template

rebalance mutual fund portfolios with this excel add in

This template is a worksheet to assist in portfolio rebalancing.

1. Add your current portfolio weighting

2. Add your desired portfolio weighting

The worksheet then indicates the number of shares to buy and sell for the desired portfolio.

Export Ticker Closing Prices

mutual fund data in excel for sector heat map

Weighted Portfolio Returns Template

review etf allocation with excel add in

This template is a worksheet to compare any portfolio against a single or weighted benchmark.

1. Defined your portfolio (ticker and % allocation)

2. Defined your benchmark or blended benchmark

Review the performance of your portfolio vs the benchmark on the Report page.

Portfolio Correlations Template

correlation of mutual funds in excel

This template is a cross-correlation matrix that compares the 5-year correlation of each portfolio component to each other.

Simply define the components of your portfolio, then view the heatmap graphic of the portfolio's cross-correlations.

Monthly S&P 500 Price Export

Simple template illustrating monthly price exports over a date range. Any prebuild FastTrack family can use this template. This shows the 500+ components of the S&P 500's monthly price exports.


Pricing

$25 a month

$25 a month allows access to 500 tickers a month

Included with FTCloud/Ft4web

Unlimited access is included with all FT Cloud+ and FT4web 2 database subscriptions. See Pricing options for FTCloud and FT4web


Install

FastTrack's Market Data Excel Add In is free to download via the Microsoft AppSource Office Store. 22 iShares ETFs are free to use with the add in, no account required.

microsoft excel add in for etf data

( https://appsource.microsoft.com/en-us/product/office/WA200001360?tab=Overview )


Sign In

sign in for mutual fund data in excel
  • After installing, open the FastTrack Market Data Task pane by clicking the FastTrack lightning bolt icon on the "Home" ribbon.
  • Click the "Account" link on the FastTrack Market Data Task Pane in the right side of Excel.
add your account number and password to access mutual fund data in excel
  • Enter your FastTrack account number and password.
  • Click "Save Credentials"

https://investorsfasttrack.com/pricing/

Footer

Contact Us

Investors FastTrack
3 Endless View Dr
Weaverville NC 28787

(866) 295-0166

About Us

Investors FastTrack is an industry leading mutual fund, ETF, and stocks market data provider. Since Investors FastTrack’s founding in 1989, FastTrack data has been a key component to thousands of money managers and individuals market success.

Investors FastTrack © 2023