* iofdb: ongoing porting to ADE/perl/SQLite finished! * iofdb: ongoing porting to ADE/perl/SQLite (minor fixes all over the place: switched double to single quotes where possible, created new first level update(), create(), destroy(), display() functions, update_*() functions set common timestamp for all their create_*() calls, ...) * iofdb: committed current actual database after account opens/closes and holdings and prices update. * iofdb: ongoing porting to ADE/perl/SQLite (ported PNG generation code) * iofdb: added old and new format databases in case overwritten in next uses and added conversion scriot too * iofdb: set IOFDB_BIN_PREFIX as the iofdb command is referred to absolutely in iofdbm * iofdb: finally deleted old shell version of iofdb * iofdb: added checks on plurality of objects according to verbs * iofdb: ongoing porting to ADE/perl/SQLite (balances now done) * iofdb: ongoing porting to ADE/perl/SQLite (prices, accounts and holdings are done; balances, historical formats, graph output, man pages remain) * iofdb: ongoing porting to ADE/perl/SQLite (update_prices almost done) * iofdb: updated README files as per all ADE-compatible modules * iofdb: more work on porting to ADE/SQLite * iofdb: switched from ade_err_error(..., iofdb_err_internal, ...) to ade_err_internal(...) * iofdb: beginnings of porting to perl and sql * iofdb: removed references to ADE_MSG_VERBOSELEVEL * iofdb: removed some option processing and usage message code that is now handled by ADE internally. * iofdb: switched from ksh to sh in invert_rc() in test scripts * iofdb: added SVN markers * iofdb: removed TODO and BUGS files which were unused. * iofdb: updated README.1ST * iofdb: removed references to sppsym and SPPSYM * iofdb: removed an svn:ignore following renamings * iofdb: removed all references to #spp in scripts, tests, man pages, renamed *.whatever.spp to *.whatever * iofdb: replaces INSTALL document with updated version suitable for new ADE * iofdb: moved the 'this manual page documents version ....' from the top of the man page to the bottom. * changed iofdb's stock code format from COUNTRYCODE:EPICCODE to EXCHANGE/YAHOOCODE (changes in iofdb for displaying of prices, changes in what iofdb prompts for when opening stock accounts, changes to my personal database, changes to iofdb-get-price) * getting prices now includes determining intermediate currencies for stocks which are not user-held currencies and then get their prices (this is to avoid using very old rates) * when calculating balances warn when using a very old rate * consequent trimming of man page's caveats. * completed first draft of all manpages. * wrote some (not all) man pages * renamed iofdb-outer-join to indicate what it *actually* does (outer join of those rows of two tables whose primary keys survive inner join filtering) Release 0.4.1 (Sun Jul 23 17:04:53 CEST 2006) * hopefully fixed bug which was leaving temp file around. Release 0.4 (Sat Oct 29 17:54:02 CEST 2005) * adding some development-specific settings to settings.mk 'cos I'm constantly using this program from the working copy (which can't otherwise find its own components 'cos it's looking outside the wc for them) * added support for filtering on iofdbm's dh command * added the calling function's name to the name of some temporary files as 'iofdb update prices' was failing 'cos temporary file was removed by a subfunction before a function had finished with it as they shared the same name. * ADE revision 1858 is required, as the test added for the above change relies on providing answers to the questions it asks from stdin. Release 0.3.2 (Tue Mar 29 15:57:04 BST 2005) * in scripts updated names of some ADE global variables (ADE_MSG_VERBOSELEVEL) * switched to extracting long option values using ade_smf_getoptval() Release 0.3.1 (Tue Mar 22 11:50:56 GMT 2005) * stopped 'iofdb display prices' displaying prices of currencies used only in closed accounts). * in iofdbm.sh.spp removed some function-body code left outside all functions (causing 'local only valid inside function calls' error) * in iofdb.sh.spp start of simulation support * in iofdb.sh.spp got update_prices() to use listaccounts rather than directly reading prices table (and getting it wrong 'cos doesn't know about closed accounts). * removed some commented out code supporting updates of prices and holdings when updating balance. * removed the level one object functions (they were already obsoleted by level one action functions) Release 0.3 (Mon Mar 21 19:32:47 GMT 2005) * removed iofdb-specific settings of ADE-related vars in settings.mk (this was only temorarily needed in order to use a debug function enhanced in the development ADE) * added support for closing accounts * removed 'update-prices-or-holdings-before-recalculating-balance' facility from update_balances * improved filtering capabilities * added filtering capabilities to iofdbm * removed many non-expert menu items from iofdbm * always require two arguments to iofdb (action and object) * if object is singular (e.g. price instead of prices) then also require specific item to apply action to. Release 0.2 (Sun Jan 23 15:46:26 CET 2005) * removed debug options on iofdb's invocation of iofdb-get-price * iofdb-get-price retry price/quote retrieval and better result testing * iofdb tests results from iofdb-get-price (actually redundant as iofdb-get-price has this now) * corrected iofdb usage message. Release 0.1 (Mon Sep 20 11:23:07 CEST 2004) * added SVN keywords to many files, including example databases. * added ignore of test outputs * added dummy missing man pages. * commented out a superfluous error message. * removed some quotes around some text of error messages for consistency. * added demo script for Sabine * moved iofdb-get-price out of lib and in to bin * many bug fixes as consequence of porting to work under iofdbm (menu driven iofdb for Sabine) * added support for interactively adding account information * added several missing registrations of temporary files in order to ensure proper clean up (still one I can't find for iofdb.PID.prices - seems correct). * moved iofdb-outer-join from lib to bin and imported it into the standard adegmt-generated template. * more quoting of possibly multi-word function arguments * added png format * resolved performance problems in displaying prices when using --history showed that the currency-to-type map generated from the accounts file was actually wrong because it was uniq'ing on the account name and not on the currency name (resulting in many many more records than there should have been). * implemented filtering and reordered output of holdings and prices table for per-subholding type paragraphing. * added support for display of latest/history and/or humanreadable/iofdb-display-format of remaining stocks. * added script lib/iofdb-outer-join (needed for history code, which will get very compilicated and repetitious without it) * added history code for balances, prices and currency holdings (but not listed and unlisted stock holdings). * added display format 'iofdb' which prints raw db format. * added framework for history code and for display format (humanreadable, gnuplot, jpeg), but no code for history or format actually added yet. * removed a duplicated function and rearranged the functions into a more sensible order. * added support for updating holdings * changed default behaviour of '--update' to automatically infer '--no-display' (unless also explicitly specified) * added [-no]--update-{holdings|prices} as sub-options of 'iofdb --update balance'. * removed svn:ignore from bldcfg for paths.*. This is because these files *are* part of the distribution of these files: the contain important config info. (This in turn is because this module is never installed, but always the working copy is used.) * added svn keywords and properties * minor tailoring to INSTALL file. * iofdb-get-price moved to lib dir * quite some code refactoring to bring about better similarity between functions at same level in prices/holdings/accounts/ balances. * deleted the data files; these are now in ~/var/iofdb. * changed dates in man pages to symbols in line with latest aderel * iofdb-get-price now doesn't display date or currency * added '--latest' and '--db-format' options to iofdb * added functions for currency to type conversion and currency to preferred currency (for stock pricing) * updated prices * added field for stock/currency flag in accounts. * updated prices. * added script iogdb-get-price to get latest price * added latest EUR/GBP prices. * corrected option processing arising from long options with spaces * added to svn:ignore * corrected tmp directory variable name * updated prices, holdings and accounts with info from Mum and ft web site.