Example:
"1" => means rank all stocks
close > 20 => Rank stocks that have a price higher than 20 separately from stocks that have a price lower or equal to 20
In the last example, you will get two stocks with a rank of "1" and two stocks with a rank of "2"...
Thanks...I understood the formula except for the grouping,i.e. "1".If I do not include the "1",will it still rank all stocks? Are there any other groupings such as 2,3,4?
Why would I get 2 stocks with a rank of 1,two stocks with a rank of 2?
I am not seeing that in my screen with the formula above.
I understand the difference between RANK and RANK!,but am not following you..
QuantShare will rank stocks that have the same group value.
If you put "1" or any other static number/text then all stocks will have the same value (and thus will be placed in the same group). There will be only one group and stocks of this group will be ranked by the application.
If you put something like "industry()" then QuantShare will create several group of stocks (one for each industry) and then it will rank each group individually. If there are 10 industries then you will have ten stocks with a rank of 1.
If you put "Name()" then there will be as many groups as stocks and thus each stock will have a rank value of "1".
Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.