Yahoo LSE ETF price divided by 100 even for USD and EUR

[hyhchan]

Hi,
Since WSJ is no longer working I switched the quotes to Yahoo. But I noticed that somehow for ETF prices listed on LSE (London), the price module will divide the price by 100, even the ETF is priced in USD or EUR. I know some prices is quoted in GBp and this treatment make sense, but can the quote module distinguish the pricing currency so that it can apply the factor only when needed?

BTW, back in WSJ module the LSE pricing also has issue, but it was the other way around - I need to put a factor of 0.01 to the quote to turn GBp to GBP.

Thanks

[Mark]

Hello hyhchan,

When using the Yahoo (UK & Ireland) server, any symbol that ends in .L will have its price divided by 100 in order to convert from pence to pounds. You can read some details on this here:

https://www.fundmanagersoftware.com/intrtv.html#YahooUK

If you don't want that, switch to regular Yahoo instead, which I believe has all the same quotes as Yahoo (UK & Ireland).

[hyhchan]

Hi Mark,

Actually I am using the yahoo historical server and the program exhibit the same behavior as using the yahoo uk site. I checked and using the yahoo main site does not have this issue but I mainly use the historical quotes to fill the price table (so that I can do it once in a while vs do it everyday)

Any plan on changing this behaviour or I need to change my settings to accommodate this?

Thanks
Howard



===================================
Retrieve Started at 1/27/2024 07:28 UTC
Program Version = 2024.18.1
Quote Module Version = 594
Retrieving from server: (YAHOO-HISTORICAL)
Requested Historical Retrieve Dates: 1/10/2024 - 1/26/2024
Requesting: "EIMI.L" 1/10/2024 - 1/26/2024
*** Request/Response Headers: https://query1.finance.yahoo.com/v7/fin ... Close=true
--- Request Headers:
GET /v7/finance/download/EIMI.L?period1=1704873600&period2=1706428800&interval=1d&events=history&includeAdjustedClose=true HTTP/1.1
User-Agent: Mozilla/5.0
Host: query1.finance.yahoo.com
Cache-Control: no-cache
Cookie: A1=d=AQABBFY8XmUCEF2EZOwBhZI5lHpAAwqiMh0FEgEBAQGNX2VoZSXUxyMA_eMAAA&S=AQAAArUlTDCFUYkr38RsdQ_LHNM; A3=d=AQABBFY8XmUCEF2EZOwBhZI5lHpAAwqiMh0FEgEBAQGNX2VoZSXUxyMA_eMAAA&S=AQAAArUlTDCFUYkr38RsdQ_LHNM; A1S=d=AQABBFY8XmUCEF2EZOwBhZI5lHpAAwqiMh0FEgEBAQGNX2VoZSXUxyMA_eMAAA&S=AQAAArUlTDCFUYkr38RsdQ_LHNM

--- Request Body:
<empty body>

--- Response Headers:
HTTP/1.1 200 OK
content-disposition: attachment; filename=EIMI.L.csv
content-type: text/csv;charset=utf-8
cache-control: private, max-age=10, stale-while-revalidate=20
vary: Origin
content-length: 584
x-envoy-upstream-service-time: 4
date: Sat, 27 Jan 2024 07:28:10 GMT
server: ATS
x-envoy-decorator-operation: finance-chart-api--mtls-production-gq1.finance-k8s.svc.yahoo.local:4080/*
Age: 0
Strict-Transport-Security: max-age=31536000
Referrer-Policy: no-referrer-when-downgrade
Connection: keep-alive
Expect-CT: max-age=31536000, report-uri="http://csp.yahoo.com/beacon/csp?src=yahoocom-expect-ct-report-only"
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff

*** Returned Data:
Date,Open,High,Low,Close,Adj Close,Volume
2024-01-17,30.000000,30.030001,29.840000,29.870001,29.870001,251802
2024-01-18,30.120001,30.270000,30.090000,30.209999,30.209999,217690
2024-01-19,30.360001,30.430000,30.180000,30.270000,30.270000,282227
2024-01-22,30.270000,30.377300,30.200001,30.280001,30.280001,348133
2024-01-23,30.420000,30.590000,30.219999,30.410000,30.410000,201197
2024-01-24,30.670000,31.070000,30.660000,30.980000,30.980000,186903
2024-01-25,30.850000,30.990000,30.790001,30.840000,30.840000,103339
2024-01-26,30.670000,31.000000,30.620001,30.969999,30.969999,92566*** End of Returned Data:
Updating: "EIMI.L"
1 -> EIMI.L: 0.298700 on 1/17/2024
1 -> EIMI.L: 0.302100 on 1/18/2024
1 -> EIMI.L: 0.302700 on 1/19/2024
1 -> EIMI.L: 0.302800 on 1/22/2024
1 -> EIMI.L: 0.304100 on 1/23/2024
1 -> EIMI.L: 0.309800 on 1/24/2024
1 -> EIMI.L: 0.308400 on 1/25/2024
1 -> EIMI.L: 0.309700 on 1/26/2024
Updated 8 Prices

[Mark]

Hi Howard,

Good point, yes, the Yahoo (Historical) will also divide any .L symbols by 100 by default. You can either turn this option off globally, so it never divides by 100 for Yahoo (UK & Ireland) or Yahoo (Historical) with the "yahoo_uk" registry option described here:

https://www.fundmanagersoftware.com/intrtv.html#YahooUK

If you set that to 1 in the registry, it won't do any of the dividing for .L symbols. However, if you want it to divide some, but not others, then you'd have to use the multiplier feature on a per-investment level under "Investment Properties... / Internet Retrieve / Multiple Retrieved Price By:".