Moving Average from eSignal into Excel

[eSignal_JasonK]

Hello Seldin,

The DDE links created from an EFS formula will only be active in Excel if the formula is also active on an Advanced Chart in eSignal.

If you are only running the formula on a 5 minute chart of $SPX, then the only active DDE link you can use would be:

=eSignal|EFS!EMA30SPX5

In order to have the daily DDE link active at the same time you need to apply the same formula to another Advanced Chart using $SPX on the daily interval.

Does this fix your DDE links?

[eSignal_JasonK]

Hello genetrader,

For some symbols like ES #F, the raw data in the chart is formatted for display. EFS doesn't automatically apply the formatting. You can use the EFS function formatPriceNumber( nValue ) to force the DDE output to take on the same formating as the chart display. Add the following line of code prior to your dde.set() call.

vEMA30 = formatPriceNumber(vEMA30);
    
ddeEMA30.set(vEMA30); 

[eSignal_JasonK]

Hello genetrader,

Here's a better solution actually. The formatPriceNumber() function converts the number to a string, which removes the EMA from being plotted on the chart. If you still want the EMA to plot on the chart then just use the formatPriceNumber() function within the dde.set() call like so:

    ddeEMA30.set(formatPriceNumber(vEMA30)); 

[seldin]

I got everything to work.

I originally cut and pasted the formula:

=eSignal|EFS!EMA10SPXD

I then tried to just type it into Excel and it then worked.

Guys,

I would like to thank you for your help.

Much appreciated.

[email protected]

[eSignal_JasonK]

Hello seldin,

Good to hear you've got it working.

ScottJ suggested adding an underscore between the symbol and the interval to improve the readability of the DDE link. If you want to incorporate that replace the line where sName is initialized to look like this:

var sName = "EMA30" + getSymbol() + "_" + getInterval(); 

The result would change the DDE link to look like this:

=eSignal|EFS!EMA30SPX_D

[mavrik73]

All in dicators on the chart to Excel

Hello.
How can I have any indicator on the chart transmitted into the Excel.
For example the Bollinger bands, CCI or any other prop indi I created in EFS ?

THank U
Itai

[AndyS]

Hi mavrik73,

Contained within this thread are code examples for using EFS to transmit indicator values to Excel. I, not being a programmer, cannot expand any further than from what is already written here.

Are you writing code to do this and looking for help?

[mavrik73]

Andy - looking for a simple export feture

As a TradeStation user one can not hide his frustration 1ns seeing the complex syntax Esignal created.

I am seeking to have some solution so that I can get either a log of prices from Esignal to Excel (Like an on going time and sale window constantly updating during the day and holds say last 20 5 min bar OHLC) and then reproduce the indicators , or just getting in dicators directly to the excel (RSI CCI etc.

I dont know how to code this.

Thanks,
Itai

[ACM]

Itai
Enclosed is an example for the DDE of CCI. Run the efs on a 5 minute chart for IBM and in Excel use the following expression
=eSignal|EFS!CCI20IBM_5
You can use this efs as a blueprint to create the ones for RSI etc. You can also find some other examples here
Alex

var ddeCCI = null;
var vCCI20 = new CCIStudy(20, "Close");

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

function main() {
    if (ddeCCI == null) {
        var sName = "CCI20" + getSymbol() +"_"+ getInterval();
        ddeCCI = new DDEOutput(sName);
    }

    var vCCI = vCCI20.getValue(CCIStudy.CCI);
    if(vCCI != null) ddeCCI.set(vCCI);

    return;
} 

[mavrik73]

Thank you Alexis!!

As like most times, ALEXIS saves the day.

Thank you for all your help and time.

Itai

[Axelar]

Forex Format

What would be the format for Forex symbols? I get #NAME? in Excel when attempting to use this sample you posted. This is the syntax I have tried to place in the cell;

=eSignal|EFS!EMA30GBPA0FXD
=eSignal|EFS!EMA30GBP A0-FX_D

I have an advanced chart (daily) opened with the efs sample posted below by JasonK

[ACM]

Axelar
See this thread that provides an answer to the same question you asked
Alex

[Axelar]

Alexis,

Thanks for the response. Unfortunately no success with the forex symbols. As I mentioned previously, I used the sample formula provided by JasonK and based on the thread you referenced, I added a replace statement. I have tested the formula with non-forex symbols and it works. Any other suggestions;

ema5.efs

var ddeEMA5 = null;
var vMA = new MAStudy(5, -1, "Close", MAStudy.EXPONENTIAL);

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

function main() {
if (ddeEMA5 == null) {
var sName = "EMA5" + 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);
ddeEMA5 = new DDEOutput(sName);
}

var vEMA5 = vMA.getValue(MAStudy.MA);
if (vEMA5 == null) return;

ddeEMA5.set(vEMA5);

return vEMA5;
}

Excel DDE call (variations of the same);

=eSignal|EFS!EMA5GBP A0-FX15
=eSignal|EFS!EMA5GBPA0FX15
=eSignal|EFS!EMA5GBPA0-FX15
=eSignal|EFS!EMA5GBP_A0-FX15


Thanks again,

Axel

[ACM]

Axel
The link in Excel should be =eSignal|EFS!EMA5GBP_A0FX_interval where _interval is the interval of the chart (ie _D for daily, _30 for 30 minute etc)
To see the correct syntax run the efs in the chart and open the Formula Output Window (see image below)
Alex

[Axelar]

Alexis,

Thanks for the quick response. I made the changes and it now works. Looking in the formula output window was quite handy.

Axe