|
|
|
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 |
HOW TO OPEN THESE FILES IN EXCEL SHIPPING / TRANSMISSION INFORMATION Data can be ordered to be transmitted via E-mail in attachments, sent via CD, or a combination of both. Downloadable data will be coming soon. 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 1 business day 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 $6.00US, within Canada is $12.00US. Outside the USA and Canada the shipping cost is $15.00US. PRIVACY POLICY Norman's Historical Data does not sell, rent, swap, exchange, or in any other way give out any personal information given to us. This includes E-mail addresses. Norman's does not send out any unsolicited E-mail. Your E-mail address will remain private. We request that you do the same with ours. ORDERING INFORMATION When ordering, PLEASE double check your information. About 1 in 10 orders contains mis-spelled E-mail addresses, and wrong or incomplete credit card numbers. When you order we MUST have the billing address of the credit card you are using. Our credit card processing company uses AVS (Address Verification System) which matches up the billing address on file for the credit card being used with the address you supply. This has been implemented to combat the growing credit card fraud problem. Credit Cards from certain countries will not be processed. Contact Norman's for details. There are two ways you can order: 1. You can use our Secure Shopping Cart. Link buttons are located next to every Historical Data set within this web site. 2. You can order all data by printing out our Mail/Fax Form. If you mail in this form you can order using the credit cards listed above, or use Cashiers Check/Money Order drawn on US Funds, or personal checks (USA only). Data will not be sent until personal check clears. Norman's Historical Data Mailing Address: PO Box
60635 We Accept the following credit cards: Visa, Mastercard, American Express. We Also accept Money Orders drawn on US Dollar funds only. Time Frame: Our standard time frame is Daily data, also called End of Day (EOD) data. Weekly and Monthly data formats are available through our Custom Data Division. We do not offer any time frame shorter than Daily. If you do not see what you want in any of the specially priced data sets within the web site, or if you only need part of a package, or just a few years worth of data, Norman's Custom Data Division would be happy to try and help. Please E-mail us and give us as many specification as possible (exchange, futures name, time period, time format, etc.) Front Month: The trading month that will be expiring next. Example: Using Corn, in February 2004 the front month would be the March 2004 contract as it is the next contract to expire. Once the March 2004 contract expires, the next contract out would become the front month. In this case that would be the May 2004 contract. Front Month, Roll On Volume: A very popular method of rolling data from one contract to the next. When the volume of trades in the next contract out becomes larger than the volume of trades of the current contract, the data rolls to the next contract out. Example: You are following Dec 2001 Corn. When the volume of trades on the Mar 2002 Corn contract (the next contract out) exceeds the volume of trades on the DEC 2001 contract, the data rolls over. Front Month, Roll On Expiration: Another very popular method of rolling data. When the current contract expires, the data rolls to the next contract out. Gann Data: A unique way of rolling data created by legendary trader W. D. Gann. When one contract expires the data rolls to the next contract out in the same contract month. Example: When the DEC 2001 Corn contract expires, the data rolls to the next DEC Corn contract (December 2002). This is done the same way for any commodity. This sometimes causes large gaps in price, but that is the way Mr. Gann did it. End Of Day: EOD data is the prices reported by the exchanges at the end of the trading day. NORMAN'S HISTORICAL DATA GUARANTEE / DISCLAIMERIf, for any reason, you are not satisfied with the data, we will do all we can to please our customers. This would include from a retransmission of data all the way up to issuing a credit for all, or part, of the amount charged towards a future purchase. If you find any discrepancies in the data, we will replace that data with verified, accurate data. Since the data is electronic, we cannot very well take it back. Disclaimer: Yes we have a disclaimer. Even the exchanges have a disclaimer concerning their own data. Although we constantly check our data, we cannot be responsible for changes made by the exchanges after settlement, or mistakes made by the exchanges. The exchanges do send out correction files, but it is possible that data has not been corrected when ordered. Corrections made by exchanges are normally minor adjustments to volume and open interest figures. Rarely do they change price data and when they do the changes are normally quite small. HOW TO OPEN THESE 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. |
Besides the hundreds of private futures traders, researchers, investors etc., that we serve each quarter, we are also supplying, or have supplied, data to clients who work in various businesses around the world. The list below does not necessarily imply these companies endorse Norman's Historical Data™.
|
|
| Main Page | Grains | Livestock | Currencies | Metals | Interest Rates | Indexes | Financials | Softs | Energies | CBOT | CME | KCBT | MGEX | |