Multicharts to Excel: Any success - MultiCharts | futures io social day trading
futures io futures trading


Multicharts to Excel: Any success
Updated: Views / Replies:2,057 / 6
Created: by arjfca Attachments:1

Welcome to futures io.

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

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

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

Reply
 
Thread Tools Search this Thread
 

Multicharts to Excel: Any success

  #1 (permalink)
Elite Member
Montreal, Canada
 
Futures Experience: Intermediate
Platform: Multicharts
Broker/Data: Interactive Broker
Favorite Futures: Forex
 
Posts: 262 since Sep 2010
Thanks: 436 given, 86 received

Multicharts to Excel: Any success

Hello

I need to send data from Multicharts to Excel . I was using XLlink from QCL but the software failed after an Mutlicharts update. QCL does not return my mail

Anybody had success to send data to an Excel sheet using another tool? I tried few of dll available on the net but no luck yet

Any help apprecieted

Martin

Reply With Quote
 
  #2 (permalink)
Elite Member
Nicosia, Cyprus
 
Futures Experience: Intermediate
Platform: Multicharts, Tradestation
Broker/Data: Interactive Brokers, MB Trading, Tradestation for data
Favorite Futures: FX, Equities
 
Posts: 39 since Oct 2012
Thanks: 44 given, 39 received

Maybe this is not efficient enough for you, but I am just using easylanguage's Fileappend command.

Andreas

Reply With Quote
The following user says Thank You to moses for this post:
 
  #3 (permalink)
Elite Member
Montreal, Canada
 
Futures Experience: Intermediate
Platform: Multicharts
Broker/Data: Interactive Broker
Favorite Futures: Forex
 
Posts: 262 since Sep 2010
Thanks: 436 given, 86 received



moses View Post
Maybe this is not efficient enough for you, but I am just using easylanguage's Fileappend command.

Andreas

Hello Andreas

I did resolved my problem using Elexcel.dll. Using your solution, Is the data received directly in Excel or you need to code a timed macro to go read the file. I had tough about this solution, but I was not able to get data read by Excel immediatly after being issued by MC


Have a good day

Martin
Montreal, Canada

Reply With Quote
 
  #4 (permalink)
Elite Member
Nicosia, Cyprus
 
Futures Experience: Intermediate
Platform: Multicharts, Tradestation
Broker/Data: Interactive Brokers, MB Trading, Tradestation for data
Favorite Futures: FX, Equities
 
Posts: 39 since Oct 2012
Thanks: 44 given, 39 received

Hi Martin,

Fileappend writes a simple text file, which I then import into Excel without any further adjustments needed (just convert text to collumns, it takes 5 seconds).

I use the portfolio backtester (that does a quick job with the 2000 equities I test), so at the end of the backtest, I have a text file with all the trades performed and some information that I need for analysis (eg the ATR of the stock traded).

For your quick reference, I copy a simple Fileappend line that will print the symbol, the entry date, and my atr14 variable defined previously in my code.

Fileappend ("c:\mytextfile.txt",
symbol + " " +
FormatDate( "dd-MMM-yy", datetojulian(date[entrydate])) + " " +
Numtostr( atr14 , 2) + " " + Newline);

Hope this helps, let me know if there is anything I can help you with.

Andreas

Reply With Quote
The following user says Thank You to moses for this post:
 
  #5 (permalink)
Elite Member
Montreal, Canada
 
Futures Experience: Intermediate
Platform: Multicharts
Broker/Data: Interactive Broker
Favorite Futures: Forex
 
Posts: 262 since Sep 2010
Thanks: 436 given, 86 received


moses View Post
Hi Martin,

Fileappend writes a simple text file, which I then import into Excel without any further adjustments needed (just convert text to collumns, it takes 5 seconds).

I use the portfolio backtester (that does a quick job with the 2000 equities I test), so at the end of the backtest, I have a text file with all the trades performed and some information that I need for analysis (eg the ATR of the stock traded).

For your quick reference, I copy a simple Fileappend line that will print the symbol, the entry date, and my atr14 variable defined previously in my code.

Fileappend ("c:\mytextfile.txt",
symbol + " " +
FormatDate( "dd-MMM-yy", datetojulian(date[entrydate])) + " " +
Numtostr( atr14 , 2) + " " + Newline);

Hope this helps, let me know if there is anything I can help you with.

Andreas

Hello Andreas

Thanks for the line code for file append. I never use it but i do see that it could be useful. For my application, I need data to be sent automatically, without any intervention of me. My initial problem was cause by the dll that I was using to send data to Excel stopped working after an update. I had to rely on an older dll collection to do the job.

My actual system do work like this
- Chart is shown in MC
- MC Code capture OHLC, last pivot High, Low and other data after each bar. This is done for to Instruments on my charts ( 2 set of data)
- This data is converted in a string and send directly to Excel with Elexcel.dll

- In Excel, Each bar data is prepared as a potential entry
- If a bar do respect my entry rule, a macro as been coded and order sent directly to my broker IB

- My Excel sheet allow me to select one of the two Instrument, adjust my stoploss, Entry type "STP", "STP LMT", "LM" MKT"
- Quantity is adjust automatically, depending of my adjustable risk$ and # pip I risk
- Entry are cancelled automatically if not triggered before the end of the bar


I don't key in my entry, all is done via mouse click and send with the same way. I still have to manage order manually, with still cause me some problem. Will code for that later. All macro are coded above the cell. To send order, I press the upperkey + mouse click on the Qty cell

I got many feature that I code, very fancy tool, but my trading result is not in relation with my Excel sheet

Martin

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Reply With Quote
 
  #6 (permalink)
Trading for Fun
London
 
Futures Experience: None
Platform: mc, TS, ninja
Favorite Futures: es
 
Bimi's Avatar
 
Posts: 118 since Mar 2010
Thanks: 42 given, 58 received


arjfca View Post
Hello Andreas

Thanks for the line code for file append. I never use it but i do see that it could be useful. For my application, I need data to be sent automatically, without any intervention of me. My initial problem was cause by the dll that I was using to send data to Excel stopped working after an update. I had to rely on an older dll collection to do the job.

My actual system do work like this
- Chart is shown in MC
- MC Code capture OHLC, last pivot High, Low and other data after each bar. This is done for to Instruments on my charts ( 2 set of data)
- This data is converted in a string and send directly to Excel with Elexcel.dll

- In Excel, Each bar data is prepared as a potential entry
- If a bar do respect my entry rule, a macro as been coded and order sent directly to my broker IB

- My Excel sheet allow me to select one of the two Instrument, adjust my stoploss, Entry type "STP", "STP LMT", "LM" MKT"
- Quantity is adjust automatically, depending of my adjustable risk$ and # pip I risk
- Entry are cancelled automatically if not triggered before the end of the bar


I don't key in my entry, all is done via mouse click and send with the same way. I still have to manage order manually, with still cause me some problem. Will code for that later. All macro are coded above the cell. To send order, I press the upperkey + mouse click on the Qty cell

I got many feature that I code, very fancy tool, but my trading result is not in relation with my Excel sheet

Martin

Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Why do you want to do it on excel is beyond me. You can only get 2 updates per second on excel, which is too slow for trading forex in my opinion. Besides, the further you are away from your broker (ie not direk link), you are introducing room for error. Have you tested your system when the market goes fast? How does it handle data overload? What if the system hangs? What is your back up plan? How do you exit a bad position?

Reply With Quote
The following user says Thank You to Bimi for this post:
 
  #7 (permalink)
Elite Member
Montreal, Canada
 
Futures Experience: Intermediate
Platform: Multicharts
Broker/Data: Interactive Broker
Favorite Futures: Forex
 
Posts: 262 since Sep 2010
Thanks: 436 given, 86 received

Hello Bimi

See my Excel sheet as a switch box only. Only data traded by Excel is from the end of the last bar. Excel do receive the OHLC and some other data like Instrument name, scale etc. Data is not receive LIVE. Once per bar only

Excel is just there to
- Select witch Instrument out of two
- Adjust my position size
- Adjust my $ risk
- Adjust my stop position
- Select what type of entry like Limit, Stop Limit, Market, etc
- Send directly the order on IB and make sure that it reside on IB server not on my PC
- I got a direct lint to my broker, in fact, more direct than with Multicharts. For that, I use TWSLINK2 dll collection.

If I change my stop loss position or entry price, QTY is automatically calculated to respect my $ risk. Entry calculated to the rounded price + - 1 pip. ETC. All I have done is to have all variables calculated instead doing it with a pencil and paper.

Since each bar is a potential entry bar, I got all data ready to manually fire, if and only if, I decide to send order.

This is only a switch box, not a black box. No intelligence is built in, no automatic order sent to broker. All is done using mouse and a finger on the Uppercase key as a security. Data is computed for reference only

With Multicharts, I did not have easily all this flexibility and my stop / entry order was residing on my PC, witch is something that I don't want.

Has a backup system... This is a flaw for the moment. I need to get on a profitable side before spending more money on a backup system ( another complete PC).

Hope it clarify what is my sheet for and goal I have achieved with... flexibility

Martin

Reply With Quote
The following user says Thank You to arjfca for this post:

Reply



futures io > > > > Multicharts to Excel: Any success

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Jigsaw Trading: TBA

Elite only

FuturesTrader71: TBA

Elite only

NinjaTrader: TBA

Jan 18

RandBots: TBA

Jan 23

GFF Brokers & CME Group: Futures & Bitcoin

Elite only

Adam Grimes: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Success and Opportunities wh Psychology and Money Management 9 February 16th, 2016 06:18 PM
MultiCharts Webinar: Peter Campbell - Systematic Trading with MultiCharts MultiCharts MultiCharts 25 August 31st, 2015 09:32 PM
Judging success in your trading DarkPoolTrading Traders Hideout 2 August 6th, 2012 09:22 AM
Key To Success George Psychology and Money Management 1 December 27th, 2009 01:12 AM


All times are GMT -4. The time now is 05:29 AM.

Copyright © 2017 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
Page generated 2017-12-16 in 0.14 seconds with 20 queries on phoenix via your IP 54.160.245.121