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