# Two Qs: Relative Strength output and Index Membership

Hello, I perused the various threads on Relative Strength usage, and suspect I am in the right spot. But would like to clarify:

1. Is it possible to output a list of stocks calculated Relative Strength values for various look-back periods, eg RS 1month, 3month, 1 year etc? This would be a monthly process.

2. Is it possible to define this list of stocks by index membership? I read that Norgate has this in their data for US exchanges, but I have other non-US exchanges to work with as well. In the absence of index membership, I could probably just use market cap as a proxy.

The workflow would be: define the population of stocks per #2. Then calculate and output the RS values for each stock in that population. And rank them as a bonus, but can do that in Excel.

This is not for backtesting, it is an input to trading and the process is applied individually to various global exchanges on a monthly basis. Some retail online screener platforms offer the output I want, but I am so so so very tired of dealing with their bugs and problems in return for my money. I want to create and take ownership for my own solution once and for all.

Thank you.

1. Relative Strength is a RATIO between given symbol and index. It is does not use period. If you meant Relative Strength Index (RSI) instead, then you can have RSI of any period
2. Yes it is possible. You can have any user-defined lists Understanding categories and Working with watch lists

Thank you Tomasz, I have actually made great progress with the demo and am happy to see I can do what I want with columns in the Analyser and code.

BTW, there are different RS methods In my case I mean this calculation. It is a ratio of percentage changes over a period of duration.

Wikipedia is not always right. If you read it carefully you would see that they have two definitions that are different. The Wikipedia article you found, first talks about price ratio, then in second sentence it talks about ratio of ratios ("percentage change over some period" is a ratio by itself, called ROC - rate of change) . Classic Relative Strength is simply this ratio:

``````Close / Index_Close;
``````

and it is not calculated over any period.

If you wish you can calculate ratio of ratios (ratio of ROCs), but this is not really Relative Strength, but "relative ROC"

``````ROC( Close, 10 ) / ROC( Foreign("Index", "C"), 10 );
``````

To refer to other symbol prices use Foreign function AFL Function Reference - FOREIGN

Indeed, I am incorrect to strictly use RS as terminology. I am indeed a long-time user of "Relative ROC".

I am so excited with the progress I have made in the Explorer part of Analysis. It is a fantastic tool.

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.