|
Functions by Category Functions by Alphabetical list
This function returns a column of the passed in column shifted to the left or to the right. Negative values refer to the past, while positive values refer to the future. When using Ref NAN (Not A Number) are introduced for invalid slots - for example, slot zero of Ref(Close,-1) will be NAN as this value can not be knowable. Depending on how and where Ref is used, you may need to explicitly convert all NAN's to zero (or some other value) by using the NVL function. For example, NVL(Ref(Close,-1),0) would convert all NAN's to zero.
As this function can look "into the future" it's usage can be dubious in some situations.
Examples: Ref(Close,-1); #Returns a column of the previous close
Related functions: Above , Below , Crossover , Crossunder , Cross , Today , Now , Yesterday , Previous , Ago
|
