RatioPlotter.eu - Equation Plotter

Plot Custom Equation

Enter tickers and coefficients (e.g., 1.0*GLD + 0.5*SLV - 1.0*USO)

Popular Equations (Free Tier)

Notes & Guidelines

Logic: This tool calculates a custom index. The formula is:

$$ \frac{ca \cdot ta + cb \cdot tb + cc \cdot tc}{cd \cdot td + ce \cdot te + cf \cdot tf} $$

Coefficients: Must be numbers (e.g., 0.5, -1, 100). If you want to subtract a ticker, use a negative coefficient. Notice in the formula that the coefficients used can alter the results of the plotted chart significantly. For the free version we have hardcoded the coefficients we think are best, but this may be flawed. To fix this you will be able to change the coefficients to your liking when we release the paid version of RatioPlotter with no limits.

Tickers: Use valid standardized financial tickers. If a field is left empty or coefficient is 0, that term is ignored.

Currency: Ensure tickers are in the same currency or the result may be distorted by exchange rates.

Example: 1.0*GLD + 0.5*SLV - 1.0*USO creates a synthetic asset that is long gold, partially long silver, and short oil.

Recommendation: Use this tool to create custom baskets or hedged positions for analysis.

Ticker Data Usage and Sourcing

Ticker Data Sources

Our data is provided from a variety of sources: The Federal Reserve (FED-* tickers), The World Bank (WB-* tickers), The International Monetary Fund (IMF-* tickers), Tiingo (T-* tickers covering: stocks, ETFs, etc), Ourselves (MATH-* tickers). The ticker data sources vary according to ticker prefix as you can see. Our ticker selector allows browsing each ticker and their description and placing them on a basket for use.

SEA() Ticker function

For ratio plotting, the SEA(Ticker) function can only be used in the denominator argument and only for plotting TickerA over SEA(TickerA) like this: T-CRUD/SEA(T-CRUD). The SEA() ticker function works by calculating the median yearly seasonality as a new dataset (see the seasonality page for details and examples of this calculation). This one year seasonality dataset is then unfolded exactly the same for many years and directly inputted as a synthetic ticker into this plotting page arguments. Example: Ratio plot of Crude Oil by its seasonality: T-CRUD/SEA(T-CRUD). To write custom SEA() function synthetic tickers simply input your ticker of choice between the parentheses such as SEA(T-CRUD).

RAT() Ticker function

The RAT() ticker function works by calculating the ratio between two tickers as a new dataset. This dataset is then directly inputted as an synthetic ticker into the plotting page arguments. To write custom RAT() tickers simply input your two tickers of choice between the parentheses, separating them with a comma. Such as RAT(T-AAPL, T-MSFT). This can only be once, synthetic tickers like RAT(RAT(T-AAPL, T-MSFT), SEA(T-qtec)) are invalid for the time being. Example, how is Google outpacing Microsoft in terms of CAGR curve: RAT(T-GOOGL,T-MSFT)/MATH-CAGR_PCT-2

LAG() Ticker function

The LAG() ticker function is used to create a lagged version of an asset. This lags a dataset with an amount of days equal to the lag value in the ticker. To write custom LAG() tickers simply input your ticker of choice and lag value between the parenthesis, seperated by a comma. Such as LAG(AAPL, 10). Lag values can only be inputted into the denominator as positive whole numbers between 1 and 7000 days. Using the ratio plotter with LAG(), a ticker can be analyzed in its auto correlation, or correlation to a nother ticker with a gap of X days (e.g.ratio plot of TICKERA by LAG(TICKERB, 30)).

MATH- Tickers

The MATH- tickers are custom mathematical tickers made by us (e.g. MATH-CAGR_PCT-2 for 2% exponential growth, MATH-CONST_VEC-1 for a constant value of 1 each day). To find the list of valid MATH tickers go to the Ticker Selector Page and search through the MATH category list. Important to mention is that when using the MATH tickers the last observed date for this MATH ticker will be far in te future.

Default Ticker Column Projections & Adjustments

Let's take T-GOOGL as an example. When the projection variable is left blank, the ratio plotter will use the default projection variable which is -AdjClose (close price adjusted for both dividends and splits). This means that when you input T-GOOGL into the ratio plotter it will actually plot the Tiingo split and dividend adjusted close price of GOOGL (T-GOOGL-AdjClose by T-MSFT-AdjClose). If you want to plot the split (but not dividend) adjusted close price of GOOGL you can input T-GOOGL-SplitAdjClose. All projection columns are provided by Tiingo, with exception of the -SplitAdjClose column which is calculated by our system.