Linked Watch Lists and Position Management
A Linked Watch-list or Portfolio is a watch-list/portfolio in the form of a comma separated value (.csv or .txt) file stored on a user’s hard-drive or network drive. The file requires a header row and subsequent rows describing the securities making up the list/portfolio and any of the positions associated with the list/portfolio.
Data set
For a watch list the header row is required along with row for each security. The only data point needed is the symbol.
For a portfolio the header row is necessary along with a row for each portfolio holding consisting of at least the symbol and the quantity of the holding (i.e. number of shares). Additional information can be included of which adds value to the portfolio experience, such as entry price, entry date, etc. The list of available fields is described later in this document.
Header Row
The first row of the .csv file or spreadsheet is the header row. This row helps Market Data understand the data of which is in the file and the order in which it is presented. At the moment the header labels need to follow the Market Data format. A future release will allow the user to map headers to a naming convention that may be specific to the client.
Header Labels and Data Values
|
Symbol |
Required for watch-list and portfolio eSignal Symbol / if client has symbol mapping then client’s symbol |
|
PfShares |
Required for portfolio Quantity of shares or contracts |
|
Long |
Omit when all postions are long, for a mixed portfolio of long and short 0 for long, 1 for short (PfShares field will be updated to handle negative numbers) |
|
Entry Price |
Required for valuations Average Price of position entry |
|
Entry Date |
MM/DD/YY |
|
Entry Commission |
Value |
|
Exit Price |
Closes Position Out Average price of position exit |
|
Exit Date |
MM/YY/DD |
|
Exit Commission |
Value |
|
ValueOfPriceChange |
Needed if using options or other products where valuation is a multiple. Options valuation typically 100, Equity 1, mini Options 10. |
|
UserComment |
Comment Field |
|
reinvestType |
Allows for Dividend Reinvestment Calculation 0 does not reinvest dividends recommended, 1 reinvests dividends not recommended |
|
valueOfInterestAccount |
APR for fixed interest rate for dividends |