Huge Example file ▾Query

help select
help balances
help from
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY currency, cost_currency   ORDER BY currency, cost_currency
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY currency, cost_currency   ORDER BY currency, cost_currency
?
?
?
?
?
?
?
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY currency, cost_currency   ORDER BY currency, cost_currency
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY currency, cost_currency   ORDER BY currency, cost_currency
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY currency, cost_currency   ORDER BY currency, cost_currency
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY currency, cost_currency   ORDER BY currency, cost_currency
SELECT     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY cost_currency   ORDER BY cost_currency
SELECT account,     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY account, cost_currency, account_sortkey(account)   ORDER BY account_sortkey(account)
SELECT account,     units(sum(position)) as units,     cost_number as cost,     first(getprice(currency, cost_currency)) as price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value,     cost_date as acquision_date   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY account, cost_date, currency, cost_currency, cost_number, account_sortkey(account)   ORDER BY account_sortkey(account)
SELECT account,     units(sum(position)) as units,     sum(cost_number)/count(cost_number) as average_cost,     sum(getprice(currency, cost_currency))/count(cost_currency) as average_price,     cost(sum(position)) as book_value,     value(sum(position)) as market_value   WHERE account_sortkey(account) ~ "^[01]"   GROUP BY account, cost_currency, account_sortkey(account)   ORDER BY account_sortkey(account)

Upload file(s):

New transaction: