GoogleSheetsTechnicalsTrading

A Collection of Functions for Technical Trading

PivotPoints.gs

Accepts arguments High, Low, and Close from which it calculates the Pivot Point with both Support and Resistance levels from one to three. Accepts the argument to be returned, "R1", "R2", "R3", "PP", "S1", "S2", or "S3".

Syntax

=PIVOTPOINTS(high, low, close, PivotPoint)

Example

=PIVOTPOINT(12.00, 10.00, 10.50, "PP")