Time Series Forecast with DDE to Excel

[gem2004]

I plot the TSF value on any chart without a problem using the following formula by Chris Kryza

http://share.esignal.com/download.js...fMovingAvg.efs

I need to modify it so that I can get the latest numerical value for TSF on an Excel sheet using DDE and a formula in the form of :

=eSignal|EFS!MACDsigES_F5 that I use for the MACD signal.

In addition I would like to know if Custom Studies could be inserted in the Function Editor of the Formula Wizard in addition to the default Builtin Studies.

Any help will be highly appreciated. Thanks.

[eSignal_JasonK]

Hello gem2004,

Take a look at the code examples in this thread, EFS DDE Links. You can incorporate the code from this example to accomplish what you need. If you do a search on "DDE and Excel," you can find many more DDE examples.

[eSignal_JasonK]

Hello gem2004,

Please attach a copy of the formula you are working with and I'll give you more specific instructions to help get you going.

[eSignal_JasonK]

Hello gem2004,

First, please review the code example in our EFS KnowledgeBase for the DDEOutput Object . This example is super basic and will help you better understand the following instructions.

1) Add a global DDEOutput object to the formula at line 38. The parameter passed to the object creates the name that will be used in Excel. If you were running this on a chart of IBM, the name would be: TSF_IBM. All DDE links from an EFS start with =eSignal|EFS! followed by the DDEOutput name we specify when creating the global DDEOutput object. The complete formula for Excel would be: =eSignal|EFS!TSF_IBM.



2) The next step is to use the set() method of the DDEOutput object to pass the actual value of the TSF to the DDE link in Excel. Insert a line at line 178 and the following code. A good rule of them to follow is to use the same logic as the return statement in main to set the return values for the DDE link. You will also use the same variable name that is used by the return statement.



3) Save the formula with a new name and then apply it to an Advanced Chart.

4) Enter the formula, =eSignal|EFS!TSF_Symbol, using the chart symbol in the name after the "TSF_" portion.

Give it a shot and let me know if you have any trouble.