Using python and dtale to analyze correlations

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.
https://github.com/man-group/dtale
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.

dtale start up

After this, go to the top left corner and click on the arrow. Select the correlation menu.

dtale 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:
https://github.com/tiagolvsantos/eod_notes

If you have any questions or want help to try some strategies up, feel free to drop me a message.

Have an awesome day,

Tiago