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
Got a credit card? use our Credit Card & Finance Calculators
Thanks to eyeball08,Wondergirly,bofh,johnstevens77,Bhoddhisatva, for Donating to support the site
HYPTUSS price scrape - currency & decimal place error
-
- Lemon Quarter
- Posts: 2042
- Joined: November 5th, 2016, 7:41 am
- Has thanked: 762 times
- Been thanked: 1178 times
-
- Lemon Quarter
- Posts: 3133
- Joined: November 4th, 2016, 11:12 am
- Has thanked: 3629 times
- Been thanked: 1518 times
Re: HYPTUSS price scrape - currency & decimal place error
TUK020 wrote: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
-
- Lemon Quarter
- Posts: 4109
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3243 times
- Been thanked: 2848 times
Re: HYPTUSS price scrape - currency & decimal place error
TUK020 wrote: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
-
- Lemon Slice
- Posts: 523
- Joined: November 5th, 2016, 1:25 am
- Has thanked: 207 times
- Been thanked: 211 times
Re: HYPTUSS price scrape - currency & decimal place error
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 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
-
- Lemon Quarter
- Posts: 4109
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3243 times
- Been thanked: 2848 times
Re: HYPTUSS price scrape - currency & decimal place error
torata wrote: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
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10025 times
Re: HYPTUSS price scrape - currency & decimal place error
kiloran wrote:
Hope that's OK (and I hope Itsallaguess is in agreement!)
It sounds like a great idea kiloran!
Cheers,
Itsallaguess
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 30 guests