eSignal & MS Excel

[Doji3333]

Has anyone tried to feed an EFS DDE opbject to any of the newer versions of office? On my older version of excel, it works perfectly (for me), but when I load up the feeder efs files (DDE Feeder) and try it with his newer version of Excel - nothing. No connection or change in price data.

Has anyone had any success linking the DDE opject to the newest excel?? If so, do you have to create a new excel connection?

Sorry, not real versed with the newer excel. Look for the trick.

B

/*

Example:  This file will create a single dde object called "DDE1".  You should be able to access this value by typing the following into any cell in MS excel.

=eSignal|EFS!DDE1

*/


var dde1obj = new DDEOutput("DDE1");

function main() {
  dde1obj.set( close( 0, sym(getSymbol()+", D") ) );

} 

[waynecd]

Hi Doji3333,

I'm no expert but this code seems to do what you want:
I typed "=eSignal|EFS!'DDE1'" in Excel 2007.
I don't own Excel 2010.

NOTE: Once I typed the "=eSignal|EFS!'DDE1'" in Excel and it returned "FALSE" or "#NAME" in the cell, I had to delete the cell entry and re-enter it again or enter it in another cell. Otherwise even a working version of the efs returned the "FALSE" or "#NAME" in Excel.

function preMain() {

setPriceStudy(true);

}

var dde1obj = new DDEOutput("DDE1");

var bInit = false;
var study = null;
function main() {
    if(!bInit){
        study = close( sym(getSymbol()+", D") );
        bInit = true;
    }
    var xy = study.getValue(0);
    if(dde1obj != null) dde1obj.set(xy );

} 

This also works:

function preMain() {

setPriceStudy(true);

}

var dde1obj = new DDEOutput("DDE1");

var bInit = false;
var study = null;
function main() {
    if(!bInit){
        study = close( sym(getSymbol()+", D") );
        bInit = true;
    }
     dde1obj.set(study.getValue(0) );

} 

The next two also work:

function preMain() {

setPriceStudy(true);

}

var dde1obj = new DDEOutput("DDE1");

function main() {

    var xy = close( 0, sym(getSymbol()+", D"));
    dde1obj.set(xy );

} 

function preMain() {

setPriceStudy(true);

}

var dde1obj = new DDEOutput("DDE1");

function main() {
    dde1obj.set(close( 0, sym(getSymbol()+", D")) );
} 

Wayne

[Doji3333]

Maybe I could ask an esignal support staff to try this with the newest version of Excel?

I'm trying to satisfy a client's request to build a custom solution using his excel spreadsheet and if this does not work properly with the newest version of excel, then I need to know so I can develop a better solution.

Thanks?

[waynecd]

Hi Doji,

Sorry the last post wasn't useful. However at:

http://social.technet.microsoft.com/Forums/en-US/office2010/thread/a2c99909-3f34-4870-9915-b4fcc2c0aaa3

they explain that you need to enable the DDE option and explains how.

"I'm not able to get data from DDE links in Excel 2010. I tried that from more than one DDE servers, but everytime I tried to stabilish the connection, Excel stops to respond."

"I found how to fix the DDE "problem", I think the default DDE option for this Office version will be disable.
To enable DDE links, go thru Options > Advanced and unmark the option "Ignore other applications that use Dynamic Data Exchange (DDE)"

In case that doesn't work try other settings as explained in:

http://social.technet.microsoft.com/Forums/en-US/excel/thread/e1b5c693-6bca-4f4f-971e-13d3d3d10b37

I hope it helps but I'll leave further responses to someone who actually knows.

Regards,
Wayne

[Doji3333]

Thank you Wayne. I really appreciate the links.

I spent 20 minutes yesterday trying to figure out how to get Excel to accept these DDE links. Guess I was looking in the wrong place. LOL

[waynecd]

Glad I was able to help you out for a change.

Wayne