Quicken updates it for me daily, but I look at it maybe once a week.
I like the idea of open office and am downloading it now. Thanks for mentioning it.
I do an update once a month into Excel. I do an investment rebalance twice a year in April and October. I make tax loss decisions in November.
I also have my stocks (plus prefs and convertibles) set up in Yahoo Finance so I can see them daily if I am feeling anal. The funds are in GlobeInvestorGold.