Historical UK stock prices.

[rupertpage]

Hello Mark,
I am attempting to retrieve historical prices for December 2009. This works fine for my foreign holdings (US & European).

However there is an issue with UK stocks. I use Yahoo-UK & Ireland for daily price updates so for example this gives me a quote for Cable & Wireless of 1.464 (ie a quote in pounds). However when I retrieve Yahoo-HISTORICAL prices I would get a quote of 146.4 (ie in pence).

Is there a solution ?

Thanks, Rupert

[Mark]

Hi Rupert,

There is a solution, but it isn't ideal if you plan on using both Yahoo-UK and Yahoo (Historical) often with the same stock. There is an investment based option to multiply the retrieved price by some factor. See "Investment Properties... / Internet Retrieve / Multiply Retrieved Price By:". You can set this to 0.01 when retrieving from Yahoo (Historical) so your prices come down in pounds, and not pence. However, when retrieving from Yahoo - UK you'll want to leave it set to 1.0. For the Yahoo - UK server if a symbol ends in "*L" or ".L", Fund Manager automatically divides the retrieved pence price by 100 to update in pounds.

ADVANCED, BUT BETTER SOLUTION:
There is a registry option you can set so that Fund Manager does not adjust prices from Yahoo-UK. If you set this registry option so that Fund Manager doesn't do this adjustment, you would then need to go into all your investments that end in *L or .L and set the multiply option to 0.01. However, then you could leave it set to 0.01 and retrieve from both Yahoo-UK and Yahoo (Historical) without having to adjust this setting in-between. This registry option can be edited using 'regedit'. Under the key:

HKEY_CURRENT_USER\Software\Beiley Software\Fund Manager\CurrentVersion\Internet Retr

create a new value named "yahoo_uk" and set it to a value of 1. Create it as a "String Value" type.