Dde efs foreign symbols

[TOM1245]

Hi,

I've successfully used the EMA30 and RSI templates to get US data into excel.

I've used for JMP the following:
=eSignal|EFS!EMA30JPMD
=eSignal|EFS!RSI14JPM_D


I've got a problem though getting it to work with foreign symbols.
What would the call function be in excel for example for this symbol PPC-ATH ?

Thanks in advance,
Yannis

[ACM]

Yannis
You may want to review this thread that provides both an explanation of the issue and how to resolve it
Alex

Hi,

I've successfully used the EMA30 and RSI templates to get US data into excel.

I've used for JMP the following:
=eSignal|EFS!EMA30JPMD
=eSignal|EFS!RSI14JPM_D


I've got a problem though getting it to work with foreign symbols.
What would the call function be in excel for example for this symbol PPC-ATH ?

Thanks in advance,
Yannis

[TOM1245]

Hi Alex,

I've managed to get RSI running using this code:

var ddeRSI = null;
var vRSI12 = new RSIStudy(12, "Close");

function preMain() {
setPriceStudy(true);
setStudyTitle("DDE_RSI_12");
setShowCursorLabel(false);
}

function main() {
if (ddeRSI == null) {
var sName = "RSI12" + getSymbol() +"_"+ getInterval();
sName = sName.replace("$", ""); // remove $ from string
sName = sName.replace("#", ""); // remove # from string
sName = sName.replace("-", ""); // remove # from string
sName = sName.replace(" ", "_") // replace space with underscore
debugPrintln("DDE Link for Excel =eSignal|EFS!"+sName);
ddeRSI = new DDEOutput(sName);
}

var vRSI = vRSI12.getValue(RSIStudy.RSI);
if(vRSI != null) ddeRSI.set(vRSI);

return;
}


In excel, the calling function is =eSignal|EFS!RSI12PPCATH_60

Could you please edit it for Stoch (9,5,3) ?

I've tried to change the RSI to Stoch in the above formula but Stoch has 3 parameters. (9,5,3)

Thanks again,
Yannis

[ACM]

Yannis
As an aside I would suggest you use the current rsi() function rather than the legacy RSIStudy() function that you used in the script you posted. For the syntax of the function and examples of its use see this article in the EFS KnowledgeBase [search also the forums as there are many other examples available]
For the Stochastic study use the stochK() or stochD() functions depending on which one you want. For the required syntax and examples of their use see this article in the EFS KnowledgeBase [search also the forums as there are numerous other examples available]
The overall logic is no different regardless of the parameters required
Alex

Hi Alex,
I've managed to get RSI running using this code:
var ddeRSI = null;
var vRSI12 = new RSIStudy(12, "Close");
function preMain() {
setPriceStudy(true);
setStudyTitle("DDE_RSI_12");
setShowCursorLabel(false);
}
function main() {
if (ddeRSI == null) {
var sName = "RSI12" + getSymbol() +"_"+ getInterval();
sName = sName.replace("$", ""); // remove $ from string
sName = sName.replace("#", ""); // remove # from string
sName = sName.replace("-", ""); // remove # from string
sName = sName.replace(" ", "_") // replace space with underscore
debugPrintln("DDE Link for Excel =eSignal|EFS!"+sName);
ddeRSI = new DDEOutput(sName);
}
var vRSI = vRSI12.getValue(RSIStudy.RSI);
if(vRSI != null) ddeRSI.set(vRSI);
return;
}

In excel, the calling function is =eSignal|EFS!RSI12PPCATH_60
Could you please edit it for Stoch (9,5,3) ?
I've tried to change the RSI to Stoch in the above formula but Stoch has 3 parameters. (9,5,3)
Thanks again,
Yannis