Excel Add-In v1
The original FastTrack Excel functions remain supported for backwards compatibility. Existing workbooks can continue using these formulas. For new spreadsheets, use the consolidated
FastTrack.Info,FastTrack.Quote,FastTrack.Stat,FastTrack.Export, andFastTrack.DateCalcfunctions documented at support.fasttrack.net.
Function reference
The legacy reference is organized by purpose:
- Returns — annualized return and total return
- Price & Market Data — price, open, high, low, moving average, volume, and unadjusted price
- Reference Data — category, expense ratio, security type, names, inception data, market capitalization, and related fields
- Statistics — alpha, beta, correlation, drawdown, Sharpe, Sortino, standard deviation, Treynor, Ulcer Index, and UPI
- Historical Exports — spill arrays for dates, prices, moving averages, and volume
- Date, Family & Utilities — date conversions, date math, family lookup, database dates, and cache refresh
Use the navigation on the left to open a category.
Common migration examples
| Legacy formula | Recommended formula for new workbooks |
|---|---|
=FastTrack.Price("SPY") |
=FastTrack.Quote("SPY", "CLOSE") |
=FastTrack.Category("SPY") |
=FastTrack.Info("SPY", "CATEGORY") |
=FastTrack.TotalReturn("SPY", "1Y") |
=FastTrack.Stat("SPY", "TOTALRETURN",, "1Y") |
=FastTrack.ExportPrices("SPY", start, end) |
=FastTrack.Export("SPY", "CLOSE", start, end) |
=FastTrack.Date2Julian(date) |
=FastTrack.DateCalc(date, "TOJULIAN") |
Existing formulas do not need to be converted merely to keep a workbook working.
Date conventions
Date parameters accept an Excel date cell, a quoted date such as "12/31/2024", a Julian date, or a FastTrack market-day number.
When a start date is omitted, legacy calculations generally default to one trailing year. When an end date is omitted, they default to the latest market day in the FastTrack database.
Legacy date short codes include 1M, 3M, 6M, 9M, 12M, 1Y, 2Y, 3Y, 5Y, 10Y, and Y for year-to-date.
Recalculation
Legacy FastTrack functions are non-volatile and recalculate when their inputs change. Use Excel's full recalculation command when you need to refresh an unchanged workbook.
Legacy function directory
Select a function below to jump directly to its complete reference.
Returns
Price & Market Data
Reference Data
Statistics
Historical Exports
Date, Family & Utilities
Complete function reference
Returns
Annualized and total-return calculations.
FastTrack.AnnReturn
Annualized return of ticker over specified dates
Syntax
=FastTrack.AnnReturn(ticker, [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date. Takes any date format, julian value, or market date Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.AnnReturn("SPY", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "ANNRETURN",, "12/31/18", "11/24/19")
FastTrack.TotalReturn
Total return of ticker over specified dates
Syntax
=FastTrack.TotalReturn(ticker, [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.TotalReturn("SPY", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "TOTALRETURN",, "12/31/18", "11/24/19")
Price & Market Data
Single-value price, moving-average, and volume formulas.
FastTrack.Price
Dividend adjusted price of the specified date
Syntax
=FastTrack.Price(ticker, [date])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
Example
=FastTrack.Price("SPY", "12/31/18")
Recommended modern equivalent
=FastTrack.Quote("SPY", "CLOSE", "12/31/18")
FastTrack.Open
Dividend adjusted open price of the specified date
Syntax
=FastTrack.Open(ticker, [date])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
Example
=FastTrack.Open("SPY", "12/31/18")
Recommended modern equivalent
=FastTrack.Quote("SPY", "OPEN", "12/31/18")
FastTrack.High
Dividend adjusted high price of the specified date
Syntax
=FastTrack.High(ticker, [date])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
Example
=FastTrack.High("SPY", "12/31/18")
Recommended modern equivalent
=FastTrack.Quote("SPY", "HIGH", "12/31/18")
FastTrack.Low
Dividend adjusted low price of the specified date
Syntax
=FastTrack.Low(ticker, [date])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
Example
=FastTrack.Low("SPY", "12/31/18")
Recommended modern equivalent
=FastTrack.Quote("SPY", "LOW", "12/31/18")
FastTrack.MovingAvg
Moving average value of specified date and moving average length
Syntax
=FastTrack.MovingAvg(ticker, [date], [length])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
length | string | Optional | Number of days over which to average the data |
Example
=FastTrack.MovingAvg("SPY", "12/31/18", 21)
Recommended modern equivalent
=FastTrack.Quote("SPY", "MA", "12/31/18", 21)
FastTrack.Volume
Dividend adjusted volume price of the specified date
Syntax
=FastTrack.Volume(ticker, [date], [avg length])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
avg length | number | Optional | Average length of volume |
Example
=FastTrack.Volume("SPY", "12/31/18", 0)
Recommended modern equivalent
=FastTrack.Quote("SPY", "VOLUME", "12/31/18")
FastTrack.UnadjPrice
Unadjusted open price of the specified date
Syntax
=FastTrack.UnadjPrice(ticker, [date])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
date | string | Optional | Date to display |
Example
=FastTrack.UnadjPrice("SPY", "12/31/18")
Recommended modern equivalent
=FastTrack.Quote("SPY", "UNADJ", "12/31/18")
Reference Data
Security names, classifications, dates, and other metadata.
FastTrack.Category
Category of ticker
Syntax
=FastTrack.Category(ticker)
Returns: string
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.Category("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "CATEGORY")
FastTrack.ExpenseRatio
Expense ratios of fund, ETF, or COF
Syntax
=FastTrack.ExpenseRatio(ticker)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.ExpenseRatio("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "EXPENSE")
FastTrack.FTCloudLink
Get link to launch chart, report, and more in a browser
Syntax
=FastTrack.FTCloudLink(ticker)
Returns: string
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.FTCloudLink("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "CLOUDLINK")
FastTrack.MarketCap
Lastest market capitalization of ticker
Syntax
=FastTrack.MarketCap(ticker)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.MarketCap("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "MARKETCAP")
FastTrack.SharesOutstanding
Latest shares outstanding value for ticker
Syntax
=FastTrack.SharesOutstanding(ticker)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.SharesOutstanding("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "SHARESOUT")
FastTrack.SecurityType
Type of security: Mutual Fund, Stock, ETF, Index
Syntax
=FastTrack.SecurityType(ticker)
Returns: string
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.SecurityType("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "TYPE")
FastTrack.ShareClass
Share class of Mutual Fund
Syntax
=FastTrack.ShareClass(ticker)
Returns: string
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.ShareClass("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "SHARECLASS")
FastTrack.StartDate
Market day representing ticker's first day of prices
Syntax
=FastTrack.StartDate(ticker)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.StartDate("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "STARTDATE")
FastTrack.Inception
Market day representing ticker's first day of prices
Syntax
=FastTrack.Inception(ticker)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.Inception("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "STARTDATE")
FastTrack.SymName
Name of specified ticker
Syntax
=FastTrack.SymName(ticker)
Returns: string
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
Example
=FastTrack.SymName("SPY")
Recommended modern equivalent
=FastTrack.Info("SPY", "NAME")
FastTrack.Yield
Trailing distribution yield of ticker from the end date. Default is trailing 1 year income distributions only.
Syntax
=FastTrack.Yield(ticker, [end], [type], [period])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
type | string | Optional | Which dividend types to include in yield calculation. Choose from 'ALL', 'SHORT', 'LONG', 'INCOME' |
period | string | Optional | Trailing time period for calculation. Options: M, Q, 1 for trailing month, quarter, and year |
Example
=FastTrack.Yield("SPY", "11/24/19", "INCOME", "1")
Statistics
Risk, correlation, drawdown, and benchmark-relative statistics.
FastTrack.Alpha
Alpha of ticker, compared to basis, over specified dates
Syntax
=FastTrack.Alpha(ticker, [basis], [length], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
length | string | Optional | Number of days to calculate correlation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.Alpha("SPY", "TLT", 21, "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "ALPHA", "TLT", "12/31/18", "11/24/19", 21)
FastTrack.Beta
Beta of ticker, compared to basis, over specified dates
Syntax
=FastTrack.Beta(ticker, [basis], [length], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
length | string | Optional | Number of days to calculate correlation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.Beta("SPY", "TLT", 21, "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "BETA", "TLT", "12/31/18", "11/24/19", 21)
FastTrack.Corr
Correlation between ticker and basis over specified dates
Syntax
=FastTrack.Corr(ticker, [basis], [length], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
length | string | Optional | Number of days to calculate correlation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.Corr("SPY", "TLT", 21, "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "CORR", "TLT", "12/31/18", "11/24/19", 21)
FastTrack.FTAlpha
FT Alpha of ticker, compared to the basis, over specified dates
Syntax
=FastTrack.FTAlpha(ticker, [basis], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.FTAlpha("SPY", "TLT", "12/31/18", "11/24/19")
FastTrack.MaxDrawDown
Maximum drawdown (loss) of ticker over specified dates
Syntax
=FastTrack.MaxDrawDown(ticker, [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.MaxDrawDown("SPY", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "MAXDRAW",, "12/31/18", "11/24/19")
FastTrack.RSquared
Coefficient of determination for the time period
Syntax
=FastTrack.RSquared(ticker, [basis], [length], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
length | string | Optional | Number of days to calculate correlation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.RSquared("SPY", "TLT", 21, "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "RSQUARED", "TLT", "12/31/18", "11/24/19", 21)
FastTrack.Sortino
Sortino ratio for the time period
Syntax
=FastTrack.Sortino(ticker, [basis], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.Sortino("SPY", "TLT", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "SORTINO", "TLT", "12/31/18", "11/24/19")
FastTrack.SharpeRatio
Sharpe ratioof ticker, compared to basis, over specified dates
Syntax
=FastTrack.SharpeRatio(ticker, [basis], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.SharpeRatio("SPY", "TLT", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "SHARPE", "TLT", "12/31/18", "11/24/19")
FastTrack.StandardDeviation
Standard Deviation of ticker over specified dates
Syntax
=FastTrack.StandardDeviation(ticker, [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.StandardDeviation("SPY", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "STDDEV",, "12/31/18", "11/24/19")
FastTrack.Treynor
Treynor Ratio of ticker over specified dates
Syntax
=FastTrack.Treynor(ticker, [basis], [riskfree], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
riskfree | number | Optional | Percentage rate to use as risk free rate. Example: .05 for 5%, .1 for 10% |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.Treynor("SPY", "TLT", 0, "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "TREYNOR", "TLT", "12/31/18", "11/24/19")
FastTrack.UlcerIndex
Ulcer Index of ticker over specified dates
Syntax
=FastTrack.UlcerIndex(ticker, [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.UlcerIndex("SPY", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "ULCER",, "12/31/18", "11/24/19")
FastTrack.UPI
Ulcer Performance Index of ticker, compared to the basis, over specified dates
Syntax
=FastTrack.UPI(ticker, [basis], [start], [end])
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
basis | string | Optional | Ticker symbol to use as basis for calculation |
start | string | Optional | First day of calculation. Takes any date format, julian value, or market date |
end | string | Optional | Last day of calculation. Takes any date format, julian value, or market date |
Example
=FastTrack.UPI("SPY", "TLT", "12/31/18", "11/24/19")
Recommended modern equivalent
=FastTrack.Stat("SPY", "UPI", "TLT", "12/31/18", "11/24/19")
Historical Exports
Spill-array formulas for historical dates, prices, averages, and volume.
FastTrack.ExportDates
Output dates into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportDates([xformat], [start], [end], [reverse], [horizontal], [Month End])
Returns: spill array (string)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
xformat | string | Optional | Export Calendar Date (C), Market Date (M), or Julian Date (J) |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
Month End | boolean | Optional | Only display month end data |
Example
=FastTrack.ExportDates("C", "12/31/18", "11/24/19", FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("C", "DATES", "12/31/18", "11/24/19")
FastTrack.ExportPrices
Output dividend adjusted prices into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportPrices(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "CLOSE", "12/31/18", "11/24/19", TRUE)
FastTrack.ExportOpenPrices
Output daily adjusted open prices into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportOpenPrices(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportOpenPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "OPEN", "12/31/18", "11/24/19", TRUE)
FastTrack.ExportHighPrices
Output daily adjusted high prices into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportHighPrices(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportHighPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "HIGH", "12/31/18", "11/24/19", TRUE)
FastTrack.ExportLowPrices
Output daily adjusted low prices into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportLowPrices(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportLowPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "LOW", "12/31/18", "11/24/19", TRUE)
FastTrack.ExportMovingAvg
Output moving average values into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportMovingAvg(ticker, [length], [start], [end], [includedates], [reverse], [horizontal])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
length | string | Optional | Number of days over which to average the data |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
Example
=FastTrack.ExportMovingAvg("SPY", 21, "12/31/18", "11/24/19", FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "MA", "12/31/18", "11/24/19", TRUE,,,,21)
FastTrack.ExportUnadjPrices
Output three years of unadjusted prices into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportUnadjPrices(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportUnadjPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "UNADJ", "12/31/18", "11/24/19", TRUE)
FastTrack.ExportVolumes
Output volume data into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportVolumes(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportVolumes("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Recommended modern equivalent
=FastTrack.Export("SPY", "VOLUME", "12/31/18", "11/24/19", TRUE)
FastTrack.ExportSemiadjPrices
Output data adjusted only for splits, ST, and LT capital gains distributions into the spill range below/right of the formula cell
Syntax
=FastTrack.ExportSemiadjPrices(ticker, [start], [end], [includedates], [reverse], [horizontal], [monthend])
Returns: spill array (number)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
ticker | string | Required | Ticker Symbol |
start | string | Optional | First day of export. Takes any date format, julian value, or market date |
end | string | Optional | Last day of export. Takes any date format, julian value, or market date |
includedates | boolean | Optional | Output two column. First is dates and second is prices |
reverse | boolean | Optional | Data sort: true sorts desc and false sorts asc |
horizontal | boolean | Optional | Spill data left to right vs up and down |
monthend | boolean | Optional | Only return month end values |
Example
=FastTrack.ExportSemiadjPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Date, Family & Utilities
Date conversion, family lookup, refresh, and database-date helpers.
FastTrack.Date2MarketDay
Convert any type of date to FastTrack Market Date
Syntax
=FastTrack.Date2MarketDay(date)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
date | string | Required | Date to convert |
Example
=FastTrack.Date2MarketDay("12/31/18")
Recommended modern equivalent
=FastTrack.DateCalc("12/31/18", "TOMARKETDAY")
FastTrack.Date2Julian
Convert any type of date to Julian date
Syntax
=FastTrack.Date2Julian(date)
Returns: number
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
date | string | Required | Date to convert |
Example
=FastTrack.Date2Julian("12/31/18")
Recommended modern equivalent
=FastTrack.DateCalc("12/31/18", "TOJULIAN")
FastTrack.Date2String
Convert any type of date to MM/dd/yyyy string
Syntax
=FastTrack.Date2String(date)
Returns: string
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
date | string | Required | Date to convert |
Example
=FastTrack.Date2String("12/31/18")
Recommended modern equivalent
=FastTrack.DateCalc("12/31/18", "TOSTRING")
FastTrack.DateMath
Convert any type of date to MM/dd/yyyy string
Syntax
=FastTrack.DateMath(date, interval, number, [eom])
Returns: any
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
date | string | Required | Date to convert. Accepts market days, calendar dates, or julian dates |
interval | string | Required | 'D' for days 'M' for months |
number | number | Required | Periods to add/subtract |
eom | boolean | Optional | Return only end of month values |
Example
=FastTrack.DateMath("12/31/18", "M", -12, FALSE)
Recommended modern equivalent
=FastTrack.DateCalc("12/31/18", "ADDMONTHS", -12, TRUE)
FastTrack.MaxNumDays
Get last day in the FastTrack databbase, represented as a market day
Syntax
=FastTrack.MaxNumDays()
Returns: number
Parameters
This function has no parameters.
Example
=FastTrack.MaxNumDays()
FastTrack.Today
Get last day in the FastTrack databbase, represented as a MM/DD/YYY
Syntax
=FastTrack.Today()
Returns: string
Parameters
This function has no parameters.
Example
=FastTrack.Today()
FastTrack.Family
Output the tickers in specified family to the 'spill range' below the formula cell
Syntax
=FastTrack.Family(famname, [horizontal])
Returns: spill array (string)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
famname | string | Required | Export Calendar Date (C), Market Date (M), or Julian Date (J) |
horizontal | boolean | Optional | Spill to horizontal or vertical range. Default is vertical. |
Example
=FastTrack.Family("ETF - Vanguard", FALSE)
FastTrack.FamilySearch
Output search results into the 'spill range' below the formula cell
Syntax
=FastTrack.FamilySearch([searchttext])
Returns: spill array (string)
Parameters
| Name | Type | Requirement | Description |
|---|---|---|---|
searchttext | string | Optional | Export Calendar Date (C), Market Date (M), or Julian Date (J) |
Example
=FastTrack.FamilySearch("Fidelity")
FastTrack.ClearCache
Get last day in the FastTrack databbase, represented as a MM/DD/YYY
Syntax
=FastTrack.ClearCache()
Returns: string
Parameters
This function has no parameters.
Example
=FastTrack.ClearCache()
Recommended modern equivalent
=FastTrack.ClearCache()