Advance portfolio

[Roy Hammerstrøm]

Hi Mike, and thanx for your reply.

Before I sent the last email, it looked like the number of shares and the
buying value was correct, but not the current value, due to the fact that
the report used old prices.
Basically since the report used one of the old prices from price database,
the current value was wrong. When was in the report and click on the price
link, it did open a window showing the price it used and the date the price
was from (prices and date from the price DB). Those dates and prices was
from several months and year ago. Some actually from way back in 2012 when
I bought the shares. When I downloaded share prices, I used the online
price retrieval, and that downloaded the current price and currency
exchange price. All was correct as far as I could se in the price DB. Most
of the prices of my shares is in USD, some in SEK, one in EUR and two in
NOK. The report is in NOK, and the report uses the exchange rates from the
price DB. It could look like the report used the first price that was in
the price DB, witch was the price when I bought the shares.

Does that answer your questions? If not, please let me know.

Anyway, I have did "play around" in the system after my last email, and
here is what I found:
Last weekend, I did delete all the share prices in the price DB, and then
added the current share price in Norwegian kroner only. This actually
solved the problem, and made report work correct. So today, I downloaded
the prices again using the online price retrieval, and then the report
apparently didn't update itself with the today's prices. So I went back to
the price DB, used the function for deleting all of the old prices, and now
the report is function correct. And now, the current price for each share
is in USD, SEK, EUR and NOK, and the report/system is using the current
exchange rate. I did double check some of the current total value, and it
is correct.
So for me it solved the problem, by first download the new prices and
exchange rates, and then delete all of the old prices in the price DB. At
least that seems to work for me.


Kind regards, Roy



2016-06-11 1:02 GMT+02:00 Mike Alexander <mta at umich.edu>:

> Sorry fir the delay replying.  I’ve inserted some comments in the text
> below.
>
> On Jun 2, 2016, at 9:20 AM, Roy Hammerstrøm <roy.hammerstrom at outlook.com>
> wrote:
>
> In "price source" I did try them both to see if that helped, but as far as
> I can tell, it didn't.
> Can it maybe be something that I've done, or should have done to connect
> the price list database and the shares?
> Or should that not matter?
>
>
> They are connected automatically, there is nothing you need to do except
> make sure you enter (or download) prices for the correct stock.
>
> It looks weird that the report don't take the prices from the database.
> I've tried to look at all the options I could find to see if that had
> anything to do with it. When I go "accounts" and then click on the "edit"
> button to change the share, one of the thing there is "smallest
> subdivision" (or what it is called in English, the one where you select
> "use product value", "1/10", "1/100", "1/1000" etc), what is the best one
> to select there?
>
>
> I don’t think the report cares what you select for that option.  It
> determines the smallest fraction of a share you can record, but dowsn’t
> affect the price.
>
> I just had at the "investment portfolio" report and in that one, it looks
> like the report uses the correct numbers.
> In fact, I just did double check the numbers in the investment portfolio,
> and the total value for each share is correct.
> And the total value for all my shares according to the investment
> portfolio, is the same as it is in the advanced portfolio.
> So I also did check the total value for my share when I bought them, and
> that amount is also correct in the advanced portfolio.
> So it then looks like the buying price and value in the advance portfolio
> is correct, but not the price.
> Therefore, since so much is correct, with the exception of the price, I
> wonder how much more we should put in to this.
>
>
> So you’re saying that the current value doesn’t equal the number of shares
> times the price?  Is that correct?  This seems odd.  Perhaps it is a
> currency exchange rate problem.  You probably said before, but I can’t
> recall the answer.  Is the currency of the report the same as the currency
> in the price database for the stocks in question?  The price fields in the
> report should be links.  If you click on one of them it should open the
> price DB entry from which the price was taken.  Does this work and if so
> what do you find?   Is the currency what you expect?  Is it the same as the
> report’s currency?  Is the price the same as shown in the report?
>
>              Mike
>
>