Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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.

Notes:

  • An instrument file cannot be deleted via the Upload Log. If you need to correct any inaccurate instrument uploads, you must upload a correct instrument file and it will over-write the previous upload.
  • The source of "Manual" must be used to FORCE an update.  Once an instrument is set to "Manual", it will be considered permanent, and will no longer be dynamically updated by differing (non-price) information received from other sources.
  • Though the Price field is required for file format to be recognized, you do NOT need to specify any close prices for the instruments in your file if you wish to preserve the closing prices that already present in your instance.

Sample Data

If creating the file by hand, you can use a text editor or Excel (save the file as .csv). Note that for PropReports to recognize the file format, the spelling of the column headings must be exact. All columns after Price are optional and may be omitted.

The following example shows how to force an update of the ISIN/CUSIP for the symbol AAPL as of date of 2020-09-24.  A price was not entered due to the desire to preserve the closing price already loaded from market data server.  (Download CSV here)

Date,Symbol,Price,ISIN/CUSIP,Source
09/24/2020,AAPL,,US0378331005,Manual

Fields

Name

Mandatory?

Format

Sample Value

Introduced 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", "Nasdaq IP Symbol" or "Bloomberg 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

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.5.95.28CUSIP or ISIN code associated with the security. All CUSIPs will automatically be converted to ISINs. Invalid values will be ignored.
DescriptionNoCHAR(256)Yahoo! Inc.1.5.94.43.9Company 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.28Three-letter code indicating where the security is listed. Please use one of the codes on this page.
TapeNoCHAR(1)A1.5.95.28US Equities only. Can be: A, B, C or blank. All other values are ignored.
SubtypeNoCHAR(4)etf1.5.95.28For equities: etf For options: call, put
Underlying SymbolNoCHAR(48)IBM1.5.95.28Options only: ticker symbol of the underlying security.
Strike PriceNoDECIMAL(18,8)1.2341.5.95.28Options only: price at which this option can be exercised.
MaturityNoMM/DD/YYYY07/17/20101.5.95.28Options and bonds only: the maturity date.
CouponNoDECIMAL(14,8)4.251.5.95.28Bonds 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.50

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.

Enabling the Upload

Before uploading for the first time, you must to make sure the Generic data source is enabled

 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.

Uploading the File

To load the instruments file into PropReports, please follow these instructions.

  • No labels