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 Quick Summary with 1 posts (0 thanks)
    4. looks_4 sam028 with 1 posts (0 thanks)
    1. trending_up 1,470 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?
Build trailing stop for micro index(s)
Psychology and Money Management
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Are there any eval firms that allow you to sink to your …
Traders Hideout
Deepmoney LLM
Elite Quantitative GenAI/LLM
 
  #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