making graphs representing share prices and other share data
$30-5000 USD
Paid on delivery
I am coding a money managing software using visual basic 6 and am using access 97 as the database. I need someone to code graphs for me. My entire user interface occurs through forms so I need the graph to appear on a form as well. I have supplied the database that the graphs need to use. I need 1 line graph that shows movement of share mid prices for a particular company over time (the share mid prices and dates are stored in a table called sharePriceHist in the database. The share mid price is in the column midPrice and the dates are in the column trans_date I will also need 3 pie charts .The 1st pie chart shows the % of shares categorised by sector. The 2nd pie chart shows the % of shares categorised by country. The 3rd pie chart shows the % of shares categorised by currency. All the data needed for the pie charts will be in 2 tables called ShTD_company and ShTDTrans. To work out the number of shares in each sector: The table ShTD_company lists all the companies' names and the sectors that the company belongs to. The table ShTDTrans uses the company name as a foreign key and lists all the shares bought and sold in that company. The total quantity of shares (which can be found in ShTDTrans) bought in all the companies under a particular sector needs to be calculated and thus you have the number of shares under a particular sector. To work out the number of shares in country and currency: The same method needs to be applied to work out shares in a country and currency, except replace the word sector with country or currency. I've tried to make my database more understandable by showing data in it as an example. I know that graphs can be done using MS graph or using Microsoft excel chart as an ole object. I trust that you will know and use the method that is better or if there is an even better method that I don't know of. Please, please, please comment the code well as I need to understand what is going on.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) 1 graph that shows share prices over time. The share price will be on the y-axis and the time will be on the x-axis. 5) A pie chart that shows the percentage of shares categorised by sector. 6) A pie chart shows the percentage of shares categorised by country. 7) A pie chart shows the percentage of shares categorised by currency. 8) The above graphs should obtain its data from the tables in the database provided 9) All the graphs should appear on a form 10) The coding should be done using visual basic 6 11) The code should be well commented.
## Platform
The software needs to run on windows 98, 2000 and xp
Project ID: #2924568