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



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


Discussion in Platforms and Indicators

Updated by xplorer
      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,026 views
    2. thumb_up 1 thanks given
    3. group 3 followers
    1. forum 4 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)

 
Thread Tools Search this Thread
 

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

  #1 (permalink)
London, UK
 
 
Posts: 38 since Jul 2015
Thanks: 11 given, 11 received

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

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!


Last edited by London Trader; August 5th, 2015 at 05:06 AM.
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
 
Best Threads (Most Thanked)
in the last 7 days on futures io
Spoo-nalysis ES e-mini futures S&P 500
72 thanks
FIO Journal Challenge - June 2020 edition w/SharkIndicators
51 thanks
June Charity Fundraiser - Feeding hungry families
47 thanks
Fixed vs trailing stops
31 thanks
AMP Futures / AMP Global Review
26 thanks
 
  #2 (permalink)
Chicago IL
 
Experience: Intermediate
Platform: NT CQG TWS
Trading: Futures and FOPs
 
Posts: 59 since Mar 2014
Thanks: 7 given, 15 received

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.


Last edited by xandman; August 12th, 2015 at 09:00 PM.
Reply With Quote
The following user says Thank You to xandman for this post:
 
  #3 (permalink)
Boca Raton
 
Experience: Advanced
Platform: Optimus Flow
Broker: Optimus Futures, LLC
Trading: Futures
 
mattz's Avatar
 
Posts: 2,463 since Sep 2010
Thanks: 2,389 given, 3,659 received



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.

PM with any questions about optimusfutures (800) 771-6748 (561) 367 8686. THERE IS A SUBSTANTIAL RISK OF LOSS IN FUTURES TRADING.
Reply With Quote
 
  #4 (permalink)
London, UK
 
 
Posts: 38 since Jul 2015
Thanks: 11 given, 11 received


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)
Super Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 4,985 since Sep 2015
Thanks: 12,507 given, 11,194 received


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



futures io Trading Community Platforms and Indicators > To/From CQG using RTD or similar (for Excel, Calc, Numbers ...)




Upcoming Webinars and Events
 

Free BloodHound Licenses to 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