Function Reference
Core Functions
All functions use the FastTrack namespace. The 4
master functions below cover most use cases.
FastTrack.Info(ticker, field)
Metadata
Retrieves static metadata about a security — name, category, type, expense
ratio, and more.
=FastTrack.Info("SPY", "NAME")
=FastTrack.Info("OAKIX", "EXPENSE")
▶ Parameters & Fields
| Param |
Type |
Description |
| ticker |
string |
Ticker symbol (e.g. "SPY") |
| field |
string |
Data point to retrieve |
Valid
Fields:
NAME
CATEGORY
TYPE
EXPENSE
MARKETCAP
STARTDATE
INCEPTION
CLOUDLINK
FTALPHA
FastTrack.Quote(ticker, field, [date],
[length])
Price Data
Returns a single historical data point — closing price, open, high, low,
volume, or moving average for a given date.
=FastTrack.Quote("SPY", "PRICE",
"1/1/2023")
=FastTrack.Quote("SPY", "MA", "1/1/2023", 200)
// 200-day MA
▶ Parameters & Fields
| Param |
Type |
Description |
| ticker |
string |
Ticker symbol |
| field |
string |
Data type to retrieve |
| date |
date |
Optional. Defaults to latest date. |
| length |
number |
Optional. Required for MA or avg VOLUME. |
Valid
Fields:
CLOSE
PRICE
OPEN
HIGH
LOW
VOLUME
MA
UNADJ
FastTrack.Stat(ticker, metric, [basis],
start, end)
Statistics
Calculates portfolio statistics over a date range — alpha, beta, Sharpe ratio,
max drawdown, returns, and more.
=FastTrack.Stat("OAKIX", "TOTALRETURN", "SP-DA", "1/1/2020", "12/31/2022")
=FastTrack.Stat("SPY", "SHARPE", "SP-DA",
EDATE(TODAY(),-12), TODAY())
▶ Parameters & Metrics
| Param |
Type |
Description |
| ticker |
string |
Subject security |
| metric |
string |
Statistic to calculate |
| basis |
string |
Optional. Benchmark ticker. Default: "SP-DA" |
| start |
date |
Start date of period |
| end |
date |
End date of period |
Valid
Metrics:
ALPHA
BETA
CORR
SHARPE
SORTINO
STDDEV
MAXDRAW
TOTALRETURN
ANNRETURN
YIELD
RSQUARED
UPI
ULCER
FastTrack.Export(ticker, type, start,
end, ...)
Spill / Array
Returns a range of historical data as a dynamic spill array. Best for building
charts and bulk data exports.
=FastTrack.Export("SPY", "CLOSE",
EDATE(TODAY(),-12), TODAY(), TRUE)
// Spills dates +
prices for last 12 months
▶ Parameters & Options
| Param |
Type |
Description |
| ticker |
string |
Ticker symbol |
| type |
string |
CLOSE, OPEN, HIGH, LOW, VOLUME, MA, UNADJ, DATES |
| start |
date |
Start date |
| end |
date |
End date |
| incDates |
bool |
Include dates column |
| reverse |
bool |
Sort newest first |
| horiz |
bool |
Spill horizontally |
| monthend |
bool |
Month-end data only |
Tip: Use FastTrack.Export
instead of many FastTrack.Quote
calls. One formula spills the entire date range — much faster.
FastTrack.DateCalc(date, operation, [param])
Helper
Utility for generating dynamic dates. Supports ADDDAYS and ADDMONTHS
operations.
=FastTrack.DateCalc(TODAY(), "ADDMONTHS", -12) // 1 year
ago
Tips & Best Practices
Use dynamic dates: Prefer TODAY() or EDATE(TODAY(),-12) over
hard-coded dates so your sheets stay current.
Bulk data: Use one FastTrack.Export formula for
price arrays instead of hundreds of FastTrack.Quote cells.
Indices: FastTrack indices use special codes — SP-DA for S&P 500, NDX-X for Nasdaq 100.
About
Investors FastTrack is an employee-owned software and data company specializing in
accurate
historical Mutual Fund, ETF, and Stock dividends. With a 31-year track
record,
FastTrack supplies professional-grade data to investors worldwide.
