tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/66316-quote-loader-extension-stopped-updating-unit-trust-pricesInfinite Kind: Discussion 2021-02-23T21:40:47Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T01:42:21Z2020-12-29T01:42:31ZQuote Loader Extension stopped updating unit trust prices<div><p>I have used the Quote loader extension successfully for a few months with no issues. Now since 21st December the prices are flagged as as error as they do not update. The exchange rates continue to update properly. Does anyone know what may have happened and how I can fix this?</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T08:29:28Z2020-12-29T08:29:28ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi spswiftsteve</p>
<p>Quote Loader is returning fund prices for me so some further investigation is required.</p>
<p>What version/build of Moneydance are you running, e.g. 2021(3032)<br>
What is your computer operating system.<br>
What build of Quote Loader are you running, e.g.3027.<br>
List a number of Ticker Symbols and there fund names along with the source you are using, FT, FT HD, Yahoo. Yahoo HD and I will test.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T10:08:38Z2020-12-29T10:26:46ZQuote Loader Extension stopped updating unit trust prices<div><p>Thanks for coming back so soon. The answers are shown next to your questions in red</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T10:17:34Z2020-12-29T10:17:34ZQuote Loader Extension stopped updating unit trust prices<div><p>(FYI - You can’t email a reply and edit below the line, your edits will get / have been lost. You should reply above the line or click the link and comment in the online form)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T10:22:56Z2020-12-29T10:22:56ZQuote Loader Extension stopped updating unit trust prices<div class="">
<blockquote type="cite" class="">
<div class="">
<table width="100%" class="">
<tr class="">
<td class="">
<div class="">
<p class="">What version/build of Moneydance are you running, e.g. 2021(3032) 2021 (2006)<br class="">
What is your computer operating system. Mac Big Sur Version 11.1<br class="">
What build of Quote Loader are you running, e.g.3027. 3027<br class="">
List a number of Ticker Symbols and there fund names along with the source you are using, FT, FT HD, Yahoo. Yahoo HD and I will test. I have taken a screenshot of the Quote loader - you can see all of the quotes (except the one for the Societe Generale share price, which is updating) are stuck on 21/12/2020. I have never got the funds that have a code starting with HK to load. I guess that these are not supported.</p>
<p class=""><br class=""></p>
<p class=""><br class=""></p>
<p class=""><img class=""></p>
</div>
</td>
</tr>
</table>
</div>
</blockquote>
<div>
<blockquote type="cite" class="">
<div class="">On 29 Dec 2020, at 16:29, derekkent23 <<a href="mailto:tender+da8e6b3ac3@tenderapp.com" class="">tender+da8e6b3ac3@tenderapp.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<table width="100%" class="">
<tr class="">
<td class="">
<p class="">// Please reply above this line<span class="Apple-converted-space"> </span><br class="">
==================================================<span class="Apple-converted-space"> </span></p>
<p class=""><b class="">From</b>: derekkent23</p>
<div class="">
<p class="">I am not support staff, just a user.<br class="">
Hi spswiftsteve</p>
<p class="">Quote Loader is returning fund prices for me so some further investigation is required.</p>
<p class="">What version/build of Moneydance are you running, e.g. 2021(3032)<br class="">
What is your computer operating system.<br class="">
What build of Quote Loader are you running, e.g.3027.<br class="">
List a number of Ticker Symbols and there fund names along with the source you are using, FT, FT HD, Yahoo. Yahoo HD and I will test.</p>
</div>
<div class="">
<p class="">On Mon, Dec 28 at 05:42 PM PST, spswiftsteve wrote:</p>
<blockquote class="">
<div class="">
<p class="">I have used the Quote loader extension successfully for a few months with no issues. Now since 21st December the prices are flagged as as error as they do not update. The exchange rates continue to update properly. Does anyone know what may have happened and how I can fix this?</p>
</div>
</blockquote>
</div>
</td>
</tr>
<tr class="">
<td class="">
<p class="">Having trouble reading this? View this discussion online:<span class="Apple-converted-space"> </span><a href="https://infinitekind.tenderapp.com/discussions/problems/66316-quote-loader-extension-stopped-updating-unit-trust-prices" class="">Quote Loader Extension stopped updating unit trust prices</a>.</p>
<p class="">To unsubscribe and stop receiving emails from<span class="Apple-converted-space"> </span><a href="https://infinitekind.tenderapp.com/" class="">https://infinitekind.tenderapp.com</a>, visit<span class="Apple-converted-space"> </span><a href="https://infinitekind.tenderapp.com/unsubscribe/f8bb8aa97135f4ea1c7efe78d90503553d145a67" class="">this page</a></p>
</td>
</tr>
</table>
</div>
</blockquote>
</div>
<br class=""></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T10:57:11Z2020-12-29T10:57:11ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi spswiftsteve</p>
<p>The screen shot shows a test I ran on a number of your securities returning current prices.<br>
Tested on Windows 10 Moneydance 2021(3032) Quote Loader 3027.</p>
<p>First thing to try update Moneydance to 2021(3032) at <a href="https://infinitekind.com/preview">https://infinitekind.com/preview</a><br>
Most people don’t get as far as running Quote Loader on 2021(2006) with Mac Big Sur</p>
<p>You should also in your computers system Preferences, General section, the option "Prefer tabs [always] when opening documents" should be changed from "always" to never or "in full screen"</p>
<p>After update report back.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T14:42:35Z2020-12-29T14:42:35ZQuote Loader Extension stopped updating unit trust prices<div><p>Hello. I have done the update. I also checked and the Preference was already set at in full screen. Unfortunately I got the same result. No prices and just the one individual stock (Societe Generale) and the currencies that updated.</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T15:11:59Z2020-12-29T15:11:59ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi spswiftsteve</p>
<p>OK let’s investigate further.</p>
<p>With Quote Loader open click Quote Loader HELP – TURN DEBUG ON/OFF selected DETAILED.</p>
<p>Close then re-open Moneydance and open Quote Loader and click GET PRICES.<br>
When the run is complete close Moneydance and post the Moneydance errlog.txt file.</p>
<p>Mac OS, it should be located at one of these locations within your Home folder:<br>
~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt or:<br>
~/Library/Application Support/Moneydance/errlog.txt</p>
<p>If you have any trouble finding your Home Library folder you can open Finder and hold down the option key while selecting the Go menu and the Library folder option should occur or you can open Finder and select Go -> Go to Folder and copy and paste in the following:<br>
~/Library</p>
<p>This should pull up your local Library folder.</p>
<p>Post the errlog.txt file</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-29T22:58:14Z2020-12-29T23:23:37ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi spswiftsteve</p>
<p>I think I see what the issue is.<br>
You have set the Exch Mod to LSE for the Tickers starting with LU<br>
If you take a look at my post that included the test of some of your Ticker you will see I left Exch Mod blank.<br>
Try that.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-30T01:43:10Z2020-12-30T01:43:10ZQuote Loader Extension stopped updating unit trust prices<div><p>It worked. Thank you so much. It has been a great help. The strange thing is that the LSE EXCH MOD was set like that from the beginning and it did work until 21st December. Any way - as long as it works….</p>
<p>Could I ask one final question: I have some funds that start with HK in their identifier. They have never loaded and still do not. Is it because there is no price at FT for them? I suspect that they are listed in Hong Kong. I have given four examples.</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-30T09:03:08Z2020-12-30T09:03:08ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi spswiftsteve</p>
<p>If you read my PDF attached to the Quote Loader release notes at <a href="https://infinitekind.tenderapp.com/discussions/investments/4914-the-new-quote-loader#comment_48217287">https://infinitekind.tenderapp.com/discussions/investments/4914-the...</a></p>
<p>You will note that in the last paragraph on page 6 talks about what you should select for the Exch Mod when the ticker is a ISIN code such as you are using, e.g. LU0053903380</p>
<p>If you have not read this PDF take a look to ensure you are getting the best out of Quote Loader. By the way the first two characters defines the country code, in the case of LU Luxenberg.</p>
<p>The only explanation I have on how it worked before is that back in June build 3025 was released correcting a error in that in earlier builds with the source FT selected the London Stock Exchange (LSE) did not add the extension :LSE to the ticker which is sometimes needed for non-ISIN tickers. So for FT selecting LSE before build 3025 would have added a blank extension.</p>
<p>As for your HK (Hong Kong) tickers as far as I can see they are not supported.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-31T02:36:07Z2020-12-31T02:36:07ZQuote Loader Extension stopped updating unit trust prices<div><p>Thanks so much. Problem sorted.</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772020-12-31T13:09:07Z2020-12-31T13:09:07ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi spswiftsteve</p>
<p>Glad I was able to help.</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-06T02:00:40Z2021-02-06T02:00:40ZQuote Loader Extension stopped updating unit trust prices<div><p>Hello again. I now seem to have a similar problem but just for one unit trust price (BlackRock European Special Situations fund) It worked perfectly until about a week ago. I have attached a screenshot that shows the issue and one that shows the details that I have entered for it. . Do you have any tips on sorting this out?</p>
<p>Thank you</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-06T06:52:44Z2021-02-06T06:52:44ZQuote Loader Extension stopped updating unit trust prices<div><p>The ticker you are using does not exist any more there is a ticker for<br>
this fund but it is LU0154234636:EUR. This could be because of Brexit,<br>
but who knows.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-06T10:03:27Z2021-02-06T10:03:27ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user<br>
Hi spswiftsteve</p>
<p>It appears that the BlackRock European Special Situations fund A2 is traded in two currencies one being LU0121276677 in US Dollars. For some reason FT seems to have removed this fund from its listing, maybe be it will return, who knows, although it is still quoted on other sites e.g. <a href="https://www.fundsquare.net/security/summary?idInstr=6302">https://www.fundsquare.net/security/summary?idInstr=6302</a></p>
<p>and by Blackrock itself at</p>
<p><a href="https://www.blackrock.com/sg/en/products/229662/blackrock-european-special-situations-fund-a2-usd">https://www.blackrock.com/sg/en/products/229662/blackrock-european-...</a></p>
<p>As Mike Suggests the other currencies it is traded in is Euros using ticket LU0154234636<br>
The dropdown on the Blackrock site confirms this.</p>
<p>One option is to change the ticker to LU0154234636 and ensure you also use Quote Loader to download US Dollar/Euro exchange rates so although QL will download in Euros it will convert the returned price to US Dollars before storing the values in the Security History window.</p>
<p>Suggest you do an EXPORT BACKUP then try this out.<br>
1. Change ticker symbol from LU0121276677 to LU0154234636<br>
2. Ensure under TOOLS – CURRENCIES – double click on EURO – EDIT that SHOW ON SUMMARY PAGE is ticked.<br>
3. Set up QL as screen shot.<br>
4. Click GET EXCHANGE RATES and save the returned Euro exchange rate.<br>
5. Click GET PRICES and note the BlackRock fund is returned in Euros (Traded Currency) but converted to US Dollars (New Price).</p>
<p>As QL is doing a currency conversion it needs an up to date exchange rate before it downloads the Blackrock price see page 5 of PDF 106 at <a href="https://infinitekind.tenderapp.com/discussions/investments/4914-the-new-quote-loader/page/4#comment_48883238">https://infinitekind.tenderapp.com/discussions/investments/4914-the...</a></p>
<p>Closing price 5 fed 2021<br>
QL LU0154234636 price is 55.72 Euros<br>
Using the returned exchange rate QL converts to a rounded 66.68 US Dollars.<br>
Comparing this with the Blackrock site for LU0121276677 it gives a price of 66.97 US Dollars, small difference probably due to exchanged rate used. Can you live with that small error? If not you will need to load the price manually into QL.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-06T10:41:52Z2021-02-06T10:41:52ZQuote Loader Extension stopped updating unit trust prices<div><p>Thank you very much. I have changed it to the EUR ticker and it seems to produce a result in USD that is close enough.</p>
<p>Thank you for your help.</p></div>spswiftstevetag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-06T15:57:55Z2021-02-06T15:57:55ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user<br>
Hi spswiftsteve</p>
<p>Glad we were able to help.</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T09:57:39Z2021-02-23T09:57:39ZQuote Loader Extension stopped updating unit trust prices<div><p>Hi, I have exactly the same problem with version 3027 that my unit trust prices will not load, whereas the old version worked perfectly. So I am going to try the above.<br>
I noticed spswiftsteve saus he cannot load Hong Kong quotes, but I have always been able to do that, fot example:<br>
Exchange HKEX<br>
Ticker 700<br>
Source FT<br>
Just the number for the Ticker, no letters</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T10:13:35Z2021-02-23T10:13:35ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user<br>
Hi davidvernonlong</p>
<p>Can you post the name of the security plus its current price so I can take a look.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T10:54:13Z2021-02-23T10:54:13ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user<br>
Hi davidvernonlong</p>
<p>Also you base currency MD is set to.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T11:08:52Z2021-02-23T11:08:52ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user<br>
Hi davidvernonlong</p>
<p>A guess.</p>
<p>Hope it helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T13:31:16Z2021-02-23T13:31:16ZQuote Loader Extension stopped updating unit trust prices<div><p>Hi,<br>
So I changed I changed the source from FT to Yahoo, and in most cases that worked, even though I can see the prices correctly quoted on the FT site itself. The exception is LU0895806098:GBP , Jupiter Global Fund - Jupiter Dynamic Bond Class D GBP Acc HSC, Price (GBP)14.40Today's Change-0.06 / -0.41%.<br>
This did not work even with Yahoo as the source.<br>
I have an older version of Quoteloader on another PC which I hardly use (3016). Guess what? When I ran it all the prices downloaded perfectly.<br>
An example of a fund which on 3027 with FT as a source did not lownload, but with Yahoo as a source did download, and downloaded correctly with 3026 in both cases is Baillie Gifford International Fund B AccumulationGB0005941272:GBX.<br>
All in this cattegory had a ticker starting with GB00<br>
I will send you privately a screen shot of the showing the failed downloads on 3027 if you wish</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T13:37:21Z2021-02-23T13:37:21ZQuote Loader Extension stopped updating unit trust prices<div><p>On the Hong Kong security. Yes I agree that works and is correct, as I pointed out in my message trying to help spswiftsteve. I have no problem with Hong Kong securities. The Ticker should be numeric only with no leading or trailing HK</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T13:57:19Z2021-02-23T13:57:19ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user<br>
Hi davidvernonlong</p>
<p>Take a lock at screen shot.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T16:13:21Z2021-02-23T16:13:21ZQuote Loader Extension stopped updating unit trust prices<div><p>Hi<br>
Yes, that works for you and for me on my old PC that uses the old Quote Load extension. I am only using that PC to check if it works correctly. However on my current PC it no longer works for some securities, whereas it always did in the past. I have compared the settings in your screen shot with my settings, and nothing untoward. The only thing I have done recently is added a new currency- Bitcoin- but I did not change the base currency.<br>
Maybe I should re-install Quote Loader extension</p>
<p>Here is a screen shot of Quote Loader with all the reds.</p>
<p>David</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T16:26:46Z2021-02-23T16:26:46ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi davidvernonlong</p>
<p>On all ISIN Tickers symbols (GB00 &LU) don’t set an Exchange (Exch Mod), set them to blank.<br>
Also on ticker CNX1 set Exch Mod to blank.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T16:38:40Z2021-02-23T16:38:40ZQuote Loader Extension stopped updating unit trust prices<div><p>Thanks, it worked. Aplogies if I missed that in one of your previous responses.</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/489353772021-02-23T16:54:27Z2021-02-23T16:54:27ZQuote Loader Extension stopped updating unit trust prices<div><p>I am not support staff, just a user.<br>
Hi davidvernonlong</p>
<p>The build of Quote loader on your old computer must be before 3025.<br>
Build 3025 add exchange extension “:LSE” to FT Ticker symbols when London Stock Exchange is selected under Exch Mod. Before this build this exchange extension was incorrectly omitted (blank). It just happens it worked against you on build 3027.</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23