• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

An I.T. System to Track Share Prices

Extracts from this document...

Introduction

Objective My dad has asked me to create an Excel Spreadsheet, which will track his share prices, as currently the quotes are only being recorded on paper, making it extremely difficult to plot graphs etc and manage it efficiently. However hopefully I will overcome this problem and allow easy automatic calculations through MS Excel. Also my user is not certain when to sell and buy shares so I will make an automated process in which my spreadsheet will decide when to take action by informing the user. Hyperlinks will be used to take the user to news on shares etc, to help make decisions on whether to buy and sell. A yearly graph on the company's shares will be present with the visual basic program, which will be updated automatically. My user is new to MS Excel, so I will need to make it as automatic as possible. Formulae What it will help me do briefly Sum Add up specific numbers. Average Calculate average. Hyperlink Link to sites, workbooks etc. Rand Create data to work from. Product Multiply cells. Vlookup Compare values in a lookup table. Round Round a number to specified decimal place. If If... Then... Else Graphs Plot share prices etc What Software am I Going To Use? I am going to use Microsoft Excel for a number of reasons, as this package has many functions. As my user is new to Excel I will need to make use of Command buttons. Below I have illustrated some other important functions in MS Excel. ...read more.

Middle

Also I will use real player channel WSJ Market Update to get the latest information on the market shares that is done through the Internet. Through the Internet I will be able to send and receive text and images via email and web browsing. Also I will have access to many quotes, news, and general gossip, as I will be able to view current issues from a wide audience of resources. However a down side to the Internet will be costs and connection charges. But recently Ntl have launched UK's first free Internet service. Also the Internet can act as storage and backup documents using Myspace and such other services. However this can be very time consuming and so will not be used for now. But hopefully one day my user will have access to a fast internet connection such as Ntl's new 512k/s cable modem service or ISDN and then will be able to access there files from any computer connected to the internet in the world. * The user - I have checked too make sure that the final user will have access to the Internet and all is well and good. Data Types Data Type When will I use it? What will it accomplish? Formulae I will use it when I believe the data inside the cell will be updated regularly. It will perform complex calculations quickly and update new cells as required. Graphs When I want to plot my share quotes, gains, loses etc. Give a better overview of the data and help make easier comparisons. ...read more.

Conclusion

To finish I will compare what I achieved, with what I said I was going to do in my identify section, shown below. My dad has asked me to create an Excel Spreadsheet, which will track his share prices, as currently the quotes are only being recorded on paper, making it extremely difficult to plot graphs etc and manage it efficiently. However hopefully I will overcome this problem and allow easy automatic calculations through MS Excel. Also my user is not certain when to sell and buy shares so I will make an automated process in which my spreadsheet will decide when to take action by informing the user. Hyperlinks will be used to take the user to news on shares etc, to help make decisions on whether to buy and sell. A yearly graph on the company's shares will be present with the visual basic program, which will be updated automatically. My user is new to MS Excel, so I will need to make it as automatic as possible. Track his share prices - I successfully got share prices from the Internet to allow tracking. Plot graphs - I created a graph for each individual company. Automatic calculations - All calculations were automatic. Sell and buy shares so I will make an automated process - I made an automatic system and at a click of a button my user was advised. Hyperlinks will be used to take the user to news on shares - I created Hyperlinks to each sites default homepage. I completed all that I intended and what my user wanted me to do successfully, but failed to satisfy myself. ?? ?? ?? ?? Navad Khanzada 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Visual basic

    * Constants are memory locations that cannot change during the execution of a program. * Both variables and constants consist of various data types. Data Types * Text is stored as "strings" of characters. * Each text character has an associated code.

  2. Computing Project

    I will also test the delete button for removing a member. Add New DVD's Form - I will test the buttons for adding the details of the DVD to see if they are added to the table. I will test whether or not the same DVD can be added again.

  1. Computing Project

    Finally you can exit. Testing Test ID Test Data Test/Type Reason for test Expected Results Actual Results Data Entry 1. [StudentID] 11457848 Ensure data entry of 8 numbers is possible '11457848' stored AS EXPECTED 2. [StudentID] 114578484584 No more than 8 numbers allowed Error message too many digits AS EXPECTED (See Screen Dump 1)

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    As this is the case the benefits of having a well-made order system for free will defiantly out way the costs. Legal feasibility: "Appropriate security measures shall be taken against unauthorised access to, or alteration, disclosure or destruction of, the data and against their accidental loss or destruction" - section 2(1)(d)

  1. Evalutation of a Spreadsheet

    With the new system you can simply delete the data on the computer and type in the new data to replace it. Also, it makes it easier to add more data where you what it to go within the spreadsheet.

  2. Unit 6 - Advanced Spreadsheet Skills

    The hold meetings to decide what produce will go in each box they do this twice a week. They pass their decisions on to the marketing department who will then advertise the new boxes available. The department currently employs 5 staff.

  1. Purposes and Features of a Relational Database

    always have valid Customer ID , and if the end user needed to view who the order belonged to, the customers details could be pulled up instantly by using the relagtionship, instead of maunally rooting through the customer table.

  2. Ways of Promoting a Website

    Client side: This type of programming language is downloaded by the web browser and run using the browser. To do so this needs a compiler, therefore a plug in is needed. Server side: Server side means programs or languages that reside on the server and that a user can interact with through the Web server itself.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work