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 xandman with 1 posts (1 thanks)
    3. looks_3 xplorer with 1 posts (0 thanks)
    4. looks_4 mattz with 1 posts (0 thanks)
    1. trending_up 2,987 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?
MC PL editor upgrade
MultiCharts
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
What broker to use for trading palladium futures
Commodities
Trade idea based off three indicators.
Traders Hideout
Cheap historycal L1 data for stocks
Stocks and ETFs
 
  #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
Thanked by:
  #3 (permalink)
 
mattz's Avatar
 mattz   is a Vendor
 
Posts: 2,493 since Sep 2010
Thanks Given: 2,441
Thanks Received: 3,791



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]
Follow me on Twitter Visit my NexusFi Trade Journal 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
Posts: 5,980 since Sep 2015
Thanks Given: 15,506
Thanks Received: 15,422


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