Looking for hint: Stroring data in the clipboard

Questions about MultiCharts and user contributed studies.
arjfca
Posts: 1292
Joined: 23 Nov 2010
Has thanked: 725 times
Been thanked: 223 times

Looking for hint: Stroring data in the clipboard

Postby arjfca » 08 Dec 2015

Hello

Is there any possibility that a string of data captured using the mouse click be saved in the clipboard. I suppose that it will need to be pass using a dll.

Any idea?

Martin

User avatar
TJ
Posts: 7740
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1033 times
Been thanked: 2221 times

Re: Looking for hint: Stroring data in the clipboard

Postby TJ » 08 Dec 2015

Hello

Is there any possibility that a string of data captured using the mouse click be saved in the clipboard. I suppose that it will need to be pass using a dll.

Any idea?

Martin
If you right click the mouse and select Copy,
the string is captured into the clipboard.

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

Re: Looking for hint: Stroring data in the clipboard

Postby arjfca » 08 Dec 2015

Hello

Is there any possibility that a string of data captured using the mouse click be saved in the clipboard. I suppose that it will need to be pass using a dll.

Any idea?

Martin
If you right click the mouse and select Copy,
the string is captured into the clipboard.
Hello TJ

Purpose: Exchanging data between MC and Excel on a manual operation.

The goal is to capture bars data from a chart in a CSV string. At the moment, using a mouseclick function, the string is built by clicking on a bar. The string has these info: Instrument, date, time, OHLC and other parameters. Then this created string is saved in a text file.

In Excel, a macro is called to read the text file, split the csv ans store the data to it's destination cell.

Problem is the macro and all the stuff is built for the Excel application. I need to recreate a new and complex Excel sheet just to capture some data from MC. I just want to do a simple test in Excel. It would be easier if the string was stored in the clipboard. It would then be more flexible to use the info easily on any Excel sheet or another application

Martin

User avatar
TJ
Posts: 7740
Joined: 29 Aug 2006
Location: Global Citizen
Has thanked: 1033 times
Been thanked: 2221 times

Re: Looking for hint: Stroring data in the clipboard

Postby TJ » 08 Dec 2015

Sounds too complicated for me... I am not good at this.

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

Re: Looking for hint: Stroring data in the clipboard

Postby arjfca » 09 Dec 2015

Thanks TJ

Clarification:
What I'm looking for is only the process for storing in the clipboard, not more

This attached function , When I use Shift MouseClick on a bar, will save on drive "G" a text file: "G:\BarInfo.txt" a string like

0.66210,0.66300,0.66210,0.66295,NZD.USD,6 Min,0.66186,2015-12-08 09:09:00,NZD.USD,6 Min,0.66186,2015-12-08 09:09:00

The goal is to get the string in the clipboard instead of a Text file

Martin
Attachments
MouseClick.pla
(41.12 KiB) Downloaded 340 times

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

Re: Looking for hint: Stroring data in the clipboard

Postby Henry MultiСharts » 17 Dec 2015

Hello Martim,

You will need to program a dll to do that: https://msdn.microsoft.com/en-us/librar ... 10%29.aspx

OZ Trade
Posts: 39
Joined: 08 Nov 2013
Has thanked: 11 times
Been thanked: 18 times

Re: Looking for hint: Stroring data in the clipboard

Postby OZ Trade » 19 Dec 2015

There is no need to copy to clipboard for this, write the information straight to a CSV and have your excel to refresh periodically

EL Collections is what you need

Download and install the .dll and read the word file, takes some learning but worth it

If you get stuck can help you

http://www.multicharts.com/discussion/v ... 319#p48320

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

Re: Looking for hint: Stroring data in the clipboard

Postby arjfca » 19 Dec 2015

There is no need to copy to clipboard for this, write the information straight to a CSV and have your excel to refresh periodically

EL Collections is what you need

Download and install the .dll and read the word file, takes some learning but worth it

If you get stuck can help you

http://www.multicharts.com/discussion/v ... 319#p48320
Hello OZ Trade

I already use a text ElCollection. At the moment, data are stored in a text file and used to transfer data to Excel using macros. Data are captured using the mouse click and sent to a .txt file. I use to get these info using the Global Variable, but now after installing MC 64, there is an incompatibility between MC and Excel.

My quest was more to be more versatile and be able to create a small study on the fly. By having the data in the clipboard, I could easily create a short study in Excel without having to code all the data capture and the process to store the value in it's appropriate cell.

Clipboard is an utility tool that is in use in many application. I think it would be a nice addon to MC.

Martin

OZ Trade
Posts: 39
Joined: 08 Nov 2013
Has thanked: 11 times
Been thanked: 18 times

Re: Looking for hint: Stroring data in the clipboard

Postby OZ Trade » 19 Dec 2015

Sorry.. misunderstood

Thought this would meet the requirements set out in your post #3

http://www.multicharts.com/discussion/v ... 28#p118623


Return to “MultiCharts”