TradeLog attempts to lookup and return the closing price for any positions held open at year-end and that need to be marked-to-market.
TradeLog uses industry-provided data for the last market day of the calendar year, typically December 31. This data contains the closing price for over fifteen thousand US-listed equities.
Effective with TradeLog v20.4, the application will return a closing or mark price for approximately 1.5 million US-listed option contracts. Using the following methodology:
The LAST price available if between the BID and ASK. The ASK price is used if LAST is greater than ASK. BID price is used if LAST is less than BID. If the result is zero, TradeLog will return a 0.01 value.
If a ticker or contract cannot be found in available data, TradeLog will return a blank field and the user must enter a closing price in order to continue. We recommend using the December brokerage statement to confirm the closing price for positions.
While TradeLog is able to lookup many positions, please keep in mind the end user is responsible for verifying the accuracy of returned results before continuing with the mark-to-market process.
Limitations and Differences:
- Data used by TradeLog may be rounded to the nearest one hundredth (or one cent), while some brokers may report more decimal places in their closing prices.
- Please beware: if your trade history contains non US-listed tickers it's possible the ticker symbol is the same for a US-listed equity. TradeLog will lookup the US-listed price. Such users should consider renaming the non US-listed tickers by adding an exchange identifier (examples: .TSX .TO .CAD. etc). See Changing Tickers.
Comments
0 comments
Article is closed for comments.