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
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