Relative strength screener and custom index

• 05/31/2017 at 7:34 PM #37157
  sauka

  Hi,

  I have played around with EQUITYFRAME and the example provided here: https://www.prorealcode.com/documentation/equityframe/.

  I keep getting errors though that the equityframe cannot be applied to the selected security or that the market does not exist. What would be the correct market names? Is the market name = name of a List? Can I create a custom list and compare securities to eachother in that custom list?

  I would like to achieve the exact thing explained in the example but comparing all stocks to some different indecis. Perhaps also create custom indecis if possible. Is it even possible to create a custom index?

  The exact code im using now is:

  TIMEFRAME(daily) CloseVal = Close EQUITYFRAME("NASDAQ","SHLM") CloseInd = Close EQUITYFRAME(default) Ratio = (CloseVal / CloseInd) * 100 RelativeStrength = (Ratio - Ratio[1]) * 100 SCREENER(RelativeStrength AS "RelativeStrength")

  1 2 3 4 5 6 7 8

  TIMEFRAME(daily) CloseVal = Close EQUITYFRAME("NASDAQ","SHLM") CloseInd = Close EQUITYFRAME(default) Ratio = (CloseVal / CloseInd) * 100 RelativeStrength = (Ratio - Ratio[1]) * 100 SCREENER(RelativeStrength AS "RelativeStrength")

   

  

  sauka

  Participant

  Topics: 1

  Replies: 2

  Been thanked: 0 times
  05/31/2017 at 8:30 PM #37164
  GraHal

  Did you see below as stated in the link on your post above?

  I’m not sure what it means either :), but maybe it’s saying you can’t compare currency with commodities or currency with index / indices?  Not doing that are you?

  NB: Through IG market or PRT CFD, it is not possible to compare instruments that are not in the same ‘market’ (list).

  

  GraHal

  Participant

  Topics: 204

  Replies: 8399

  Been thanked: 2041 times
  05/31/2017 at 8:44 PM #37165
  sauka

  I also read that and at the moment I’m actually just trying to get the EQUITYFRAME to work by comparing different securities in one market but I cant seem to get it working.

  I also wonder why it is not possible to compare securities to an index. Am I missing something?

   

  

  sauka

  Participant

  Topics: 1

  Replies: 2

  Been thanked: 0 times
  05/31/2017 at 8:58 PM #37167
  GraHal

  Maybe the number of decimal places in the price / value has something to do with it?
  Also some instruments have volume figures and some do not?.
  Also maybe its a technical thing that equityframe just cant be applied across different lists?

  In short … I don’t know! 🙂

  Ill have a go and let you know if I get it working.

  

  GraHal

  Participant

  Topics: 204

  Replies: 8399

  Been thanked: 2041 times
  05/31/2017 at 9:19 PM #37168
  GraHal

  Naah I can’t make any sense of it, sorry sauka.

  It should make you feel better anyway … knowing you not on your own!? 🙂

  

  GraHal

  Participant

  Topics: 204

  Replies: 8399

  Been thanked: 2041 times
  05/31/2017 at 9:46 PM #37172
  GraHal

  Nicolas may spot this and advise how to get equityframe working.

  

  GraHal

  Participant

  Topics: 204

  Replies: 8399

  Been thanked: 2041 times
  06/01/2017 at 9:19 AM #37191
  Nicolas

  It’s not possible to compare a security with an index, if these 2 are not in the same “shares list”. I know it’s weird, but that’s how it works.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4739 times
  06/01/2017 at 8:10 PM #37255
  sauka

  Well, I cant even get equityframe to compare different stocks in the same list. could you pleae give some advice?

  

  sauka

  Participant

  Topics: 1

  Replies: 2

  Been thanked: 0 times
  06/02/2017 at 9:07 AM #37271
  Nicolas

  Please share us your code, so we could give more precise advises! 😉

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4739 times
  06/02/2017 at 9:32 AM #37276
  GraHal

  Code below off the link below, we both couldn’t get any ‘sense’ out of it, and we both tried different instruments (out of same list).

  https://www.prorealcode.com/documentation/equityframe/

  Thank you Nicolas

  TIMEFRAME(daily) CloseVal = Close EQUITYFRAME("NASDAQ","AMZN") CloseInd = Close EQUITYFRAME(default) Ratio = (CloseVal / CloseInd) *100 RelativeStrength = (Ratio - Ratio[1]) *100 SCREENER(RelativeStrength AS"RelativeStrength")

  1 2 3 4 5 6 7 8 9 10 11

  TIMEFRAME(daily) CloseVal = Close   EQUITYFRAME("NASDAQ","AMZN") CloseInd = Close   EQUITYFRAME(default) Ratio = (CloseVal / CloseInd) *100 RelativeStrength = (Ratio - Ratio[1]) *100   SCREENER(RelativeStrength AS"RelativeStrength")

   

  

  GraHal

  Participant

  Topics: 204

  Replies: 8399

  Been thanked: 2041 times
  06/06/2017 at 1:39 PM #37623
  Nicolas

  Here is a simple example to calculate the EURGBP current value with EURUSD and GBPUSD:

  EQUITYFRAME("Currencies","EURUSD") eurusd=close equityframe("Currencies","GBPUSD") gbpusd=close result=eurusd/gbpusd screener[1](result)

  1 2 3 4 5 6 7 8 9

  EQUITYFRAME("Currencies","EURUSD") eurusd=close   equityframe("Currencies","GBPUSD") gbpusd=close   result=eurusd/gbpusd   screener[1](result)

   

  1 user thanked author for this post.

  GraHal

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4739 times
• Author
  Posts