Portfolio Management Software for Indian stock markets

This project received 19 bids from talented freelancers with an average bid price of $1875 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
Project Description

Inviting experienced developers with experience in [url removed, login to view] (or C#) and MS Access to develop a portfolio management software for the Indian stock markets.

Developer pre-requisites
+ Knowledge of [url removed, login to view] 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.

Features :

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.

Reporting :
+ 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)

Others :
+ 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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online