Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

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

06/17/2020

All

Date of the quote (you can upload quotes for multiple days in one file).

Symbol

Yes

CHAR(48)

IBM

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 "Wedbush Symbol".

Price

Yes

DECIMAL(18,8)

1.234

All

Closing /settlement price of the security.

If field is left blank, a price will not be posted.

Volume

No

CHAR(10)

55710000

All

Shares or contracts traded that day.

Currency

No

CHAR(3)

USD

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)

1

1.5.94.43.9
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/CUSIPNoCHAR(12)US03783310051.16.1.5.95.28CUSIP or ISIN +International Securities Identification Number (ISIN) associated with the security. Invalid values will be ignored.
CUSIPNoCHAR(9)0378331001.16.1+Committee on Uniform Security Identification Procedures (CUSIP) code associated with the security. All CUSIPs will automatically be converted to ISINs. Invalid values will be Invalid values will be ignored.
SEDOLNoCHAR(7)0540528AllStock Exchange Daily Official List (SEDOL) identifier associated with the security. Invalid values will be ignored.
FIGINoCHAR(12)BBG000BLNNV01.16.1+Financial Instrument Global Identifier (FIGI) associated with the security. Invalid values are ignored.
DescriptionNoCHAR(256)Yahoo! Inc.1.5.94.43.9AllCompany 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 ExchangeNoCHAR(3)NAS1.5.95.28AllThree-letter code indicating where the security is listed. Please use one of the codes on this page.
TapeNoCHAR(1)A1.5.95.28AllUS Equities only. Can be: A, B, C or blank. All other values are ignored.
SubtypeNoCHAR(4)etf1.5.95.28AllFor equities: etf For options: call, put
Underlying SymbolNoCHAR(48)IBM1.5.95.28AllOptions only: ticker symbol of the underlying security.
Strike PriceNoDECIMAL(18,8)1.2341.5.95.28AllOptions only: price at which this option can be exercised.
MaturityNoMM/DD/YYYY07/17/20101.5.95.28AllOptions and bonds only: the maturity date.
CouponNoDECIMAL(14,8)4.251.5.95.28AllBonds only: coupon rate - the amount of interest paid per year expressed as a percentage of the face value of the bond.
SourceNoCHAR(32)Sterling1.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.

Image RemovedImage Added

Step 2: If the Generic source is in the Disabled Sources list, click Enable next to it to update the configuration.

...