I can´t say this enough times, correlations matter and correlations are in deed a traders best friend.
Correlations are very useful but very hard to plot without some code knowledge. Fortunately the guys that made dtale are life savers.
dtatle is a library that allows you to manipulate data, you can re-order it, plot it, export it, etc.
Today I will share with you a simple way to plot ETF correlations.
For starters you should go to my shared content and download the spreadsheet with the ETF data, I will update this file at least monthly.
https://eod-notes.com/shared-content/ click on the “Reports” link and download the file.
I will assume you have python installed on your machine.
For starters you need to install dtale
pip install dtale
After dtale is installed you can copy paste this snippet.
import pandas as pd import dtale data = pd.read_excel("YOUR_FILE_PATH.xlsx") d= dtale.show(data) d.open_browser()
Replace “YOUR_FILE_PATH.xlsx” with your file path and run it.
You will see something like this.
After this, go to the top left corner and click on the arrow. Select the correlation menu.
A new window will pop up, now you are free to explore. search for specific correlations, change the Rolling Window for a smother data, have fun.
Find more stuff on my github:
If you have any questions or want help to try some strategies up, feel free to drop me a message.
Have an awesome day,