Stock Portfolio Manager

THE PROGRAMMER MUST HAVE A THOROUGH KNOWLEDGE OF SECURITIES TRADING. ALSO, I WILL NOT ACCEPT ANY BID WITHOUT FIRST HAVING SEEN SAMPLES OF THE PROGRAMMER'S PREVIOUS WORK. SOURCE CODE SHOULD BE WELL DOCUMENTED AND WRITTEN IN VB SO THAT I, OR SOMEONE ELSE, CAN MODIFY IT IN THE FUTURE IF NECESSARY. I want a Stock Portfolio manager that has an intuitive interface with the following features: 1) It will maintain an historical transaction database which can handle both long and short sales of stocks and options and can also handle option assignment and expiration; 2) Manager will retrieve from and display all open positions; 3) Manager will display summary of portfolio value and performance (including charting the total portfolio value or charting the value of the individual securities which make up that portfolio - note this assumes an ability to download historical data); 4) Manager will display transaction detail; 5) Manager will display similar detail for options positions; 6) Manager will permit the entry of related trades, or permit the user to relate trades that are already in the database. Related trades are spreads, straddles, etc; 7) Manager will permit sorting & filtering of data on various fields; 8) Manager will permit "what if" analysis to quickly evaluate potential trades; 9) To the extent feasible, the program should be "modularized" so that features can be optionally turned on or off and so that new features can be added in the future. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. I want a Stock Portfolio manager that has an intuitive interface with the following features: 1) It will maintain an historical transaction database which can handle both long and short sales of stocks and options and can also handle option assignment and expiration; this historical data will also include some computed values such as total transaction costs and, in the case of options, the computed value of the option (based on Black-Scholes or Cox, Ross, Rubenstein) both at the time the position was entered and at the time the position was exited; it will compute the length of time that the position was held (for tax purposes) and produce reports (e.g., all transactions for calendar year, gains/losses, etc) 2) Manager will retrieve from and display all open positions (note that some closing transactions may only close a portion of a position: e.g., puchase 1,000 shares, later sell 500) [this impacts computed cost for the remaining shares or contracts, among other things] 3) Manager will display summary of portfolio value and performance (including charting the total portfolio value or charting the value of the individual securities which make up that portfolio - note this assumes an ability to download historical data); 4) Manager will display transaction detail (for either open or closed positions) including a summary of any position in a security (one position in a security may have been created with several opening transactions) including average cost, unrealized gain/loss (this also implies the ability to download current quotes); it will also display transaction detail for each transaction making up that position in that security; 5) Manager will display similar detail for options positions including also computations of intrinsic and time value; Black-Scholes &/or CRR option values (I have these formulas); 6) Manager will permit the entry of related trades, or permit the user to relate trades that are already in the database. Related trades are spreads, straddles, etc in which multiple related positions are considered to be a single position. In these cases, it is not usually the absolute price of the security that is of interest, but rather the difference in the prices of two related stocks, or the differences in the time and/or intrinsic values of related options; 7) Manager will permit sorting & filtering of data on various fields (account, entry date, expiration date, stock symbol, open straddles, etc; 8) Manager will permit "what if" analysis to quickly evaluate potential trades, e.g., what will my gain/loss be if I close a position at a particular price?; what will be the impact on a particular stock or option position if the price of the (underlying) stock rises or falls to a hypothetical price? What will be the CRR value of two options in a spread position be if the price of the underlying goes to a particular price, etc; 9) To the extent feasible, the program should be "modularized" so that features can be optionally turned on or off and so that new features can be added in the future. ## Platform Windows 2000