Click here to Login

How to use QuantShare Indicators in the Grid Tool

Updated on 2017-04-25

In a previous post, we have introduced the grid tool and how you can use it to create real time sheets. Today, we are going to show you how to use QuantShare functions and indicators and apply them to particular cells.

We are going to show you how to create and calculate in real time the relative strength index of a particular stock.

- Select "Tools -> Grid -> Grid Editor".
- Select the first cell "A1" then type a ticker symbol. Example: GOOG
- Click on the second cell "B1" then in the above tool bar, click on the "Formulas" button

A new control will open where you can add QuantShare language as well as C# formulas.

For this example, we will need to create a QS language formula, so let us click on the "Add formula" button at the top.

Let us name that function by typing a name next to the "Name" field. Call this function "rsi".
Below that field, click on the combo box next to "Data Used" and select "Realtime" as we want to calculate the real time value of the relative strength index.
In the formula editor on the right, type the following formula:
cell = Rsi(2);

This simple formula will calculate the 2-bar relative strength index then return the result to the cell.

Please note that you can add indicators by clicking on the "Add Indicator" button and you can also display the available functions/methods by using CONTROL+SPACE hotkey.

By default, each QS formula in the Grid tool has two parameters by default which are the ticker symbol name and the time frame. You can add additional parameters by click on the "Add Variable/Parameter" button.
Later, we can access that formula within a particular cell by calling this function:
=Formula.rsi("GOOG", 60)

This will execute the "rsi" function we just created while passing "GOOG" as ticker symbol and 60 (1-minute) as time frame.

Click on the "Compile" button at the top then close the form.

- Select the second cell again "B1" then type in the above formula editor (next to "Fx" button)
=Formula.rsi(A1, 60)

Note how we replaced "GOOG" by A1. This means that the function will use the value that is returned by the A1 cell as first parameter. If you change the ticker symbol in A1, the formula in B1 will be automatically updated.

The final step would be now to select a data feed for our cells. Select both cells, right click then select "Data Feed" then your data feed.

To save this grid, click on "File" then "Save".

You can open that grid directly in QuantShare by selecting "Tools -> Grid -> Open Grid" in the QuantShare menu then selecting the grid you just saved.

no comments (Log in)

QuantShare Blog
Search Posts

Recent Posts

Create Graphs using the Grid Tool
Posted 1292 days ago

Profile Graphs
Posted 1397 days ago

Previous Posts

How to Use the Percentage Scale
Posted 2756 days ago

Introduction to the Grid Tool
Posted 2855 days ago

Trading the Strategy Equity Curve
Posted 2992 days ago

More Posts


Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2024
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Follow us on Google+
RSS Trading Items

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.