#Xojo array number of values full#

For each data point, LOWESS finds the n nearest points to that data point (n is configurable), and performs weighted linear regression using a tricube weighting function. LOWESS works by assuming a small segment of any curve can be approximated by a straight line. It is a commonly used algorithm for drawing a smooth curve through a number of points.

#Xojo array number of values full#

The full name of LOWESS is 'Robust locally weighted regression and smoothing scatterplots'.

MsgBox join(oldValueStrings, ' ')+EndOfLine+EndOfLine+join(newValueStrings, ' ') Notes: The value to use if the division is zero divided by zero.

To handle these special cases, the financeDiv method has an argument specifying what value to assume in case the division is zero divided by zero.Īn array of numbers used as divisors to divide the CDArrayMBS object. Traditionally, under the above case, the RSI will be consider as 50%. In case the price does not change at all during that period, and the RSI will become zero divided by zero. For example, the Relative Strength Index is defined as the ratio between positive price changes and absolute value of all price changes over a period of time. In many financial formulas, it is possible to have cases of zero divided by zero. financeDiv(values() as Double, zeroByZeroValue as Double)ĭivides the CDArrayMBS object by the given array, with special handling of the case of zero divided by zero. aggregateValues(srcArray() as Double, aggregateMethod as Integer, param as Double = 50.0) as Double()ĬDArrayMBS. Currently, only AggregatePercentile needs a parameter to specify the percentile used.ĬDArrayMBS. The method to aggregate the data, which must be one of AggregateSum, AggregateAvg, AggregateStdDev, AggregateMin, AggregateMed, AggregateMax, AggregatePercentile, AggregateFirst, AggregateLast, AggregateCount. The resulting CDArrayMBS object can then be used to aggregate daily data into weekly data.ĭue to aggregation, the length of the output array will usually be shorter than, and never be longer than, the length of the input array. The CDArrayMBS object is typically created by applying lectStartOfHour, lectStartOfDay, lectStartOfWeek, lectStartOfMonth, lectStartOfYear or lectRegularSpacing to a data array.įor example, to group daily data into weekly data, one may create an CDArrayMBS object with the dates of the daily data, then lectStartOfWeek to select only the elements representing the start of a week. Note that a group includes the starting delimiter position but excludes the ending delimiter position.

The positions of all non-kNoValue elements in the CDArrayMBS object will be used as delimiters positions.įor example, if the CDArrayMBS object consists of an array of 50 elements, and only the elements at 0, 10, 20, 30, 40 are not NoValue, then the groups will be defined as positions 0 - 9, 10 - 19, 20 - 29, 30 - 39 and 40 - 49. In this method, the CDArrayMBS object represents the delimiters used to group elements in the srcArray. This method should only be used when the data are not coming from a database, or the aggregation method are not supported by the database used. If the data is from a database, aggregation can often be more efficiently and conveniently performed by using the GROUP BY clause of SQL. This primary usage of this method is for changing data resolution, such as to convert a daily data into weekly data. aggregate(srcArray() as Double, aggregateMethod as Integer, param as Double = 50.0) as CDArrayMBSĪggregates a data array by merging groups of elements, similar to the GROUP BY clause in SQL statements.