mabonyi

Asset Correlation Tool v3, improved

mabonyi Updated   
I found this useful tool among the indicators but it wasn't doing the correlation study correctly.

Everything in markets, with only a few exceptions, are rising in value over time and therefore trended to time. The simplest method I found is to use link relative or first difference detrending, before calculating a correlation between assets.

I also updated it to include more assets, to use the latest Cryptocap indices like BTC.D/ETH.D/TOTAL2 and the top 100 crypto index CIX100. I improved the colour schemes, too

Included in the source code are some other ideas like the FRED:M1 and FRED:M2 (only on daily charts), the Yuan/Yen/EUR/USD, etc. There's lots of scope for correlating unrelated markets.

I'll keep updating it as I use it to find truly correlated assets. Some kind of signal line of known correlations, to subtract from the baseline fuzz of market activity.

Any improvements are most welcome; I'm a novice at best at statistics and build on others' work.

- mabonyi
Release Notes:
Changed to first differences as the default. I already replaced circles with lines, to more clearly see the differences. Small transparency to make it legible.
Release Notes:
This is the latest version for the revised Asset Correlation Tool, now version 4. It has a few striking new features:

  • changed the short title to be very short, for those of us using it with 2/4/8 chart layouts
  • "Same as symbol" timeframe support
  • min-max normalisation
  • mean normalisation
  • z-score normalisation (aka standardisation: mean over stdev)
  • the differentials will choose first-difference then link relative if both are enabled
  • the normalisations are mutually exclusive and the first one enabled will be the one used
  • you can use 1 differential (normal, first difference, or link relative) and 1 normalisation (min-max, mean, or standardise) together
  • different plot styles and transparency defaults for maximum visibility

Example use case was that I saw a drop in correlation between USDCNH and CNYUSD which provided a great signal to trade.

I recommend you exercise caution and try to understand the reason for using the different algorithms. Each differential and each normalisation has its own purpose and this is only a crude tool.

As always, this isn't financial advice, do your own research, etc etc.

Open-source script

In true TradingView spirit, the author of this script has published it open-source, so traders can understand and verify it. Cheers to the author! You may use it for free, but reuse of this code in a publication is governed by House Rules. You can favorite it to use it on a chart.

Disclaimer

The information and publications are not meant to be, and do not constitute, financial, investment, trading, or other types of advice or recommendations supplied or endorsed by TradingView. Read more in the Terms of Use.

Want to use this script on a chart?