Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

LSE stocks

Questions about updating prices or transactions in Fund Manager

Postby realbg » Thu Jun 03, 2010 10:44 pm

Hello,

I have bought some stocks that are traded on LSE. The problem is at LSE the stock prices are quoted in Pences (Cents) rather than Pound (Dollars).

So, I bought 1,000 shares at 400p each = 4,000 pounds. Because 400 pence = 4 pound.

The price quote (no matter Bloomberg or Yahoo) will quote prices in pences not poundes.

So, If I mark the transaction as 1,000 shares at 4.00 Pound/share, then the P&L will be incorrect, because the Bloomberg quote will import 400P giving me 10000% gain.

The only way to mark the transaction for the P&L to be correct is to mark it as 10 shares at 400 Pound/share. Then, it will be streamlined with the quote, but this is not ideal.

In short, is there a function that automatically divide the price quote by 100 so that I can mark both quantity and price correctly?

Thank you.

Aileen
realbg
 
Posts: 23
Joined: Fri Jan 22, 2010 12:13 am
Location: HONG KONG

Postby Mark » Fri Jun 04, 2010 8:26 am

Hi Aileen,

There are 2 different solutions for this:

1) Use the "Yahoo - UK & Ireland" quote server, and make sure your symbol has the ".L" suffix. This will correctly retrieve in pounds.

2) If you want to use a different server, you can set a price retrieval multiplier of 0.01 under "Investment Properties... / Internet Retrieve".

If you only want to retrieve certain investments from Yahoo - UK/Ireland set this quote server for just those investments under "Investment Properties... / Internet Retrieve", and leave all the other ones set to use your default quote server.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11772
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 24 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.