By Matt Abar on 9/23/2009 11:14 AM

Managing your imports is a complicated process. Almost all portfolio accounting data comes from custodial import sources, as opposed to manual data entry. In most systems, you lose the provenance of your data once the import has completed. You can't look at a specific transaction or client record and determine which custodian or import file the data came from.

Even if you can figure out where your data came from, what options do you have for fixing problems? You need high-level tools that let you manage blocks of data at the custodian or file level. If you import a bad batch of files, you need some way to back out information globally without going line-by-line through your accounts or having to restore a database backup.

Read More »

By Matt Abar on 8/31/2009 3:15 PM

The bulk of the work we've been doing over the last month has been cleaning up our SOA layer so  FinFolio can run in a web browser. It was much trickier than I'd anticipated but we're finally ready to go.

Read More »

By Matt Abar on 8/25/2009 12:35 PM

Now that the beta is trucking along, we've been whittling down the remaining FinFolio R1 features. We have a few things that I'll be highlighting over the next week, starting with grouping. Most portfolio management systems have some sort of grouping structure that lets you create miscellaneous groups of clients, accounts, etc. They usually do this by allowing you to select specific items at the time you create the group; this is called "static" grouping...

Read More »

By Matt Abar on 6/22/2009 9:41 AM

On Friday, we posted an update to the FinFolio beta. We are planning on doing weekly updates during the Beta period as we make changes and fixes. This is primarily because we need to do regular custodial interface updates now that we're getting good feedback from the beta sites.

This last update included the developer example project, which is a Visual Studio 2008 project that can be compiled as a FinFolio add-in...

Read More »

By Matt Abar on 6/19/2009 7:52 AM

One of the benefits of building software from scratch is that you can eliminate limitations of existing systems. Sometimes this comes from better design, but often the new functionality comes at a cost, either in slower software speed or more complicated code maintenance. With Techfi, a good example of this was having current values and other calculations available in the software without having to run reports. In order to do this, we moved some of the business logic into the database, which made our imports take longer* than other systems.

Read More »

By Matt Abar on 6/8/2009 5:52 PM

We just released Beta1. Woo hoo!

I'm reasonably happy with the state of the product. The beta is as clean as we can make it without having any live installations; our bug lists are clean and we only have a small handful of known issues. Mike and I feel that the product is about where Techfi was in its last year in terms of release quality. We're a bit late but we haven't compromised on any of the features or promises we've made over the last year. I think we're well on our way to delivering a next generation portfolio management system.

Read More »

By Matt Abar on 5/28/2009 9:32 AM

I recently upgraded to a larger screen, a 30" 2560x1600 Samsung LCD panel. I'm not sure a screen this large is ever "necessary", but our GUI development environment takes up so much space, that my smaller screen was almost unusable. When we work on our WPF screens, we usually have five different panes open, with two main panes sitting side-by-side -- the GUI representation of the screen and the XAML code-behind where we write the screen code.

With my smaller 21" monitor, I could only see ten lines of code at once. With the new monitor, I can easily show the GUI and code-behind next to each other, at least 50 lines at once, making it much easier to debug and add features.

FinFolio follows the same paradigm, letting you put different panes beside each other. If you have a larger monitor, you'll have a richer user experience...

Read More »

By Matt Abar on 5/12/2009 11:40 AM

FinFolio graphs started off as a 2-day project to give our screenshots some sizzle. But the more we dug in and started playing with different graph layouts, the more we realized that graphs should be an integral part of the software.

FinFolio has a modular graphing system that offers visualization options for every major data type. Click the graphs button and a 2-graph tool window opens in the right side of the software; it dynamically changes depending on which household/account/etc. is displayed in the main window. Open up a client and the graph window shows you the client's accounts on the top pie graph, and his security positions on the bottom graph.

Read More »

By Matt Abar on 3/5/2009 2:30 PM

We've run into some feature creep with the beta and we're running late. Feedback from the beta sites prompted us to add additional features. Our goal is for clients to start running the FinFolio beta in parallel with their current systems which is a necessary step for any new software but doubly so for a portfolio management system, due to the numerous transaction interfaces with custodians, legacy software, and complementary systems.

Importing transaction data from custodians or legacy PMS systems is very tricky. If there *is* a specification for a particular interface, important details are usually missing. Information is often contained in comment fields or in undocumented alternate transaction codes. The sample data we work with rarely has anything but the most common transaction types, so we don't know how a custodian handles corporate actions, reversals, option expirations, or other uncommon situations until we see it come down in the live data.

Read More »

By Matt Abar on 2/20/2009 3:17 PM

FinFolio will be attending the Virtual Office Tech Tools conference next week in Texas. If you've been reading the blog and/or are planning on being a beta, please drop by the booth and say hello.

We're doing an in-depth demo of FinFolio Workstation after the last panel on Friday (around 6:30).  And I'm on the Portfolio Management Software I panel, along with reps from Morningstar, Portfolio Director, Open Finance Network and Arcorns.

• Portfolio Management Software I Panel - Friday,  9:10am - 10:25am
• FinFolio Demo - Friday, 6:30pm - 7:30pm in the Spectrum Room

I hope to see you there!

Read More »