|
|
|
Commodity Futures Historical DataNormans Historical Data Main Page cbot chicago board of trade quotes cme chicago mercantile exchange historical data comex new york comex exchange historical data csce coffee sugar and cocoa exchange historical data currency data forex fx historical data interest rates historical data kcbt kansas city board of trade historical data wce winnipeg commodity exchange historical data Commodity Historical Data, Stockmarket Quotes, Historical Futures Data, Forex Historical Data, Cash Prices, Globex Futures Quotes, WD Gann Data and More |
HISTORICAL DATA SPECIFICATIONS: Our data currently covers most North American Commodities exchanges. Some exchanges covered are: Chicago Board of Trade (CBOT), Chicago Mercantile Exchange (CME), Commodity Exchange of New York (COMEX), Coffee, Sugar and Cocoa Exchange (CSCE), New York Mercantile Exchange (NYMEX), New York Board of Trade (NYBOT), Kansas City Board of Trade (KCBT), Minneapolis Grain Exchange (MGEX), Winnipeg Commodity Exchange (WCE), New York Cotton Exchange (NYCE) and more. (Sorry, no individual stock data, no options data). All data is daily data, also called End Of Day (EOD). We have no shorter time frames. All data is in plain text (ASCII), comma delimited. This format is easily imported into most spreadsheet (Excel, QuattroPro, etc.) and charting programs. You will find data samples throughout this web site. Some data packages also contain Roll on Volume Data, Roll on Expiration Data, Gann formatted data. Weekly and Monthly data, are available by special order through our Custom Data Division. If you have special requests, please contact our Custom Data Division. WHAT THE DATA INCLUDES: Data usually includes the Open, High, Low, Close. Cash/Spot data varies according to exchange. Most data will also include Volume & Open Interest figures. You will find data examples throughout the web site. Every page that shows a historical data package will also show an example of that data for your to look at, copy, test, etc. Our data is normally updated through the end of the previous trading week. HOW THE DATA IS SENT: Data can be ordered to be transmitted via E-mail in attachments, sent via CD, or a combination of both. When transmitting the data, historical data will be zipped (compressed) and put into attachments unless otherwise instructed. Be sure your E-mail server is set to allow attachments of 100 - 500K and allows multiple E-mail from one source. Some do not, particularly many of the free services (Hotmail, Yahoo, Google) and AOL. Spam blockers and virus protection programs can also interfere with transmission. Transmission of data normally occurs within 24 hours of order confirmation, but please allow up to 48 hours. Credit cards are not charges until the order is ready to transmit. If sending the data via CD, we ship via US Postal Service. The shipping cost to addresses within the USA is $5.00, to addresses within Canada is $8.00US and all other areas outside the USA the shipping cost is $12.00US. |
HOW TO OPEN PLAIN TEXT, COMMA DELIMITED FILES IN EXCEL First, do not copy and paste the data into Excel. You will only get one column. You must tell Excel to open the files. To do this: 1. Open your Excel program. 2. Go to File>Open 3. Find the file you wish to open. You may need to tell Excel
to look at all file types, not just Excel formatted files.
To do this, look at the bottom of the 'Open' box. You should
see a drop down menu called:
'Files of type:'. 4. Choose the file you wish to open. When you choose the file the Text Import Wizard box should open. Under 'Original Data Type' choose Delimited. 5. In the second step , under 'Delimiters' make sure the only checkbox chosen is Comma. These files are all comma delimited. 6. For the third and final step, under 'File data format' choose 'General'. 7. Choose 'Finish'. Your data should now open in Excel and be in the proper columns. Once you are done with the files, if you wish to re-save the file, decide what format to save the files in. There are a number of format options you can choose when saving. |
|
| Main Page | Grains | Livestock | Currencies | Metals | Interest Rates | Indexes | Financials | Softs | Energies | CBOT | CME | KCBT | MGEX | |