Advanced Portfolio problems

[dunbrokin]

The US$/NZ$ is 1.4932 . The price in the Price Editor of BBBY is US$68.8
(Google has it at US$69.03 today) and I have 523. So, 523*68.8*1.4932 =
NZ$53,728 or so....and the basis in Advanced Portfolio shows NZ$35,982. Now
if we multiply NZ$35,982 by 1.5 we get the correct number. Hence, my
contention that the way the Price Editor picks up the FX rate has got it
the wrong way around. How do we fix this?I have not put any FX values into
the Price Editor...it sources them independently....and it was correct up
until about 2 months ago.

On Thu, Jul 16, 2015 at 11:55 AM, Mike Alexander <mta at umich.edu> wrote:

> --On July 15, 2015 at 8:24:08 PM +1200 dunbrokin <dunbrokin at gmail.com>
> wrote:
>
>  In the Advanced Portfolio, when calculated in my native currency of
>> NZ$, the Value number of each holding not in NZ$ is calculated
>> incorrectly. It seems the US$ number is multiplied by the NZ$ rate
>> rather than being divided by it. Hence I get a lower value than I
>> should do....For example I have 523 shares in BBBY (Bed Bath and
>> Beyond) they are currently trading at US$68.80. I would expect the
>> value of them to be around NZ$53,129 and instead it is showing a
>> valuation of NZ$35,982.
>>
>
> According to my calculation USD68.80 is worth about NZD104.61.  How many
> shares of BBBY are we talking about?  500?  This should be about NZD52303.
>
> Are you sure you have the correct price entered in the price data in
> GnuCash?  Open the price editor from the Tools menu and look at the entries
> for USD in the currency section.  They should show a security of USD and a
> currency of NZD with a value between about 1.520 now and 1.314 a few weeks
> ago.  It sounds like you've somehow gotten the wrong values into the price
> data.
>
> I can't help you with the other problem since I've never tried pasting the
> report into a spread sheet.  I know others have so it must be possible.
>
>             Mike
>
>