Rsi

Calculates the relative strength index on a given column, on a row-by-row basis. Developed by J. Welles Wilder, the Relative Strength Index (RSI) is a momentum oscillator that measures the speed and change of price movements. RSI oscillates between zero and 100. According to Wilder, RSI is considered overbought when above 70 and oversold when below 30. Signals can also be generated by looking for divergences, failure swings and centerline crossovers. RSI can also be used to identify the general trend.

Pass in a partition_col, an order_col, and a lookback window size.

NOTE: Your data should be a properly formatted timeseries dataset before applying this transformation. In other words, each period should only appear once, and periods considered zero should be imputed with 0 already.

Example use case: On daily stock data, calculate RSI by TICKER, with a 14-period lookback window.

Parameters

Name	Type	Description	Is Optional
partition_col	column	Grouping column to calculate RSI within.
order_col	column	Column to order rows by when calculating the agg window. RSI automatically sorts ascending.
value_col	column	Column to calulate RSI against.
window	int	Number of periods to use as a lookback period, to calculate RSI.

Example

ds = rasgo.get.dataset(fqtn="RASGOCOMMUNITY.PUBLIC.ZEPL_DAILY_STOCK_FEATURES")

ds2 = ds.rsi(partition_col = 'TICKER', 
              order_col = 'DATE', 
              value_col = 'CLOSE', 
              window = 14)

Source Code

RasgoTransforms/rsi.sql at main · rasgointelligence/RasgoTransformsGitHub