Versions Compared

Key

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

...

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

Name of the route, ECN or exchangeShares 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.

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

Note

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

...