HYPTUSS price scrape - currency & decimal place error

[TUK020]

Is there any way of adjusting for price scrape errors?

HYPTUSS returns 137.75 pence for PHAU.L ETF physical gold, when this is the price in USD. This means that the actual price in pence is something like 11,000

[ReformedCharacter]

Is there any way of adjusting for price scrape errors?

HYPTUSS returns 137.75 pence for PHAU.L ETF physical gold, when this is the price in USD. This means that the actual price in pence is something like 11,000

Is it an error? I see both Digital Look and HL give prices in USD and the fact sheet gives the base currency in USD:

https://www.fundslibrary.co.uk/FundsLib ... CEsl83&r=1

One suggestion would be to create a spreadsheet link to a reliable USD\GBP exchange rate, such as:

https://www.exchangerates.org.uk/Pounds ... -page.html

and adjust the formula for those stocks denominated in USD.

RC

[kiloran]

Is there any way of adjusting for price scrape errors?

HYPTUSS returns 137.75 pence for PHAU.L ETF physical gold, when this is the price in USD. This means that the actual price in pence is something like 11,000

Message received and understood! We'll look at it

--kiloran

[torata]

This is a wishlist request that the price and denomination are separated off into separate cells (at least for the LibreOffice version, although I assume it's the same for Excel), rather than the current method of formatting the cell to show denomination.
I use vlookup to advise me of income from upcoming dividends but it treats everything as pence unless I manually overwrite, and as the dividends update overtime, it can get messy when they are sorted by payment date.
I suppose parity with the dollar would solve that though...

But if you could find your way to implementing that, I for one would be very grateful

torata

[kiloran]

This is a wishlist request that the price and denomination are separated off into separate cells (at least for the LibreOffice version, although I assume it's the same for Excel), rather than the current method of formatting the cell to show denomination.
I use vlookup to advise me of income from upcoming dividends but it treats everything as pence unless I manually overwrite, and as the dividends update overtime, it can get messy when they are sorted by payment date.
I suppose parity with the dollar would solve that though...

But if you could find your way to implementing that, I for one would be very grateful

torata

I'm testing a fix for this right now on the Excel version...... I'm detecting if the currency is USD, and if so I use Yahoo's USD-GBP exchange rate to convert to pence, and display the price in pence,and also highlight in red to indicate that the price has been manipulated.

Hope that's OK (and I hope Itsallaguess is in agreement!)

I'll work on a similar fix for the LibreOffice version

--kiloran

[Itsallaguess]

Hope that's OK (and I hope Itsallaguess is in agreement!)

It sounds like a great idea kiloran!

Cheers,

Itsallaguess