[R-SIG-Finance] Existing packages for personal finance and OFX importation
Brian G. Peterson
brian at braverock.com
Sun Jun 6 14:36:08 CEST 2010
On 06/05/2010 09:04 AM, Sébastien Durand wrote:
> Hello to all,
> I got my mind into it did some search and comparison I got myself decided to do the following :
> I want to build a package for personal finance :
> -In this package I wish to be able to :
> -Read OFX data
Assuming we're talking about:
as identified by Dirk, this is an XML format.
returns zero hits.
... so the first thing to try would be to use the XML package by Duncan to see
if you can parse the DTD and and parse the files into R.
Then there will likely be some work in figuring out what you want the data
structures to look like just for handling the input data. I would recommend
documenting and packaging the OFX parser as a separate R package, it feels like
a standalone package.
> -Recognize transaction
Packages like blotter can do this, though you'd also need to identify the
instruments that you are having transactions on. For 'personal finance' I
assume that this would include things like cash (various currency balances),
stocks, bonds, mutual funds, etc. All of these should be easy enough to model
in FinancialInstrument so the transactions will then make sense and add up in
> -Setup a budget through the use of buckets or envelope through time
> -Have cashflow plotting methods
There's not enough information on these two for me to understand what you want
to do. There are various methods for handling portfolio rebalancing and
optimization in R already, and of course plenty of plotting methods. If we're
still talking about transactions and portfolios, blotter can handle a lot of this.
> -This package will be able to utilise data from multiple accounts
layered account/portfolio structure is handled by blotter.
> My first question is quite simple:
> Is there a package that can already do what plan to build ?
Parts of it, see above.
> My second question is:
> Is there a package that can simply import OFX data ?
I think the OFX part is the part not covered, but if you're lucky, Duncan's XML
package will do most of the heavy lifting of parsing the files per the DTD and
getting them into R. Your work would be in sorting that into R objects for
further manipulation, and then passing the transactions on to the blotter.
> Thanks a lot!
> R-SIG-Finance at stat.math.ethz.ch mailing list
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions should go.
Brian G. Peterson
More information about the R-SIG-Finance