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: 8448
Joined: 25 Aug 2011
Has thanked: 1207 times
Been thanked: 2705 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: 8448
Joined: 25 Aug 2011
Has thanked: 1207 times
Been thanked: 2705 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.
These users thanked the author Henry MultiСharts for the post (total 2):
arjfcaJoshM

arjfca
Posts: 1270
Joined: 23 Nov 2010
Has thanked: 720 times
Been thanked: 222 times

Re: Using DDE to send data from MultiCharts to Excel

Postby arjfca » 26 Apr 2012

Henry Multicharts wrote: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: 8448
Joined: 25 Aug 2011
Has thanked: 1207 times
Been thanked: 2705 times

Re: Using DDE to send data from MultiCharts to Excel

Postby Henry MultiСharts » 26 Apr 2012

arjfca wrote:
Henry Multicharts wrote: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.
These users thanked the author Henry MultiСharts for the post:
arjfca

arjfca
Posts: 1270
Joined: 23 Nov 2010
Has thanked: 720 times
Been thanked: 222 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: 1270
Joined: 23 Nov 2010
Has thanked: 720 times
Been thanked: 222 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: 8448
Joined: 25 Aug 2011
Has thanked: 1207 times
Been thanked: 2705 times

Re: Using DDE to send data from MultiCharts to Excel

Postby Henry MultiСharts » 27 Apr 2012

arjfca wrote: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.


arjfca wrote: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.
These users thanked the author Henry MultiСharts for the post:
arjfca


Return to “MultiCharts”