SQL: what happened between two balance sheets aka the Income Statement or Profit + Loss a/c

[Wm]

Tue, 30 Dec 2014 16:14:45 <54A315C5.2070000 at fastmail.net>  Gregory 
Gincley <rollenwiese at fastmail.net>

>On 12/29/2014 07:21 PM, Wm wrote:

>> this gives us a balance sheet at the end of 2013 and you can
>> probably work out how to get one for the end of 2012 yourself [1]

>This works sort of, but the market value of accounts tied to certain
>commodities may not be accurate for any given effective date.

Reports may and should be expanded.

I like a challenge and already know how to deal with commodities and 
their values at points in time, gnc has solved most of them as it 
happens.

You are correct in that an individual must report accurately about the 
value of their assets at the necessary reporting date required by their 
country.  Thing is, jurisdictions differ.

> In order
>to caclulate the market value, you probably need to join to the prices
>table and multiply the sum of the split quantity by the price for that
>commodity as of your effective date.

You definitely need the date, SQL can't answer which price you should 
use in valuing stuff.  That is between you and your legislative body.

> Or a suitable alternative if no
>price is available for that exact date.

Yup.  In modern economies with efficient markets this is solved by the 
price of the commodity or stock known to be traded nearest the reporting 
date.

I probably haven't answered your question (looking back up I might, 
possibly, just have) but what I have done is some good in encouraging 
good questions.

Yours is one, feel free to ask again.

-- 
Wm...