NexusFi: Find Your Edge


Home Menu

 





Downloading ASCII Data


Discussion in Brokers

Updated
      Top Posters
    1. looks_one rleplae with 4 posts (0 thanks)
    2. looks_two bluefightingcat with 3 posts (0 thanks)
    3. looks_3 sam028 with 1 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 1,491 views
    2. thumb_up 0 thanks given
    3. group 3 followers
    1. forum 8 posts
    2. attach_file 0 attachments




 
Search this Thread

Downloading ASCII Data

  #1 (permalink)
 bluefightingcat 
Espoo Finland
 
Experience: Intermediate
Platform: TradingBlox, Tradestation
Trading: Stocks
Posts: 41 since Sep 2015
Thanks Given: 2
Thanks Received: 10

Hi,

Anybody aware of a way I can download Futures data into ascii (or excel) with the following data:

D,T,O,H,L,C,V,OI,DM,UC

My current datafeed is IQFeed and they say that they can provide the data. I use Qcollector to use the data from IQfeed to build that data files but I can't figure out how to get the Delivery Month (DM) and Unadjusted Close (UC) into the ascii file.

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
MC PL editor upgrade
MultiCharts
What broker to use for trading palladium futures
Commodities
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Quantum physics & Trading dynamics
The Elite Circle
Trade idea based off three indicators.
Traders Hideout
 
  #3 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863



bluefightingcat View Post
Hi,

Anybody aware of a way I can download Futures data into ascii (or excel) with the following data:

D,T,O,H,L,C,V,OI,DM,UC

My current datafeed is IQFeed and they say that they can provide the data. I use Qcollector to use the data from IQfeed to build that data files but I can't figure out how to get the Delivery Month (DM) and Unadjusted Close (UC) into the ascii file.

To my knowledge, that is not possible in historical

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #4 (permalink)
 bluefightingcat 
Espoo Finland
 
Experience: Intermediate
Platform: TradingBlox, Tradestation
Trading: Stocks
Posts: 41 since Sep 2015
Thanks Given: 2
Thanks Received: 10

IQFeed has this data available. The issue is getting it into a CSV/ASCII file.....

Started this thread Reply With Quote
  #5 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863


bluefightingcat View Post
IQFeed has this data available. The issue is getting it into a CSV/ASCII file.....

Not in the history interface, to my knowledge only in the fundamental/real-time interface.

Do you have a developer license ?
Did you check the fields ?

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #6 (permalink)
 bluefightingcat 
Espoo Finland
 
Experience: Intermediate
Platform: TradingBlox, Tradestation
Trading: Stocks
Posts: 41 since Sep 2015
Thanks Given: 2
Thanks Received: 10

I don't have a developers license. However now that you mention it, you might be right. The expiration date information is only available in the real-time interface.

There might be some sort of solution to this by using DTN.IQ Time and Sales software. If I have understood correctly you can export the data into CSV with the Time and Sales software. However sales support is still closed so not sure whether it can do what I want.

Do you know whether this issue is vendor specific. Could I use eSignals Qlink or something to fix the issue?

Started this thread Reply With Quote
  #7 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863


bluefightingcat View Post
I don't have a developers license. However now that you mention it, you might be right. The expiration date information is only available in the real-time interface.

There might be some sort of solution to this by using DTN.IQ Time and Sales software. If I have understood correctly you can export the data into CSV with the Time and Sales software. However sales support is still closed so not sure whether it can do what I want.

Do you know whether this issue is vendor specific. Could I use eSignals Qlink or something to fix the issue?

The best solution is just to buy a develop license and write your own tool
that interfaces to IQfeed for this type of specific need...

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #8 (permalink)
 
sam028's Avatar
 sam028 
Site Moderator
 
Posts: 3,765 since Jun 2009
Thanks Given: 3,825
Thanks Received: 4,629


rleplae View Post
The best solution is just to buy a develop license and write your own tool
that interfaces to IQfeed for this type of specific need...

Hmm, I don't see how to get these Delivery Month (DM) and Unadjusted Close (UC) with IQFeed protocol, so not sure it will help in this case...

Success requires no deodorant! (Sun Tzu)
Follow me on Twitter Reply With Quote
  #9 (permalink)
 
rleplae's Avatar
 rleplae 
Gits (Hooglede) Belgium
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader, Proprietary,
Broker: Ninjabrokerage/IQfeed + Synthetic datafeed
Trading: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
Posts: 3,003 since Sep 2013
Thanks Given: 2,442
Thanks Received: 5,863


sam028 View Post
Hmm, I don't see how to get these Delivery Month (DM) and Unadjusted Close (UC) with IQFeed protocol, so not sure it will help in this case...

for me this question is about continuous contract, the author forgot to mention

DM you can deduct it doing a differential between the continuous contract and the specif month (the delivery is part of the symbol of the specific month).

UC you take it from the front month

Logic :
- take history in continuous contract
- take history in individual contract
- synchronize the streams and add from the front into the continuous

it's a bit of work, but that's how i would do it...

(@sam028 c'est un peu de bricollage)

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote




Last Updated on January 27, 2017


© 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