Re: need advice on a solution
On 10/04/2010 02:33 AM, Doug wrote:
On 10/04/2010 03:15 AM, Doug wrote:
On 10/04/2010 02:59 AM, Long Wind wrote:
I'm rather confused.
Another user Ron just say the opposite.
Suppose stock prices in an array (or table or database)
and annual earnings of 10 years in another array (or table or database)
to compute PE using average of last 3 years
is like writing a program
Can spreadsheet really do the job?
You'll have to write the equations, but you can save the "go-to" and
and "case of" commands, and stuff like that. (The go-to is ensconced
in the entry on the spread sheet--it's not really gone.) If you're
programming--one of the responders mentioned Pascal, that's a nice
language--then by all means, write the program. It will probably be of
more generic use in the future. But it would seem to me that a
_would_ be capable of what you want to do. Just don't ask me to
Well I'm "replying" to my own post:
I suggested using a spread sheet because that's the sort of thing they were
designed to do: manipulate financial data. If you're going to do a lot
then you should learn to use spread sheets. (Some people are so
comfortable with them, they use spread sheets for things like schedules.)
Personally, however, if I had the problem, I would almost certainly
polish up my
Pascal and write a program. I just wanted to clear that up. --doug
The "problem" is that stock splits make your data model pretty
complex. Maybe a spreadsheet jockey could make it work, but it
would be hideous and opaque.
Seek truth from facts.