Oscillators and their comparison - Excel

Have you ever wished to compare various oscillators of technical analysis and the profits they can earn you by trading? Have you wished to find out which of them would be the best for you? Now you have the possibility to enter your own data, set number of days for calculation and see which of the indicators woul be the most and least profitable for you.

In this Excel file you can find the most common Oscillators used in trading. You can also use it for any other reasons - e.g. studying or making some statistics. The file calculates chosen Oscillators, their values, profit, win/loss ratio etc. from any entry data, you enter in.

The file is being made in Excel 2002 and contains 14 basic Oscillators. They are:

1. W%R – Williams percentage range. It contains calculations from 2 to 30 days.
2. RSI – Relative strength index. It contains calculations from 2 to 30 days.
3. SSTO, FSTO – Stochastic oscillator. It contains calculations from 2 to 30 days.
4. CCI – Commodity channel index. It contains calculations from 2 to 30 days.
5. MACD – Moving average convergence divergence. It contains calculations from 2 to 100 days.
6. PPO – Percentage price oscillator. It contains calculations from 2 to 100 days.
7. TRIX – Triple smoothed exponential index. It contains calculations from 2 to 100 days.
8. UO – Ultimate oscillator. It contains calculations from 2 to 100 days.
9. TSI – True strength index. It contains calculations from 2 to 30 days.
10. RVI – Relative vigor index.
11. CMO - Chande momentum oscillator. It contains calculations from 2 to 30 days.
12. ROC - Rate of change (Momentum). It contains calculations from 2 to 30 days.
13. DPO - Detrended price oscillator. It contains Even calculations from 2 to 58 days.
14. SRSI - Stochastic Relative strength index. It contains calculations from 2 to 30 days.

This is the page view of the first Excel sheet.

The way how to calculate the Oscillators from your entry data is really very easy:

1. Intert your data in the SUMAR sheet (OHLC price). These prices should be inserted in A-E columns (just in the SUMAR sheet. The data will be automatically copied to all the remaining sheets).

2. Now you have the option to choose from which price you would like to calculate the Oscillators - Open, High, Low or Close price (Close price is the present value). This can be done in G column, G1 cell.

3. In J3 and J4 cells you enter the information about minimum price movement (1 tick) and a value of the single tick in USD. If you don't enter these information, don't worry. The Indicators will be calculated, but the results for profit and loss will be distorted.

4. Every Oscillator is being calculated on a separate sheet. We can switch between them and watch for their profitability. We have got the option to change days for their calculation. They usually range from 2 to 30 days. Some of the indicators are available from 2 to 100 days. The values that can be changed are marked with blue colour. Other cells that are filled in with other colour than blue should remain untouched. With the view of maximum possibilities and variability, some indicators also provide the option to change some of the other values - e.g. the smoothing constant etc. Every Oscillator sheet looks following:

That's it! Now you can compare the Oscillators results, see which one would be the most profitable one and would best suits your needs.

We will also show you, how exactly to adjust the Indicator settings. Let's choose the RSI. As you can notice, there are 8 blue cells, which means 8 cells we can adjust.

The first blue cell is "Number of  days for calculation". If we click the V4 cell, we can notice an arrow on the right side. When we click on the arrow, we can see all the days available for RSI calculation. In this case we can calculate any RSI from 2 to 30 days. Should any other value than the present one be chosen then all the RSI values and theoretical profits are also changed.

The second cell is RSI's Signal line - EMA. We can set here how far or close should the EMA move next to its RSI. Higher number mans longer distance between them and the less signals for trades it generates. If we don't want to use the EMA, we can set it to 1. It means that the EMA is equal to the basic RSI values. The Buy and Sell signals will be generated just when the Limits (70/30) will be crossed.

Next blue cells are to set Limits and Style of trading. Preview:

How to trade: Here we have 3 options. We can leave the "nonstop" value. It means that we will be still in a trade - either in Long or Short position. "xtrend" means that we are interested just in days when RSI crosses its EMA bellow and above its limit values (bellow 30 and above 70). "xrange" at a first sight offers us a illogical option to trade these limits wrong side out - above 30 and bellow 70 values. Yes, it is an illogical option on the first sight, but you would be surprised how profitable it could be to trade this way. It was already mentioned before, that this file has been prepared with the view to offer you maximum ways how to experiment with the indicators.

RS smoothing: we can choose whether to smooth the RS values for RSI calculation.

Short/Long curves crossings: It means crossings the Oscillator's values with its Signal line. We can leave the "normal" values or we can choose the "reversion" option. In the first option the Buy signal is generated when RSI values crosses its EMA upwards (bellow the 30 limit) - it is the usual setting of RSI. In the second option the Buy signal is generated when the EMA crosses its RSI values upwards (still bellow 30 limit) - so we have the option to invert the curves.

Trades reversion: is another option we can use. If you set the indicator to be extremelly lossy - e.g. 30 thousand USD, it is not a bad news but contrariwise - a very good news for you. You can use the "trades reversion" option to invert all the trades. So you will get the Sell instead of the Buy recommendation and vice versa. Instead of 30 thousand loss you can get 30 thousand profit.

Sell and Buy lines are the limits for signals that we will take into consideration (e.g. Above and Bellow these lines). Of course we can adjust them as we wish to.

All the oscillators are prepared with the view to offer you maximum ways how to experiment with their settings. Should you have any problem with the indicator's meaning or their original settings, you can click their name (abbreviation) and you will be redirected to eTrading.sk website. There you will find all the information about the certain indicators.

All the Oscillators with their Profits (or Losses) are also displayed in one aggregate Table in the basic SUMAR sheet. You also don't have to search for the most and least profitable indicator on your own. They are already market with the MAX and MIN words. You can see the table bellow:

The oscillators were set to get approx. the same profits. But of course its up to your preferences, how you set their settings. If you are not interested in the Profits and Losses, but just in the indicator values, then you just need to put in entry data (OHLC price) in the SUMAR sheet and you can find all the oscillator values in the other sheets.

You can find not just the financial results but also other additional information by every Oscillator. E.g. the RSI and the settings 14 days and 33 days for its Signal line would earn us about 25 thousand USD on aggregate.

There are also other values displayed below the Financial ones. For the above stated RSI we can find out that:

• Average profit per 1 trading day would be 16,88 USD
• Percentage of profitable trades would be 49,69 %,
• Profit to Loss Ratio 1,15 (means that average profit would be by 15 % higher compared to average loss)
• Number of trading days is 1488, what makes about 6 years. We would be 423 days in Short trades and 1065 days in Long trades.

If you are interested in downloading this file, the process is following:

1. Enter the section with Excel indicators
2. Choose the indicators you are interested in e.g. the file described in this article. You can choose the files by clicking the cart next to everyone of them.
3. If you are happy about your selection, click on the Big Green Cart above the indicators and you will be redirected to the checkout. By clicking Checkout you can send a donation using your credit card, debit card or Paypal account. After the transaction is completed a link with files you can download will be delivered to your email adress.

The whole process will take up to 1 minute and the Excel file will be prepared immediately for download. In case of any other questions, some download problems or if you are interested in other form of payment (e.g. bank transfer) please don't hesitate to contact us HERE

If you are interested just in certain oscillators, not in the File as a bulk, then yes, you also have this option. You can choose from the single indicators, donate via PayPal and furthermore there is no need to Register: Enter the download page

In the end: Most of the cells are not locked. It means you can change them, but this is not recommended as the former formulas can be overwritten and you will get distorted values. You can adjust and experiment with the file. But remember that it is strictly forbidden to make any changes in the copyright or spreading this file to the public in any form or selling it. The file can be downloaded only from our eTrading.sk website.

Despite the fact that the file was prepared with maximum attention, there may be some inaccuracies in it. The file is being sold "as is", with the possible errors including. In no event shall we be liable for lost profits or any special, incidental or consequential damages arising out of or in connection with our website or any of our service. We don't guarantee the accuracy of the file, but should you find any problem in it, please contact us HERE. The inaccuracy will be removed and a new version will be sent to you for free.

We believe that you will really like this Oscillators realization. It's being made with the view of maximum simplicity of use and utilization, as well as nice visual performance. Enjoy it!