Dec
11

Howto Build Calculated Symbols

Calculated symbols are symbols base on modifying underlying data, resulting data can be used as regular data series for real-time or historical data analysis.

NeoTicker user defined symbols provide real-time custom calculated data series, historical data for these calculated symbols can be filled in with calculated cache data.

For example GLOBEX mini JPY future contract (i.e. 6J) is quoted in JPYUSD instead of the more popular spot pair USDJPY. Apply an invest calculation (i.e. 1/price) to 6J contract will simulate price movement of USDJPY, this will allow traders to get a better sense price action of spot pairs as compare to futures.

Another calculated symbol application is for spread or pairs traders to display calculated result of pairing as direct quote instead of referring to two instruments all the time. These calculated spread allow traders to know price difference at a glance and apply indicators on them like moving averages.

Inverse Symbol

In this example I use IQFeed as my data source. First I will add the JPY contract symbol in a chart and quote window.

Basic chart and quote window of JPY CME contract

Basic chart and quote window of JPY CME contract

To quickly demonstrate how user defined symbol result looks like, I added a formula indicator to the chart with the formula “1/c” and a formula column with formula “1/last”.

JPY contract with inverse fomula result

JPY contract with inverse fomula result

This result is sufficient for traders who just like to have price inverse as a reference.

To create to inverted symbol open up user define symbol manager, change the following fields.

Symbol: JPYINVERT
Base Timeframe: FOREX
Evaluation Type: Formula
Base Symbol: @JY#

Then at Formula tab field enter formula “1/last”. (Note: user define symbol use quote window formula syntax).

User defined symbol manager Settings for JPY inverse symbol

User defined symbol manager Settings for JPY inverse symbol

Now add symbol JPYINVERT into a quote window, there is a real-time quote of inverted 6J symbol, invert symbol can also be added to chart.

JPYINVERT added to quote and chart

JPYINVERT added to quote and chart

This completes adding an inverse symbol as user defined symbol in NeoTicker.

Blog Developed
By ContentRobot