dde study values

[jobe1]

Thanks everyone for helping me get to the point where I can modify existing studies to make them dde-outputtable. There are a few problems/inconveniences about which someone may have an answer:

1) Due to the singularity of Excel (one cell, one value) and the plurality of many studies (stochastics, bollinger bands), I am generating a veritable pile o' study names. Would someone mind sharing her system for naming and filing studies? Currently, everything goes into the wizard folder named according to the syntax necessary to provide enough info, but not necessarily intuitive should you need to choose one the next day.

2) The last time I spoke with an eSignal technical support representative (a consummate pro, his expertise surpassed only by his patience) he about had an aneurism when I told him how many advanced charts I had open on one page. I don't necessarily need to be looking at all of these advanced charts at the same time, but as I understand it, in order for Excel to be able to call a dde-outputted study, the study must be running within an advanced chart. And I would like to output at least seven study values on 15 or so symbols and on three different time intervals- the logistics of which require me to have open 45 advanced charts displaying over 300 studies. You don't have to tell me I'm out of luck going this route. Question is, can a Quote Board display study values, and if so, would displaying a study value in a Quote Board enable Excel to call it, and would going that route be less of a strain on memory? Follow up query: can I run more than one instance of eSignal to better utilize my computer's dual processor?

3) Excel does not like futures' symbols in the dde syntax of a study value. I tried the single quotation mark before and after the symbol to no avail. What I've ended up doing is creating a study name for the futures' symbols on which I'd like to output study values. For instance, for the 10 Yr future continuous contract, "ZN #F," I created the spread symbol name "TenYears" with the formula "1ZN #F." Excel loves it. If there is a way to make Excel read futures symbols in conjunction with dde study values that doesn't require any work outside of Excel, I'd actually appreciate your proving me a moron, because it feels silly the way I am trying to do it.

Thanks for any ideas on any of these!

[arbor03]

I would like to know this as well as this would help me immensely.

I do however think this might get a faster response on the EFS boards?

Best Regards,

Tim

[eSignal_JasonK]

Re: dde study values

Hello jobe1,

Originally posted by jobe1
Thanks everyone for helping me get to the point where I can modify existing studies to make them dde-outputtable. There are a few problems/inconveniences about which someone may have an answer:

1) Due to the singularity of Excel (one cell, one value) and the plurality of many studies (stochastics, bollinger bands), I am generating a veritable pile o' study names. Would someone mind sharing her system for naming and filing studies? Currently, everything goes into the wizard folder named according to the syntax necessary to provide enough info, but not necessarily intuitive should you need to choose one the next day.

When you are creating the name for the dde link in the study, for example:

var dde = new DDEOutput( "movavg" + getSymbol() );

You can incorporate some of the chart information along with a short description of what type of data it will be linking. In the example above, the dde link name will become movavgIBM. That will become the name you reference in excel.

=eSignal|EFS!movavgIBM

You may also want to consider incorporating the chart interval into the name with getInterval() as well. I would recommend that the name you use starts with the description of the type of data followed by the symbol and possibly the chart interval.

2) The last time I spoke with an eSignal technical support representative (a consummate pro, his expertise surpassed only by his patience) he about had an aneurism when I told him how many advanced charts I had open on one page. I don't necessarily need to be looking at all of these advanced charts at the same time, but as I understand it, in order for Excel to be able to call a dde-outputted study, the study must be running within an advanced chart. And I would like to output at least seven study values on 15 or so symbols and on three different time intervals- the logistics of which require me to have open 45 advanced charts displaying over 300 studies. You don't have to tell me I'm out of luck going this route. Question is, can a Quote Board display study values, and if so, would displaying a study value in a Quote Board enable Excel to call it, and would going that route be less of a strain on memory? Follow up query: can I run more than one instance of eSignal to better utilize my computer's dual processor?

EFS study values cannot be output to the Quote Board at this time. Regarding multiple instances of eSignal, please review the following article from our eSignal Knowledgebase.

Running Multiple Instances of eSignal

3) Excel does not like futures' symbols in the dde syntax of a study value. I tried the single quotation mark before and after the symbol to no avail. What I've ended up doing is creating a study name for the futures' symbols on which I'd like to output study values. For instance, for the 10 Yr future continuous contract, "ZN #F," I created the spread symbol name "TenYears" with the formula "1ZN #F." Excel loves it. If there is a way to make Excel read futures symbols in conjunction with dde study values that doesn't require any work outside of Excel, I'd actually appreciate your proving me a moron, because it feels silly the way I am trying to do it.

Thanks for any ideas on any of these!

The identifier string used for the DDE formula in Excel cannot contain any special characters or spaces. If you use the get Symbol() function to build the identifier string, you can use the String.replace() method to parse these items from the string. Please visit the following thread, Moving Average from eSignal into Excel, to see a complete formula example.