If you are just looking to override a few of the closing prices or spot rates you can follow instructions on how to manually adjust a closing price. As of PropReports version 1.5.92.28 you can use a comma-separated values (CSV) file to load a large number of quotes into PropReports. Please follow RFC 418 guidelines when creating CSV files. Notably, if you will have field values with commas, the field value must be in quotes.
Sample Data:
If creating by hand, you can use a text editor or Excel (save as csv). For PropReports to recognize the file format, the spelling of the column headings must be exact. All columns after Price are optional.
Date,Symbol,Price,Volume,Currency 06/17/2010,IBM,130.98,5571000,USD
Fields:
Field Name | Mandatory? | Format | Sample Value | Description |
|---|---|---|---|---|
Date | Yes | MM/DD/YYYY | 06/17/2010 | Date of the quote (you can upload quotes for multiple days in one file). |
Symbol | Yes | CHAR(48) | IBM | Ticker symbol of the instrument being quoted. Please follow the PropReports symbol naming convention. If specifying a spot rate, use F/X symbols (e.g. @CADUSD) |
Price | Yes | DECIMAL(18,8) | 1.234 | Closing /settlement price of the security. |
Volume | No | CHAR(10) | 55710000 | Shares or contracts traded that day. |
Currency | No | CHAR(3) | USD | Three-character ISO 4217 code for the currency in which the security is traded. If unspecified, PropReports will default to USD. |
Multiplier | No | DECIMAL(15,4) | 1 | The multiplier (sometimes called "contract size" for options and "value multiplier" for futures) to use when computing profit and loss. If the value is empty or column is omitted, PropReports will default to 1 for equities and futures, and 100 for options. Version 1.5.94.43.9 and greater. |
| Description | No | CHAR(256) | Yahoo! Inc. | Company name or contract description. If a description contains a comma, please remember to enclose the field in quotes (e.g. "Google, Inc."). This value is ignored for options. |
Enabling the Upload
Before uploading for the first time, you must to make sure the Generic data source is enabled
- Click on the 'Upload' menu.
- Click on the 'Sources' sub-menu.
- If the Generic source is in the Disabled Sources list, click Enable next to it.
.png?version=1&modificationDate=1327529075311&cacheVersion=1&api=v2)
Uploading the File
To load the file into PropReports, please follow these instructions (the file type is Instruments).