NT + Zenfire Historical Data

[⭐ ptop]

Does anyone here have historical data for futures that they can share as Zenfire does not have historical data and as I can't connect to NT server with cracked NT, I don't get the historical data I need. I don't know if disktrading historical data is on here, can't seen to find it.

 

Thanks in Advance :)

[sniffy]

  ptop said:

Does anyone here have historical data for futures that they can share as Zenfire does not have historical data and as I can't connect to NT server with cracked NT, I don't get the historical data I need. I don't know if disktrading historical data is on here, can't seen to find it.

 

Thanks in Advance :)

 

Obviously, I don't know exactly what you want but this website seems to give ten years worth of daily data for various instruments including some futures. I have never used it but I hope it helps.

 

http://www.tradingblox.com/tradingblox/free-historical-data.htm

[⭐ ptop]

Thanks sniffy, that is something like what i need but in wrong format, it is seperated with a "," instead of a ";" and it does not have all the instruments I trade, I thought maybe someone who uses tradestation or has data from disktrading or the like would be willing to share as it seems alot of us use NT with zenfire.

 

thanks again

[sniffy]

Specific Data Download

 

ah well ... good try.

 

Maybe ask for a specific instrument, timeframe and format and someone with tradestation might be kind enough to upload it to 4shared or similar site.

 

If this takes off perhaps Kardel would make it a sticky post as others might find this helpful too.

 

Anyways, here is another site that might help. Good luck!

 

http://pitrading.com/free_market_data.htm

[sniffy]

P.S. ptop

 

You can use NotePad in Windows to replace a "," by a ";" or whatever you want if you have the data as a .txt file or something that could be opened by Notepad. No doubt other editors will do something similar.

[⭐ ptop]

Thanks sniffy, I have been trying to change the date format and eliminating the data that I don't need, but at this rate it will take forever lol, the format that I need it in is with the ";" separator I put a sample below.

 

The contracts I am looking for right now are CL, TF, GC, YM, ES, and the futures currencies if anyone has these or can export the last 10 years in this format I would greatly appreciate it.

 

Daily Bars Format

 

Each bar must be on its own line and fields must be separated by semicolon (;). Only 1 day bars can be imported.

 

 

The format is:

 

yyyyMMdd;open price;high price;low price;close price;volume

 

 

Sample data:

 

20061023;1377.25;1377.25;1377.25;1377.25;86

 

20061024;1377.25;1377.25;1377.25;1377.25;27

 

20061025;1377.25;1377.25;1377.25;1377.25;24

 

20061026;1377.50;1377.50;1377.25;1377.25;82

[sniffy]

Try This Ptop

 

I see what you want ptop. In theory I think this is relatively straightforward using the data from http://pitrading.com/free_market_data.htm and Excel.

 

I have tried a sample using the downloaded ES file.

 

Here is the 4shared link for the ES file, hopefully in the format you want. Have a look at it, if it's correct/what you want, let me know and I will post the Excel instructions.

 

Here's the link ...

 

http://www.4shared.com/document/Mmw-3o2N/TransformedES.html

 

good luck

[⭐ ptop]

sniffy that worked perfect, thanks so much, how did you do that i have been racking my brains out trying to figure it out.

 

Thanks Again

[sniffy]

I'll post the excel code as soon as I can ptop

 

bit busy now but will post it later

[sniffy]

Here is what I did ...

 

1. Download the appropriate file from Pitrading - should give you a *.TXT file

2. Open with EXCEL - this should open the TEXT IMPORT WIZARD

3. Choose "delimited" and "Start import at row " 2 (don't import the column headers), press Next

4. Step 2, select "comma" delimiters (you should now see 7 columns neatly setup), press Next

5. Step 3, Column 1 select as "Text"

Column 2-6 select as "General"

Column 7 select as "do not import" (skip the open interest), press Finish

 

You should now see Columns A-F populated in Excel

 

6. Inside Excel now, In Row 1, Column H (for example). put the following Excel instruction

 

=CONCATENATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,4,2),";",B1,";",C1,";",D1,";",E1,";",F1)

 

(for some reason the forum makes it look like there is a space after the first semi-colon but in reality there isn't, each semi-colon is entered as ";" without any space)

 

7. Now copy H1 vertically down to the end of the data, you should see column H populated

with your heart's desire

8. Now highlight column H and copy that, open a new blank spreadsheet and paste that stuff into column A using "paste Special" and select "Values"

9. Now save the new spreadsheet using "Save As " and "Other Formats" and select "Save as Type" Text(Tab Delimited)(*.txt)

10. Hopefully Bob's your uncle and you have a .txt file in the format that you need

 

I hope I wrote these instructions correctly - but let me know if I made any errors.

 

Good luck!

Edited October 28, 2010 by sniffy

[sniffy]

... I assume this technique would work with OpenOffice (hxxp://www.openoffice.org/) if you don't have Excel

[⭐ ptop]

works perfect except when i saved text(tab delimited)I get a space after date;

20011025; 466.8;474.5;466.8;474.5;694

20011026; 485.8;485.8;475.5;477;643

20011029; 476.6;478.2;471.8;472.4;582

20011030; 476.6;476.6;458.9;464.4;604

 

How do I change so no space.

 

Thanks so much

[sniffy]

see my updated comment in the instructions ptop, it's the forum that has added the space for some reason, just use ";" for each semi-colon

[⭐ ptop]

I can't thank you enough sniffy, works like a charm :)

[sniffy]

that's great ptop, well done

 

glad to be of help

[iac2trade]

Much appreciated sniffy! Thanks for the support, your instructions to this task was right in the money.

 

"High five" to ptop for bringing this Tread to the table! Thanks guys

 

kudos