Using EleXcel, interface to Excel - futures io
futures io futures trading



Using EleXcel, interface to Excel


Discussion in MultiCharts

Updated June 16th 2011 by arjfca
    1. trending_up 2,650 views
    2. thumb_up 3 thanks given
    3. group 2 followers
    1. forum 2 replies
    2. attach_file 0 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Using EleXcel, interface to Excel

(login for full post details)
  #1 (permalink)
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
 
Posts: 263 since Sep 2010
Thanks: 440 given, 91 received

Using EleXcel, interface to Excel

Hello


I'm seeking information to start using EleXcel to interface Multicharts with Excel.

Anyone is using it?

I want to test these function but no luck yet. I,m just turning around...
- Start Excel sheet
- Read a double value from a cell
- Write a double value to a cell
- Read a string from a cell
- Write a string to a cell

Any help truly appreciated

Martin

Reply With Quote

Can you help answer these questions
from other members on futures io?
Convert NinjaTrader NT7 indicator to Tradestation EasyLanguage and RADARSCREEN
Platforms and Indicators
Issue meeting order entry conditions
Elite Automated NinjaTrader Trading
Last 5 minutes Label
ThinkOrSwim
Moving average with Lag reduction
NinjaTrader
Linux?
ThinkOrSwim
 
 
(login for full post details)
  #2 (permalink)
Portland, OR
 
Experience: Intermediate
Platform: Sierra Chart
Trading: ES
 
Posts: 269 since Jan 2011
Thanks: 327 given, 180 received

Martin - I have used this in the past. If I recall - you can't really open the spreadsheet directly but it can read/write to an already open spreadsheet. I would try to find an example code to perform couple of these operations ( have to dig through and also need to make sure they work.

This is a sample code ( compiles fine but haven't tested it completely):

----
Vars:WorkbookName("Test.xls");
Vars:WorksheetName("Sheet1");
Vars:Initialized(false);
Vars:boolXLStarted(false);
Vars:boolWorksheetReady(false);
Vars:boolGetRtn(false);
Vars:boolSetRtn(false);
Vars:var1(0);
Vars:var2(0);
Vars:var3("");
Vars:var4("");
 
 
// Initialization
Once(CurrentBar=1)begin
ifInitialized=falsethen
begin
XLStarted = ELXL_Initialize ;
WorksheetReady=ELXL_WithSheet(WorkbookName,WorksheetName);

ifXLStartedandWorksheetReadythenInitialized=true;
end;
ifInitialized=falsethenraiseruntimeerror("Excel Initialization Failure");
end;
// Main Program
iflastbaronchart_sandbarstatus(1)=2thenbegin
GetRtn=ELXL_GetcellNumberRC(2,1,var1);// Second Row Column 1
SetRtn=ELXL_SetCellNumberRC(2,2,var1);// Second Row Column 2

GetRtn=ELXL_GetCellStringRC(3,1,var3);
SetRtn=ELXL_SetCellStringRC(3,2,var3);
end;
-------

Reply With Quote
The following 3 users say Thank You to ejtrader for this post:
 
(login for full post details)
  #3 (permalink)
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
 
Posts: 263 since Sep 2010
Thanks: 440 given, 91 received


Thanks EJTrader I will look around that.

Martin

Reply With Quote


futures io Trading Community Platforms and Indicators MultiCharts > Using EleXcel, interface to Excel


June 16, 2011


Upcoming Webinars and Events
 

Free BloodHound Licenses for everyone!

June
 

Every journal equals ten meals for the hungry

June
     



Copyright © 2020 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts