Getting Data from an Excel Spreadsheet into a Signal
-
- Posts: 23
- Joined: 24 May 2010
- Location: USA
Getting Data from an Excel Spreadsheet into a Signal
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.
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Dear titletrading,
There is a free library made for this purpose. We can send it to you via e-mail if you want.
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.
-
- Posts: 23
- Joined: 24 May 2010
- Location: USA
Free Library
that would be vey helpful, please email that to the address on my acct as soon as possible. Thank you
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
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.
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.
-
- Posts: 23
- Joined: 24 May 2010
- Location: USA
Error
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
- (1.26 MiB) Downloaded 408 times
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times