Inviting experienced developers with experience in VB.NET (or C#) and MS Access to develop a portfolio management software for the Indian stock markets.
+ Knowledge of VB.NET and databases.
+ Knowledge of Indian stock markets, BSE (cash) and NSE (cash, futures and options).
+ Based in India, and accessible via Skype and phone.
+ Robust, error-free and fully documented source code.
A general overview of the requirements is as follows :
+ MDI style UI with menus and tool-bars.
+ Treeview on the left side (Explorer style) that displays Clients and sub-accounts.
+ Context menus wherever applicable.
+ Use data-abstraction so that database can be easily switched from MS Access to MySQL in the future.
+ Use plug-in / framework so that various data-sources can be easily extended. E.g importing contract notes, querying stock prices etc.
Clients and Accounts :
+ Create Clients (uniquely identified by Client Name).
+ Create Trading sub-accounts for each Client (uniquely identified by sub-account name)
+ Create (automatically) a cash account for each trading sub-account. Proceed from sale of shares is credited to cash account, and purchase of shares is debited to the linked cash account. So each trading sub-account has a linked cash account.
+ Ability to transfer money in/out of linked cash account.
+ Ability to add expense / income category. E.g. demat charges, auction charges (loss), auction payment (credit) etc.
Trade Entry :
+ Enter trades in a Client (sub-account) manually, or via importing contract notes from broker. E.g. Buy / Sell, Quantity, Brokerage, STT etc.
+ Recommend using a plug-in architecture for importing contract notes so it is extensible in the future to different brokers.
+ Adjustment for options expiring worthless, or exercised.
Data Synchronizing :
+ Refresh prices from free data-source (NSE, BSE and Yahoo! Finance). Use plug-in architecture for extensibility to different sources.
+ Store prices of stocks in portfolio in database to show daily equity / account value (store daily bhavcopy of BSE and NSE)
+ Store only EOD prices of futures and options in the portfolio to avoid data bloating.
+ Display open positions of each client through reports or in a window.
+ Capital gains report, MTM reports etc.
+ Reports to display total brokerage paid, STT paid etc, and category-wise expense.
+ Reports can be exported to Excel or PDF (use open-source PDF library)
+ This is a single user application, so a single login screen is sufficient.
+ Management features like data-backup and restore.
+ Use open-source components whenever possible e.g. ZedGraph control for charting.
+ Should work for BSE (cash stocks), NSE (cash stocks, futures and options).
+ No need for MCX, commodities, mutual funds etc.
Detailed requirements document will be provided to only to shortlisted candidates. If you have any questions feel free to send me a message.