⭐ ptop Posted October 22, 2010 Report Share Posted October 22, 2010 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 :) Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 24, 2010 Report Share Posted October 24, 2010 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 Quote Link to comment Share on other sites More sharing options...
⭐ ptop Posted October 25, 2010 Author Report Share Posted October 25, 2010 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 Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 25, 2010 Report Share Posted October 25, 2010 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 Tiblemont, ⭐ Kardel Sharpeye, ⭐ ptop and 1 other 4 Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 25, 2010 Report Share Posted October 25, 2010 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. Quote Link to comment Share on other sites More sharing options...
⭐ ptop Posted October 26, 2010 Author Report Share Posted October 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 26, 2010 Report Share Posted October 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
⭐ ptop Posted October 26, 2010 Author Report Share Posted October 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 26, 2010 Report Share Posted October 26, 2010 I'll post the excel code as soon as I can ptop bit busy now but will post it later Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 26, 2010 Report Share Posted October 26, 2010 (edited) 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 ⭐ ptop and tradernate 2 Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 26, 2010 Report Share Posted October 26, 2010 ... I assume this technique would work with OpenOffice (hxxp://www.openoffice.org/) if you don't have Excel ⭐ ptop 1 Quote Link to comment Share on other sites More sharing options...
⭐ ptop Posted October 26, 2010 Author Report Share Posted October 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 26, 2010 Report Share Posted October 26, 2010 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 1 Quote Link to comment Share on other sites More sharing options...
⭐ ptop Posted October 26, 2010 Author Report Share Posted October 26, 2010 I can't thank you enough sniffy, works like a charm :) Quote Link to comment Share on other sites More sharing options...
sniffy Posted October 26, 2010 Report Share Posted October 26, 2010 that's great ptop, well done glad to be of help Quote Link to comment Share on other sites More sharing options...
iac2trade Posted November 23, 2010 Report Share Posted November 23, 2010 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.