If you would like to manually override any instrument data (as of PropReports version 1.7.84) you can use a comma-separated values (CSV) file. 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.
| Note |
|---|
Notes:
|
...
| No Format |
|---|
Date,Symbol,Price,ISIN/,CUSIP,Source 09/24/2020,AAPL,,US0378331005,037833100,Manual |
Fields
Name | Mandatory? | Format | Sample Value | Introduced Available in Version | Description |
|---|---|---|---|---|---|
Date | Yes | MM/DD/YYYY |
| All | Date of the quote (you can upload quotes for multiple days in one file). |
Symbol | Yes | CHAR(48) |
| All | 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). To specify a ticker in a different format you can name this column "Sterling Symbol," "Reuters Symbol," "Nasdaq IP Symbol," "Bloomberg Symbol" or "Bloomberg Wedbush Symbol". |
Price | Yes | DECIMAL(18,8) |
| All | Closing /settlement price of the security. If field is left blank, a price will not be posted. |
Volume | No | CHAR(10) |
| All | Shares or contracts traded that day. |
Currency | No | CHAR(3) |
| All | 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) |
| All | 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. |
| ISIN/CUSIP | No | CHAR(12) | US0378331005 | 1.16.1.5.95.28CUSIP or ISIN + | International Securities Identification Number (ISIN) associated with the security. Invalid values will be ignored. |
| CUSIP | No | CHAR(9) | 037833100 | 1.16.1+ | Committee on Uniform Security Identification Procedures (CUSIP) code associated with the security. Invalid values will be ignored. All CUSIPs will automatically be converted to ISINs. Invalid values will be |
| SEDOL | No | CHAR(7) | 0540528 | All | Stock Exchange Daily Official List (SEDOL) identifier associated with the security. Invalid values will be ignored. |
| FIGI | No | CHAR(12) | BBG000BLNNV0 | 1.16.1+ | Financial Instrument Global Identifier (FIGI) associated with the security. Invalid values are ignored. |
| Description | No | CHAR(256) | Yahoo! Inc. | 1.5.94.43.9All | 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. |
| Listing Exchange | No | CHAR(3) | NAS | 1.5.95.28All | Three-letter code indicating where the security is listed. Please use one of the codes on this page. |
| Tape | No | CHAR(1) | A | 1.5.95.28All | US Equities only. Can be: A, B, C or blank. All other values are ignored. |
| Subtype | No | CHAR(4) | etf | 1.5.95.28All | For equities: etf For options: call, put |
| Underlying Symbol | No | CHAR(48) | IBM | 1.5.95.28All | Options only: ticker symbol of the underlying security. |
| Strike Price | No | DECIMAL(18,8) | 1.2341.5.95.28 | All | Options only: price at which this option can be exercised. |
| Maturity | No | MM/DD/YYYY | 07/17/2010 | 1.5.95.28All | Options and bonds only: the maturity date. |
| Coupon | No | DECIMAL(14,8) | 4.251. | 5.95.28All | Bonds only: coupon rate - the amount of interest paid per year expressed as a percentage of the face value of the bond. |
| Source | No | CHAR(32) | Sterling | 1.5.95.50All | Source of the data being uploaded (see list of source names). If the column is not present, the source defaults to Generic). Use source of "Manual" to force an update. |
...
Step 1: Navigate to the Upload / Sources page.
Step 2: If the Generic source is in the Disabled Sources list, click Enable next to it to update the configuration.
...