FastTrack Market Data

Excel Add In

Visit FastTrack's Microsoft AppSource Listing

Getting Started

The FastTrack Market Data Add In allows easy export of FastTrack data and statistics to Excel for personal use.

Simply add your account number and password to the FastTrack Market Data Add In Task Pane to access data.

Account

Password

Help Page

Full documentation, onboarding, and example templates are available on our help website.
Launch Excel Add In Help

Install

Get the FastTrack Market Data Add-in from Microsoft's AppSource
https://appsource.microsoft.com/en-us/product/office/WA200001360

Account Details

Monthly Usage

Your account can export 200mb of data into excel per month. Each ticker request is approximately 0.01 MB of data.

A typical month has 21 market days, so this limit allows approximately 950 tickers downloaded each market day.

Each time you open a new excel workbook, new data must be downloaded.

Current Ticker Usage

You've used out of the allowed per month. (* as of )

All subscribers are limited to 200 MB of export each month.
30 years of data for a single ticker is approximately 0.01 MB of data.

FT Cloud Console Export

This is a windows console program used to automate downloading the dividend adjusted prices for any family.

Install Instructions

Download the zip file
Unzip and save contents on computer
Run the setup.exe file: https://ftcloud.fasttrack.net/export/installFastTrackDataExport.zip

Data Export Instructions

FastTrackExport.exe is the program file that will export the dividend adjusted closing prices or statistics of a family to a csv file

Specify, "-EXPORT" or "-STATS"
Then list the below parameters (in any order):
- -a for account
- -p for password
- -k for export key (found in box above)
- -f for the family name
- -o for output file
- -s for start date (optional, default value is 9/1/88)
- -e for end date (optional, default value is last day in database)
- -l for log location (optional, default is "" and no log is written)

Examples

This comand line will download and save the closing prices for every ticker in the "All - ETF" family from Jan 1, 2000 to present

[install path]\fasttrackexport.exe -export -a [account] -p [password] -o "c:\temp\export.csv" -f "ALL - ETF" -s 2000-01-01"

This comand line will download and save the closing prices for every ticker in the "Index-S&P 500" family from Aug 1, 2010 to Aug 1, 2015

[install path]\fasttrackexport.exe -export -a [account] -p [password] -o "c:\temp\SP500.csv" -f "Index-S&P 500" -s 2010-08-01 -e 2015-08-01"

Investors FastTrack | (866) 295-0166 | support@FastTrack.net

Error