How to calculate the correlation coefficient?

• 06/06/2018 at 7:03 AM #72405
  thomas2004ch

  From this URL I can use draw the Linear-Regression on a stock. But I wonder how to calculate its ‘correlation coefficient’? My purpose is to scan stocks with higher ‘correlation coefficient’ or smaller valatility.

  It seems there is no function called Correlation by ProRealCode?

   

   

  

  thomas2004ch

  Participant

  Topics: 27

  Replies: 39

  Been thanked: 1 time
  06/06/2018 at 7:04 AM #72406
  thomas2004ch

  Sorry, I forget the URL. Here it is:

  https://www.prorealcode.com/prorealtime-indicators/linear-regression-channel-with-percent-upper-and-lower-lines/

  

  thomas2004ch

  Participant

  Topics: 27

  Replies: 39

  Been thanked: 1 time
  06/06/2018 at 8:03 AM #72412
  Nicolas

  You can try to use the R-squared instruction, it measures the error rate of the linear regression on selected price.

  1 user thanked author for this post.

  immo_vienna

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  06/06/2018 at 9:36 AM #72437
  thomas2004ch

  Hi Nicolas,

  Many thanks. But as I use the LinearRegression-Indicator posted in your URL above, I failt to see the lines for stock EHC. Why?

  

  thomas2004ch

  Participant

  Topics: 27

  Replies: 39

  Been thanked: 1 time
  06/06/2018 at 10:14 AM #72443
  Nicolas

  I don’t know. Do you have sufficient data for the chosen period of the channel? Did you change the percentage to test different settings?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  06/06/2018 at 12:02 PM #72461
  thomas2004ch

  Ok, I change the length from 100 to 20, then I can see it.

  1 user thanked author for this post.

  immo_vienna

  

  thomas2004ch

  Participant

  Topics: 27

  Replies: 39

  Been thanked: 1 time
• Author
  Posts