tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5512-how-to-loadi-currency-history-data-use-the-load-security-history-extensionInfinite Kind: Discussion 2020-11-19T15:51:02Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-17T19:38:31Z2020-11-17T19:38:31ZHow to load currency history data use the "load security history" extension<div><p>I've worked out the answer to my own question. The ticker needs to be "GBPUSD=X".</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-17T20:35:24Z2020-11-17T20:35:24ZHow to load currency history data use the "load security history" extension<div><p>I am not support staff, just a user.<br>
Hi Chris</p>
<p>Have you considered using Quote Loader to obtain Security prices an exchange rates automatically. It an extension by the same developer as "load security history" extension, Mike Bray.</p>
<p>For information see post 63 at<br>
<a href="https://infinitekind.tenderapp.com/discussions/investments/4914-the-new-quote-loader/page/3#comment_48442233">https://infinitekind.tenderapp.com/discussions/investments/4914-the...</a></p>
<p>Download the PDF attached to posts 63 and have a read.</p>
<p>To get an overview take a look at the YouTube videos by using the links on page 1 and 2 of the PDF.</p>
<p>Let us know how you get on or if you need help just post.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-17T23:30:14Z2020-11-17T23:32:12ZHow to load currency history data use the "load security history" extension<div><p>I looked at the documentation, it looks like it can in theory download historical information, which is new since I last looked at it. But it will only do it for ETF's (if getting data from FT) so it won't give me data for many of my holdings.</p>
<p>I mention FT because I'm extremely reluctant to even test using Yahoo again. My past experience with Yahoo data is not just that prices (for a particular ticker) would randomly fluctuate between being quoted in pounds or pence, but that the actual currency in their price histories would switch between Euros and pounds or dollars and pounds without warning. Literally within one download spanning a period of say 90 days, there would be period where the prices were one currency, then another period where they were in a different currency. Every time I use Yahoo to see whether it can be relied upon, it messes up my historical data by replacing it with nonsense, and I have to go back to my normal methods to repair the data.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-18T00:00:06Z2020-11-18T00:00:53ZHow to load currency history data use the "load security history" extension<div><p>I've decided to try the quote loader with Yahoo prices. Since it apparently only loads prices I don't already have, it can't cause too much harm if the Yahoo prices are as bad as they used to be.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-18T08:41:55Z2020-11-18T08:41:55ZHow to load currency history data use the "load security history" extension<div><p>I am not support staff, just a user.<br>
Hi Chris</p>
<p>I would be interested in your finding.</p>
<p>Quote Loader has been widely used since 2018 and there has not been a single post I can remember describing the issues you found with Yahoo. Alfa Vantage as used by the extension “Quote and Exchange Rate Updater” is another thing. I abandoned it because it regally switched from pounds to pence then back again.</p>
<p>Quote Loader checks the unit of currency and in the case of any securities quoted in pence converts then to pounds to conform to the way Moneydance stores sterling.</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T08:47:29Z2020-11-19T08:48:02ZHow to load currency history data use the "load security history" extension<div><p>Quote loader has loaded ticker IESU wrongly. It has recorded a closing price for 18/11/2020 of £0.0317 instead of £3.17.</p>
<p>Looking at the Yahoo historical data page, the page says prices are quoted in pence, the current price is quoted pence, but the historical prices on the same page are quoted in pounds. At least most near the top are, as you run your eye down the page you will see that some prices are in pence, but most are in pounds.</p>
<p>The Yahoo data is garbage and I can't see anything quote loader can do to overcome this. This is for an ishares tracker ETF, so hardly some obscure security that no-one has ever looked at before.</p>
<p><a href="https://uk.finance.yahoo.com/quote/IESU.L/history?p=IESU.L&.tsrc=fin-srch">https://uk.finance.yahoo.com/quote/IESU.L/history?p=IESU.L&.tsr...</a></p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T08:57:22Z2020-11-19T08:57:22ZHow to load currency history data use the "load security history" extension<div><p>FT HD does not retrieve data for that ticker. (It does work for some other random ticker I tried, so it looks like a ticker-specfic issue.)</p>
<p>The only data source that currently brings back a correct figure is "Yahoo" (without HD.)</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T09:00:56Z2020-11-19T09:00:56ZHow to load currency history data use the "load security history" extension<div><p>You may be wondering what my alternative source of correct data is. I use Googlefinance function in a google spreadsheet to get 90 days of historical data for each of my holdings. I have a daily job that downloads the spreadsheet to a local .csv file, and runs it through some code to produce an input file that the price history loader can use. I obviously have to invoke the price history loader manually at least once every 90 days to keep my data up-to-date.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T09:13:01Z2020-11-19T09:13:01ZHow to load currency history data use the "load security history" extension<div><p>Sorry, looking at IESU some more, I realise the error is worse/more complicated than I initially thought. Google is telling me the correct price is £2.3915. So I'm guessing that maybe some other currency (probably dollars) is being quoted, though not even consistently.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T09:16:23Z2020-11-19T09:16:23ZHow to load currency history data use the "load security history" extension<div><p>My guess is that the Yahoo prices I initially thought were in pounds are actually in dollars. So the price history is mingling prices in dollars with prices in pence, while claiming that all prices are in pence.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T09:28:34Z2020-11-19T09:29:03ZHow to load currency history data use the "load security history" extension<div><p>Another ticker I use, VFEM (Vanguard emerging markets tracker ETF) also appears to have Yahoo historical prices that vary randomly between dollars and pounds.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T12:43:49Z2020-11-19T12:43:49ZHow to load currency history data use the "load security history" extension<div><p>So looking at FT and FT HD the prices for IESU are in GBX and seem to be<br>
correct (today 230.6 = £2.306). Yahoo is in GBp which is the equivalent<br>
of GBX. Its current price is also 230.6 = £2.306. Yahoo HD is<br>
incorrect. Starting on 21/9/2020 it is recording a strange prices on<br>
some days. Quote Loader will only load what is there and this is an<br>
issue with Yahoo Historical Data. For IESU your could delete the prices<br>
from 21/9 to present, run QL, change all sources to Do Not Load, change<br>
the source for IESU to FT HD and get prices. Select the returned prices<br>
and click on Save Selected Prices (DO NOT SAVE PARAMETERS).</p>
<p>Remember, FT does not allow access to historical data for shares, only<br>
funds.</p>
<p>Hope this helps.<br>
Mike (not support)</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T12:59:39Z2020-11-19T12:59:39ZHow to load currency history data use the "load security history" extension<div><p>I noticed that there are (correct) historical prices for IESU and VFEM on the FT web site, but selecting FT HD brings back nothing (red box) for me. FT (without HD) doesn't work either. Other securities I tried with FT HD do work, not sure why these don't.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T13:00:36Z2020-11-19T13:00:36ZHow to load currency history data use the "load security history" extension<div><p>I am not support staff, just a user.<br>
Hi Chris.</p>
<p>On your two example securities I have to agree Yahoo has gone crazy on historical prices. As you say for IESU Yahoo historical data is sometime in Pound, Pence or US Dollars.<br>
However, both seen to return correct prices when the Quote Loader source is FT HD, see screen shot.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T13:02:02Z2020-11-19T13:02:02ZHow to load currency history data use the "load security history" extension<div><p>I am not support staff, just a user.<br>
Hi Chris.</p>
<p>Screen shot</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T13:05:16Z2020-11-19T13:05:16ZHow to load currency history data use the "load security history" extension<div><p>Thanks Derek, after looking at your screenshot I removed the exchange information for those two, and now FT HD works.</p></div>Christag:infinitekind.tenderapp.com,2009-01-14:Comment/488372902020-11-19T13:09:24Z2020-11-19T13:09:24ZHow to load currency history data use the "load security history" extension<div><p>I am not support staff, just a user.<br>
Hi Chris.</p>
<p>Great.<br>
I hope Yahoo get there act together, but at least FT HD works.</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23