Main Description
The Ratio and Correlation Tool allows the user to enter 2 tickers. The tool will then calculate the ratio of those 2 tickers, and the correlation between those 2 tickers.
The Ratio and Correlation Tool allows the user to enter 2 tickers. The tool will then calculate the ratio of those 2 tickers, and the correlation between those 2 tickers.
SETTINGS
Numerator Ticker
Enter the ticker that you would like to see the ratio and correlation of. The Numerator will be the ticker that the tool divides the price of the denominator ticker. Denominator Ticker Enter the ticker that you would like to see the ratio and correlation of. The Denominator will be the ticker that the tool divides the numerator ticker by. Ratio Output = Numerator Ticker Price / Denominator Ticker Price Correlation Output = Correlation between numerator ticker and denominator ticker |
OUTPUTS
The tool outputs fully interactive charts showing day to day equity (not just monthly data), day to day draw down, transitions from stock to cash symbol, a summary of performance, % allocation per symbol, annual/monthly performance table, and a full trade list.
Outputs include: Ratio between the 2 input funds, correlation between the 2 input funds, and a price chart comparing the 2 input fund returns (with dividends) over the period selected. |