Tables
Asset
Represents a product (share, option, certificate, whatever).
Columns
- ISIN
- International Securities Identification Number, 12 digits. More information: Investopedia.
- RefSector
- Foreign key, points to the industry/sector record that characterizes a business.
- Remarks
- Free text, for general purpose use, notes, et cetear.
- WKN
- Wertpapier-Kenn-Nummer. A ID number used in Germany.
Chart
Links an asset to an external chart diagram (or other online resource).
Company
The company characteristics, name, business description, et cetera.
CompanySector
Relates a company to one or more business sectors.
Dividend
Date and amount of profit distributed per share.
Exchange
A stock market exchange.
Fundamental
Company fundamental data at the specified date and time. Link list.
News
Link and time to company news.
Quote
The asset price at a stock exchange at a given point in time.
Related Asset
Links an asset to (somehow) related assets. A perfect means to compare similar assets.
Sector
Business sectors and industries. A tree data structure.
Symbol
An asset, traded under a symbol or ticker name at a specific stock exchange.
Trade
Order submitted to a broker. Tracks success or failure, costs, limits, gain and loss, the rules followed, everything required to analyze the deal. A rating value can be used to rate a trade.
Watchlist
Group of related assets to be monitored.
WatchlistItem
Points to an asset on a watch list.