Linear Regression Slope

• 09/18/2019 at 12:58 AM #107867
  planbtrading

  Hi Team, i’m doing some calculations of pricing data outside of PRT which I wish to reconcile back to PRT to ensure I understand the numbers correctly. I’m currently calculating the slope of prices in excel using the excel slope formula =slope(an array of LN(close), a linear list of numbers eg: 1-90) and the above is not reconciling with the inbuilt linear regressions slope function in PRT.

  Does anyone know the logic used behind the inbuilt function?

  thanks

  planb

  

  planbtrading

  Participant

  Topics: 2

  Replies: 2

  Been thanked: 0 times
  09/18/2019 at 7:52 AM #107873
  Nicolas

  There are some codes in the library/forums that are the same than the linear regression of the platform. Slope is just the difference between the value of the current period and a previous N one.

  1 user thanked author for this post.

  planbtrading

  

  Nicolas

  Keymaster

  Topics: 83

  Replies: 20906

  Been thanked: 4871 times
  11/27/2021 at 8:31 PM #182431
  Vjper

  Guten Abend,

  hoffentlich ist die Anfrage noch aktuell!

  @Planhandel:

  Meinst du diese Steigung : Σ[(x – x*) * (y – y*)] / Σ[(x – x*)²]

  Falls du den Code gefunden  hast (Beispielsweise mit einer Schleife von: for x = 1 to n), dann würde ich mich freuen, wenn Sie unterstützen könnten.

  Good evening, I hope the request is still up to date!

  @Planhandel: Do you mean this slope:  Σ [(x – x *) * (y – y *)] / Σ [(x – x *) ²]

  If you have found the code (for example with a loop of: for x = 1 to n), then I would be happy if you could support.

   

  

  Vjper

  Participant

  Topics: 8

  Replies: 23

  Been thanked: 2 times
  11/27/2021 at 10:23 PM #182433
  robertogozzi

  @Vjper

  Only post in the language of the forumthat you are posting in. For example English only in the English speaking forums and French only in the French speaking forums.

  Thank you 🙂

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 18044

  Been thanked: 4611 times
• Author
  Posts