{"id":562,"date":"2021-02-12T12:33:36","date_gmt":"2021-02-12T12:33:36","guid":{"rendered":"http:\/\/140.82.46.175\/?page_id=562"},"modified":"2021-02-12T12:57:02","modified_gmt":"2021-02-12T12:57:02","slug":"ratio-and-correlation","status":"publish","type":"page","link":"https:\/\/rotationinvest.com\/how-to\/ratio-and-correlation\/","title":{"rendered":"Ratio and Correlation Tool How To Guide\u200b"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Main Description<\/strong>
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.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Settings<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Numerator Ticker<\/strong>
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.<\/p>

Denominator Ticker<\/strong>
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.<\/p>

Ratio Output = Numerator Ticker Price \/ Denominator Ticker Price<\/em><\/p>

Correlation Output = Correlation between numerator ticker and denominator ticker<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Start\/End Simulation Date<\/strong>
The date values to start and end the simulation. If a ticker is unavailable for some of the date range entered the default behavior will be to only test the dates when all tickers are available.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t


Rolling Correlation Length<\/strong>
The number of trading days that the correlation between the 2 input stocks is calculated over. A large number will use more the stock’s history to calculate the correlation, and a smaller number will show the more recent stock price correlation.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Outputs<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Downloads<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Downloads that are available are a full trade spreadsheet, day by day strategy equity spreadsheet (which can be uploaded to any of our portfolio combination tools), and a list of settings you used to create the results. You may also download an HTML report with fully interactive graphs that you can save and send to others.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

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. Settings Numerator Ticker Enter the ticker that you would like to see the ratio and correlation of. The Numerator will be the ticker …<\/p>\n

Ratio and Correlation Tool How To Guide\u200b<\/span> Read More »<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"parent":31,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/pages\/562"}],"collection":[{"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":8,"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/pages\/562\/revisions"}],"predecessor-version":[{"id":573,"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/pages\/562\/revisions\/573"}],"up":[{"embeddable":true,"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/pages\/31"}],"wp:attachment":[{"href":"https:\/\/rotationinvest.com\/wp-json\/wp\/v2\/media?parent=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}