Jump to content

NT + Zenfire Historical Data


ptop

Recommended Posts

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 :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by sniffy
Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...