5 Comments
Oct 15, 2023Liked by FXMacroGuy

Thanks! The correlation matrix looks like it could potentially be made using Excel. Do you use excel or other software for that? If you do use excel, can you recommend any good free (of reasonably priced) API data sources for use in excel? Any tutorial links would be much appreciated. I don't mind if data is delayed. I want to be able to search for basically any instrument like I can in TradingView, but I want to have it in excel so I can setup correlation matrices and run statistical analyses either in excel or export the .csv to R/R Studio (guess I could figure out how to get data directly into R with Python but that's a bit beyond my pay grade).

Expand full comment
author

Yes, it's done in Excel with TradingView data. I don't have any free API sources but data can be exported from TradingView, so it's very flexible. I've written a guide on that and how to build a dashboard or correlation matrix with Excel on top of it: https://fxmacro.ck.page/free-excel-guide

Expand full comment
Oct 15, 2023Liked by FXMacroGuy

Thank you so much! That's perfect.

Expand full comment

Thank you, great coverage as always! Have a good Sunday!

Expand full comment
author

Thank you 🙏

Expand full comment