Advanced Portfolio problems

[dunbrokin]

Sorry, yes I got confused. The basis is NZ$45k as you say and the value is
the value in US$ and not NZ$ as I had wrongly assumed (given that there was
a NZ$ in front of the number). Indeed the conversion rate seems to be 1. I
do not know where the 1 came from. There are only 4 or 5 entries in the
Price Editor for the NZ$ (I did do a get rid of old quotes a few months
ago....so that may have a bearing!). You have seen the latest fx price and
attached is the earliest price...none of the fx prices in the price editor
show 1. The date of the report is the same date as I showed in the previous
screenshot 17 July 2015. The currency conversion comes from wherever the
default currency is chosen from. Could the time difference be a problem? NZ
is often on a different day to the US?

Thanks for your help....much appreciated.

On Thu, Jul 16, 2015 at 2:50 PM, Mike Alexander <mta at umich.edu> wrote:

> --On July 16, 2015 at 2:03:49 PM +1200 dunbrokin <dunbrokin at gmail.com>
> wrote:
>
>  The price of 1 US$ in NZ$ (according to the Price Editor...which has
>> given the correct price for the last 3 years and has only recently,
>> as in the last 2 months...I have changed nothing.... starting giving
>> it in the reverse way) in 1.4932 as above. Perhaps it will be clearer
>> from the attached screenshots.
>>
>
> The basis of BBBY in the report is NZ$45,750.15, not NZ$35,982.40. That is
> the current value, not the basis.
>
> The price shown in the report is the current price, not the basis price.
> Since 523*68.80 is 35982.40 it appears that the report is using an exchange
> rate of 1 for USD vs. NZD.  The report doesn't show the purchase price or
> prices of BBBY that were used to calculate the basis, but I suspect that
> they average around USD87.40.  The question then becomes a matter of where
> did it find the bogus exchange rate of 1. What other entries are there in
> the price data base for the price of USD in NZD?  Did you somehow get an
> entry of 1 in there somehow?  What is the date of the report and what price
> source is selected in the report options.
>
> If there aren't too many of them, list the purchase and sales of BBBY that
> go into calculating the basis and let me know what basis calculation method
> you used.
>
> I have a test file that is essentially the same as this case and it works
> fine.  I don't think there is anything fundamentally wrong with the report.
>
>         Mike
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2015-07-16 14:58:40.png
Type: image/png
Size: 111344 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150716/6f63d74b/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2015-07-16 15:09:48.png
Type: image/png
Size: 33417 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150716/6f63d74b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2015-07-16 15:10:44.png
Type: image/png
Size: 8058 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150716/6f63d74b/attachment-0005.png>