NexusFi: Find Your Edge


Home Menu

 





Multicharts to Excel: Any success


Discussion in MultiCharts

Updated
    1. trending_up 3,593 views
    2. thumb_up 4 thanks given
    3. group 3 followers
    1. forum 6 posts
    2. attach_file 1 attachments




 
Search this Thread

Multicharts to Excel: Any success

  #1 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91

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

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Futures True Range Report
The Elite Circle
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #2 (permalink)
 FastBull32 
 
Posts: 39 since Oct 2012

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

Andreas

Reply With Quote
  #3 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91



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

Started this thread Reply With Quote
  #4 (permalink)
 FastBull32 
 
Posts: 39 since Oct 2012

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
  #5 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91


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


Started this thread Reply With Quote
  #6 (permalink)
Bimi
London
 
Posts: 118 since Mar 2010
Thanks Given: 42
Thanks Received: 58


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


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
  #7 (permalink)
 arjfca 
Montreal, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: Interactive Broker
Trading: Forex
Posts: 263 since Sep 2010
Thanks Given: 440
Thanks Received: 91

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

Started this thread Reply With Quote
Thanked by:




Last Updated on November 15, 2012


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts