Data converter from a format to another format - Platforms and Indicators | futures io social day trading
futures io futures trading


Data converter from a format to another format
Updated: Views / Replies:4,281 / 22
Created: by Nicolas11 Attachments:9

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

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

Reply
 9  
 
Thread Tools Search this Thread
 

Data converter from a format to another format

  #21 (permalink)
Patient Discipline
Bellingham, WA USA
 
Futures Experience: Beginner
Platform: NT
Broker/Data: Mirus (Broker), Continuum (Data), Dorman (Clearing)
Favorite Futures: Futures
 
aventeren's Avatar
 
Posts: 202 since Mar 2013
Thanks: 426 given, 191 received


Nicolas11 View Post
@aventeren ,

Could you test the following?

I propose to use a Windows batch file to apply the jar to the various .txt files of the directory.

1. In the directory of your CL .txt files, make sure that there is :
- no "input.txt"
- no "output.txt"
- no ConvertedFiles sub-directory

2. In the directory of your CL .txt files, copy the jar file

3. Copy/paste the code below into NotePad (or similar) and save it in the CL .txt folder under the name "convert.bat" (no .txt suffix)

4. At this stage, your directory should like:
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


5. Launch the batch console from the Window "Accessories" Menu.
Navigate to the above-mentioned directory with "cd"
Type "convert"
It should launch the process, ending with something like:
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).


The ConvertedFiles sub-directory should contain the output files.

Nicolas

 
Code
@echo OFF

rem | Batch Conversion
rem | v1
rem | September 5th, 2013
rem | by Nicolas11 @ futures.io (formerly BMT)

echo Batch conversion (v1)
echo ---------------------

if exist ConvertedFiles (
	echo ERROR: Directory ConvertedFiles already exist
	goto End
)

if exist "input.txt" (
	echo ERROR: input.txt already exits
	goto End
)

if exist "output.txt" (
	echo ERROR: output.txt already exits
	goto End
)

echo Creation of ConvertFiles directory
mkdir ConvertedFiles

for /f "delims=" %%a in ('dir /b *.txt') do (
	echo Conversion of %%a
	rename "%%a" "input.txt"
	DataConverter_for_BigMike_req02_v01.jar
	move "output.txt" "ConvertedFiles\%%a" > del123.tmp
	rename "input.txt" "%%a"
)

del del123.tmp

:End
echo End.

I just got back from my wife's 39 week pregnancy check (all is well).

I'll run this now and report back.

Thanks!

Reply With Quote
 
  #22 (permalink)
Patient Discipline
Bellingham, WA USA
 
Futures Experience: Beginner
Platform: NT
Broker/Data: Mirus (Broker), Continuum (Data), Dorman (Clearing)
Favorite Futures: Futures
 
aventeren's Avatar
 
Posts: 202 since Mar 2013
Thanks: 426 given, 191 received


Nicolas11 View Post
@aventeren ,

Could you test the following?

Well I'm be damned, the batch file approach worked. It took me less than 5 minutes to convert all of the files and then import them to NT7 as tick data. WELL DONE @Nicolas11!!!!

Okay, now for my end. I'll start converting the data and posting it on the CL Historical Tick Data post: https://futures.io/elite-circle/3381-historical-cl-crude-oil-futures-contract-tick-data-minute-data.html--and I'll make sure to post up my file locations by month in the Summary tab for easy reference.

At this point I am laser focused on the CL, but I may expand to the ES, etc in the future, at which point I will find a similar home for the converted data.

In all seriousness, I really appreciate your time and effort on the quick turnaround from the other side of the world. It's experiences like these that make futures.io (formerly BMT) so amazing. Thanks.

Okay, I'm off.

Reply With Quote
The following 2 users say Thank You to aventeren for this post:
 
  #23 (permalink)
Elite Member
London
 
Futures Experience: Beginner
Platform: NinjaTrader
Favorite Futures: TF
 
Posts: 2 since Jun 2014
Thanks: 5 given, 1 received


Hi folks / Nicolas -

There appeared to be changes to the QCollector format from March 2013 (from a slash to a dash for date separation with the year reversed in March and again in June 2013 where time then has three further digits). As a result Nicolas' converter Request02 doesn't recognise the format. Is there a chance of a version that could convert the newly exported format(s)? (Or alternatively does anyone have NT7 last tick data for TF, ES, 6E, CL & YM) from March 2013 - Feb end 2014?.... Thanks and greatly appreciate your effort.

Darren

PS. in the meantime I'll try and hack / re-compile Nicolas' original source code and will upload if I get it to work


Last edited by darrentate; March 30th, 2015 at 03:59 PM.
Reply With Quote

Reply



futures io > > > Data converter from a format to another format

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
possible to convert downloaded historical data to replay format (.ntm) gztanwei NinjaTrader Programming 10 August 24th, 2012 12:37 AM
here's way to convert tick data from NT to comma-separated format, with Mac or Linux theorist Platforms and Indicators 1 July 1st, 2012 05:00 AM
software with milliseconds and L2 in data format bidask201 Platforms and Indicators 2 May 13th, 2012 08:10 PM
ideal data format for MC mea109 MultiCharts 3 September 9th, 2011 04:36 AM
What should I have as 'days back' under 'Format Data Series' eone Traders Hideout 5 February 24th, 2010 07:38 AM


All times are GMT -4. The time now is 09:43 PM.

Copyright © 2017 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
Page generated 2017-12-12 in 0.09 seconds with 20 queries on phoenix via your IP 54.221.93.187