said:
>Interesting. Have you had problems with Mesa/2's data integrity?
None whatsoever. It's just that since I have access to many tools
available and know how to use them, I pick the tool I believe is best for
the job and I transfer data from tool to tool as needed.
>Any other data storage strategies out there?
Sure, lots of them. Brown bag full of receipts. Graph paper. I am not
kidding, my dad, a retired optomotrist, tracks all his investments on
paper. He's pretty much scared of computers for all the typical reasons
and refuses to work the way that they work. BTW, I consider him a
successful investor.
Peter's text files are fine too. There's so much variation in investment
transactional data that this is in some ways easier than trying to map the
data into a database. I know a successful ISV who does exactly this for
their portfolio management software.
The key is you you need to understand the data you are storing, you need
to understand why you are storing it and you need to know how to process
it to get useful information out of it.
>Is there a problem storing financial data in spreadsheet form? Especially
>the kind of data we're working on here, summary stuff.
IMO, none. There are normalization issues, but that really doesn't matter
given the small volume of data you are dealing with.
As others have suggested, you need to move the detail data for each of
your investments to a separate layer. This will make the data easier to
read and process.
Steven
--
----------------------------------------------------------------
"Steven Levine" MR2/ICE 2.28a #10183 Warp4/FP11
www.scoug.com irc.webbnet.org #scoug (Wed 7pm PST)
----------------------------------------------------------------
=====================================================
To unsubscribe from this list, send an email message
to "steward@scoug.com". In the body of the message,
put the command "unsubscribe scoug-sundialsig".
For problems, contact the list owner at
"rollin@scoug.com".
=====================================================
<< Previous Message <<
>> Next Message >>
Return to [ 30 |
May |
2001 ]
The Southern California OS/2 User Group
P.O. Box 26904
Santa Ana, CA 92799-6904, USA
Copyright 2001 the Southern California OS/2 User Group. ALL RIGHTS
RESERVED.
SCOUG, Warp Expo West, and Warpfest are trademarks of the Southern California OS/2 User Group.
OS/2, Workplace Shell, and IBM are registered trademarks of International
Business Machines Corporation.
All other trademarks remain the property of their respective owners.
