Getting Data from an Excel Spreadsheet into a Signal

Questions about MultiCharts and user contributed studies.
titletrading
Posts: 23
Joined: 24 May 2010
Location: USA

Getting Data from an Excel Spreadsheet into a Signal

Postby titletrading » 24 May 2010

I have a strategy signal that requires fixed data (both strings and numbers) from an excel sheet. How can I automatically call up the information in these cells to my signal for calculations? The list is about 70 symbols long and compares the "getsymbolname" command to the returned name from the spreadsheet to determine if the correct row is being used to return other values.

User avatar
Dave Masalov
Posts: 1712
Joined: 16 Apr 2010
Has thanked: 51 times
Been thanked: 485 times

Postby Dave Masalov » 25 May 2010

Dear titletrading,

There is a free library made for this purpose. We can send it to you via e-mail if you want.
Last edited by Dave Masalov on 25 May 2010, edited 1 time in total.

titletrading
Posts: 23
Joined: 24 May 2010
Location: USA

Free Library

Postby titletrading » 25 May 2010

that would be vey helpful, please email that to the address on my acct as soon as possible. Thank you

User avatar
Dave Masalov
Posts: 1712
Joined: 16 Apr 2010
Has thanked: 51 times
Been thanked: 485 times

Postby Dave Masalov » 25 May 2010

Dear titletrading,

Your e-mail address is hidden in your Profile settings. You can send me a letter at dmasalov@multicharts.com, so I can reply you and send you the library.

titletrading
Posts: 23
Joined: 24 May 2010
Location: USA

Error

Postby titletrading » 25 May 2010

Well I was able to get ELXL to compile into my signal but now I get an error that crashes MC whenever I try to use the signal. A previous version without ELXL worked fine. Attached is the error msg.
Attachments
untitled.bmp
untitled.bmp (1.26 MiB) Viewed 185 times

User avatar
Dave Masalov
Posts: 1712
Joined: 16 Apr 2010
Has thanked: 51 times
Been thanked: 485 times

Postby Dave Masalov » 26 May 2010

Dear titletrading,

Could you please come to our Live Chat so we can connect to your PC remotely and localize the problem?


Return to “MultiCharts”