NexusFi: Find Your Edge


Home Menu

 





To/From CQG using RTD or similar (for Excel, Calc, Numbers ...)


Discussion in Platforms and Indicators

Updated
      Top Posters
    1. looks_one London Trader with 2 posts (0 thanks)
    2. looks_two mattz with 1 posts (0 thanks)
    3. looks_3 xandman with 1 posts (1 thanks)
    4. looks_4 xplorer with 1 posts (0 thanks)
    1. trending_up 2,950 views
    2. thumb_up 1 thanks given
    3. group 3 followers
    1. forum 4 posts
    2. attach_file 0 attachments




 
Search this Thread

To/From CQG using RTD or similar (for Excel, Calc, Numbers ...)

  #1 (permalink)
London Trader
London, UK
 
Posts: 38 since Jul 2015
Thanks Given: 11
Thanks Received: 11

Hi all,

Has anyone succeeded in connecting CQG to a spread sheet (i.e. Excel, Calc, Numbers or other)?

Apparently CQG and Excel both support RTD for connectivity. Has anyone succeeded in using the RTD feature? Does RTD work across machines (i.e. CQG on Windows to/from Excel on Mac)? Does the RTD feature work bi-directionally in real-time? Any thoughts or experiences would be appreciated!

Alternatively, has anyone succeeded in moving data between any trading platform and any spreadsheet?

Thanks!

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Request for MACD with option to use different MAs for fa …
NinjaTrader
Ninja Trader 8 Drawing Tools Wanted
NinjaTrader
NexusFi Journal Challenge - May 2024
Feedback and Announcements
ZombieSqueeze
Platforms and Indicators
Looking for an MQL4 MetaTrader programmer/coder
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
48 thanks
NexusFi site changelog and issues/problem reporting
46 thanks
Battlestations: Show us your trading desks!
34 thanks
GFIs1 1 DAX trade per day journal
32 thanks
Friendly challenge question to vendors
19 thanks

  #2 (permalink)
 xandman 
Chicago IL
 
Experience: Intermediate
Platform: NT CQG TWS
Trading: Futures and FOPs
Posts: 59 since Mar 2014
Thanks Given: 7
Thanks Received: 15

I have used CQG RTD. It is an incredible value. Unfortunately, it was lacking some important historical data that I needed for modeling options. On a positive note, one of the tech support people offered to build me a VBA macro to fix some problems. They have great people. Additionally, you already have some pre-built RTD spreadsheets at CQG.com.

Understand that RTD will not work across machines. It makes use of your existing installation of CQG. Thus, RTD will not work if you are not logged into the CQG client. That's all RTD implementations regardless of vendor/product.

I don't know what you mean by bi-directional. If you mean order management functions, I don't think it has that. It is just data. Possibly with some technical indicators that were calculated on the server side.

The excel reporting is the most diverse and professional that I have ever seen. But, I am a retail trader and most brokers will provide this export functionality via a broker web portal.

Reply With Quote
The following user says Thank You to xandman for this post:
  #3 (permalink)
 
mattz's Avatar
 mattz   is a Vendor
 
Posts: 2,493 since Sep 2010
Thanks Given: 2,440
Thanks Received: 3,789



London Trader View Post
Hi all,

Has anyone succeeded in connecting CQG to a spread sheet (i.e. Excel, Calc, Numbers or other)?

Apparently CQG and Excel both support RTD for connectivity. Has anyone succeeded in using the RTD feature? Does RTD work across machines (i.e. CQG on Windows to/from Excel on Mac)? Does the RTD feature work bi-directionally in real-time? Any thoughts or experiences would be appreciated!

Alternatively, has anyone succeeded in moving data between any trading platform and any spreadsheet?

Thanks!

I believe that amongst the CQG platforms, Q Trader has the ability to have RTD along side your platform.
I think that CQG Trader has this ability as well with a $25 add on.

Matt
Optimus Futures

There is a risk of loss in futures trading. Past performance is not indicative of future results.

Trading futures and options involves substantial risk of loss and is not suitable for all investors. Past performance is not necessarily indicative of future results. You may lose more than your initial investment. All posts are opinions and do not claim to be facts. Please conduct your own due diligence. Use only Risk capital when trading Futures.
1 800 771 6748 local 561 367 8686 email [email protected]
Reply With Quote
  #4 (permalink)
London Trader
London, UK
 
Posts: 38 since Jul 2015
Thanks Given: 11
Thanks Received: 11


xandman View Post
I have used CQG RTD. It is an incredible value. Unfortunately, it was lacking some important historical data that I needed for modeling options. On a positive note, one of the tech support people offered to build me a VBA macro to fix some problems. They have great people. Additionally, you already have some pre-built RTD spreadsheets at CQG.com.

Understand that RTD will not work across machines. It makes use of your existing installation of CQG. Thus, RTD will not work if you are not logged into the CQG client. That's all RTD implementations regardless of vendor/product.

I don't know what you mean by bi-directional. If you mean order management functions, I don't think it has that. It is just data. Possibly with some technical indicators that were calculated on the server side.

The excel reporting is the most diverse and professional that I have ever seen. But, I am a retail trader and most brokers will provide this export functionality via a broker web portal.

Awesome tips, thank you!

Reply With Quote
  #5 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Frequency: Never
Duration: Never
Posts: 5,924 since Sep 2015
Thanks Given: 15,417
Thanks Received: 15,231


xandman View Post
I have used CQG RTD. It is an incredible value. Unfortunately, it was lacking some important historical data that I needed for modeling options. On a positive note, one of the tech support people offered to build me a VBA macro to fix some problems. They have great people. Additionally, you already have some pre-built RTD spreadsheets at CQG.com.

Understand that RTD will not work across machines. It makes use of your existing installation of CQG. Thus, RTD will not work if you are not logged into the CQG client. That's all RTD implementations regardless of vendor/product.

I don't know what you mean by bi-directional. If you mean order management functions, I don't think it has that. It is just data. Possibly with some technical indicators that were calculated on the server side.

The excel reporting is the most diverse and professional that I have ever seen. But, I am a retail trader and most brokers will provide this export functionality via a broker web portal.

Hi London Trader

I second what xandman says: RTD offers lots of functionality. If there is anything specific you need to achieve let me know and I'll see if I can help.

Reply With Quote





Last Updated on December 21, 2015


© 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