Excel Add-In v1

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, and FastTrack.DateCalc functions 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.

Complete function reference

Returns

Annualized and total-return calculations.

Legacy compatibility: These formulas remain available for existing workbooks. Use the consolidated functions for new spreadsheets.

FastTrack.AnnReturn

Annualized return of ticker over specified dates

Syntax

=FastTrack.AnnReturn(ticker, [start], [end])

Returns: number

Parameters

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst 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
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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.

Legacy compatibility: These formulas remain available for existing workbooks. Use the consolidated functions for new spreadsheets.

FastTrack.Price

Dividend adjusted price of the specified date

Syntax

=FastTrack.Price(ticker, [date])

Returns: number

Parameters

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate to display
lengthstringOptionalNumber 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate to display
avg lengthnumberOptionalAverage 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
datestringOptionalDate 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.

Legacy compatibility: These formulas remain available for existing workbooks. Use the consolidated functions for new spreadsheets.

FastTrack.Category

Category of ticker

Syntax

=FastTrack.Category(ticker)

Returns: string

Parameters

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol

Example

=FastTrack.ExpenseRatio("SPY")

Recommended modern equivalent

=FastTrack.Info("SPY", "EXPENSE")

Get link to launch chart, report, and more in a browser

Syntax

=FastTrack.FTCloudLink(ticker)

Returns: string

Parameters

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
endstringOptionalLast day of calculation. Takes any date format, julian value, or market date
typestringOptionalWhich dividend types to include in yield calculation. Choose from 'ALL', 'SHORT', 'LONG', 'INCOME'
periodstringOptionalTrailing time period for calculation. Options: M, Q, 1 for trailing month, quarter, and year

Example

=FastTrack.Yield("SPY", "11/24/19", "INCOME", "1")
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

Statistics

Risk, correlation, drawdown, and benchmark-relative statistics.

Legacy compatibility: These formulas remain available for existing workbooks. Use the consolidated functions for new spreadsheets.

FastTrack.Alpha

Alpha of ticker, compared to basis, over specified dates

Syntax

=FastTrack.Alpha(ticker, [basis], [length], [start], [end])

Returns: number

Parameters

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
lengthstringOptionalNumber of days to calculate correlation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
lengthstringOptionalNumber of days to calculate correlation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
lengthstringOptionalNumber of days to calculate correlation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast day of calculation. Takes any date format, julian value, or market date

Example

=FastTrack.FTAlpha("SPY", "TLT", "12/31/18", "11/24/19")
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

FastTrack.MaxDrawDown

Maximum drawdown (loss) of ticker over specified dates

Syntax

=FastTrack.MaxDrawDown(ticker, [start], [end])

Returns: number

Parameters

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
lengthstringOptionalNumber of days to calculate correlation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
riskfreenumberOptionalPercentage rate to use as risk free rate. Example: .05 for 5%, .1 for 10%
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
basisstringOptionalTicker symbol to use as basis for calculation
startstringOptionalFirst day of calculation. Takes any date format, julian value, or market date
endstringOptionalLast 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.

Legacy compatibility: These formulas remain available for existing workbooks. Use the consolidated functions for new spreadsheets.

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

NameTypeRequirementDescription
xformatstringOptionalExport Calendar Date (C), Market Date (M), or Julian Date (J)
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
Month EndbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
lengthstringOptionalNumber of days over which to average the data
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly 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

NameTypeRequirementDescription
tickerstringRequiredTicker Symbol
startstringOptionalFirst day of export. Takes any date format, julian value, or market date
endstringOptionalLast day of export. Takes any date format, julian value, or market date
includedatesbooleanOptionalOutput two column. First is dates and second is prices
reversebooleanOptionalData sort: true sorts desc and false sorts asc
horizontalbooleanOptionalSpill data left to right vs up and down
monthendbooleanOptionalOnly return month end values

Example

=FastTrack.ExportSemiadjPrices("SPY", "12/31/18", "11/24/19", FALSE, FALSE, FALSE, FALSE)
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

Date, Family & Utilities

Date conversion, family lookup, refresh, and database-date helpers.

Legacy compatibility: These formulas remain available for existing workbooks. Use the consolidated functions for new spreadsheets.

FastTrack.Date2MarketDay

Convert any type of date to FastTrack Market Date

Syntax

=FastTrack.Date2MarketDay(date)

Returns: number

Parameters

NameTypeRequirementDescription
datestringRequiredDate 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

NameTypeRequirementDescription
datestringRequiredDate 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

NameTypeRequirementDescription
datestringRequiredDate 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

NameTypeRequirementDescription
datestringRequiredDate to convert. Accepts market days, calendar dates, or julian dates
intervalstringRequired'D' for days 'M' for months
numbernumberRequiredPeriods to add/subtract
eombooleanOptionalReturn 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()
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

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()
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

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

NameTypeRequirementDescription
famnamestringRequiredExport Calendar Date (C), Market Date (M), or Julian Date (J)
horizontalbooleanOptionalSpill to horizontal or vertical range. Default is vertical.

Example

=FastTrack.Family("ETF - Vanguard", FALSE)
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

Output search results into the 'spill range' below the formula cell

Syntax

=FastTrack.FamilySearch([searchttext])

Returns: spill array (string)

Parameters

NameTypeRequirementDescription
searchttextstringOptionalExport Calendar Date (C), Market Date (M), or Julian Date (J)

Example

=FastTrack.FamilySearch("Fidelity")
Compatibility note: No direct consolidated replacement is currently documented. Continue using this legacy formula in existing workbooks.

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()