Project Report On Online Share Trading Simulation

Online Share Trading Simulation

Project Report On

ONLINE SHARE TRADING SIMULATION

Internal Guide Miss Hita M. Joshi

By: Brijesh R. Patel Manish B. Parmar Naresh A. Patel

B. Tech Semester VII Computer Engineering Nov - Dec 2008

Submitted to, Department of Computer Engineering / Information Technology, U. V. Patel College of Engineering Ganpat University, Kherva - 382 711 E-Trade

1

Online Share Trading Simulation

U.V.PATEL COLLEGE OF ENGINEERING

DD/MM/YY

CERTIFICATE TO WHOM SO EVER IT MAY CONCERN This is to certify that Mr/Ms __________________student of B. Tech Semester VII (Information Technology / Computer Engineering) has completed B. Tech Project-1 titled “Title of the project” in the year 20082009.

Project Guide name Sign

E-Trade

Head CE / IT Department 2

Online Share Trading Simulation

Acknowledgement

Engineering curriculum never completes without acquiring project experience along with technical information practiced by others. However in the process of learning it is very difficult task to integrate modular technical information without any proper guidance. Through words I cannot express my feelings but still here I grab this opportunity to express our gratitude to all those informative and supportive pillars who were directly or indirectly involved in the process of completion of my project. Finally, I would like to thank my Head of the Department Prof. Kiran R. Amin for his constant guidance, encouragement and moral support. At the end my grateful thanks go to our institute, which offer us Industrial training in 6th semester to develop our practical skill.

E-Trade

3

Online Share Trading Simulation

Abstract

As we all know that ‘Information is Power’ in this era. And economics, management and finance are the most powerful subjects at any field in this world. In this era of ‘Information Technology’ the world is growing faster and faster. And fast interchange of share dealing makes the person more wealthy. Information provided of proper share price in proper time has too much value. For any busy person who has no time of dealing shares through any firm or intermediate brokers can buy or sell their shares through internet providing better feasibility through any share trading website. So here is presented a better solution for any share market relate person who can see the current share price and buy and sell among any listed companies. So much manual work and time reduced and much paper work can be saved. Any person above 18 can register to the website and deal of any company’s share like buy, sell etc.

E-Trade

4

Online Share Trading Simulation

Index

E-Trade

5

Online Share Trading Simulation

E-Trade

6

Online Share Trading Simulation

Project Profile Project Title

Online Share Trading Simulation

Project Definition

Give the ease to the users for buying and selling of shares through online after registering to the website.

Scope of Project

Project is useful for Commercial Trade.

Organization

E-Trade

Internal Guide

Miss Hita M. Joshi

External Guide

Mr. Hitesh Rajput

Team Size

Three Persons

Developed By

Brijesh R. Patel(05CE27) Manish B. Parmar(05CE26) Naresh A. Patel(05CE37)

Front End

Microsoft Visual Basic .Net 2008

Back End

Microsoft SQL Server 2000

Project Submitted

B S Patel Polytechnic, Kherva

Project Duration

15-April-2008 to 12-july-2008

About Project

E-Trade

7

Online Share Trading Simulation

As we all know that ‘Information is Power’ in this era. And economics, management and finance are the most powerful subjects at any field in this world. In this era of ‘Information Technology’ the world is growing faster and faster. And fast interchange of share dealing makes the person more wealthy. Information provided of proper share price in proper time has too much value. For any busy person who has no time of dealing shares through any firm or intermediate brokers can buy or sell their shares through internet providing better feasibility through any share trading website. So here is presented a better solution for any share market relate person who can see the current share price and buy and sell among any listed companies. So much manual work and time reduced and much paper work can be saved. Any person above 18 can register to the website and deal of any company’s share like buy, sell etc. There are main modules included.  User:  Login  Registration  Buy share  View Portfolio  Sell share  View Company Information  View Company Share Information  View Latest Market NEWS E-Trade

8

Online Share Trading Simulation

 Give Feedback

 Admin:  Register Company  Manage Company Information(Insert/Edit/Delete/Update)  Manage Company Share Price(Edit/Delete/Update)  Manage User Information(Edit/Delete/Update)  Manage market NEWS(Insert/Edit/Delete/Update)

Introduction OVERVIEW OF PROJECT: -We are assigned the task to develop a web application for Online share trading System. -We decide to develop this application using ASP.NET. -We first started with requirement analysis by studying various share sites to get a clear idea about theis application. -Then we devide the complete project in two basic modules: -Administrator E-Trade

9

Online Share Trading Simulation

-User. -Then we started preparing the database according to the requirement analysis. -After finalizing the initial database , we started the design of the application which was followed with omplementation of the functionalities. -We have followed the iterative waterfall model for development of the web application. -Then we have tested the web application under various environmental conditions

SCOPE OF PROJECT: - The Internet and other technologies have opened up innovative new ways to give and maintain, and to communicate and collaborate across boundaries.

This application is able to provide following functionalities: -Basic share trading functionalities such as user can buy share ,sell the share, view the company portfolio etc. and admin can add company, delete company, edit company information, news information, change the company share price etc.. -In module of a user this application facilities like share the company share and viewing transaction. The user can obviously not update any share price information by own.

E-Trade

10

Online Share Trading Simulation

-In this project facilities like edit share price of company by admin. Admin can change the share price of company according by itself. If company share price change that affect the user account. PURPOSE OF PROJECT: -This system has been made up from the scratch, so the problem facing with the other commercial web application has been kept in mind and has been removed. -As it made in ASP.NET technology, consuming application are varing from language. So, programmers have ease of choosing the development language and do not need to worry about the deployment environments. -No need to install on individual system so can be accessed remotely through internet. -Perform vice it is a faster as possible . It does not really consume amount of RAM while running. -Object oriented Architecture along with managed runtime makes this system Robust, Rich, Safe, Faster and Reliable.

E-Trade

11

Online Share Trading Simulation

Feasibility Analysis 1 .Technical feasibility: Share trading is one of the fast growing sites.  It is easy to use.

 Available through internet.  Any One can use no need technology knowledge.. 2 Time schedule feasibility:- To develop the project according the time schedule. - First do requirement specification and analysis. - Then create database of project. - After that create design of project, then coding. - Then, last testing of the final project. 3 Operational feasibility: Removes manual work.  No chance for manual error because Data (result) is directly fetch from result file.  No extra programming or other skills are required  Reduce Paper Work  Faster Work  Reduce Repetition of Work by saving quick notes

E-Trade

12

Online Share Trading Simulation

 Data can be fetching from Excel File, so existing data if any can be also used.

4 Implementation feasibility:-

5 Economic feasibility  To get company share price directly from internet .  To earn more money using this type of websites through internet.  There is no need of special training to use this software.

 No extra hardware cost..

E-Trade

13

Online Share Trading Simulation

E-Trade

14

Online Share Trading Simulation

Basic Hardware and Software Requirements

End-User Browser Configuration:

Browser

Windows Operating System 2000 XP

Microsoft Internet   Explorer 6.0  Netscape 7.1   Mozilla FireFox 1.0.x  Key  Fully tested and supported Configurations have not been fully tested but  should function properly. System Requirements for Installing Visual Studio Express 2008*

Processor

Operating System

E-Trade

Minimum: • 600 megahertz (MHz) Pentium processor Recommended: • 1 gigahertz (GHz) Pentium processor Visual Studio Express can be installed on any of the following systems: • Microsoft® Windows® 2000 Professional SP4 • Microsoft® Windows® 2000 Server SP4 • Microsoft® Windows® 2000 Advanced Server SP4 • Microsoft® Windows® 2000 Datacenter Server SP4 • Microsoft® Windows® XP Professional x64 Edition (WOW) • Microsoft® Windows® XP Professional SP2 • Microsoft® Windows® XP Home Edition SP2 • Microsoft® Windows® XP Media Center Edition 2002 SP2 • Microsoft® Windows® XP Media Center Edition 15

Online Share Trading Simulation

RAM

Hard Disk Display

2004 SP2 • Microsoft® Windows® XP Media Center Edition 2005 • Microsoft® Windows Server™ 2003, Standard Edition SP1 • Microsoft® Windows Server™ 2003, Enterprise Edition SP1 • Microsoft® Windows Server™ 2003, Datacenter Edition SP1 • Microsoft® Windows Server™ 2003, Web Edition SP1 Installation of Visual Studio 2005 on the Intel Itanium (IA64) is not supported. Minimum: • 192 megabytes (MB) Recommended: • 256 MB Up to 1.3 GB of available space may be required Minimum: • 800 x 600 256 colors Recommended: • 1024 x 768 High Color — 16-bit

About Microsoft Visual C# .Net 2008 Visual C#.NET is the most recent generation of Visual C#. Developers will be pleased to note that its new features include inheritance, method overloading, structured exception handling, and more. These capabilities make it easier than ever to create .NET applications, including Windows applications, web services, and web applications. The articles in this section give you all the tips you need to work wit this useful language. As a medium of communication, blogs have their strengths and weaknesses. The informal nature of the communication makes it incredibly easy to communicate information on an ongoing basis. The down side, of course, is that the very informality of blogs can also trip you up if you don't E-Trade

16

Online Share Trading Simulation

pay enough attention to follow up. I've certainly been guilty of that on this blog (there are still some loose ends I think haven't really been tied up), and we've been guilty of that as a team. One thing we haven't always done a good job of is keeping people apprised of feature decisions that we've made as the VC# 2008 product cycle has progressed. As a result, there has been some confusion as to what features are in and which features are out of the product. So let me start by giving a reasonably concise list of the feature set for VC# 2008...

 General Features  Friend assemblies. We now pay attention to the Internals Visible to attribute.  Relaxed delegates. As long as there is a way to map one delegate's parameters to another, you can now convert freely between delegate types. (I'd wanted to see this extended into full delegate currying, but that will have to wait for a future release.)  Runtime agility. The ability to compile without a VC# runtime, or targeting another VC# runtime.  Calling Object members on interfaces. Minor feature, but useful in some situations.  Improved generic type inferencing. In VC# 2005, we would not infer a type for a type parameter that had multiple inferred types (i.e. a parameter T matched two arguments typed as Integer and Long). In VC# 2008, we will now pick the wider of the two types. (Actually, it's E-Trade

17

Online Share Trading Simulation

more complex than this, but you get the idea.)

 LINQ  Local variable type inferencing.  Anonymous types.  Extension methods.  Nullable types.  Query expressions. This is the From...Where...Select... expression.  Object initializers. For VC# 2008, we will only support initializing read-write fields of non-collection objects (more on this further down).  Expression trees.  Lambda expressions. For VC# 2008, we will only support expressions in lambdas, not statements.  Partial methods.

 XML  XML literals.  XML members.  XML namespaces.

E-Trade

18

Online Share Trading Simulation

I think most everything on this list has so far been discussed, with the exception of the omissions from object initializes. Our original plans, going back to PDC05, included several more features for object initializes, such as being able to write to read-only properties, as well as collection and array initializes. In the end, the schedule for VS 2008 was not sufficient to implement these features with a high degree of confidence which unfortunately means that they will have to wait to a release beyond VC# 2008.

E-Trade

19

Online Share Trading Simulation

About Microsoft SQL Server 2005 Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we'll cover six of the more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and Books Online. Let's take a brief look at each: Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases. Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. It's a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications, create/modify stored procedures and execute administrative tasks. SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It's a great tool for optimizing databases with performance issues or troubleshooting particular problems. Service Manager E-Trade

20

Online Share Trading Simulation

is used to control the MS SQL Server (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQL Server Agent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services. Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group. Books Online is an often overlooked resource provided with SQL Server that contains answers to a variety of administrative, development and installation issues. It's a great resource to consult before turning to the Internet or technical support.

E-Trade

21

Online Share Trading Simulation

E-Trade

22

Online Share Trading Simulation

Use Case

In the early stages of a development project, use case diagrams describe real-world activities and motivations. You can refine the diagrams in later stages to reflect user interface and design details.

E-Trade

23

Online Share Trading Simulation

E-Trade

24

Online Share Trading Simulation

Data Flow Diagram

Introduction One of tools of structuring analysis is the Data Flow Diagram. A Data Flow Diagram is a Graphical representation of the proposed system. Data Flow Diagram serves two purposes: Provide a graphical tool, which can be used by the analyst to explain his understanding of the system to the user. Can be readily converted into a structure Chart , which is used in design.

Data flow diagram Elements A Data flow diagram needs to be simple because a user has to go through it, understand it, and suggest correction and changes. A Data Flow Diagram uses only four elements. These four elements are: External entities Process Data Flow Data Store.

External Entities An external entity is a source and/or destination of data, for the system under consideration. As the name suggest, it lies outside the contexts of system. It is represented by a solid square.

Process E-Trade

25

Online Share Trading Simulation

A process represents some amount of work being performed on data. A process does ant transformation of data from one from to another.

Data Flow Data flow represents the path of data as it flows through a system. An arrow represents it, the arrowhead points in the direction in which data moves. The name of data flow is written along the line.

Data Store If there is a logical requirement for the data to be stored, it is held in the data store. A data store, therefore, is a repository of data. It is represented by an open edged rectangle. A number and a name identify each data like a process.

Context Level DFD

E-Trade

26

Online Share Trading Simulation

First Level DFD DF

E-Trade

27

Online Share Trading Simulation

SECOND LEVEL DFD

E-Trade

28

Online Share Trading Simulation

E-R Diagram E-Trade

29

Online Share Trading Simulation

E-Trade

30

Online Share Trading Simulation

Data Dictionary

ADMIN Sr No

Field

1 2 3

id admin password

Data Type Int nvarchar nvarchar

Size

Fk/Pk

4 50 50

Required Reference Table No No No

Company_info Sr No

Field

Data Type Size

Fk/Pk

Required Reference Table

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

company_id Company_name industry House Incorporation_year chairman Director Secratory Auditor Face_value Office_address City Country Email Website Office_telephone

Int Nvarchar Nvarchar Nvarchar Int Nvarchar Nvarchar Nvarchar Nvarchar Money Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar Varchar

Pk

Yes Yes No No Yes Yes Yes No No Yes Yes No No No No Yes

E-Trade

4 200 50 50 4 50 50 50 50 1000 30 30 200 200 50

31

Online Share Trading Simulation

Company_share Sr No

Field

Data Type Company_id Int Price Money Last_price Money Change Float Change_perce Float Min Money Max Money Today_change money

1 2 3 4 5 6 7 8

Size

Fk/Pk

Required

4

Pk

Yes Yes No No No No No Yes

Fk/Pk

Required

8 8

Reference Table

Feedback Sr No

Field

Data Size Type User_name Varchar 50 Date Datetime comment nvarchar 4000

1 2 3

Reference Table

No No No

NEWS Sr No 1 2 3 4

Field News_id date Subject body

Data Type int datetime Nvarchar Nvarchar

Size 4 8 50 4000

Fk/Pk Required Reference Table Pk Yes No No No

User_info Sr No

field

1 2

User_id Datetime

E-Trade

Data Size Type Int 4 Datetime 8

Fk/Pk

Required

Pk

Yes Yes

Reference Table

32

Online Share Trading Simulation

3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

First_name Last_name Birth_date Gender Address City State Pin_code Mobile_no Emailid User_name Password Question Answer User_amount

Nvarchar Nvarchar Datetime Nchar Nvarchar Nvarchar Nchar Int Varchar Nvarchar Nvarchar Nvarchar Nvarchar Nvarchar money

50 50 8 10 500 50 10 4 50 300 50 50 200 200

Yes Yes No Yes No No No No No Yes Yes Yes No No Yes

User_share Sr No

Field

1 2 3 4 5 6

Trans_id User_name Company_id Quantity Price total

E-Trade

Data Type int nvarchar Int Int Money money

Size

Fk/Pk

4 50 4 4

Pk Fk1

Required Reference Table Yes Yes user_Info Yes No No No

33

Online Share Trading Simulation

E-Trade

34

Online Share Trading Simulation

E-Trade

35

Online Share Trading Simulation

Here this kind of a system is in the developing phase and lots of future enhancements are planned and are under going 1 st level analysis. This application can be expanded with many new other building schemes and areas. Due to the time constraint we were not able to provide various enhancements such as: This is a Reference Modal of share trading Application for Education Institute. You can add following Futures.

-Change the share price directly through internet. -Login only those user their have account in any bank system. -Admin can put various advertisements. E-Trade

36

Online Share Trading Simulation

-If share price increase than display green color and if share price decrease than display red color.

 Conclusion After the completion of our project we conclude that, this system can be really helpful to various sensex for their day to day transactions and share management. Less time and effort is required to maintain and use this kind of system. This type of system is more useful for earn more money in less time. Thus these system should be used and implemented by sensex to give more reliable service to user. E-Trade

37

Online Share Trading Simulation

E-Trade

38

Online Share Trading Simulation

For the successful working of my project we have referred many sources for the code snippets, logics and tips n tricks form the various books as well as web sites. Most I searched for the required possessions on the google.com search engine. Many of the logics in my projects are used from the free code listed on the web pages. Books Referred 

The Complete Reference VB.Net by Jeffery R. Shapiro



Black Book in VB.Net



Used MSDN

Websites Referred E-Trade

39

Online Share Trading Simulation

E-Trade



www.msdn.microsoft.com



www.google.com



www.codeguru.com



www.saicare.com



www.tutorial.com



www.functionx.com

40