• 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

    Test strategy Once the system has finished I will test it in a methodological and structural way to make sure all process, buttons etc work correctly and efficiently. I will use testing The order in which I will test the system is as follows: Setup Username and Password Form

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    Coax has two conductors: an outer braided cylindrical one surrounding an inner solid or stranded core. The two conductors that are separated by a dielectrics, insulating material and the cable has an outer protective sheath. This construction is electrically designed to minimize signal interference and attenuation, and in this regard coax is far superior to twisted pair.

  2. Smart Card System

    it is also able to access data and devices anywhere on the LAN. This means that many users can share expensive devices, such as laser printers, as well as data. Users can also use the LAN to communicate with each other, by sending e-mail or engaging in chat sessions.

  1. System I designed in order to produce a promotion package for her newly formed ...

    9 BEGUM SHAHEENA F 25/02/85 WALSALL 69 Milton Street Cash 11 QAMAR NAFISA F 19/07/85 WALSALL 44 Milton Street Cash 25 AFZAL IRFAN M 12/09/84 WALSALL 121 Newman Street Cash Notice that I never included 'street', as there are other roads that ended in street in my best data file (data file 3).

  2. Computing Project

    Also the laptop can be connected to a computer in the office via a USB cable meaning that the data could be backed up and if needed archived. IDENTIFICATION OF SUITABLE ALGORITHMS FOR DATA TRANSFER Process to calculate Total number of lessons so far = ([Student Lessons])*([Total])

  1. Describe the functions of each section within the shops and Head Office, paying particular ...

    how it is captured * Team details from completed order form from a mail order brochure entered onto data screen on computer using input devices such as keyboard and mouse * Product colour from completed order form from a mail order brochure entered onto data screen on computer using input

  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)

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