We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

I.T. System to Track Share Prices Paper

Words: 738, Paragraphs: 9, Pages: 3

Paper type: Essay , Subject: Stem Cells

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.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. Cells can easily be identified. Formulas can easily be entered. As shown above, calculations can be easily done in Excel, making it user friendly. Finally to make my spreadsheet more attractive I can use the below simple tools. MS Word Art Drawing Tools & Shapes ClipArt’s Shadow and 3d style Free rotate Basic drawing shapes Fill ColourWhat other packages can also do the job? Software Name Advantages Disadvantages MS Excel Simple user interface with many facilities.

Don't use plagiarized sources. Get Your Custom Essay on I.T. System to Track Share Prices
Just from $13,9/Page

Get Essay

If data in one cell is changed accidentally all results may be altered.

MS Access This software is a relational database and is not a spreadsheet so cannot be compared. Lotus 123 Simple user interface with many facilities. In some ways better than Excel. Same as excel. Claris Works Spreadsheet Simple to use with common basic functions. Not a familiar interface and lacks the power of macros etc. MS Works SpreadsheetSimilar to MS Office software as MS Works suite provides a Word Processor and a database. Not enough advanced features. Star Office Spreadsheet Software suite is free. Also has a word processor. Extremely basic, lacks to many key features, which Excel contains. From the above table I can see that MS Excel and Lotus 123 are best suited to my task, as they have a simple layout with great advanced features, including macros, which other packages fail to provide.

Both packages seem extremely versatile and powerful.

MS Excel has a great help facility also.

VBA code and forms can be created in Microsoft Excel, making it very unique.I will use MS Excel to create the spreadsheet, as I am most familiar with it and also currently the user has a tight budget and is not willing to invest any more money. With excel I will also be able to edit any macro visual basic code, as this will be required later on in the project. What am I personally hoping to achieve? I am aiming to expand my Excel knowledge and VBA knowledge and create a 90 % automated system, in which my user just has to click a button.Analysis My approach to the task: As currently the share prices and quotes are only being extracted from one site, which is www.netscape.com, I have decided that my user will be requiring other resources and sites for the latest news and decisions.

Also the user is uncertain which data and text applies to which company so by adding comments to cells I will hopefully resolve the issue.

My users data is also extremely unorganised, as weekly he receives his share prices and quotes through the mail and how much profit etc he is making. My worksheet however will hopefully make the mail prices obsolete, as the calculations will be done through Excel more regularly. So in this project I will be creating the following.Worksheets – Different aspects of the shares will be put on multiple worksheets, which will all be linked to one another. Quotes – Will be taken from visual basic program. News – Will be taken from real player and CNBC channel through a TV Card and also other various sites. Graphs – Quotes will be plotted automatically as data is entered. Hyperlinks – Take my user to my VB program and relevant sites or cells. This information will consists of the following Data Structure’s – Type Of Data Structure

About the author

This paper is written by Sebastian He is a student at the University of Pennsylvania, Philadelphia, PA; his major is Business. All the content of this paper is his perspective on I.T. System to Track Share Prices and should be used only as a possible source of ideas.

Sebastian other papers:

How to cite this page

Choose cite format:

I.T. System to Track Share Prices. (2017, Aug 17). Retrieved from https://paperap.com/paper-on-3475-t-system-track-share-prices/

Is Your Deadline Too Short?
Let Professionals Help You

Get Help

Our customer support team is available Monday-Friday 9am-5pm EST. If you contact us after hours, we'll get back to you in 24 hours or less.

By clicking "Send Message", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
No results found for “ image
Try Our service

Hi, I am Colleen from Paperap.

Hi there, would you like to get such a paper? How about receiving a customized one? Click to learn more https://goo.gl/CYf83b