Bob Stanfield writes:
> I have put together a program for my own consumption that
> tracks and graphs my portfolio. Through daily downloads I have
> loaded my MySQL database with a history of the portfolio.
>
> One feature I use is the tracking a comparison between two+
> stocks and/or a stock index with the the computation of the Beta and
> covariance. (The stock prices are normalized for the comparison)
>
Excuse my ignorance here - my stats is a little rusty (and was only
fairly limited to begin with). Could you please explain what these
statistics mean (at a high level, don't worry about the nitty-gritty
of computing them), and what they help you do? I'm guessing that
covarience is related to how accurately the value of one stock/index
predicts the value of another, but beyond that you've lost me.
> A second important graph is the tracking of my portfolio
> asset allocation. This is table driven. This allows me the discipline
> of re-balancing the portfolio between growth/mature stocks and fixed
> income instruments as the market bounces off the wall.
>
Yep, this is on my list.
> A third chart I am working on is an ad hoc chart/report based
> on MySQL "select ..." statements maintained in a separate reports file.
> This is not user friendly, but defines a functional need.
So this is a hack you provide to let you graph just about anything in,
as you said, an "ad hoc" manner? We provide similar facilities.
> BTW, my data is stored on a MySQL database mostly to give
> me data integrity discipline that my broker does not seem to recognize
> their clients might know about and want.
While we're not using a database yet, it's a medium-to-long term goal.
------------------------------------------------------------
Robert Merkel [EMAIL PROTECTED]
------------------------------------------------------------
--
Gnucash Developer's List
To unsubscribe send empty email to: [EMAIL PROTECTED]
