making graphs representing share prices and other share data

Completed Posted Apr 11, 2003 Paid on delivery
Completed 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

Engineering Graphic Design Microsoft Microsoft Access MySQL PHP Software Architecture Software Testing Visual Basic Windows Desktop

Project ID: #2924568

About the project

13 proposals Remote project Active Apr 16, 2003

Awarded to:

vw774592vw

See private message.

$20.4 USD in 14 days
(22 Reviews)
3.2

13 freelancers are bidding on average $205 for this job

eplc1

See private message.

$255 USD in 14 days
(102 Reviews)
7.5
Prashantskin

See private message.

$42.5 USD in 14 days
(530 Reviews)
7.1
praveenmenonvw

See private message.

$38.25 USD in 14 days
(88 Reviews)
5.7
arhimede

See private message.

$42.5 USD in 14 days
(16 Reviews)
4.2
lubnavw

See private message.

$41.65 USD in 14 days
(10 Reviews)
3.8
ashm01

See private message.

$17 USD in 14 days
(4 Reviews)
3.7
vw627985vw

See private message.

$63.75 USD in 14 days
(3 Reviews)
1.3
zakiavw

See private message.

$25.5 USD in 14 days
(3 Reviews)
0.0
lonetron

See private message.

$1700 USD in 14 days
(0 Reviews)
0.0
whiterosevw

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
patrikaonline

See private message.

$84.15 USD in 14 days
(0 Reviews)
0.0
mmocharla2003

See private message.

$255 USD in 14 days
(0 Reviews)
0.0