Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 00:12:26 +0000



Post From: Correlation Matrix in Spreadsheet - how?

[2016-06-05 09:20:54]
Cavalry3162 - Posts: 523
Hello SC,

i am a bit lost with the spreadsheet.

what i want to do is to create a correlation matrix, a bit like this: http://www.mrci.com/special/corr180.php just as a spreadsheet.

in your examples there was a chart involved all the time to get some data into the sheet. but there was never an example to get two or more charts into one spreadsheet.

can you point me into a direction?

In the end, i want to have that matrix for a couple different time frames (x days, x hours, x minutes), so there's probably quite some charts involved.
the data (as a starting point) should come out of these symbols (see attachment)

any help is highly appreciated!

thanks,
Andreas
image2016-06-05_05-19-50.png / V - Attached On 2016-06-05 09:20:46 UTC - Size: 566.17 KB - 551 views