Percent Rank Function Needed - Trading Software

Percent Rank Function Needed

swalk10
2010-06-19 20:42:16

Perhaps I have missed this, but I can't seem to locate a percent rank function. Could you please help indicate the appropriate code.

That is, I need to create a function that transforms any vector array into a percent rank array.
For example, I need to look at the last 200 bar of the closing price, and for each bar, know what % that bar's closing price is within the prior 200 bars
(so, a price of 110, if it were the high of last 200 bars would be 100, if the low, it would be 0, etc.).
Typically, the function would be called as X = PERCENTRANK(CLOSE, 200);
Of course, variable close could be swapped for any other variable.

Also, could you kindly show how I would "call" this function within your other features (ranking systems, simulator, etc.)

Thanks - hopefully I can then use this as a learning step also.

QuantShare
2010-06-21 06:53:28

Best Answer

Hi,

This function can be created using the "Create Functions" feature. However, I prefer to add it to the list of indicators so it can be highly optimized.
It will be available in the next release.

If you want me to create this function using "Create Functions" and send you the trading object, please let me know.

To use this function and any other function in ranking system or simulator, just type it:
PERCENTRANK(CLOSE, 200)

swalk10
2010-06-21 13:08:06

Thanks for the quick follow-up. Indicator would be fine, as long as it is "editable", so that I can test creating modified versions of the code (i.e., expanded to PERCENTRANK on multiple variables together, etc.).

I will also take a further look at your "Create Functions" feature - might be a good topic for an upcoming post :)

Regards,
Scott

QuantShare
2010-06-22 06:29:54

Here is the PercentRank function:
Percentile - Percent Rank of a Trading Indicator

And here is a post about custom indicators:
http://www.quantshare.com/sa-137-how-to-create-your-own-technical-analysis-indicators

Percentile - Percent Rank of a Trading Indicator (by QuantShare, uploaded several months ago)

No notes

swalk10
2010-06-22 09:05:35

Everything I could ask for and more!

I believe Percent Rank is a fundamental building block of time series analysis that will benefit many users.

Thanks!

Get more messages

No more messages

Back


Trading Items Percentile - Percent Rank of a Trading Indicator Trading System Based on the CloseHL Percent Rank Oscillator CloseHL Percent Rank Oscillator Percent Rank Market Indicator Trading Indicator Rank	How-to Lessons Difference between the watchlist and the screener tools How to calculate the average of a time series using the money man... How to plot two different time frames in the same chart How to plot arrows below/above candlesticks on a chart How to create a hatched area in a chart
Related Forum Threads Composite Function Percent Change (close) indictor Comp Function newbie looking for function help Backtest using AutoSR function	Blog Posts Fundamental Stock Analysis: Rank stocks based on a valuation rati... 3 ways to rank stocks in a trading system - Simulator and Potfoli... Buy the best/top rated stocks or how to create powerful rank base... Trading Indicators using the Rank and Percentile functions Trading System: Buy Stocks based on their Sharpe Ratio Rank