tag:infinitekind.tenderapp.com,2009-01-14:/discussions/moneydance-development/7337-quote-loader-v3046-m-bray-not-loading-quotes-consistently-in-latest-beta-builds-v4078Infinite Kind: Discussion 2022-08-09T16:40:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-06T16:54:46Z2022-05-06T16:54:46ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>I installed MD v4078 and I noticed that Quote Loader(3046) was not loading a significant number of quotes (the number loaded varied but at least 30-50%. I tried beta v4077, v4074 with the same results.</p>
<p>When I reverted to v4073, everything worked again and all quotes were being loaded again.</p>
<p>I reinstalled 4078 and the errors returned. Log files shows dozens of entries similar to :</p>
<pre>
<code>Quote Load>INFOT:09:51:02-pool-6-thread-4(GetQuoteTask,call) Processing MAXR URI:https://finance.yahoo.com/quote/MAXR/history?p=MAXR
Quote Load>INFO:09:51:08-pool-6-thread-2(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:08-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=ALA.TO
Quote Load>INFOT:09:51:08-pool-6-thread-2(GetQuoteTask,call) Processing MGP URI:https://finance.yahoo.com/quote/MGP/history?p=MGP
Quote Load>INFO:09:51:09-pool-6-thread-3(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:09-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=BAM
Quote Load>INFOT:09:51:09-pool-6-thread-3(GetQuoteTask,call) Processing IYR URI:https://finance.yahoo.com/quote/IYR/history?p=IYR
Quote Load>INFO:09:51:13-AWT-EventQueue-0(loadPricesWindow,updatePrices) URI loadPrice?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=L.TO&p=111.94999695&d=2022-05-06T12:50:54&c=CAD&ht=114.06999969482422&lt=111.69999694824219&v=301560
Quote Load>INFOT:09:51:13-pool-6-thread-1(GetQuoteTask,call) Processing ANRG.TO URI:https://finance.yahoo.com/quote/ANRG.TO/history?p=ANRG.TO
Quote Load>INFO:09:51:16-pool-6-thread-4(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:16-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=MAXR
Quote Load>INFOT:09:51:16-pool-6-thread-4(GetQuoteTask,call) Processing PKI.TO URI:https://finance.yahoo.com/quote/PKI.TO/history?p=PKI.TO
Quote Load>INFO:09:51:21-pool-6-thread-2(GetQuoteTask,call) error returned 503
Quote Load>INFO:09:51:21-AWT-EventQueue-0(loadPricesWindow,failedQuote) URI errorQuote?tid=6d83ec8d-c9e2-4ed3-b9d6-6878ec5a9f26&s=MGP</code>
</pre>
<p>The errors are mostly with Canadian Traded stock but there are quite a few for US stocks as well.</p></div>Bob Btag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-06T18:27:30Z2022-05-06T18:27:30ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>How many securities do you have?</p>
<p>Mike Bray the Quote Loader developer has update Quote Loader for another user who reported that some of his 198 securities were not being returned. Build 3047 is awaiting signing by Infinite Kind (Moneydance) but if you want to try it out its available on Mike’s site <a href="https://bitbucket.org/mikerb/moneydance-2019/downloads/">https://bitbucket.org/mikerb/moneydance-2019/downloads/</a><br>
Download securityquoteload3047.mxt. Rename it to securityquoteload.mxt. In Moneydance go to Extensions/Manage Extensions and click on 'Add From File' (bottom left). Click on Yes to the warning, click on Install for the Add Extension. Restart Moneydance. Then try it out and let us know if this works.</p>
<p>If you still have issue it would help diagnose the issue if you could send a copy of all your securities. This is simple to do as follows:</p>
<p>The following instruction creates a simple spread sheet which contains all your Security Names and Ticker symbols, nothing else.<br>
The instruction is based on using Excel, but other spread sheet applications should work as well but some of the instruction may be slightly different.</p>
<p>Exporting data to excel.<br>
1. In Moneydance in the Side Bar click on the report “Portfolio”.<br>
2. Click Edit, Reset, OK and then Copy to Clipboard.<br>
Import into excel.<br>
1. Open excel and in the top left-hand cell click paste.<br>
2. Delete all columns except the columns containing Security Names and Symbols.<br>
3. Delete all rows that do not contain Symbols, including the row containing the word “Ticker”.<br>
4. You should now be left with a list of Security Names and their associated Ticker Symbols.<br>
5. Save file as a CSV file type and compress it to a ZIP file and post.<br>
I will then create a test Data Set with all your securities and pass it on to Mike.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-07T06:32:27Z2022-05-07T06:32:27ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>Hi Bob, error 503 is 'the server is not ready to handle the request'. This looks like a problem with the source rather than MD or Quote Loader. Can you run it again. If it still fails please let me have the excel sheet as indicated by Derek.<br>
Thanks<br>
Mike</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-07T17:00:18Z2022-05-07T17:00:18ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>On retest, it looks like the MD version number makes no difference. I've attached logs from 4073 and 4078. Both had 21 errors (displayed on the screen on completion of the run).</p>
<p>Also attached Ticker Symbols and quote load parameters.</p></div>Bob Btag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-07T17:13:53Z2022-05-07T17:13:53ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>Also downloaded QL 4037 and tested against MD 4078. Only 1 error for a security that previously loaded OK (SLF: TSX)</p></div>Bob Btag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-07T17:51:40Z2022-05-07T17:51:40ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>I was just looking at your csv file, it looks like you have 527 securities.</p>
<p>That would take some time for me to import into a test data set.</p>
<p>But if I am reading you last post correctly using QL 4073 only give you one error , Sun Life Financial Inc where you are using the Tinker SLF:TSX . However, in the error log it looks like you are using SLF.T</p>
<p>Try changing the ticker for Sun Life Financial Inc to just SLF</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-07T18:06:55Z2022-05-07T18:07:54ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>Or if its the Sun Life Financial Inc is traded on the Toronto exchange change to SLF.TO</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-10T08:35:49Z2022-05-10T08:35:49ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>Did you resolve the issue with Sun Life Financial Inc?</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-10T16:05:50Z2022-05-10T16:05:50ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>Yes sorry forgot to post. It was my error, I had mistakenly assigned the wrong exchange (Tokyo instead of Toronto). So all is good now with the Quote Loader 4037 release.</p></div>Bob Btag:infinitekind.tenderapp.com,2009-01-14:Comment/541686522022-05-10T16:30:20Z2022-05-10T16:30:20ZQuote Loader v3046 (M Bray) not loading quotes consistently in latest beta builds v4078<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>Great. Thanks for the feed back</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23