Thank you Bob

I will take on board what you said and get to work with what I have already
done. If I cannot get any further then I will ask for help again.

Many thanks again
M1keHailu

"Bob Phillips" wrote:

You need to think of a class as the representation of your business model.
So you have companies, so you need a company class, you have stock prices,
so you need a stock price class. You may have others.

Identify all of the attributes (properties) of these objects, and actions
that operate on/by these objects (methods) and that defines the behaviour of
your class. You then need to code up the class modules to reflect this
behaviour.

You will need a collection class also, to collect the companies, to collect
the prices, etc.

--
__________________________________
HTH

Bob

"M1kehailu" wrote in message
...
Hello all, this is my first time posting here.
I would like some help visualizing a problem that I just cannot seem to
do.
I know some sites do not allow to ask for help on coursework but I could
not
find that in the rulebook here, and incase you need any more
clarification,
yes it is my coursework for a uni project that I humbly ask for your help.

I have to structure a peice of software in VBA in an object oriented
format
(i thought excel VBA lacked some inheritance functions that C++ has?)
anyway,
my peice of software is to generate simple and log returns of 30
companies'
stock prices, generate the mean of those, then compute their variances.
For the life of me I cannot even begin to structure them into classes,
objects and whatnot, would anybody be kind enough to help a noob?
WARNING this is a 3 part question, i need help translating some other
functions too.
many thanks in advance to anyone's help