| Current Members Log-In |  View Your Shopping Cart

Home
Data Products
Publications
Fundamentals
CRB Indexes
B2B Products

CRB Home Page
CRB DataCenter
Final Markets
More ...
CRB PriceCharts
CRB Encyclopedia of Commodity and Financial Charts
CRB Commodity Yearbook
More ...
Crop Production Calendar Maps
Weekly Precipitation Maps (NOAA)
More ...
Index Quotes and Charts
Daily Closing Values
More ...
Publications
Data Products
More ...


 
- CRB PowerSystem™ Software

CSV Format Description

The CSV (Comma Separated Values) format is an ASCII file format. As such, data in a CSV file can be read with a standard text editor.

PowerDist vs PowerGen Created Files
  • PowerDist
    • From Startup or InfoTech CD: Converts .PRO files to .CSV by Symbol
    • From CRB DataCenter: Converts downloaded Daily and Monthly files to .CSV by file
  • PowerGen:
    • From Startup or InfoTech CD: Converts .PRO files to .CSV by Symbol
    • From Local Source: Converts .PRO files to .CSV by Symbol


.CSV File Structure:

Futures and Options

Source Filename Default Location
Futures

Cash

Nearby Futures
SP2005M.CSV

SP----Y.CSV

SPNFVOI.CSV
C:\Program Files\CRB\Data\ASCII\Futures\SP\
(formerly C:\CRB\Text)
Options SP2005M1065P.CSV
(SP1065R5.CSV)
C:\Program Files\CRB\Data\ASCII\Options\SP\
(formerly C:\CRB\Text)

Commitments of Traders

Source Filename Default Location
PowerDist
Startup and InfoTech CD
SP----C.CSV C:\Program Files\CRB\Data\ASCII\COT\SP\
SP----C,20071211,47319,-26457,-20862
SP----C,20071218,11695,-18448,6753
SP----C,20071224,-7222,-8394,15616
SP----C,20071231,-13080,-13296,26376
PowerDist
CRB DataCenter
Daily
FUTALL20071231.CSV C:\Program Files\CRB\Data\ASCII\COT\SP\
AD----C,20071231,-31054,18024,13030
BA----C,20071231,-514,-47,561
BO----C,20071231,-68856,57395,11461
BP----C,20071231,8789,-2809,-5980
C-----C,20071231,-223121,329547,-106426
PowerDist
CRB DataCenter
Monthly
FUTALL200712.CSV C:\Program Files\CRB\Data\ASCII\COT\SP\
AD----C,20071231,-31054,18024,13030
BA----C,20071231,-514,-47,561
BO----C,20071231,-68856,57395,11461
BP----C,20071231,8789,-2809,-5980
C-----C,20071231,-223121,329547,-106426
PowerGen - CD and Local SP----C.CSV C:\Program Files\CRB\Data\ASCII\COT\SP\
AD----C,20071231,-31054,18024,13030
BA----C,20071231,-514,-47,561
BO----C,20071231,-68856,57395,11461
BP----C,20071231,8789,-2809,-5980
C-----C,20071231,-223121,329547,-106426

Volatility

Source Filename Default Location
Volatility SP2005M.CSV C:\Program Files\CRB\Data\ASCII\Volatility\SP\
(formerly C:\CRB\Text)

U.S. Equities (adjusted*)

Source Filename Default Location
Equities (adjusted*) IBM.CSV C:\Program Files\CRB\Data\ASCII\Equities\I\
(formerly C:\CRB\Text)
*The .CSV Equities files are created by PowerGen using the corresponding .STK and .EVT files to adjust for Splits and/or Dividends.

Mutual Funds

Source Filename Default Location
Mutual Funds FGBRX.CSV C:\Program Files\CRB\Data\ASCII\Funds\F\
(formerly C:\CRB\Text)

Previous


Click Help on the Main menu bar for additional assistance. If you have any questions,
please call +1.800.621.5271 or +1.312.554.8456 or email: info@crbtrader.com

Quotes & Charts | About CRB | Contact CRB | Support Pages | Sitemap
Copyright © 1934 - 2017 by Commodity Research Bureau - CRB. All Rights Reserved.
Market data provided by ddf and subject to user agreement and privacy policy.
209 W. Jackson Blvd. • Suite 200 • Chicago, Illinois 60606-6940 • USA
Phone: 800.621.5271 or 312.554.8456 • Fax: 312.939.4135 • Email: info@crbtrader.com
Press Ctrl+D to bookmark this page - Set http://www.crbtrader.com as your Home Page