Statistics question

Discussion in 'Trading' started by bozwood, Oct 27, 2005.

  1. bozwood

    bozwood

    Is there a way to normalize the slope of the linear regression of price data so that different units from different stocks/commodities can be compared?

    Thanks in advance,
    Jonathan
     
  2. I'm certainly no stats pro, but can't you do it in %?

    - The New Guy
     
  3. Perhaps try some pair trading or similar methods. :confused:
     
  4. Heck, I'm not even sure if I understand what you're asking, but if you're asking what I think you're asking and you have access to bloomberg, type HRA <stock> <stock> (or something like that, not sure of the exact syntax) and then there's a setting for something like "regression type" and put that on percentage, then you can compare two seperete products based on their regression in % rather than points.

    I think this is where you're going...

    - The New Guy
     
  5. bozwood

    bozwood

    I have been playing around with that. Looks like it may work, but I am not sure if it is mathematically sound. Thanks for the suggestion
     
  6. Personally I put almost everything into % before running calculations and then translate that back into point moves for each product. It's always made more sense to me to do it that way to avoid apples/oranges situations...

    - The New Guy
     
  7. skepticaltrader

    skepticaltrader Guest

    I think in e-signal you can do a "Standard Deviation" and a "Standard Error" for Linear Regression.

    I'm not right in front of e-signal so I could be wrong.

    The only other way to do it is to manually do it in Microsoft Excel.

    Hope this helps.
     
  8. bozwood

    bozwood

    Actually, I am trying to do it in excel. Any ideas?

    Thanks
     
  9. bozwood

    bozwood

    Just trying to get a comparable slope across different stocks, etc.

    Thanks for the ideas
     
  10. skepticaltrader

    skepticaltrader Guest

    I'm not really sure since I haven't used Excel in so long. I would assume you could do a line graph of prices and if I remember correctly there is a "Standard Deviation" function built into their statistical tool.

    I'll try and play with it some either tonight or tomorrow and I'll get back with you on it.

    Please let me know if you figure out how to do it in Excel.

    Thanks
     
    #10     Oct 27, 2005