EQUITYFRAMECondition related to a specific security in a specific market (ProScreener command only).
Syntax :
|
1 |
EQUITYFRAME("market","ticker") |
This instruction is useful when you want to compare a specific “ticker” to other securities for instance.
Example :
(excerpt of the ProScreener documentation)
This screener allows us to visually display the correlation between a security and other securities
in the same market. We calculate the ratio of the closing prices of 2 securities selected using “EQUITYFRAME”. We then calculate the difference between the current level of the ratio and the ratio for the previous day.
in the same market. We calculate the ratio of the closing prices of 2 securities selected using “EQUITYFRAME”. We then calculate the difference between the current level of the ratio and the ratio for the previous day.
|
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") |
NB: Through IG market or PRT CFD, it is not possible to compare instruments that are not in the same ‘market’ (list).
The below code gives similar values to the “Relative Strength Comparison” default indicator of the platform:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
EQUITYFRAME("Indices Euronext","PXI") valeur2=close equityframe(default) valeur1=close Forcerelative= valeur1/valeur2 while Forcerelative < 0.4 and Forcerelative > 0 do forcerelative=forcerelative*10 wend while Forcerelative > 6 do forcerelative=forcerelative/10 wend SCREENER(forcerelative) |
What do you mean exactly with: ” it is not possible to compare instruments that are not in the same ‘market’ (list).” Do you refer to watchlists, so It could be fixed just by creating a custom list incuding all needed instruments?
Even with own personal lists, if the securities were not in the same “markets”, it will not work.
Bonjour,
Dans l’exemple donné ici le screener ne peut comparer que le titre AMZN
Il n’est pas possible de faire un screener qui compare les titres du SP500 au SP500 ?
Merci
Dans ce cas déclarer l’indice à la place de AMZN à la ligne 4. Attention cependant, je pense que cela n’est possible qu’en V11.