This is a trading item or a component that was created using QuantShare by one of our members.

This item can be downloaded and used by QuantShare Trading Software.
Trading items are of different types. There are data downloaders, trading indicators, trading systems, watchlists, composites/indices...

You can use this item and hundreds of others for free by downloading QuantShare.

Top Reasons Why You Should Use QuantShare:

Works with US and international markets (stock, forex, options, futures, ETF...)

Offers you the tools that will help you become a profitable trader

Allows you to implement any trading ideas

Exchange items and ideas with other QuantShare users

Our support team is very responsive and will answer any of your questions

We will implement any features you suggest

Very low price and much more features than the majority of other trading software

If you want to compare a certain value of a time-series for a particular security to the value of other securities for the same date, then you should use the z-score. You will need to standardize data in order to use the z-score or the standard score.

The standard score, which is commonly referred to as the z-score, represents the distance between the score or the value and the observation or indicator mean for all the population (U.S. stocks) in units of the standard deviation. The population does not have to be normally distributed.

For each date, you will need to get every security time-series value (The time-series could be the share price, the volume or any indicator), and then calculate the mean and the standard deviation of these values. The end result should be two time-series, one that contains the standard deviation values and the other that contains the mean values.

This can be easily done using the composite plug-in. Mean and Standard deviation - Z-Score is an example on how to do that. This item calculates the one-day rate of return mean and standard deviation of all securities and for every trading bar.

The final step will be to use the following formula to calculate the standard score (z-score):
z = (x - mean) / (standard deviation)

Where z is the z-score for a particular bar and for a specific security and x is the security indicator's value for that bar.

The formula is named "zscore"; it accepts two parameters. The first one is the indicator or time-series for which you want to get the z-score values, and the second parameter is the composite symbol name.
Example:
score = zscore(roc(close, 1), "_RETURN SDV");

Let us take Google (GOOG) and the 25/01/2010 bar for example; a negative z-score value means that the one-bar rate of return of Google on 25/01/2010 was lower than the average one-bar rate of return of all U.S. stocks. A z-score value higher than two means that the one-bar rate of return of Google on 25/01/2010 was two standard deviations above the average one-bar rate of return of all U.S. stocks.

In case the indicator values follow a normal distribution, you can use the standard score and the statistical tables to calculate the percentile rank.

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.