Using DDE to send data from MultiCharts to Excel

Questions about MultiCharts and user contributed studies.
pschriber2
Posts: 36
Joined: 24 Apr 2012
Has thanked: 6 times
Been thanked: 2 times

Using DDE to send data from MultiCharts to Excel

Postby pschriber2 » 24 Apr 2012

Hi,

I'm trying to send data (i.e. price, signals, indicators, high, etc.) from MultiCharts to an Excel spreadsheet. However, from what I've seen so far, I'm only able to do use a DDE to send data from a broker platform like IB to MultiCharts and then to Excel. Does anyone know if this is possible to do, and if so, how would I go about this?

Any help or suggestions would be greatly appreciated.

Thanks,

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: Using DDE to send data from MultiCharts to Excel

Postby Henry MultiСharts » 24 Apr 2012

ELExcel.dll is capable of sending data from MultiCharts to Excel.
Please use forum search to find more information about it, there has been a number of threads about it already.

pschriber2
Posts: 36
Joined: 24 Apr 2012
Has thanked: 6 times
Been thanked: 2 times

Re: Using DDE to send data from MultiCharts to Excel

Postby pschriber2 » 24 Apr 2012

Thanks. However, from what I've read it's only been truly tested with TS and MT. I have read that it gave some users issues when used with Multicharts because of the multi-threading. Anyone have any issues with ELExcel.dll?

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: Using DDE to send data from MultiCharts to Excel

Postby Henry MultiСharts » 25 Apr 2012

You can declare the DLL function as ThreadSafe to increase the performance of calculation and optimization of the study.

arjfca
Posts: 1292
Joined: 23 Nov 2010
Has thanked: 725 times
Been thanked: 223 times

Re: Using DDE to send data from MultiCharts to Excel

Postby arjfca » 26 Apr 2012

You can declare the DLL function as ThreadSafe to increase the performance of calculation and optimization of the study.
Henry, How do you do that?


Actually, I'm using XLInput to send data to Excel.

Maybe I could use ELExcel as a backup option if it is a solid solution

Martin

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: Using DDE to send data from MultiCharts to Excel

Postby Henry MultiСharts » 26 Apr 2012

You can declare the DLL function as ThreadSafe to increase the performance of calculation and optimization of the study.
Henry, How do you do that?


Actually, I'm using XLInput to send data to Excel.

Maybe I could use ELExcel as a backup option if it is a solid solution

Martin
Please refer to the Wiki example.

arjfca
Posts: 1292
Joined: 23 Nov 2010
Has thanked: 725 times
Been thanked: 223 times

Re: Using DDE to send data from MultiCharts to Excel

Postby arjfca » 26 Apr 2012

Thanks

Another question. Any Idea if the ELExcel.DLL will be available for the 64 version?

Martin

arjfca
Posts: 1292
Joined: 23 Nov 2010
Has thanked: 725 times
Been thanked: 223 times

Re: Using DDE to send data from MultiCharts to Excel

Postby arjfca » 27 Apr 2012

Treadsafe with an External dll XLLink.DLL

Anybody could explain me what is about . This an answer that I received. Don't understand what is all about.
Hi Martin,
Let me know if you try it. Note that unless MultiCharts supports the threadsafe attribute with ‘external method’ you will need to pass the PL self pointer.

If there is a problem, it will likely be with MultiCharts’ PLKit.dll which is a dependency.

David
Martin

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: Using DDE to send data from MultiCharts to Excel

Postby Henry MultiСharts » 27 Apr 2012

Thanks
Another question. Any Idea if the ELExcel.DLL will be available for the 64 version?
Martin
ELExcel.DLL is a third party dll. We are not developing updates for it and do not have the information if it will be updated or not.

Treadsafe with an External dll XLLink.DLL
Anybody could explain me what is about . This an answer that I received. Don't understand what is all about.
Martin
It is not clear what was mentioned by this answer. Please contact the person you got reply from directly for clarifications.


Return to “MultiCharts”