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,760 / 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 100,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, 192 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, 192 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 02: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)

September Journal Challenge (sponsored by TopstepTrader)

September

Free Elite Membership: Twitter Tuesday and Facebook Friday!

Tue & Fri
 

Trading with Python: Using Machine Learning w/Ran Aroussi [12:30PM ET]

Elite only

TopstepTrader (TBD)

Sep 25

RandBots (TBD)

Sep 27

Anthony Drager (TBD)

Oct 4
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
possible to convert downloaded historical data to replay format (.ntm) gztanwei NinjaTrader Programming 10 August 23rd, 2012 11:37 PM
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 04:00 AM
software with milliseconds and L2 in data format bidask201 Platforms and Indicators 2 May 13th, 2012 07:10 PM
ideal data format for MC mea109 MultiCharts 3 September 9th, 2011 03:36 AM
What should I have as 'days back' under 'Format Data Series' eone Traders Hideout 5 February 24th, 2010 06:38 AM


All times are GMT -4. The time now is 04:59 AM. (this page content is cached, log in for real-time version)

Copyright © 2018 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 2018-09-19 in 0.11 seconds with 15 queries on phoenix