[Patch] reworked advanced-portfolio.scm

[Herbert Thoma]

Andrew Sackville-West wrote:
> On Thu, 23 Feb 2006 19:45:28 +0100
> Herbert Thoma <herbert.thoma at iis.fraunhofer.de> wrote:
 >
>>Most of my securities are denominated in Euro. I own some
>>in USD as well, but I bought them for a certain Euro amount
>>and I will sell them for Euro. So I get a cost basis in
>>Euro from the transactions. The money in and money out
>>values are consequently all in Euro. And since my report
>>currency is Euro I never need currency conversion for
>>money in or out.
>>
>>The only place where I need currency conversion is the
>>current value because the stock quotes of the USD securities
>>are in USD.
> 
> SO in this case you are using the pricedb to set the stock price
> in USD, right?

Yes, right.

> I think it works then because the exchanges are
> only done if there is a pricedb entry.

Agreed.

> There is, in my working
> version, no exchange done on data gathered from transactions directly.

>>So in the case where the report currency is the same as
>>the transaction currency you should allways use the
>>transaction value and don't do any currency conversion for
>>money in or out.
>>
>>If the report currency is not the transcation currency
>>then you porbably should use the currency conversion factor
>>from the price db that is closest to the transaction time.
> 
> So you are saying in the case where there is both pricedb
> and transaction data AND the report currency is different from
> the txn currency, we should use the pricedb entries to make
> the exchange? This means that if you have transaction data that
> is more recent than the pricedb, you'd prefer the more out-of-date information? 

Hmm, I usually do a get-quotes once a day, so I think I have
a reasonable price.

Anyway, how do you get price data from the transaction?
Say you buy 10 shares X for 100 EUR and the report currency is USD.
There is no conversion rate for EUR to USD in this transaction,
so you have to look for one in the pricedb, don't you?

  Herbert.

> A
> 
-- 
Herbert Thoma
Group Manager Video
Multimedia Realtime Systems Department
Fraunhofer IIS
Am Wolfsmantel 33, 91058 Erlangen, Germany
Phone: +49-9131-776-323
Fax:   +49-9131-776-399
email: tma at iis.fhg.de
www: http://www.iis.fhg.de/