EquityQuote

Gets the current equity quote for a symbol.
REST api documentation

new EquityQuote(symbol: string, fieldName: string?): Promise<Array<Array<any>>>
Parameters
symbol (string) Equity symbol.
fieldName (string?) The name of the specific quote field. If 'all' or not specified will return full quote.
Returns
Promise<Array<Array<any>>>: A range with the Equity quote information

EquityQuoteUpdating

Gets the updating equity quote for a symbol.
REST api documentation

new EquityQuoteUpdating(symbol: string, fieldName: string, updateIntervalInSeconds: number, invocation: StreamingInvocation?): void
Parameters
symbol (string) Equity symbol.
fieldName (string) The name of the specific quote field. If 'all' will return full quote.
updateIntervalInSeconds (number) Seconds between updates. Shortest valid interval is 30 seconds.
invocation (StreamingInvocation?) (NOT VISIBLE TO USER) The callback that handles the response
Returns
void: A range with the updating Equity quote information

EquityTimeSeries

Gets the historical equity quotes for a series.
REST api documentation

new EquityTimeSeries(symbol: string, interval: string, isAdjusted: boolean, optOutputsize: string?): Promise<Array<Array<any>>>
Parameters
symbol (string) Equity symbol.
interval (string) Frequency of returned time series (Monthly,Weekly,Daily,60min,30min,15min,5min,1min).
isAdjusted (boolean) For raw equity quotes this is 'false'. Adjustments are for corporate actions.
optOutputsize (string?) (Optional: default value set by user) Full or compact series (full, compact).
Returns
Promise<Array<Array<any>>>: A range with the equity price history.

EquityTimeSeriesUpdating

Gets the updating historical equity quotes for a series. Really only useful for intraday series
REST api documentation

new EquityTimeSeriesUpdating(symbol: string, interval: string, isAdjusted: boolean, optOutputsize: string, invocation: StreamingInvocation?): void
Parameters
symbol (string) Equity symbol.
interval (string) Frequency of returned time series (Monthly,Weekly,Daily,60min,30min,15min,5min,1min).
isAdjusted (boolean) For raw equity quotes this is 'false'. Adjustments are for corporate actions.
optOutputsize (string) ('compact' default) Full or compact series (full, compact). Omit value to use default
invocation (StreamingInvocation?) (NOT VISIBLE TO USER) The callback that handles the response
Returns
void: An range with the updating equity price history. Updates at the same frequency as interval

ExchangeRate

Gets the current exchange rate between 2 currencies.
REST api documentation

new ExchangeRate(fromCurrency: string, toCurrency: string, fieldName: string?): Promise<Array<Array<any>>>
Parameters
fromCurrency (string) Currency code converting from.
toCurrency (string) Currency code converting to.
fieldName (string?) (Optional) The name of the specific quote field. If 'all' or not specified will return full quote.
Returns
Promise<Array<Array<any>>>: A range with the exchange rate and associated info.

ExchangeRateUpdating

Gets the updating exchange rate between 2 currencies.
REST api documentation

new ExchangeRateUpdating(fromCurrency: string, toCurrency: string, fieldName: string, updateIntervalInSeconds: number, invocation: StreamingInvocation?): void
Parameters
fromCurrency (string) Currency code converting from.
toCurrency (string) Currency code converting to.
fieldName (string) The name of the specific quote field. If 'all' will return full quote.
updateIntervalInSeconds (number) Seconds between updates. Shortest valid interval is 30 seconds.
invocation (StreamingInvocation?) (NOT VISIBLE TO USER) The callback that handles the response
Returns
void: A range with the exchange rate and associated info.

ExchangeRateSeries

Gets the historical exchange rate between 2 currencies.
REST api documentation

new ExchangeRateSeries(fromCurrency: string, toCurrency: string, interval: string, optOutputsize: string?): Promise<Array<Array<any>>>
Parameters
fromCurrency (string) Currency code converting from. This field can be a physical or crypto currency
toCurrency (string) Currency code converting to. This field can only be a physical currency
interval (string) Frequency of returned time series (Monthly,Weekly,Daily,60min,30min,15min,5min,1min).
optOutputsize (string?) (Optional: default value set by user) Full or compact series (full, compact).
Returns
Promise<Array<Array<any>>>: A range with exchange rate history.

ExchangeRateSeriesUpdating

Gets the updating historical exchange rate between 2 currencies. Really only useful for intraday
REST api documentation

new ExchangeRateSeriesUpdating(fromCurrency: string, toCurrency: string, interval: string, optOutputsize: string, invocation: StreamingInvocation?): void
Parameters
fromCurrency (string) Currency code converting from. This field can be a physical or crypto currency
toCurrency (string) Currency code converting to. This field can only be a physical currency
interval (string) Frequency of returned time series (Monthly,Weekly,Daily,60min,30min,15min,5min,1min).
optOutputsize (string) ('compact' default) Full or compact series (full, compact). Omit value to use default
invocation (StreamingInvocation?) (NOT VISIBLE TO USER) The callback that handles the response
Returns
void: A range with the updating equity price history. Updates at the same frequency as interval

TechnicalIndicator

Gets the specified Technical Indicator history for a specific equity.
REST api documentation

new TechnicalIndicator(symbol: string, indicator: string, interval: string, argumentArray: Array<Array<any>>): Promise<Array<Array<any>>>
Parameters
symbol (string) Equity symbol.
indicator (string) Name of the Indicator.
interval (string) Frequency of returned time series (Monthly,Weekly,Daily,60min,30min,15min,5min,1min).
argumentArray (Array<Array<any>>) 2 Column range with arguments specfic to this indicator. See Full Documentation
Returns
Promise<Array<Array<any>>>: A range with the indicator history.

TechnicalIndicatorUpdating

Gets the updating specified Technical Indicator history for a specific equity.
REST api documentation

new TechnicalIndicatorUpdating(symbol: string, indicator: string, interval: string, argumentArray: Array<Array<any>>, invocation: StreamingInvocation?): void
Parameters
symbol (string) Equity symbol.
indicator (string) Name of the Indicator.
interval (string) Frequency of returned time series (Monthly,Weekly,Daily,60min,30min,15min,5min,1min).
argumentArray (Array<Array<any>>) 2 Column range with arguments specfic to this indicator. See Full Documentation
invocation (StreamingInvocation?) (NOT VISIBLE TO USER) The callback that handles the response
Returns
void: A range with the indicator history. Updates at the same frequency as interval

SymbolSearch

Search for equity symbols given a string
REST api documentation

new SymbolSearch(searchString: string): Promise<Array<Array<any>>>
Parameters
searchString (string) A string representing the equity symbol to search for.
Returns
Promise<Array<Array<any>>>: A range with a list of possible matches to the query

AvailableCryptoCurrencies

Gets the currently available crypto currencies.

new AvailableCryptoCurrencies(): Promise<Array<Array<any>>>
Returns
Promise<Array<Array<any>>>: A range with a list of available crypto currencies (2 columns). Both code and description.

AvailablePhysicalCurrencies

Gets the currently available physical currencies.

new AvailablePhysicalCurrencies(): Promise<Array<Array<any>>>
Returns
Promise<Array<Array<any>>>: A range with a list of available physical currencies (2 columns). Both code and description.

SectorPerformance

Sector performance calculated from S&P 500 incumbents
REST api documentation

new SectorPerformance(): Promise<Array<Array<any>>>
Returns
Promise<Array<Array<any>>>: A range with the Sector performance grid

SectorPerformanceUpdating

Gets the updating Sector performance calculated from S&P 500 incumbents
REST api documentation

new SectorPerformanceUpdating(updateIntervalInMinutes: number, invocation: StreamingInvocation?): void
Parameters
updateIntervalInMinutes (number) Minutes between updates. Shortest valid interval is 1 minute.
invocation (StreamingInvocation?) (NOT VISIBLE TO USER) The callback that handles the response
Returns
void: A range with the updating Sector performance grid

UnixTimestampToUTCDateTimeNano

Given a Unix Timestamp the function will return a range with an Excel date accurate to seconds and the number of nanoseconds.

new UnixTimestampToUTCDateTimeNano(unixTimestamp: Array<Array<string>>): Promise<Array<Array<any>>>
Parameters
unixTimestamp (Array<Array<string>>)
Returns
Promise<Array<Array<any>>>: A range with the Excel date (accurate to seconds) and nanoseconds

UTCDateTimeNanoToUnixTimestamp

Given an Excel date accurate to seconds and the number of nanoseconds this function will return a Unix Timestamp as string.

new UTCDateTimeNanoToUnixTimestamp(excelDate: any, nanoseconds: number?, prefix: string?): Promise<string>
Parameters
excelDate (any) Excel date (accurate to seconds)
nanoseconds (number?) nanoseconds to add to timestamp in seconds. Default is 0
prefix (string?) for timestamp to force string representation. Default is 'TS'
Returns
Promise<string>: The unix timestamp as a string with nanosecond accuracy

HistoricTickQuotes

Polygon.io function. Spreadsheet Function: PG.HistoricTickQuotes. Gets the tick level historical quotes for the specific ticker.

(Requires a Polygon.io API Key. Signup at https://polygon.io/signup, use partner code ALPHAV for a 10% discount)

REST api documentation

new HistoricTickQuotes(ticker: string, date: any, timestamp: any, timestampLimit: any?, limit: number?, reverse: any?): Promise<Array<Array<any>>>
Parameters
ticker (string) Equity ticker symbol.
date (any) Date/Day of the historic ticks to retrieve.
timestamp (any) Timestamp offset, used for pagination. This is the offset at which to start the results. Using the timestamp of the last result as the offset will give you the next page of results. Can be an Excel date or a Unix timestamp
timestampLimit (any?) Maximum timestamp allowed in the results. Can be an Excel date or a Unix timestamp
limit (number?) Limit the size of response, Max 50000.
reverse (any?) Reverse the order of the results. This is useful in combination with timestamp param.
Returns
Promise<Array<Array<any>>>: A range with the historic quote information

HistoricTrades

Polygon.io function. Spreadsheet Function: PG.HistoricTrades. Gets the historical trades for the specific ticker.

(Requires a Polygon.io API Key. Signup at https://polygon.io/signup, use partner code ALPHAV for a 10% discount)

REST api documentation

new HistoricTrades(ticker: string, date: any, timestamp: any, timestampLimit: any?, limit: number?, reverse: any?): Promise<Array<Array<any>>>
Parameters
ticker (string) Equity ticker symbol.
date (any) Date/Day of the historic ticks to retrieve.
timestamp (any) Timestamp offset, used for pagination. This is the offset at which to start the results. Using the timestamp of the last result as the offset will give you the next page of results. Can be an Excel date or a Unix timestamp
timestampLimit (any?) Maximum timestamp allowed in the results. Can be an Excel date or a Unix timestamp
limit (number?) Limit the size of response, Max 50000.
reverse (any?) Reverse the order of the results. This is useful in combination with timestamp param.
Returns
Promise<Array<Array<any>>>: A range with the historic trade information

EquityAggregates

Polygon.io function. Spreadsheet Function: PG.EquityAggregate. Gets the aggregate information for an equity ticker.

(Requires a Polygon.io API Key. Signup at https://polygon.io/signup, use partner code ALPHAV for a 10% discount)

REST api documentation

new EquityAggregates(ticker: string, multiplier: number, timespan: string, from: any, to: any, adjusted: any?): Promise<Array<Array<any>>>
Parameters
ticker (string) Equity ticker symbol.
multiplier (number) Size of the timespan multiplier as an integer
timespan (string) Size of the time window. timespan must be one of (minute,hour,day,week,month,quarter,year)
from (any) From date.
to (any) To date.
adjusted (any?) Flag to set if the results are adjusted for splits. Default value is true
Returns
Promise<Array<Array<any>>>: A range with the equity aggregate information