Asset Allocations

[David Boyce]

I was wondering if anyone could offer me any advice on getting a stock
valuation out of GNUCash via SQL.

I'm looking to create a spreadsheet in Excel that gets data out of the
GNUCash database.  I'm looking to have a spreadsheet in excel that sets
each account type (cash, stock, bonds, fixed asset) etc and then be able to
produce a report that says I have X percentage saved as bonds etc.  I know
perhaps I should do this within GNUCash but the problem is some funds are
weighted X across several asset classes.

I've got some code that gets a balance out for a cash account...