Portfolio Manager

[sputnik]

I have starting setting up the Portfolio Manager and found there is a slight problem dealing with UK shares. If I purchase say 1000 shares at £1 each. The prices are indicated in pennies ie 100. MyMoney calculates costs as 1000 x 100 = £100000 when it should be £1000. I tried using the dowloaded quote normaliser to see if makes any difference but unfortunately not.

Also there are rounding problems as some the UK shares are quoted upto 4 decimal places. So I have to make the adjustments via fees to make it the correct balancing figure to the settlement documents.

However, if I select for a Mutual Funds the calculations are correct and seem to have no problems with the funds I hold.

Please advise

[mthadm]

Hello,

Normally the penny/pounds issues shoudl be taken care of by quote normalizer. Whats the ticker name and the source you are getting it from, we will try to reproduce this


Thanks,

[sputnik]

You can most of the UK tickers and it does the same. The one I used are BP, TEP, CSR DNO to name a few

Cheers

[mthadm]

We will double check,

Thanks

[mthadm]

Hello,


We seem to be getting correct prices for these securities, see attached

bp.png (13.65 KiB) Viewed 7773 times

To automatically convert prices from pennies to pounds please enter normalized factor 100, this way downloaded quotes will use this number to arrive at a correct price, the formula is simple:

Code: Select all

        updatedQuote.setDayClose( last
                                  / security.getQuoteNormalizerFactor() );


Thanks,

[sputnik]

Hi

Perhaps I did not make myself clear. If you Portfolio Add having selected a UK share, the total is a multiple of 100 (shares) x 470 (cost per share) = £47000 not £4700 because the shares are £4.70 not £470 which is where the problem lies. I tried to copy and paste the image but could not work our how too!

Cheers

[mthadm]

There may be a communication problem, we seem to be saying the same thing.

On London exchange stock quotes can be quoted in both pence and pounds, to convert from pence into pounds please Edit security (you can click on it in the Quote Board or go through List Manager) and enter quote normalizer = 100.

This will convert downloaded prices into pounds, does that not work for you?

Thanks,

[sputnik]

You are correct using the normaliser but it does not generate the correct cost price in the Edit Investment Transaction. I will give you an example:

LHS the fields are populated with the correct investment and activities:

RHS

Quantity 4438
Price 22.085
Tax
Fee
Commision
Total £98013.23

This is incorrect. The total cost (excluding fees etc for the moment) should be £980.13. However if I used the normaliser 100 then it shows the price as 23.00 which again is incorrect as the calculation is now £1020.74. The normaliser is dividing by 100 and is rounding to 2 decimal places rather than 4 that is needed for calculation purposes.

What I would prefer as it fits in with the UK market is that if the shares are priced from UK (which are always in pennies), the software calculates correctly without having to adjust via the normaliser and to 4 decimal places but the total is rounded to 2 decimal places. I must point out this is only a problem with shares and not with any other investment types such as funds which calculates correctly.

[mthadm]

we will take a look,


Thanks

[sputnik]

Hi Is there any further news on this problem?

Regards

Sputnik